Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
Create a Map chart in Excel - Microsoft Support
You can use a map chart to compare values and show categories across geographical regions. Use it when you have geographical regions in your data, like countries/regions, states, counties or postal codes. Note: This feature is available if you have a Microsoft 365 subscription.
Create a flow chart with SmartArt - Microsoft Support
This article explains how to create a flow chart that contains pictures. You can use the methods described in this article to create or change almost any SmartArt graphic. Try different layouts to achieve the results you want. What do you want to do? On …
Tutorial: Import Data into Excel, and Create a Data Model
These tutorials build and refine an Excel workbook from scratch, build a data model, then create amazing interactive reports using Power View. The tutorials are designed to demonstrate Microsoft Business Intelligence features and capabilities in …
Load the Solver Add-in in Excel - Microsoft Support
The Solver Add-in is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel. To use the Solver Add-in, however, you first need to load it in Excel. Click Go. In the Add-Ins available box, select the Solver Add-in check box, and then click OK.
Filter for unique values or remove duplicate values
In Excel, there are several ways to filter for unique values—or remove duplicate values: To filter for unique values, select Data > Sort & Filter > Advanced. To remove duplicate values, select Data > Data Tools > Remove Duplicates. To highlight unique or duplicate values, from the Home tab, use the Conditional Formatting command in the Style group.
Automate tasks with the Macro Recorder - Microsoft Support
To automate a repetitive task, you can record a macro with the Macro Recorder in Microsoft Excel. Imagine you have dates in random formats and you want to apply a single format to all of them. A macro can do that for you. You can record a macro applying the format you want, and then replay the macro whenever needed.
Keyboard shortcuts in Microsoft 365 - Microsoft Support
Many users find that using Microsoft 365 apps with keyboard shortcuts on an external keyboard helps them work more efficiently. For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen, and are an essential alternative to using a mouse.
Analyze Data in Excel - Microsoft Support
Analyze Data in Excel empowers you to understand your data through natural language queries that allow you to ask questions about your data without having to write complicated formulas. In addition, Analyze Data provides high-level visual summaries, trends, and patterns. Have a question? We can answer it!
Detect errors in formulas - Microsoft Support
Formulas can sometimes result in error values in addition to returning unintended results. The following are some tools that you can use to find and investigate the causes of these errors and determine solutions. Note: This topic contains techniques that can help you correct formula errors.
Ways to count values in a worksheet - Microsoft Support
Use the SUBTOTAL function to count the number of values in an Excel table or range of cells. If the table or range contains hidden cells, you can use SUBTOTAL to include or exclude those hidden cells, and this is the biggest difference between SUM and SUBTOTAL functions. The SUBTOTAL syntax goes like this: SUBTOTAL (function_num,ref1, [ref2],...)