Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
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 Office, …
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.
Create, edit, and manage connections to external data
Create an Office Data Connection (ODC) file. By using the dialog box or the Data Connection Wizard, you can use Excel to create an Office Data Connection (ODC) file (.odc). For more information, see Connection properties Share data with ODC. Create a …
Merge columns (Power Query) - Microsoft Support
In Power Query, you can merge two or more columns in your query. You can merge columns to replace them with one merged column, or create a new merged column alongside the columns that are merged. You can only merge columns of a Text data type. The following data is …
Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
Refresh an external data connection in Excel - Microsoft Support
Refresh an external data connection in Excel. To keep imported external data up-to-date, you can refresh it to see recent updates and deletes. Excel provides many options for refreshing data, including when you open the workbook and at timed intervals. Note: To stop a refresh, press Esc.
Use AND and OR to test a combination of conditions
This formula nests the AND function inside the OR function to search for units sold between April 1, 2011 and January 1, 2012, or any units sold by Nancy. You can see it returns True for units sold by Nancy, and also for units sold by Tim and Ed during the dates specified in the formula.
Using wildcard characters in searches - Microsoft Support
Use wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern. These characters can be the asterisk (*), the question mark (?), and the tilde (~).
Basic tasks in Excel - Microsoft Support
Get started with basic tasks in Excel such as opening a workbook, entering and formatting data, calculating data, and trying some quick analysis features..
Manage workbook links - Microsoft Support
Create a workbook link. Description of workbook link management and storage in Excel. Linking to other workbooks is a very common task in Excel, but sometimes you might find yourself with a workbook that has links you can’t find even though Excel tells you they exist.