Microsoft Excel Crash Course 2026: Masterclass for Weekend

Name: Microsoft Excel Crash Course 2026: Masterclass for Weekend
Rating: 4.2 (104 reviews)

A Beginner's Crash Course in Microsoft Excel 2026 - Learn Excel Formulas, Pivot Tables, Charts, Tips and Tricks

Created byMetla Sudha Sekhar

Last updated 12/2025

English

English [Auto],

What you'll learn

Be Confident in Microsoft Excel concepts
Learn new techniques and formulas to tackle tasks faster and better in Excel
Reduce the complexity of your spreadsheets
Apply the right tools for a quick solution on a given task
Learn one of the most powerful Microsoft Excel that exists today
Master essential Excel formulas for data statistics
Aggregation results by applying Pivot table creations for analysis
Create eye-catching visual charts like a flash with handson
Develop skills in real-world functionality on Excel formulas on your sheet
Learn to create drop-down list item functionality
learn what is Generative AI for future learning
Participate in Practice test to test your learning skills
Discover and use the top AI tools that every professional should know

Course content

8 sections • 61 lectures • 5h 36m total length

Introduction3:38
Explore Excel fundamentals through practical, hands-on exercises, with formulas and techniques explained in an online tutorial that speeds up learning and enables real-time problem solving.
Getting started on Windows, macOS, Android, and IOS1:33
you will learn which operation to choose to start learning and working your favorites' operating system
How to ask great questions1:58
you will know how to ask a great question you may face in course training duration
FAQ1:29
here you will know the basic frequently asked questions
Start Excel6:56
you will learn how to start to excel in Microsoft windows operating systems
DOWNLOAD these Files First0:02
Download these demos excel files and practice all lectures to get ready to work in real-world corporate office environments.
To actually learn and use new Excel techniques, you need to apply them at every opportunity you get in your own spreadsheets, even if that means it will take you longer the first time. In the long run, it will mean time-saving and robust spreadsheets. Take notes when you watch each tip and formula and think about your own Excel files and where you could apply these.
learn what is Generative AI for future learning14:06
Generative artificial intelligence is artificial intelligence capable of generating text, images, videos, or other data using generative models, often in response to prompts. best ai tools are chatgpt, tabnine for developers, and more
Best Practices for Learning Online Course5:14
You will learn how to learn online courses in a more productive way.

Overview of top Excel tips3:30
you will learn top tips and basic overview of these
Add numbers like a pro8:56
Learn to add numbers like a pro in Excel by using autosum, the sum function across ranges, and conditional sums with sumif.
Save time by filling cells automatically4:54
Did data enter into one column? Split it4:52
Learn how to split data into first and last names in Excel using flash fill, autofill, and text-to-columns, with shortcuts like Ctrl+E to speed up data separation.
Switch data around by transposing it5:50
Sort and filter for quick results6:40
Learn to sort data from smallest to largest and filter to show only the needed values, using department and color filters for quick results.
Create a data table for tasks to make it easy5:21
Make drop-down list7:31
Quick Data Analysis6:22
Great charts for your visualization4:43
Pivot Tables for Data Analytics6:08

Introduction1:14
Basic formula operations6:14
Master basic formula operations in Excel by learning how to insert functions, use auto sum, and explore built-in categories like financial, logical, and text functions for real-world data tasks.
Mathematical functions level119:54
Mathematical functions level212:23
Text functions level19:07
Text functions level212:56
Logical functions11:03
Date time functions6:20
V Lookup formula12:12
HLookup formula4:07
Learn how to use HLOOKUP for horizontal lookups in Excel, retrieving employee ID and salary from a master data table with exact and approximate matches.
HLookup + Match formula8:34
Match + Index formula5:21
Learn to use index + match in excel to retrieve salary data from a master table by matching employee id, an alternative to vlookup.
Practice Test Quey

