Advanced Excel Course

Advanced Excel course is offered by Computer Age. Computer Age Group of Institutions, Pioneer and most reputed Computer and Allied Training Institutions operating since 1993.

We are committed to conduct Industry standard Computer courses to satisfy the students and professionals to make successful career in the Computer Field.

Content:

• 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