The best ways to learn Excel for work without paying for a course

“Proficient in Excel” is the most over-claimed line on the average resume, and hiring managers know it. Most people who write it can format a table and add up a column. The people who get hired for it can take a messy export, clean it, join it to another list, summarize it with a pivot table and turn it into something a manager can read. That gap is about three weeks of deliberate practice wide, and you do not need to pay anyone to close it.

Here is what “good at Excel” means in an office, the twenty functions that cover most of the work you will ever be asked to do, why pivot tables are the highest-value hour you can spend, a four-week self-study plan with concrete tasks, the free resources worth your time, and how to prove the skill on a resume in a way that survives a practical test.

What “good at Excel” means at work

There are roughly three levels, and job postings rarely say which they mean.

Level one: can use. Enter data, format cells, sort and filter, write basic formulas, print something that fits on a page. Most people are here.

Level two: can build. Combine data from different sheets with lookups, clean messy imports, use conditional logic, build pivot tables and charts, and produce a report that someone else can refresh. This is what “proficient” should mean, and it is what most administrative, finance, operations, HR, sales support and analyst roles actually need.

Level three: can automate. Power Query, data models, and macros where nothing else will do. Useful in finance and analytics roles; overkill for most others.

Aim for a solid level two. It covers the overwhelming majority of office work, and it is what practical hiring tests check.

The 20 functions that cover most office work

Learn these, in this order, and you will be able to do most of what is asked of you. Everything else can be looked up when you need it.

Function	What it does	Typical use
SUM, AVERAGE	Totals and means of a range	Every report you will ever build
COUNTA	Counts non-empty cells	How many rows have a value
COUNTIFS	Counts rows meeting one or more conditions	Orders per region per month
SUMIFS	Adds values meeting one or more conditions	Revenue by product where status is “paid”
IF	Returns one thing or another based on a test	Flag overdue invoices
IFERROR	Replaces errors with something sensible	Hide #N/A from failed lookups
AND, OR	Combine conditions inside IF	Flag rows that are both late and over a threshold
XLOOKUP	Finds a value in one list and returns a match from another	Pull a customer’s email onto an order list
VLOOKUP	The older lookup you will still meet in existing files	Reading and fixing inherited spreadsheets
INDEX and MATCH	The flexible lookup that works in every version	When XLOOKUP is unavailable or the lookup is two-way
TRIM	Removes stray spaces	Cleaning imported names and codes
LEFT, RIGHT, MID	Pull part of a text string	Extract a year from a reference number
TEXTJOIN	Joins text with a separator	Build a full name or an address line
TEXT	Formats a number or date as text	“Mar 2026” labels from a date
TODAY, EOMONTH	Current date and month-end dates	Age of an invoice, reporting periods
NETWORKDAYS	Working days between two dates	Turnaround times excluding weekends
ROUND	Rounds to a set number of decimals	Stop pennies drifting in totals
UNIQUE	Lists the distinct values in a range	Every customer who ordered this quarter
FILTER	Returns rows meeting a condition, as a live list	Open tickets assigned to one person
SORT	Sorts a range by formula	Ranked lists that update themselves

XLOOKUP, UNIQUE, FILTER and SORT need Excel 2021 or Microsoft 365; on older versions, INDEX and MATCH and Remove Duplicates do the same jobs more slowly. Learn to combine them (IFERROR around XLOOKUP, TRIM inside a lookup); that is where real fluency shows.

Pivot tables: the highest-value hour

If you learn one thing beyond formulas, learn pivot tables. They turn a list of ten thousand transactions into “sales by region by month” in about six clicks, with no formulas, and they are what separates people who report from people who retype.

The trick is that pivot tables need clean data: one header row, one record per row, no merged cells, no subtotals in the middle, no blank columns, consistent data types (dates as dates, numbers as numbers). Most pivot table frustration is really data layout frustration. Get into the habit of converting any list to a Table (Ctrl+T) first; it names the range, expands automatically, and feeds the pivot cleanly.

From there: drag a field to Rows, another to Columns, a number to Values, and you have a cross-tab. Right-click a date to group it by month or quarter. Add a Slicer for a clickable filter. Refresh when the source changes. That is ninety percent of what anyone does with them.

The habits that matter as much as the functions

Fluency is mostly a set of small habits that make you fast and make your work trustworthy.

• Keyboard first. Ctrl+arrow to jump to the edge of data, Ctrl+Shift+arrow to select to it, Ctrl+T for a table, F2 to edit a cell, F4 to toggle absolute references, Alt+= for AutoSum, Ctrl+Shift+L to toggle filters.
• Absolute references. Understand what the dollar signs do ($A$1 versus A1 versus $A1) before you copy a formula anywhere. Most broken spreadsheets come down to this.
• Flash Fill, Text to Columns, Remove Duplicates. The three built-in tools that do most cleaning without formulas.
• Freeze Panes, Conditional Formatting, Data Validation. Headers that stay put, cells that go red when late, dropdowns that stop people typing “Yes,” “yes” and “Y” in the same column.

