Witsy.io
Login Take Test

Practice Excel online

Excel exercises in a real spreadsheet that runs in your browser, each step checked as you go. No signup and nothing to install.

Lesson

This is Witsheet, Witsy’s in-browser spreadsheet. It works like Excel and checks each step as you go.

Practice in a spreadsheet, not a quiz

That’s what every page here is like. A tutorial makes sense while you read it; then you open a real file and the formula won’t come. Each page is a short job in a spreadsheet: a quote to fill, an export to clean, a sales log to summarize, with every step checked as you do it.

Pick the skill your work or an upcoming Excel test asks for. If you’d rather practice in your own Excel, the worksheets below are free files with tasks to work through. And if you don’t know where to start, the free placement test at the end of the page finds your level first.

Pick a skill to practice

VLOOKUP practice → Price an order from a product list: column numbers, FALSE, and the SKU that isn’t there.Pivot table practice → Answer a manager’s questions about a café chain’s sales log with pivot tables.Excel practice data → 7 free downloadable .xlsx datasets, each with a tasks sheet — sales orders, price lists, messy exports and more.Data entry practice → Type a delivery note into a stock table: the Tab and Enter rhythm, and series fills.Excel formula practice → A budget with totals, averages and shares that survive being copied down a column.Excel practice for beginners → No experience assumed: enter data, write your first SUM and AVERAGE, make the totals bold.Data cleaning practice → A customer export with stray spaces, wrong capitals and broken codes, cleaned column by column.Keyboard shortcuts practice → Jump to the edge of the data, back to A1, and select a whole block without the mouse.XLOOKUP practice → Fill a customer quote from a catalog, including a lookup to the left of the codes.SUMIF & COUNTIF practice → An order summary that answers by region, threshold and product, with SUMIFS’s argument order.IF function practice → Sales against target, the rep who lands on the line, and a two-condition flag with AND.Excel table practice → Turn a plain range into a table: sort it, total it, and filter it to answer a budget question.Sort & filter practice → Sort and filter a sales list to answer the questions a meeting asks.

Excel practice worksheets

To practice in your own Excel or Google Sheets, download a workbook. Each holds fictional data at full size and a Tasks sheet of questions to answer with it. More on what’s in each is on the Excel practice data page.

Preparing for an Excel test?

The Excel assessment test guide covers what employers’ screening tests ask, and the Excel practice test page is the place to rehearse one.

Learn the rest of Excel the same way

Witsy’s Excel course teaches a few hundred small skills, called Wits, the way this page teaches the basics: in a real spreadsheet, a step at a time. The placement test finds the ones you already have.

Your Wit map

Test your spreadsheet Wits.

Take a few minute test to see how good you actually are with spreadsheets. Witsy creates a map of the Wits you should learn next.

Take the placement test Or just start learning →
new unproven weak mid strong very strong super strong