Microsoft Excel : Ultimate Crash Course For Professionals

From Zero to Hero in Excel : Learn Charts, Data Cleaning, Look Ups, Pivot Tables, Power Query, Dashboard & Copilot

What you'll learn

Understand and navigate the Excel interface confidently, using ribbons, worksheets, and cell formatting for professional data handling.

Master Core Mathematical & Logical Functions and formulas such as SUM, AVERAGE, IF, AND, OR and nested logic for dynamic calculations.

Work with Date & Time Functions Professionally and handle project timelines and reports using DATE, TODAY, NETWORKDAYS, and other essential date functions.

Work with VLOOKUP, HLOOKUP, XLOOKUP, and INDEX-MATCH to extract and match data across tables.

Summarize large datasets using Pivot Tables and visualize the summaries with Pivot Charts for quick decision-making.

Model and Analyze Data Using Power Pivot, Create relationships, KPIs, and DAX calculations across multiple tables for powerful, scalable data models.

Connect to diverse data sources, clean and transform data, and automate refresh processes using Power Query.

Design Professional Dashboards for Reporting by using visuals, slicers, pivot charts, and KPIs into interactive dashboards to present performance insights.

Automate repetitive tasks using macro recording and basic VBA to save time and reduce manual effort.

Use Excel’s AI tools and Microsoft Copilot to auto-generate summaries, formulas, visuals, and insights with ease.

Requirements

No prior Excel experience is required—this course starts from the basics and builds up to advanced topics.

Basic computer literacy and comfort with using a keyboard, mouse, and navigating files and folders are expected.

Access to a computer or laptop with Microsoft Excel (preferably Office 2016 or later, or Microsoft 365) is necessary.

A willingness to practice regularly and apply the concepts to real-world data scenarios will help maximize learning.

An interest in improving productivity, analyzing data, or creating reports will make the learning experience more impactful.

Description

Master Excel like a pro — just in 9 hours.This comprehensive crash course is designed specifically for working professionals who want to supercharge their Excel skills for real-world productivity, decision-making, and data analysis.Whether you’re in finance, operations, HR, sales, or project management, this course will help you unlock Excel’s full potential — from basic spreadsheets to advanced analytics — using the latest tools and techniques trusted by top analysts.What You'll Learn:Excel Fundamentals:Navigate the Excel interface, enter and format data, use essential formulas, and apply logical functions effectively.Cell Referencing Techniques:Master relative, absolute, and mixed referencing to build flexible and reusable formulas.Data Cleaning & Management:Learn practical Excel methods to clean, organize, and structure raw data for reliable analysis.Data Protection & Validation:Safeguard your worksheets using validation rules, sheet protection, and controlled access features.Lookups & Data Consolidation:Retrieve and consolidate data using VLOOKUP, HLOOKUP, XLOOKUP, INDEX, and MATCH functions.Sorting, Filtering & Conditional FormattingOrganize, filter, and visually highlight trends, anomalies, and key metrics in dynamic reports.Charts & Data Visualization:Create impactful Excel charts, Pivot Charts, and interactive dashboards to communicate data stories clearly.Data Modeling, Pivot Tables & Power Pivot:Analyze and summarize large datasets with powerful pivot tables and Power Pivot for advanced modeling.Power Query for ETL:Automate data extraction, transformation, and loading tasks with Power Query — a must-know tool for professionals.Design Professional Dashboards for ReportingCombine visuals, slicers, pivot charts, and KPIs into interactive dashboards to present performance insights.Macros & Automation with VBAEliminate repetitive tasks by recording macros and understanding basic VBA scripting.AI Features & Excel CopilotExplore Excel’s latest AI tools including Copilot, to automate insights, perform smart analysis, and accelerate reporting.Why This Course is Different:Built for busy professionals with no fluff, just impactCovers end-to-end Excel workflows from raw data to presentationLearn through real-life business examples and exercisesSuitable for all versions of Excel (2016 to Microsoft 365)Whether you’re starting from the basics or aiming to become an Excel power user, this course gives you the knowledge and confidence to handle any task with ease — and stand out at work.Enroll now and take the fast track to Excel mastery.

Overview

Section 1: Introduction and Download Course Resources

Lecture 1 Introduction to the Course

Lecture 2 Download All Courses Resources

Section 2: Getting started with Excel

Lecture 3 Excel Interface

Lecture 4 Navigation and Selection Keyboard Shortcuts & Download Resources

Lecture 5 Functions in Excel

Lecture 6 Mathematical Functions in Excel

Lecture 7 Logical Functions in Excel

Lecture 8 Date Functions in Excel

Lecture 9 Range Vs Table

Lecture 10 Data Formatting and Number Formats in Excel

Lecture 11 Database Functions and Subtotal in Excel

Lecture 12 Relative, Absolute and Mixed Referencing in Excel

Lecture 13 Tips from Ranjit

Section 3: Complex Logical and Nested Formulas in Excel

Lecture 14 IF,AND,OR,NOT & Download Resources

Lecture 15 Nested IF and IFS

