Course Description
Do you want to learn how to design a worksheet that will bring clarity to your calculations and help you analyze your data to ensure you make informed decisions? Discover the many benefits of using the Excel Format as Table command. This amazing Excel command will eliminate a lot of repetitive formatting and repetitive steps that are required to create formulas and functions.
Course Time
3-hour virtual class
Lesson Objectives:
- Understand why you would use the Format as Table command?
- Automatically extend the table’s formatting to a new row or column
- Always keep the list headers visible
- Easily select a table, row or column
- Easily insert a row or column
- Total row function magic
- Quickly create formulas
- Formula autofill magic
- Easy sorting and filtering
- Table Slicers
- Dynamic charts – Insert a Chart
- Summarize with PivotTables
- Table keyboard shortcuts
- Efficiently Create your own Table
- Bonus: Use the Format as Table command to create an Accessible PDF