1. Introducing Excel 2. Entering and Editing Worksheet Data 3. Essential Worksheets Operations 4. Working with Cell and Ranges 5. Introducing Table 6. Worksheet Formatting 7. Understanding Excel Files 8. Using and Creating Templates 9. Printing Your Work 10. Introducing Formulas and Functions
Data Analysis (06 Months)
11. Creating Formulas that Manipulate Text 12. Working with Dates and Times 13. Creating Formulas the Count and Sum 14. Creating Formulas that Look Up Values 15. Creating Formulas for Financial Applications 16. Performing Magic with Array Formulas 17. Creating Chart and Graphics 18. Creating Sparking Line Graphics 19. Using Custom Number Formats 20. Using Data Validation 21. Protecting Your Work 22. Importing & Cleaning Data 23. Introducing Pivot Tables 24. Performing Spreadsheet What if Analysis 25. Analyzing Data Using Goal Seeking, Solver and Consolidate 26. Macro & VBA with Macro. 27. Power Query
