Microsoft Excel Career Accelerator
Master Microsoft Excel from beginner to advanced with easy step-by-step lessons. Learn formulas, charts, data analysis, and automation to boost your productivity and career.
Checking price...
Module 1 - Basic Excel
Guided by leading data expert Vivek Dhumal, this module is designed to help you progress from the basics of Excel to using it with near-professional expertise.
A. Module Overview
- Module Roadmap
B. Introduction to Excel
- Session Introduction
- Getting to Know the Excel Workspace
- Organizing Data with Sort and Filter
- Basic Report Formatting
- Using Conditional Formatting
- Advanced Report Formatting
- Page Setup and Printing Options
- Protecting and Naming Files
- Key Takeaways
C. Data Cleaning – Part I
- Session Introduction
- Working with CSV and Delimited Files
- Time-Saving Keyboard Shortcuts
- Basic Formulas
- Advanced Functions
- Cell References and Text Functions
- Logical Formulas
- Creating and Formatting Charts
- Understanding Different Chart Types
- Key Takeaways
D. Data Cleaning – Part II
- Session Introduction
- Creating Pivot Tables
- Analyzing Data Using Pivot Tables
- Applying Filters in Pivot Tables
- Using VLOOKUP
- Common Excel Errors
- Summary
Module 2 - Advanced Excel
Explore more complex Excel functionalities and learn how to conduct detailed analysis efficiently.
A. Module Overview
- Module Roadmap
B. Core Excel Functions
- Session Introduction
- Defining the Problem
- Sort and Filter Techniques
- Text Functions
- Statistical Functions
- Logical Functions
- Conditional Formatting
- Key Takeaways
C. Data Analysis Applications
- Session Introduction
- LOOKUP Functions
- INDEX and MATCH
- Pivot Tables Deep Dive
- What-If Analysis – Part I
- What-If Analysis – Part II
- Key Takeaways
Module 3 - Excel Practice
Hands-on Excel Dataset to apply your Excel data analysis skills.
A. Practice
- Practice Dataset
- Practice Functions Online
Content
Excel Basics Mastery
Learn to navigate Excel and use essential features like sorting, filtering, and formatting confidently.
Advanced Excel Functions
Master complex formulas, pivot tables, VLOOKUP, INDEX-MATCH, and data analysis techniques.
Data Visualization
Create insightful charts, dashboards, and advanced visualizations for clear data storytelling.
Automation with Macros
Record and use macros to automate repetitive Excel tasks efficiently.
Statistical & What-If Analysis
Perform statistical calculations and scenario analysis to support decision-making.
Real-world Project Application
Apply Excel skills to analyze sales data through a comprehensive superstore sales project.
Working Professionals
Data Analysts
College Students
Business Owners
Job Seekers
Data Science Aspirants