- Working with Formulas
- Working with Functions
- Learning function categories
- Lookup Functions
- H LookUp
- V LookUp
- Working with Pivot Tables
- Enhancing Pivot Tables
- Creating Data tables
- Using the Scenario Manager
- Using Goal Seek and Solver
- Automating tasks using Macro
- Using relative Macro
- Working with Useful Keyboard Sortcut keys
- Data Validation
- Importing and Exporting Data
- Working with Web
- Cell and workbook protection
- Customizing Quick Access Toolbar
- Working with more formatting features consolidating worksheet
- Working with Graph Objects
- Working with Charts