Duration of the online course: 12 hours and 34 minutes
Become confident in Excel—from your first spreadsheet to advanced techniques that save hours of work. This free online course is designed for anyone who wants to turn messy data into clear, reliable answers, whether you’re studying, managing a business, or working in an office role that depends on accurate reporting. You’ll build a strong foundation in everyday Excel tasks and then progress into the tools that make your work faster, cleaner, and more professional.
You’ll start by learning practical essentials like entering and editing data efficiently, using keyboard shortcuts, formatting numbers correctly, and organizing information across worksheets. As you advance, you’ll work comfortably with cells and ranges, make sense of large datasets using Excel tables, and speed up repetitive tasks with features like AutoFill, custom lists, and Flash Fill—perfect for cleaning up names, dates, codes, and patterns without manual copying.
The course then moves into the core of what makes Excel powerful: formulas. You’ll learn how formulas are built, how Excel calculates results, and how to write dependable expressions using logical functions, math tools, and statistical calculations. From there, you’ll level up with lookup and reference techniques that help you pull the right data from lists, match records, and analyze information across sheets with confidence. You’ll also handle real-world text scenarios using functions that extract, combine, and reshape text, plus date and time formulas that support schedules, timelines, and reporting.
To help you work like a pro, you’ll explore named ranges (including dynamic versions), add safeguards with data validation and drop-down lists, and master sorting and filtering for quick analysis—even when data isn’t perfectly consistent. Finally, you’ll use conditional formatting to spot trends, errors, and key values instantly, making dashboards and reports easier to read and act on. By the end, you’ll be able to build spreadsheets that are accurate, efficient, and ready for real workplace demands.
Video class: Getting Started with Excel | Excel For Beginners | FREE Excel Course
22m
Exercise: What is the keyboard shortcut to move horizontally across multiple columns?
Video class: [FREE Excel Course] Lesson 2 - Data Entry, Editing, and Number Formatting
21m
Exercise: What types of data can Excel hold?
Video class: [FREE EXCEL COURSE] Lesson 3 - Data Formatting in Excel
25m
Video class: [FREE EXCEL COURSE] Lesson 4 - Working with Cells and Ranges
33m
Exercise: What is the purpose of the name box in Excel?
Video class: [FREE EXCEL COURSE] Lesson 5 - Managing Worksheets in Excel
16m
Exercise: Which is NOT a method to navigate worksheets in Excel?
Video class: [FREE EXCEL COURSE] Lesson 6 - Excel Tables Overview
21m
Exercise: What is the keyboard shortcut to create a table in Excel?
Video class: [FREE EXCEL COURSE] Lesson 7 - Auto-fill, Custom Lists, and Flash Fill
13m
Exercise: Autofill can be accessed:
Video class: [FREE EXCEL COURSE] Lesson 8 - Number Formatting in Excel
26m
Exercise: How can you access the Format Cells dialog box in Excel?
Video class: [FREE Excel Course] Lesson 9 - Excel Formula Basics
26m
Exercise: What is the correct order of precedence for operators in Excel formulas?
Video class: [FREE Excel Course] Lesson 10 - Logical Formulas in Excel
23m
Exercise: What does the AND function in Excel return when all logical arguments are true?
Video class: [FREE Excel Course] Lesson 11 - Math Formulas in Excel
33m
Video class: [FREE Excel Course] Lesson 12 - Lookup and Reference Formulas in Excel
46m
Exercise: Which Excel function is used to find the position of a data point in a list?
Video class: Stats Formulas in Excel - Explained with Examples
41m
Exercise: How does the AVERAGE function in Excel handle blank cells?
Video class: [FREE Excel Course] Lesson 14 - Text Formulas in Excel
32m
Exercise: What does the MID function in Excel do?
Video class: [FREE EXCEL COURSE] Lesson 15 - Date & Time Formulas in Excel
40m
Exercise: What is a possible result of the =TODAY() formula?
Video class: 10 Advanced Excel Formula Examples | FREE Excel Course
45m
Exercise: What is a practical way to compare two lists in Excel to identify mismatches?
Video class: Creating Named Ranges in Excel | Dynamic Named Range in Excel | FREE Excel Course
22m
Exercise: How can you create a dynamic named range in Excel?
Video class: Data Validation in Excel | Drop-down lists | FREE Excel Course
31m
Exercise: What can you use to prevent entry of invalid data in Excel cells?
Video class: Data Sorting & Filtering in Excel (Basic + Advanced) | FREE Excel Course
16m
Exercise: Wildcards are used to:
Video class: Excel Conditional Formatting (Overview + Advanced Examples)
25m
Exercise: Where can you find Conditional Formatting in Excel?
12 hours and 34 minutes of online video course
Digital certificate of course completion (Free)
Exercises to train your knowledge
100% free, from content to certificate
Ready to get started?Download the app and get started today.
Install the app now
to access the courseOver 5,000 free courses
Programming, English, Digital Marketing and much more! Learn whatever you want, for free.
Study plan with AI
Our app's Artificial Intelligence can create a study schedule for the course you choose.
From zero to professional success
Improve your resume with our free Certificate and then use our Artificial Intelligence to find your dream job.
You can also use the QR Code or the links below.

Free CourseExcel for Beginners: 2-Hour Crash Course in Formulas, Charts and Pivot Tables
2h09m
30 exercises

Free CourseMicrosoft Access for Beginners: Building Your First Database
6h19m
20 exercises

Free CourseGoogle data studio
3h42m
11 exercises

Free CourseWord for beginners
43m
8 exercises

Free CourseWord
1h46m
25 exercises

Free CoursePowerPoint
2h15m
22 exercises

Free CourseGoogle workspace full course
7h58m
6 exercises

Free CoursePowerPoint for beginner
1h51m
24 exercises

Free CourseWord 2010
4h24m
16 exercises

Free CourseExcel for beginners
54m
9 exercises
Thousands of online courses in video, ebooks and audiobooks.
To test your knowledge during online courses
Generated directly from your cell phone's photo gallery and sent to your email
Download our app via QR Code or the links below::.
+ 10 million
students
Free and Valid
Certificate
60 thousand free
exercises
4.8/5 rating in
app stores
Free courses in
video and ebooks
Course comments: Excel basic to advanced
Students found the course excellent, beginner-friendly, and easy to follow, with clear teaching and practical Excel skills. Many said it’s very helpful for daily use; a few noted minor issues like video clarity and certificate concerns.
LONEWOLF GAMING
I only saw 6 videos till now but this course is really outstanding u had covered each and every detail of excel.
Atharva Shile
Nicely taught by the respective sir. Really was an awesome experience and the introduction part was absolutely a masterpiece. What a keen teaching!!!
Jaymin Baraiya
Course provides knowledge and partical use of MS Excel. Its makes easier to understand and use Excel.
Dyniesha Brown
Very informative and it's set at an easy to learn pace and beginner friendly . Ihope It's really real and I can get an actual certificate.
Juanita Phiri
very helpful as i use excel on a regular basis
Amit kumar Shaw
I think no one can teach better than him
pratiksha anil gujar
Excellent course...!!!
Jakey Barua
it's really helpful. . .
Tordzro Daniel
very nice course
Balbulee Raphael
very understandable,