A four-week self-study plan

Thirty to forty-five minutes a day, five days a week. Each week has a project, because you will not remember a function you have not used on something you care about. If you are doing this alongside a full-time job, our guide on learning a new skill while working full-time has the scheduling side.

Week one: the basics and a personal budget. Download three months of transactions from your bank as a CSV. Open it, convert it to a Table, fix the date column, add a Category column, and use SUMIFS to total spending by category by month. Add COUNTIFS for the number of transactions. Freeze the header row, apply conditional formatting to anything over a threshold, and make it printable on one page. By Friday you should be comfortable moving around the sheet without the mouse.

Week two: logic and lookups. Make two sheets: a customer list (ID, name, email, region) and an order list (order ID, customer ID, amount, date, status). Use XLOOKUP (and then INDEX and MATCH, for practice) to pull the customer name and region onto every order. Wrap the lookup in IFERROR. Add an IF column that flags orders over thirty days old and unpaid, using TODAY. Use COUNTIFS to find customers with more than three orders. Invent the data or use a public sample; the structure is what matters.

Week three: cleaning messy data. Find or make a deliberately messy file: names in one column with inconsistent capitalization and extra spaces, dates stored as text, phone numbers in three formats, duplicate rows. Clean it using TRIM, PROPER, LEFT and MID, Text to Columns, Flash Fill and Remove Duplicates. Then rebuild a full name column with TEXTJOIN and a reporting-month column with TEXT and EOMONTH. Save a before and after.

Week four: pivot tables, charts and a one-page report. Take a sales dataset of a few thousand rows (Microsoft’s sample “Financial Sample” workbook or any retail dataset from Kaggle works). Build a pivot showing revenue by product by month, group dates by quarter, add a slicer for region, and put a chart next to it. Then build a one-page summary sheet that pulls the key numbers from the pivot with formulas, so that refreshing the data updates everything. Add UNIQUE and FILTER to list the top customers dynamically. Keep all four files.

Free resources that are actually worth the time

You do not need a course. You need a reference, a few explainers, and data to practice on.

• Excel itself. The Insert Function dialog explains every argument, and the Help pane links to Microsoft’s own tutorials, which are decent and free. Excel for the web is free with a Microsoft account and has almost everything you need for level two.
• ExcelJet. The best free function reference on the internet, with short worked examples for every function above and a shortcut list worth printing.
• YouTube. Leila Gharani, ExcelIsFun and MyOnlineTrainingHub all have long-running channels with clear, specific videos; search the exact task rather than watching a beginner series end to end.
• Public data. Your own bank exports, government open-data portals in the US, UK, Canada and Australia, and Kaggle datasets give you realistic, messy practice material.
• Your public library. Many library systems offer free access to LinkedIn Learning with a library card, which includes structured Excel courses if you decide you want one after all.

Google Sheets shares most of these functions and is fine for early practice, but do the final weeks in Excel if that is what your target employers use; the pivot table and keyboard differences are enough to trip you up in a test.

How to prove it on a resume

Do not write “proficient in Excel.” Write what you built, and name the tools.

In the experience section, as a bullet under a real job or a project: “Built a monthly sales dashboard in Excel (pivot tables, XLOOKUP, slicers, conditional formatting) that replaced a manual report and cut preparation time from a day to under an hour.” If you have no work example yet, use the week-four project and describe it honestly as a personal project.

In the skills line, list the specific capabilities rather than the software: “Excel: pivot tables, XLOOKUP/INDEX-MATCH, SUMIFS/COUNTIFS, data cleaning, charts, Tables and structured references.” A hiring manager who knows Excel reads that and believes you; a keyword filter matches on it.

Be ready for a test. A growing number of employers give a short practical Excel exercise for roles that mention it, often thirty minutes with a messy dataset and three or four questions. The four-week plan above is built to match what those tests ask. Our piece on the rise of skills tests in hiring covers the formats and how to approach them.

A portfolio file you can talk through beats a certificate in most interviews, though the Microsoft Office Specialist Excel exams are a recognized, relatively cheap option if you want one. And if the spreadsheet work turns out to be what you enjoy, it is the foot in the door to analytics roles; what a data analyst actually does starts, for most people, with Excel.

Start with something you already do by hand

Tonight, open a blank workbook and rebuild one thing you currently do manually: a rota, a budget, a tracking list, an expense claim. Make it a Table, add one SUMIFS and one conditional format, and save it. Tomorrow add a lookup. The plan above is the structure, but the real driver is having a file you use every week that gets a little smarter each time you open it.