Learn Excel for Free: The Best Courses and Practice Tools

Excel shows up in almost every kind of job. Office managers track schedules in it, warehouse leads use it for inventory, and small business owners keep their books in it. Being comfortable with spreadsheets is one of the most useful skills you can add to your resume.

You do not need to pay for a course to get good at Excel. Some of the best teaching material online is free, and you can practice without even buying the software.

This guide shows you where to learn, how to practice, and what to learn in which order, so you can move from nervous beginner to someone others ask for help.

You can practice without buying Excel

The first worry many people have is cost. Microsoft Excel usually comes with a paid Microsoft 365 subscription, but there are free ways to practice.

• Excel for the web is a free, browser-based version. Sign in with a free Microsoft account at office.com. It covers the core features you need as a beginner.
• Excel mobile apps for phones and small tablets offer basic editing for free.
• Google Sheets is free with a Google account and works very similarly for formulas, sorting and charts.
• Library and school computers often have full desktop Excel installed.

Advanced features, such as some Power Query or macro tools, need the desktop version. You will not need those until later.

The best free Excel courses

Here are trusted places to learn, each with a different style.

GCFGlobal

GCFGlobal is a free learning site run by the Goodwill Community Foundation. Its Excel tutorials start at the very beginning, with what a cell is and how to enter data, then move through formulas, charts and basic functions. Lessons are short, clear and written in plain language. This is the best starting point if spreadsheets feel intimidating.

Microsoft's own training

Microsoft Support has free Excel video training covering the basics, formulas, tables, charts and PivotTables. Search "Excel video training" on the Microsoft Support site. The lessons are short and match the current version of Excel, which helps if menus look different from older tutorials.

Exceljet

Exceljet offers a huge free library of articles explaining individual functions and formulas, with clear examples. It also sells paid video courses, but the free function guides are enough for most learners. It is excellent as a reference when you get stuck on something like XLOOKUP or IF statements.

Chandoo.org

Chandoo is a long-running Excel teaching site. It offers a free multi-hour Excel course on YouTube with downloadable practice workbooks, covering formulas, pivot tables, conditional formatting and dashboards. It is good for people who have learned the basics and want to work faster.

YouTube channels

Many excellent Excel teachers publish free videos. Search for channels such as ExcelIsFun, Leila Gharani and MyOnlineTrainingHub. Pick one teacher whose style you like and follow a playlist in order, rather than jumping between random videos.

Online course platforms

Coursera, edX and Alison host Excel courses from universities and companies. Some offer free previews or free access to lessons, and certificates usually cost money. Coursera Financial Aid may cover eligible courses. Your library may also offer free LinkedIn Learning access with a library card.

Comparison of free Excel resources

Resource	Best for	Level	Certificate
GCFGlobal	First-time users	Beginner	No
Microsoft Support training	Learning current menus and features	Beginner to intermediate	No
Exceljet	Looking up functions and formulas	All levels	No (paid courses available)
Chandoo	Dashboards and pivot tables	Intermediate	No
YouTube channels	Visual, step-by-step learning	All levels	No
Coursera, edX, Alison	Structured courses	Beginner to advanced	Usually paid; aid on some

A step-by-step learning plan

Learning Excel works best in layers. Try this order, spending a week or two on each step with a few short practice sessions.

1. The basics. Entering data, selecting cells, rows and columns, saving files, and simple formatting.
2. Simple formulas. Addition, subtraction, SUM, AVERAGE, MIN and MAX. Learn how cell references work.
3. Absolute and relative references. Understand the dollar sign in formulas like $A$1. This trips up many beginners.
4. Sorting, filtering and tables. Turn a range into a table and use filters to find what you need.
5. Logic and lookups. Learn IF, COUNTIF, SUMIF and XLOOKUP (or VLOOKUP in older versions).
6. Charts. Create column, line and pie charts, and learn when each one makes sense.
7. PivotTables. Summarize large amounts of data in seconds. This is often the skill that impresses employers most.
8. Clean-up tools. Text functions, removing duplicates, and data validation.

Once you are comfortable with these, you can explore Power Query, dynamic arrays and basic automation.

Where to find free practice data

Watching videos is not enough. You learn Excel by doing. Here are free sources of practice material:

• Course workbooks. GCFGlobal, Chandoo and many YouTube teachers offer downloadable files.
• Excel templates. Excel includes free templates for budgets, schedules and invoices. Open one and study how it works.
• Public data. Sites like data.gov and your city's open data portal offer real spreadsheets on topics such as weather, traffic and budgets.
• Your own life. Track your spending, your workouts or your job applications in a spreadsheet.

A great challenge: take a messy public dataset, clean it up, summarize it with a PivotTable, and make one clear chart. That becomes a small portfolio piece.

Should you get an Excel certification?

Microsoft offers the Microsoft Office Specialist (MOS) certification for Excel, delivered through Certiport testing centers. The exam is paid, and prices vary by location and testing center. Some community colleges, workforce programs and libraries offer vouchers or discounts.

A MOS certificate can help for administrative and office roles, especially if you have little formal experience. For most jobs, though, showing what you can do matters more. Being able to say "I built a spreadsheet that tracks X and saves Y hours" is often stronger than a certificate.

How to show Excel skills to employers

Employers see "proficient in Excel" on almost every resume, so make yours specific.

• List the actual skills: PivotTables, XLOOKUP, conditional formatting, charts.
• Describe a real example, even from personal or volunteer work.
• Be ready for a practical test. Some employers ask candidates to complete a short Excel task during interviews.

Practicing with timed tasks helps you stay calm if that happens.

Common beginner mistakes to avoid

Almost everyone makes the same few mistakes when learning Excel. Knowing them in advance saves you a lot of frustration.

• Typing numbers as text. If a number sits on the left side of a cell or will not add up, Excel may be treating it as text. Look for a small green triangle warning.
• Hard-coding values in formulas. Writing =A1*0.07 buries the tax rate inside the formula. Put the rate in its own cell and refer to it instead.
• Merging cells everywhere. Merged cells look neat but break sorting and filtering. Use "Center Across Selection" instead.
• Not saving versions. Before big changes, save a copy with a new name so you can go back.
• Skipping keyboard shortcuts. Learning a few, like Ctrl+C, Ctrl+V, Ctrl+Z and Ctrl+Arrow keys, makes you noticeably faster.

Fixing these habits early makes your spreadsheets easier for others to understand, which employers appreciate.

FAQ

How long does it take to learn Excel?

You can learn the basics in a couple of weeks with regular practice. Becoming confident with lookups, charts and PivotTables usually takes a few months of steady use.

Is Google Sheets the same as Excel?

Not quite, but most beginner and intermediate skills transfer. Formulas, sorting, filtering and charts work in similar ways, so practicing in Sheets is still valuable.

Is Excel for the web really free?

Yes, with a free Microsoft account. It lacks some advanced desktop features, but it is more than enough for learning the fundamentals.

What Excel skills do employers look for most?

Common requests include formulas, sorting and filtering, lookups, charts and PivotTables. Check job listings for the roles you want to see what comes up most.