Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
Create a drop-down list - Microsoft Support
You can help people work more efficiently in worksheets by using drop-down lists in cells. Drop-downs allow people to pick an item from a list that you create. Windows macOS Web. In a new worksheet, type the entries you want to appear in your drop-down list.
XLOOKUP function - Microsoft Support
Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID.
Repair an Office application - Microsoft Support
Repair an Office application. If a Microsoft 365 application such as Word or Excel isn’t working correctly, sometimes restarting it will fix the problem. If that doesn’t work, you can try repairing it. When you’re done, you might need to restart your computer.
Filter data in a range or table - Microsoft Support
Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data.
Overview of Excel tables - Microsoft Support
To make managing and analyzing a group of related data easier, you can turn a range of cells into an Excel table (previously known as an Excel list). Note: Excel tables should not be confused with the data tables that are part of a suite of what-if analysis commands.
Calculate the difference between two dates - Microsoft Support
Calculate the difference between two dates. Use the DATEDIF function when you want to calculate the difference between two dates. First put a start date in a cell, and an end date in another. Then type a formula like one of the following.
Activate Office - Microsoft Support
To use Microsoft 365 on your new device, you can activate Microsoft 365 as a 1-month trial of Microsoft 365 Family. You can also buy Microsoft 365 or a non-subscription version of …
Change the format of a cell - Microsoft Support
Format text in cells. Format numbers. Format a date the way you want. Format cells by including predefined formatting styles, and things like borders and fill colors.
TEXT function - Microsoft Support
Overview. In its simplest form, the TEXT function says: =TEXT (Value you want to format, "Format code you want to apply") Here are some popular examples, which you can copy directly into Excel to experiment with on your own. Notice the format codes within quotation marks.
About Power Query in Excel - Microsoft Support
With Power Query (known as Get & Transform in Excel), you can import or connect to external data, and then shape that data, for example remove a column, change a data type, or merge tables, in ways that meet your needs. Then, you can load your query into Excel to …