arrow_back
Module 1: Introduction to Excel in the Workplace
Mastering Excel for Real-World Applications
Role of Excel in business functions
Exploring the Excel interface & data types
Shortcuts and time-saving tricks
Module 2: Data Entry & Cleaning
Importing data (from files, web, etc.)
Removing duplicates and blank rows
Text-to-columns, trimming, formatting
Module 3: Essential Excel Functions
Logical: IF, AND, OR
Lookup: VLOOKUP, XLOOKUP, INDEX/MATCH
Text: LEFT, RIGHT, CONCATENATE, TEXTSPLIT
Math: SUMIF, AVERAGEIF, ROUND, INT
Module 4: Data Analysis Essentials
Sorting, filtering, and custom views
Creating and using tables
Conditional formatting for insights
Named ranges & formula auditing
Module 5: Pivot Tables & Business Insights
Creating pivot tables from scratch
Grouping, filtering, and summarizing
Calculated fields
Pivot charts for visual insights
Module 6: Dashboards for Decision-Making
Designing a basic interactive dashboard
Using slicers and dynamic charts
Best practices in layout, color, and storytelling
Case: Sales or HR Dashboard
Module 7: Practical Case Studies & Projects
Finance: Budget vs Actual Analysis
HR: Attrition and Leave Tracker
Operations: Inventory Movement Analysis