Accessibility best practices with Excel spreadsheets
Use a simple table structure for data only, and specify column header information. To ensure that tables don’t contain split cells, merged cells, or nested tables, use the Accessibility Checker. Visually scan your tables to check that they don't have any completely blank rows or columns.
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-management employees.
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.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000. The second argument is the range of cells, C2-:E7, in which to search for the value you want to find. The third argument is the column in that range of cells that contains the value that you seek.
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.
VLOOKUP function - Microsoft Support
Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID. In its simplest form, the VLOOKUP function says:
Outline (group) data in a worksheet - Microsoft Support
Use an outline to quickly display summary rows or columns, or to reveal the detail data for each group. You can create an outline of rows (as shown in the example below), an outline of columns, or an outline of both rows and columns. 1. To display rows for a level, select the appropriate outline symbols.
Video: Set up a holiday budget in Excel - Microsoft Support
Manage your budget and expenses in Excel and you can keep tabs on specific expenditures, like your annual winter bash, and whole categories, like donations or gift-giving. Set up a holiday budget. To find a template, type holiday budget in the …
Diagnostic data in Microsoft 365 - Microsoft Support
In Word, Excel, PowerPoint, Outlook, OneNote, Project, or Visio: Go to File > Account > and under Account Privacy select Manage Settings. Select the level of diagnostic data that you're comfortable with. The settings you choose will also roam to …