Advance Excel Course
Advanced Excel Course Is A Training Program That Provides Individuals With An In-Depth Understanding Of The Advanced Features And Functionalities Of Microsoft Excel. Participants Will Learn How To Use Advanced Formulas, Create Complex Charts And Graphs, Analyse Data Using Pivot Tables, And Automate Tasks With Macros.
Microsoft Excel Is A Widely Used Tool For Data Analysis And Management, And The Advanced Excel Course Is Designed To Help Individuals Maximise The Potential Of Excel In Their Work. This Course Is Ideal For Professionals Who Work Extensively With Excel And Want To Enhance Their Skills.
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
