Microsoft Excel Mastery: Learn from Basics to Advanced

Name: Microsoft Excel Mastery: Learn from Basics to Advanced
Rating: 5.0 (6 reviews)

Learn Excel from scratch: formulas, Pivot Tables, charts, dashboards, and data analysis for real-world use.

Created byAarohi Singla

Last updated 5/2025

English

What you'll learn

Master Excel from scratch and build powerful spreadsheets with confidence
Format cells, tables, and reports like a professional analyst
Automate your workflow with advanced sorting, filtering, and data validation
Import and connect data from text files, databases, cloud, and web sources
Clean, transform, and prepare data effortlessly using Power Query
Create stunning charts and dynamic visualizations for impactful reporting
Dominate essential Excel functions like IF, VLOOKUP, INDEX, MATCH, and more
Build interactive Pivot Tables and slicer-driven dashboards
Design KPI dashboards to monitor business metrics in real time
Work with Date, Time, Text, Numeric, and Statistical functions like a pro
Boost your Excel speed with productivity hacks and best practices
Solve real-world business problems through hands-on Excel projects

Course content

7 sections • 28 lectures • 16h 36m total length

Excel Essentials: Your First Step to Mastering Data22:16

Introduction to Excel and Its Components28:57
Understand the Excel environment, workbooks, worksheets, and navigate cells, ranges, and tables confidently.
Formatting Cells and Data31:24
Master number formats, date formats, paste special, and make your spreadsheets clean and professional.
Navigating Excel and Conditional Formatting20:29
Enhance your workflow with fonts, styles, borders, and apply conditional formatting rules to visualize your data smartly.
Advanced Sorting, Filtering, and Data Validation35:58
Learn powerful techniques to sort, filter, validate data, remove duplicates, and prepare your datasets for analysis.

Importing Data into Excel37:17
Bring data into Excel from TXT, CSV, Excel files, databases, SQL servers, Oracle, and cloud sources easily.
Hands-On with Data Reading & Connections21:54
Connect, manage, and troubleshoot real-world data sources for smoother analysis workflows.
Power Query & Data Exporting21:23
Use Power Query to clean and transform data, then export into multiple formats for reporting and sharing.
Basic Charts32:15
Create essential visualizations like bar charts, pie charts, and doughnut charts to represent your data clearly.
Intermediate Charts46:17
Visualize trends and comparisons with stacked bar charts, line charts, and combo charts.
Advanced & Dynamic Charts42:16
Build advanced visualizations like scatter plots, bubble charts, speedometers, and dynamic charts for dashboards.

Cell References & Logical Conditions27:05
Master relative/absolute references and logical IF conditions for smart formula building.
Lookup Functions – Vertical & Match-Based44:41
Retrieve data efficiently using VLOOKUP, MATCH, and powerful combined lookup techniques.
Advanced Lookups & Navigation Tools33:52
Unlock complex referencing with INDEX, OFFSET, HLOOKUP, and dynamic navigation strategies.
Data Modeling with Excel Functions34:59
Apply lookup and logical functions to real-world datasets to build strong Excel data models.

Pivot Table Foundations21:56
Understand how to create basic pivots, differentiate between dimensions and measures, and build summaries.
Building Pivot Tables21:23
Organize data into rows, columns, filters, and values to extract deep insights.
Advanced Pivot Tools & Interactivity42:46
Use slicers, form controls, and aggregation techniques to make your pivot tables powerful and interactive.
KPI Metrics & Dashboards38:36
Design real-world dashboards integrating KPIs to track and present business performance clearly.
Practice Session: Pivot Tables & Dashboards18:33
Apply your skills to create Pivot Tables, use advanced features like slicers and running totals, and design a dashboard with KPIs to visualize business performance.

Pivot Table Field Operations & Value Summarization53:16
Learn how to organize Pivot Table fields and summarize data using functions like sum, count, and average. This lesson focuses on setting up fields and customizing value summaries.
Advanced Calculations – Rankings, Running Totals & More43:00
Explore advanced Pivot Table features such as running totals, rankings, and calculated fields to add deeper insights and custom metrics to your data.
Pivot Enhancements & Styles48:18
Refresh connections, create calculated fields, and apply professional pivot layouts and slicer designs.
Data Model & KPI Design50:35
Model multi-table data and design dashboards based on KPI performance indicators.
Real-Time Dashboards with KPIs48:37
Build real-time, business-driven dashboards like a World COVID Dashboard for live reporting.

Date & Time Functions38:15
Master date and time functions for project timelines, aging analysis, and custom formatting.
Text & Character Functions39:11
Transform, clean, and manipulate text data for reporting and data cleansing.
Numeric & Statistical Functions with Practical Examples51:18
Apply powerful numeric and statistical functions in real-world scenarios to analyze and interpret data effectively.

Requirements

No prior experience is required to join our Data Analytics course—it's beginner-friendly and open to all.
We’ll teach you everything from basic formulas to advanced functions step by step. All you need is a laptop with Excel and a desire to learn!

Description

Welcome to "Full Excel Journey: Master Basics to Advanced Functions."
This comprehensive course is your ultimate guide to mastering Excel for data analysis, whether you're a beginner or looking to level up your skills. Through hands-on lessons and practical examples, this course will empower you with the knowledge to tackle data analysis tasks efficiently and effectively.

What You’ll Learn:

Excel Fundamentals:
- Understand the Excel interface and its essential features.
- Master basic data entry and formatting techniques.
- Learn how to use simple functions like SUM, AVERAGE, and COUNT to start your data analysis journey.
Data Manipulation:
- Organize and clean your data with sorting and filtering techniques.
- Apply conditional formatting to highlight key data points.
- Master tools to manage large datasets and improve their usability.
Advanced Excel Functions:
- Learn how to use powerful functions like VLOOKUP, INDEX-MATCH, and more.
- Understand logical functions (IF, AND, OR) to solve complex problems.
- Discover advanced techniques such as array formulas for greater efficiency.
Data Visualization:
- Create and customize various charts, graphs, and pivot tables.
- Visualize data insights effectively to communicate findings clearly.
- Learn best practices for presenting data visually.
Real-World Data Analytics:
- Apply your skills in real-world scenarios, including financial analysis and large dataset handling.
- Work with practical examples of report generation and decision-making.
- Understand how to leverage Excel for day-to-day business analytics.

By the end of this course, you’ll have a comprehensive understanding of Excel’s most powerful features, allowing you to analyze and present data like a pro in any industry.

Who this course is for:

This Excel course is for anyone who wants to build strong spreadsheet skills from the ground up. It’s perfect for students, job seekers, working professionals, small business owners, or anyone looking to manage data better. Whether you're from a non-technical background or switching careers, this course is for you.

Microsoft Excel Mastery: Learn from Basics to Advanced

What you'll learn

Explore related topics

Course content

Introduction to Data Analytics1 lecture • 22min

Excel Basics and Data Management4 lectures • 1hr 57min

Importing, Connecting, and Visualizing Data6 lectures • 3hr 21min

Excel Functions and Data Modeling4 lectures • 2hr 21min

Pivot Tables and Dashboard Building5 lectures • 2hr 23min

Advanced Pivoting and KPI Dashboards5 lectures • 4hr 4min

Excel Deep-Dive: Functions and Practical Application3 lectures • 2hr 9min

Requirements

Description

Who this course is for: