Spreadsheet Application
(Basic & Advanced)
- Starting Excel
- Understanding the Excel Program Screen
- Using Keyboard Commands
- Create spreadsheet
- Using Contextual Menus and the Mini Toolbar
- Using Help Exiting
- Format spreadsheet
- Editing a Worksheet
- Working with Chart Analysis
- Working with Chart Labels
- Working with Chart Axes
- Working with Chart Backgrounds
- Working with Advanced Functions
- Working with Functions
- Using the IF Function
- Using Table Lookup Functions (HLookup and VLookup)
- Using Text Functions
- Creating and Working with PivotTables
- Understanding PivotTables
- Working with Recommended PivotTables
- Creating a PivotTable using an External Data
- Print spreadsheets