Excel (Advance)

Advanced Excel courses can be a great way to improve your Excel skills and become proficient in using advanced features for data analysis and reporting.

By the end of the course, you'll have a solid understanding of advanced formulas and functions, data analysis, macros and VBA, charts and graphs, data validation, advanced formatting, collaboration and sharing, and more.

Additionally, you'll be able to apply these skills in a professional setting, making you a valuable asset to any business or organization that uses Excel for their operations.

Course Modules

• Learn Excel Basics from Scratches
• Introduction to Excel Interface
• Font Formatting & Alignment Tools
• Number Formatting Options
• Navigation Shortcuts
• Lists in Excel & Creating Custom Lists
• Sorting In Filtering
• Conditional Formatting
• Format Painter
• Alt Key Customs Short cut creation
• Tables & Importance of Tables
• Alt key Shortcuts
• 60 + Advanced Formulas Mastery
• Advanced Lookup Formulas
• Date & Time-Based Formulas
• Text Based Formulas
• Array Formulas
• Modern Spill Formulas
• Switch & Text Join Formula
• Unique Formula
• Concatenate Formula
• Financial Formula
• Statical Formula
• Common Errors & Solutions
• Understanding the Importance of Pivot Table
• Understanding Filed list Contents
• Clear, Select & Move Functions
• Refresh Pivot tables
• Sorting, Filtering & Grouping Data
• Formatting in pivot tables
• Pivot tables layout
• Calculated fields
• Pivot charts
• Slicer
• Timelines
• Interactivity of slicers
• 4 mega case studies