Course Details

Advance Excel training.   1. Introduction to MS Excel / Spreadsheet 2. Performing Data Analysis Working with Formulas Working with Functions Learning function categories Lookup Functions H LookUp V LookUp 3. Analyzing Data using Pivot Tables Working with Pivot Tables Enhancing Pivot Tables 4. Performing Spread Sheets Creating Data tables Using the Scenario Manager Using Goal Seek and Solver 5. Automation Task  Automating tasks using Macro Using relative Macro Working with Useful Keyboard Sortcut keys 6. Database Management 7. Working with Styles, Templates and Tables 8. Working with other Advance features Data Validation Importing and Exporting Data Working with Web Cell and workbook protection Customizing Quick Access Toolbar Working with more formatting features consolidating worksheet 9. Using Charts and Graphics Working with Graph Objects Working with Charts Advance Excel training with Macros 10. Macros Advance level