Introduction

Course overview

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