Create an organization chart in Office by using SmartArt
Use a SmartArt graphic to create an organization chart in Excel, Outlook, PowerPoint, or Word to show the reporting relationships in an organization, such as department managers and non …
Apply data validation to cells - Microsoft Support
Use data validation to restrict the type of data or the values that users enter into a cell, like a dropdown list. Select the cell (s) you want to create a rule for. Select Data >Data Validation. …
RIGHT, RIGHTB functions - Microsoft Support
This article describes the formula syntax and usage of the RIGHT and RIGHTB functions in Microsoft Excel. RIGHT returns the last character or characters in a text string, based on the …
Use Microsoft Query to retrieve external data
You can use Microsoft Query to retrieve data from external sources. By using Microsoft Query to retrieve data from your corporate databases and files, you don't have to retype the data that …
Excel functions that return ranges or arrays - Microsoft Support
In September, 2018 we announced that Dynamic Array support would be coming to Excel. This allows formulas to spill across multiple cells if the formula returns multi-cell ranges or arrays. …
Download free, pre-built templates - Microsoft Support
You can download free, pre-built document templates with useful and creative themes from Office when you click File > New in your Office app. Templates can include calendars, business …
Quick start: Filter data by using an AutoFilter - Microsoft …
With filtering, you can control not only what you want to see, but what you want to exclude. You can filter based on choices you make from a list, or you can create specific filters to focus on …
Insert a symbol - Microsoft Support
You can easily insert a special character, fraction, or other symbol in your PowerPoint presentations and Excel workbooks. The most important thing to understand when inserting …
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 …
Learn more about SmartArt Graphics - Microsoft Support
Combined with other features such as themes, SmartArt graphics help you create designer-quality illustrations with only a few clicks of your mouse. You can create a SmartArt graphic in Excel, …
Use sparklines to show data trends - Microsoft Support
Learn how to use sparklines to show data trends and visually represent your data within a cell of an Excel worksheet.