Free Course Image Excel basic to advanced

Free online courseExcel basic to advanced

Duration of the online course: 12 hours and 34 minutes

4.79

StarStarStarStarStar

(222)

Upgrade your Excel skills fast with a free online course—tables, formulas, lookups, and automation tools to boost productivity and career value.

In this free course, learn about

  • Excel interface basics, workbooks/worksheets, and navigation shortcuts
  • Data types, efficient data entry/editing, and using the Name Box to jump to ranges
  • Cell/range operations and formatting: fonts, alignment, borders, fills, and styles
  • Number formats and the Format Cells dialog (currency, percent, dates, custom formats)
  • Worksheet management: add/rename/move/copy/delete sheets and navigate between them
  • Excel Tables: create (Ctrl+T), structured references, and table benefits
  • AutoFill, Custom Lists, and Flash Fill to generate and clean data quickly
  • Formula fundamentals: operators, references, and order of precedence
  • Logical functions like IF/AND/OR and how they evaluate TRUE/FALSE conditions
  • Math, statistical, text, and date/time functions (e.g., AVERAGE, MID, TODAY)
  • Lookup/reference tools (e.g., MATCH) and techniques to compare two lists for mismatches
  • Named ranges, including creating dynamic named ranges for expanding datasets
  • Data validation with drop-down lists to prevent invalid entries
  • Sorting/filtering (incl. wildcards) and conditional formatting to analyze data visually

Course Description

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.

Course content

  • 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?

This free course includes:

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 course
Icon representing technology and business courses

Over 5,000 free courses

Programming, English, Digital Marketing and much more! Learn whatever you want, for free.

Calendar icon with target representing study planning

Study plan with AI

Our app's Artificial Intelligence can create a study schedule for the course you choose.

Professional icon representing career and business

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.

QR Code - Download Cursa - Online Courses

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.

LG

LONEWOLF GAMING

StarStarStarStarStar

I only saw 6 videos till now but this course is really outstanding u had covered each and every detail of excel.

AS

Atharva Shile

StarStarStarStarStar

Nicely taught by the respective sir. Really was an awesome experience and the introduction part was absolutely a masterpiece. What a keen teaching!!!

JB

Jaymin Baraiya

StarStarStarStar

Course provides knowledge and partical use of MS Excel. Its makes easier to understand and use Excel.

DB

Dyniesha Brown

StarStarStar

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.

JP

Juanita Phiri

StarStarStarStarStar

very helpful as i use excel on a regular basis

AK

Amit kumar Shaw

StarStarStarStarStar

I think no one can teach better than him

PA

pratiksha anil gujar

StarStarStarStarStar

Excellent course...!!!

JB

Jakey Barua

StarStarStarStarStar

it's really helpful. . .

TD

Tordzro Daniel

StarStarStarStarStar

very nice course

BR

Balbulee Raphael

StarStarStarStarStar

very understandable,

More free courses at Office Productivity (Excel, Word and More)

Free Ebook + Audiobooks! Learn by listening or reading!

Download the App now to have access to + 5000 free courses, exercises, certificates and lots of content without paying anything!

  • 100% free online courses from start to finish

    Thousands of online courses in video, ebooks and audiobooks.

  • More than 60 thousand free exercises

    To test your knowledge during online courses

  • Valid free Digital Certificate with QR Code

    Generated directly from your cell phone's photo gallery and sent to your email

Cursa app on the ebook screen, the video course screen and the course exercises screen, plus the course completion certificate