Microsoft Excel Masterclass: From Beginner to Advanced

Name: Microsoft Excel Masterclass: From Beginner to Advanced
Rating: 4.0 (12 reviews)

Excel Basics To Advanced Formulas, Functions, Data Analysis, PivotTables and Reporting Made Easy

Created byMuhammad Riaz Uddin

Last updated 2/2026

English

English [Auto],

What you'll learn

Navigating the Excel interface
Understanding Workbooks, Worksheets, Rows, Columns, and Cells
Using Basic Shortcuts for Efficiency
Formatting Cells (font, size, color, borders)
Adjusting Row and Column Sizes
Data Validation Techniques (drop-down lists, data types)
Using SUM, AVERAGE, COUNT, MIN, MAX
Understanding Relative, Absolute, and Mixed References
Logical Functions: IF, AND, OR
Text Functions: CONCATENATE, LEFT, RIGHT, MID, LEN
Lookup Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP
Using Slicers and Timelines for Interactive Analysis
Dynamic Charts Using Named Ranges and more

Course content

4 sections • 23 lectures • 2h 24m total length

Navigating the Excel interface7:04
Explore the Microsoft Excel interface from a beginner perspective, navigating the ribbon, tabs, sheets, and essential tools for formatting, data management, formulas, and layout.
Understanding Workbooks, Worksheets, Rows, Columns, and Cells5:13
Explore the core Excel concepts of workbooks, worksheets, rows, columns, and cells, including active cells and basic data organization from a beginner-friendly perspective.
Basic Data Entry and Editing5:11
Master basic data entry in Excel by organizing data into rows and columns with month, name, and age, and using autofill to extend months and edit data in a worksheet.
Using Basic Shortcuts for Efficiency5:01
Master essential Excel shortcuts to navigate data quickly, edit cells efficiently, and format text with bold, italic, and underline, boosting data-entry speed.

Formatting Cells (font, size, color, borders)6:01
Master cell formatting in Excel by adjusting font, size, color, borders, and fill; apply bold, italic, underline, strike through, and superscript or subscript, plus currency or date formats; use Ctrl+1.
Adjusting Row and Column Sizes6:56
Learn how to adjust row and column sizes in Excel to improve readability and appearance. Explore auto fit and manual width and height adjustments.
Using Format Painter and Paste Special6:12
Learn to format cells using the Format Painter and Paste Special to copy formatting, borders, formulas, values, and other data across sheets.
Data Validation Techniques (drop-down lists, data types)6:09
Apply data validation in Excel to enforce numeric constraints, such as whole numbers between 1 and 24, manage drop-down lists and data types, and identify invalid data.
Sorting and Filtering Data5:03
Apply sorting and filtering in Excel to organize data by alphabetical order or month, expand selections, and use header filters with dynamic sort and dynamic filter options.
Freezing Panes and Splitting Windows for Better Navigation4:28
Learn to freeze panes and split windows in Microsoft Excel to keep headers visible and improve data entry, including freezing the top row or first column.

Introduction to Formulas and Functions6:00
Learn how to use basic Excel formulas to sum, average, and count values with cell references, the fx function picker, and simple data validation steps.
Using SUM, AVERAGE, COUNT, MIN, MAX5:44
Master basic Excel functions by calculating sum, average, maximum, and minimum across a range like F2 to F6, using the function button and the clone button to extend results.
Understanding Relative, Absolute, and Mixed References6:14
Explore relative, absolute, and mixed cell references in Excel, showing how copying formulas changes results, how absolute references lock rows or columns with dollar signs, and how mixed references behave.
Logical Functions: IF, AND, OR5:55
Explore Excel logical functions IF, AND, and OR to evaluate student scores, apply pass/fail rules by average with a 60 cutoff, and flag detentions for scores below 50.
Text Functions: CONCATENATE, LEFT, RIGHT, MID, LEN6:27
Learn how to use Microsoft Excel text functions to combine names and extract data with concatenate, left, right, mid, and len, using practical examples.
Date and Time Functions: TODAY, NOW, DATE, DATEDIF5:41
Learn how to use Excel date and time functions—today, now, and date. Apply DATEDIF to compute ages or months of tenure from birth or hire dates.
Lookup Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP8:54
Explore vlookup and hlookup for vertical and horizontal lookups, then master index, match, and xlookup to retrieve data in any direction with built-in fallback.

Creating and Formatting Tables7:42
Learn how to create and format Excel tables, apply themes, filter and sort by headers, use conditional formatting, and convert tables back to ranges.
Using Conditional Formatting for Data Visualization7:56
Explore conditional formatting in Excel to visualize data with color scales, data bars, icon sets, and custom formulas, highlighting low scores and department-specific trends.
Applying Data Validation Rules12:44
Explore data validation in Excel to enforce input rules, create dropdown lists, and control length, numbers, and dates with practical examples from department lists, score ranges, and custom formulas.
Introduction to PivotTables and PivotCharts5:08
Master pivot tables and pivot charts to rearrange data, drag fields into columns and rows, and visualize results with templates and colors.
Grouping and Summarizing Data in PivotTables3:14
Create pivot tables from your dataset to group and summarize data by date, product, and region. See top-selling products and regional patterns to inform strategy.
Using Slicers and Timelines for Interactive Analysis5:21
Learn to build interactive analyses in Excel by using slicers and a timeline with a pivot table, filtering by region, product, and order date.

Requirements

No experience needed. You'll learn everything from the beginning.

Description

Excel is one of the most essential tools for data management, analysis and decision making in today’s business and academic world. Whether you’re a beginner looking to learn the basics or a professional aiming to master advanced techniques, this course will take you step by step from novice to Excel expert.

In Microsoft Excel Masterclass: From Beginner to Advanced, you’ll learn how to organize, analyze and visualize data efficiently. You’ll work with real-world examples, hands-on exercises, and practical projects that make Excel skills immediately applicable.

What you’ll learn

Excel basics: navigation, formatting, and essential functions
Advanced formulas and functions for data analysis
Creating PivotTables and PivotCharts for summarizing data
Designing professional reports and dashboards
Tips and shortcuts to improve speed and efficiency
Real-world applications for business, finance and personal projects

Why take this course?

Step by step guidance from beginner to advanced
Hands-on, practical exercises for real-world scenarios
Learn at your own pace with lifetime access
Build job ready Excel skills that boost career growth

By the end of this course, you’ll be able to analyze data, create reports and build dashboards like a pro, unlocking the full potential of Excel for business, study or personal use.

Enroll now and start from today.

Who this course is for:

Beginners who want a solid foundation in Excel
Anyone aiming to become proficient in data management and analysis
Students needing Excel skills for academic or research purposes
Professionals looking to improve workplace productivity

Microsoft Excel Masterclass: From Beginner to Advanced

What you'll learn

Explore related topics

Course content

Introduction to Excel4 lectures • 22min

Formatting and Data Organization6 lectures • 35min

Formulas and Functions7 lectures • 45min

Data Analysis Tools6 lectures • 42min

Requirements

Description

Who this course is for: