Beginner Friendly Beginner → Advanced
Excel & Advanced Excel
Master Excel for Data Analysis, Reporting & Dashboarding
8 weeks 8 Modules Weekend Batch 389+ enrolled
About This Course
Learn Excel from fundamentals to advanced data analysis techniques including formulas, pivot tables, data cleaning, and interactive dashboard creation.
Excel fundamentalsAdvanced formulasPivot tablesData cleaningDashboarding
What You'll Achieve
Automate reports
Analyze business data
Build dashboards
Course Curriculum
Week 1
Excel Fundamentals
- Introduction to Excel environment
- Basic navigation & interface
- Data entry & formatting
- Sorting, filtering, and data validation
- Understanding data types
Week 2
Core Functions & Data Handling
- Basic functions (SUM, COUNT, AVERAGE, etc.)
- Logical functions (IF, AND, OR, NOT)
- Text functions (LEFT, RIGHT, MID, TRIM, etc.)
- Date & time functions
- Named ranges & structured references
Week 3
Advanced Functions & Lookups
- VLOOKUP, HLOOKUP (use cases & limitations)
- INDEX, MATCH (advanced lookup techniques)
- Nested functions
- Dynamic formulas
- Introduction to data modeling in Excel
Week 4
Data Analysis & Transformation
- Data cleaning techniques
- Handling large datasets
- Conditional formatting
- Data manipulation using formulas
- Preparing data for analysis
Week 5
Pivot Tables & Reporting
- Introduction to Pivot Tables
- Row, column, values, and filters
- Data summarization & aggregation
- Creating summary reports
- Cross-tab analysis
Week 6
Advanced Pivot & Data Analysis
- Calculated fields in Pivot Tables
- Grouping & binning
- Slicers & timelines
- Changing report layouts
- Advanced data analysis techniques
Week 7
Data Visualization & Dashboarding
- Chart types (bar, line, pie, scatter, etc.)
- Choosing the right chart
- Chart formatting & customization
- Introduction to dashboards
- Designing interactive dashboards
Week 8
Advanced Dashboarding & Projects
- Building dynamic dashboards using Pivot controls
- Using slicers, timelines, and interactivity
- Advanced charts (waterfall, thermometer, etc.)
- Dashboard design best practices
- End-to-end business dashboard project
Who Is This For?
Beginners
Business professionals
Analysts
Meet Your Instructor
What Our Students Say
“I had a highly positive experience completing the SQL course with AnalyticShala. The instructor is very knowledgeable, clear and responsive, ensuring an engaging and effective learning experience.”
SameerData Analyst @ Infosys
“I recently took Data Analytics using Python classes with AnalyticShala, and my experience was exceptional. The course provided a deep and practical understanding of the subject.”
NehaManager @ Genpact