Lecture 16 SUM IF and COUNT IF

Lecture 17 SUMIFS and COUNTIFS

Section 4: Data Cleaning Techniques in Excel

Lecture 18 Remove Errors and Blanks & Download Resources

Lecture 19 Remove Duplicates

Lecture 20 Dividing Data from Single Column

Lecture 21 Replace and Substitute

Lecture 22 Left,Right & Mid

Lecture 23 Concat,Find and Replace

Lecture 24 Trim & Case Change

Section 5: Data Visualization and Charting in Excel

Lecture 25 Introduction to Excel Charts. Pie Chart & Download Resources

Lecture 26 Elements of a Chart

Lecture 27 Column Chart

Lecture 28 Column chart to compare fields

Lecture 29 Bar Chart

Lecture 30 Line Chart

Lecture 31 Combination Chart

Lecture 32 Pareto Chart

Lecture 33 Scatter Plot

Lecture 34 Sparklines

Lecture 35 Tips from Ranjit

Section 6: Named Ranges in Excel

Lecture 36 Creating and Using Named ranges & Download Resources

Section 7: Look Up And Reference Functions In Excel

Lecture 37 VLOOK UP to Search for a Value in Column & Download Resources

Lecture 38 VLOOKUP & MATCH

Lecture 39 INDEX & MATCH for Vertical & Horizontal Look Up

Lecture 40 HLOOK UP & MATCH to search for a value in the top row

Lecture 41 XLOOK UP to Search in Range or Array

Lecture 42 Approximate Match in Look Up Functions

Lecture 43 Tips from Ranjit

Section 8: Data Protection and Data Validation in Excel

Lecture 44 Encrypting File with Password & Download Resources

Lecture 45 Protecting Worksheet & Allow Edit Ranges

Lecture 46 Protecting Workbook

Lecture 47 Data Validation

Section 9: Sorting and Filtering Data

Lecture 48 Sorting and Custom Sort & Download Resources

Lecture 49 Filtering Data and Using Advanced Filters for complex criteria

Lecture 50 Filter & Sort Functions

Section 10: Conditional Formatting and Data Consolidation

Lecture 51 Conditional Formatting using Icons ,Data Bars & Download Resources

Lecture 52 Conditional Formatting using Rules

Lecture 53 Conditional Formatting Using Formula

Lecture 54 Data Consolidation

Lecture 55 Tips from Ranjit

Section 11: Pivot Tables and Pivot Charts

Lecture 56 Learning Pivot Tables & Download Resources

Lecture 57 Value Field Settings in Pivot Tables

Lecture 58 Pivot Chart & Slicer

Lecture 59 Tips from Ranjit

Section 12: Data Modeling using Power Pivot

Lecture 60 Introduction to Data Model & Download Resources

Lecture 61 Creating a Data Model in Power Pivot

Lecture 62 Creating Pivot Tables & Pivots Charts from Data Model

Lecture 63 Tips from Ranjit

Section 13: Excel Business Dashboard using Power Query, Power Pivot and Charting

Lecture 64 Excel Dashboard Introduction and Data Import in Power Query (Download Resources)

Lecture 65 Data Cleaning in Power Query

Lecture 66 Data Modelling in Power Pivot

Lecture 67 Creating Layout of Dashboard

Lecture 68 Key Performance Indicators in Excel Dashboard

Lecture 69 Use of Doughnut Chart to Present Data

Lecture 70 Column Chart and Bar Charts

Lecture 71 Slicers, Findings and Observations, View Settings

Lecture 72 Tips from Ranjit

Section 14: Macros for Automation and understanding VBA code of macro

Lecture 73 Recording, Running Macros & Download Resources

Lecture 74 Understanding Visual Basics Code of Recorded Macros

Section 15: AI Features in Excel

Lecture 75 Flash Fill

Lecture 76 Insert Data from Picture

Lecture 77 Analyze Data in Excel

Lecture 78 Recommended Charts in Excel

Lecture 79 Forecast

Section 16: Copilot in Excel : AI Assistant

Lecture 80 Copilot to Sort, Filter, Highlight Data in Excel & Download Resources

Lecture 81 Generate formulas in Excel with Copilot

Lecture 82 Text Insights using Copilot

Lecture 83 Data Insights using Copilot

Lecture 84 Data Visualization with Copilot in Excel

Lecture 85 Tips from Ranjit

Working professionals looking to improve their Excel skills for data handling, reporting, and productivity.,Students and fresh graduates aiming to build strong Excel skills for internships, jobs, or higher education.,Data analysts and business professionals who want to master Excel tools for data cleaning and analysis.,HR professionals needing to manage employee data, reports, and dashboards efficiently.,Finance and accounting professionals working with budgets, forecasts, and financial models in Excel.,Project managers who want to track progress, timelines, and KPIs using Excel dashboards.,Entrepreneurs and small business owners seeking to analyze performance and make data-driven decisions.,Anyone interested in learning Excel from scratch and progressing to advanced tools like Power Query, Pivot Tables, and Copilot.