Microsoft Excel

Three tips for getting started with Excel Charts

Chris Menard

07 Jan 2021 — 2 min read

Charts in Microsoft Excel are easy. This short video shows three tips for creating charts. I'll cover two keyboard shortcuts for making charts, using Recommend Charts, and creating charts using Quick Analysis.

Tip # 1 - Use Keyboard Shortcuts to create Charts

Windows Keyboard shortcuts

- **F11** to create a chart on a new worksheet - **ALT + F1** to create a chart on the current worksheet

Mac Keyboard shortcuts

- **FN + F11** to create a chart on a new worksheet - **FN + ⌥ + F1** to create a chart on the current worksheet

_Note_: If these shortcuts don't work on the Mac, you must turn off the conflicting Mission Control keyboard shortcut on your Mac by going to System Settings > Keyboard > Shortcuts > Mission Control and disabliging Show Desktop \[F11\].

YouTube Video on Three tips for getting started with Excel Charts

Three tips for getting started with Excel Charts - YouTube

Steps to use recommended charts

1. Select the data to chart 2. Click the **insert** tab 3. Click **Recommended Charts -** screenshot above 4. Select a chart to preview the chart 5. Click **OK**

Tip # 3 - Use Quick Analysis to create a Chart

Steps to use Quick Analysis

1. Select the data to chart 2. Click the **Quick Analysis icon** 3. Click **Charts -** screenshot above 4. Mouse over the charts to preview 5. Click a chart to add to the worksheet

Count Unique Values in Excel with UNIQUE, SORT, and COUNTIF Functions Tutorial

Table of Contents * 📋 Why this method works and when I use it * 📋 Setting up the table * 🔎 Extract distinct values with UNIQUE * ↕️ Sort the unique list with SORT * 🔢 Count occurrences using COUNTIF * ✅ Why tables beat ranges for this task * 🔁 When to use this instead of a pivot table * 🔧 Quick checklist to

Financial Ratios - Formula Completion in Excel using Copilot

Writing formulas in Excel can be time-consuming and challenging, even for experienced users. Selecting the right function, referencing the correct cells, and ensuring proper syntax often slows down workflows and leads to errors. Many users spend extra time troubleshooting mistakes, searching for examples, or trying to recall the exact formula

Excel Formula Completion - Using XLOOKUP

I tested how well Excel's formula completion with Copilot handles a multi-step calculation that would normally require a nested function. The goal was simple: calculate profit by subtracting the total cost of units sold from total revenue, with unit costs stored in a separate lookup table. Instead of

Copilot in Teams Meetings without Transcription: Use AI While Respecting Privacy

Microsoft Teams has a great Copilot feature. A Microsoft 365 license is required for this feature. In a Teams meeting, I need AI assistance during a conversation, but the participants do not want the call recorded or transcribed. There are plenty of situations where privacy matters: a vendor asks for