Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
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 (~).
Manage your Microsoft 365 subscription or Office product
For Microsoft 365 Family or Personal subscriptions: Select Install premium Microsoft 365 apps and follow the prompts to install or reinstall the desktop apps. On the Microsoft 365 subscription tab, select Manage. From here you can: Renew your subscription with a …
Load the Analysis ToolPak in Excel - Microsoft Support
Perform statistical and engineering analysis with the Analysis ToolPak. The Analysis ToolPak is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel.
Keyboard shortcuts in Microsoft 365
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.
Show changes that were made in a workbook - Microsoft Support
Show Changes in Excel lets you see exactly what edits were made to your workbooks, so you can confidently allow others to collaborate on your work. You can see details of who changed what, where, and when, along with the previous value of the cell for quick reversion.
INDEX function - Microsoft Support
The INDEX function returns a value or the reference to a value from within a table or range. There are two ways to use the INDEX function: If you want to return the value of a specified cell or array of cells, see Array form. If you want to return a reference to specified cells, see Reference form.
Edit or make changes to a PDF file - Microsoft Support
To convert a PDF and edit it in Word, check out Edit PDF content in Word. Or use a third-party PDF converter tool to import your PDF into an Office file format, make your changes, and then save the file in PDF format again.
Excel functions (alphabetical) - Microsoft Support
Overview of formulas in Excel. How to avoid broken formulas. Detect errors in formulas. A complete list of all Excel functions in alphabetical order.
Create a timeline - Microsoft Support
Learn how to create a timeline in Microsoft Office apps. Create a graphical representation of a sequence of events with the SmartArt graphic timeline.
Share your documents - Microsoft Support
You can share your documents for free using Microsoft 365, regardless of whether you or the recipient have a subscription or a Microsoft account. The act of sharing maybe successful, however, the recipient may not be able to open the file because of the Sensitivity label on it.