Objectives. You will be able to:
- Create, save, and use a custom worksheet template
- Explore dynamic array functions
- Use the LOOKUP, text, date, and database functions
- Use advanced filtering and sorting techniques
- Apply and modify data validation for numbers, text, and date cells
- Use Subtotal functions and the Subtotals feature
- Use Data Consolidation to summarize data from multiple ranges
- Create, modify, and filter a PivotTable
- Create macros and add form controls
- Create custom charts and chart templates
- Insert, format, and modify graphics, screenshots, symbols, and 3D models
- Run the Accessibility Checker and address needed changes
- Protect sheets, workbooks, and ranges