Free online course Excel basic to advanced

About the free online course

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.