Introduction1:45
Split Text into columns7:03
Flash Fill7:03
Master flash fill in excel to quickly extract digits, text, and names using left, right, and middle operations, automate with ctrl+e, and concatenate names.
Remove Duplicates7:47
Master removing duplicates in Excel with data tools, headers, and column selections, then use advanced filter and conditional formatting to isolate or copy unique records.
Data Validation6:34
Learn how to enforce clean data in Excel by applying data validation rules to cells, setting criteria, messages, and error alerts for numbers, text, dates, and more.
Get - import Data from Text5:38
Get - import Data from CSV3:22

Introduction1:08
Learn how to create pivot tables, adjust value field settings, and format numbers with decimals using the pivot table design wizard.
Creating Pivot Table6:43
Create a pivot table from clean source data to summarize sales by region and name, using rows, columns, and values, with drag-and-drop of fields and refresh when the data changes.
Value field settings4:06
Learn to configure value field settings in pivot tables to summarize data with count, average, max, min, and standard deviation, and to customize totals and number formats.
Number format2:28
Pivot Table Design3:20
Excel Exercise1:29
Solution for Excel Exercise1:33

Introduction1:12
Excel Charts – Categories2:30
Explore Excel chart categories, including column, bar, line, pie and donut charts, plus advanced types like sunburst, histogram, scatter, waterfall, stock, and map charts, accessed via insert charts.
Elements of a chart4:12
Easy way to create charts1:55
Column or Bar charts4:21
Formatting charts3:37
Line charts2:13
Area charts2:03
Pie and Doughnut charts3:47
Learn to create pie and donut charts in Excel by selecting data, inserting pie or donut charts, and adjusting data ranges, slice separation, and chart elements like data labels.
Format Area Plot or XY chart7:33
Scatter or bubble charts2:08

Requirements

You will need a PC with any version of Excel installed
No prior technical experience is required! All you need is a computer!

Description

The "Microsoft Excel Crash Course 2026: Masterclass for Weekend" is your fast track to mastering Excel in just a weekend. Designed for beginners and professionals alike, this comprehensive course equips you with the skills to harness the full power of Excel for data management, analysis, and visualization.

In this hands-on crash course, you’ll start with the basics of Excel, learning how to navigate the interface, create and format worksheets, and organize data efficiently. Quickly progress to mastering essential features like formulas, functions, and pivot tables to analyze data with ease.

update: Learn the top AI tools every professional needs to boost productivity

Discover how to create dynamic charts and graphs to visually represent data and share insights effectively. Explore math formulas, data validation, and filters to enhance your datasets and make them more interactive.

The course also introduces advanced topics, such as VLOOKUP, HLOOKUP, INDEX-MATCH, and other critical functions that save time and improve accuracy. Learn to automate tasks with macros, and gain insights into Excel’s data analysis tools for more sophisticated workflows.

By the end of this weekend masterclass, you’ll confidently manage and analyze data, build professional-grade spreadsheets, and create stunning visual reports. Whether you're preparing for a job, tackling business challenges, or improving productivity, this crash course is your ultimate guide to Excel mastery.

Make the most of your weekend. Enroll now and unlock the full potential of Microsoft Excel!

Who this course is for:

Working Professionals beginning their Data Analytics
Anyone curious to master excel from beginner to Advanced in a short span of time
Anyone interested in learning the quick Excel concepts
Anyone who wants to grasp the concept with real-world examples of Excel Data Analytics
Anyone about to join their first corporate job

Microsoft Excel Crash Course 2026: Masterclass for Weekend

What you'll learn

Explore related topics

Course content

Introduction8 lectures • 35min

Future Essential AI Tools for Every Professional1 lecture • 5min

Top 10 Excel Tips to Save You Time11 lectures • 1hr 5min

Excel essential functions12 lectures • 1hr 49min

XLookup only for Excel 2021 and Office 3654 lectures • 26min

Get Data and tools7 lectures • 39min

Pivot Tables7 lectures • 21min

Excel Charts11 lectures • 36min

Requirements

Description

Who this course is for: