Try these free Excel tools designed to save you time and make your work easier. Use the helper and finder tools below to explore Excel functions, formulas, and guides that help you become more productive and confident in spreadsheets.
These tools fix what is in front of you right now. The courses teach you to build the spreadsheet in the first place: 280+ free video lessons with downloadable workbooks, no login and no credit card required.
Taught by Nicole Hullihen, MBA, multi industry executive and multi year Microsoft MVP
Troubleshooting Excel errors can be frustrating.
Search through the top 10 Excel errors and see:
• What each error means
• The cause behind it
• How to fix it instantly
The full reference below is the same information the tool returns, written out so you can scan or search the whole list at once.
#DIV/0! Divide by zeroWhat it means: A formula is trying to divide by zero or by an empty cell. Excel cannot return a number, so it returns this error instead.
How to fix it: Check the divisor. If it can legitimately be zero or blank, wrap the formula so it handles that case, for example =IFERROR(A2/B2,0) or =IF(B2=0,"",A2/B2).
#N/A Value not availableWhat it means: A lookup function could not find a match. VLOOKUP, XLOOKUP, MATCH and INDEX/MATCH all return this when the value you searched for is not in the lookup range.
How to fix it: Confirm the value actually exists and that both sides are the same data type, since a number stored as text will never match a real number. Check for stray spaces with TRIM, and make sure VLOOKUP is set to exact match with FALSE as the fourth argument.
#VALUE! Wrong type of argumentWhat it means: The formula received the wrong kind of input, most often text where a number was expected. Arithmetic on a cell containing letters or a stray space triggers it immediately.
How to fix it: Find the offending cell and check its contents. Numbers imported as text are the usual cause, and running the column through Data, Text to Columns and clicking Finish converts them back to real numbers.
#REF! Invalid cell referenceWhat it means: The formula points at a cell that no longer exists, almost always because a row, column or sheet it referred to was deleted. This one is destructive, since the original reference is gone for good.
How to fix it: Press Ctrl+Z immediately if you just deleted something. Otherwise the formula has to be rewritten, because Excel cannot recover what the reference used to point at.
#NAME? Excel does not recognise the textWhat it means: Usually a misspelled function name, a text value missing its quotation marks, or a named range that does not exist. =SUmm(A1:A5) and =IF(A1=Gold,1,0) both produce it.
How to fix it: Check the spelling of the function, make sure text criteria are wrapped in quotes, and confirm any named range still exists under Formulas, Name Manager.
#NUM! Invalid number in the calculationWhat it means: The maths is impossible or the result is too large for Excel to store. The square root of a negative number is the classic example, as is an iterative function that never converges.
How to fix it: Check the inputs for negative values where they are not allowed, and verify that arguments are within the range the function accepts.
#NULL! Ranges do not intersectWhat it means: Caused by a space between two ranges where Excel expected a comma or colon. The space is the intersection operator, so =SUM(A1:A5 C1:C5) asks for cells the two ranges share, and there are none.
How to fix it: Replace the space with a comma to add both ranges together, or with a colon to make one continuous range.
#SPILL! The result cannot spill into the cells it needsWhat it means: A dynamic array formula returns several values but something is blocking the cells below or beside it. Even a single space in one of those cells is enough.
How to fix it: Clear the blocked cells. Excel outlines the intended spill range with a dashed border, so click the warning icon and choose Select Obstructing Cells to jump straight to the problem.
#CALC! The calculation engine cannot produce a resultWhat it means: A dynamic array formula is asking for something impossible, such as an empty array or a nested array Excel cannot represent. It appears mainly in Microsoft 365.
How to fix it: Check any FILTER function that might return nothing and supply an if_empty argument, for example =FILTER(A2:A20,B2:B20="Gold","None found").
#GETTING_DATA External data is still loadingWhat it means: Not really an error. A cell is waiting on an external source, an add-in or a large recalculation, and shows this placeholder in the meantime.
How to fix it: Wait for it to finish. If it never clears, check the data connection under the Data tab and confirm the source is reachable.
Can you write a formula to sum only the odd numbers in this list?
Example: Column A: 2, 5, 8, 11, 14
=SUMPRODUCT(A1:A5,MOD(A1:A5,2))How can you highlight the top 3 sales values using Conditional Formatting?
Example: Column B: 4500, 7200, 6100, 8800, 5300
=B1>=LARGE($B$1:$B$5,3)How can you remove duplicate values from a list while keeping original order?
Example: Column D: Apple, Orange, Apple, Banana, Orange
=UNIQUE(D1:D5)Ever been asked for a quick calculation or report in Excel and weren't sure which formula to use?
The Excel Formula Finder shows you the 27 most common boss requests — from combining first and last names, to calculating percentages, finding top performers, or pulling data automatically.
For each request, you'll get:
• A plain-English explanation
• The exact Excel formula to use
• A simple example you can copy instantly
Stop wasting time guessing — this tool gives you the right formula in seconds.
Every request in the tool, listed in full so you can search the page or copy a formula straight out of the table.
| The request | What it does | Formula | Example |
|---|---|---|---|
| Can you combine first and last names? | Join two text columns together with a space. | =A2 & " " & B2 |
A2=John, B2=Doe → John Doe |
| How do I extract the first name? | Get the text before the first space. | =LEFT(A2,FIND(" ",A2)-1) |
A2=John Doe → John |
| How do I extract the last name? | Get the text after the first space. | =RIGHT(A2,LEN(A2)-FIND(" ",A2)) |
A2=John Doe → Doe |
| How many employees are there? | Count non-empty cells in a range. | =COUNTA(A2:A100) |
Counts filled rows in column A |
| How many in Sales department? | Count rows matching a specific word. | =COUNTIF(B2:B100,"Sales") |
Counts rows where B=Sales |
| What's total revenue for East region? | Sum numbers if criteria met. | =SUMIF(C2:C100,"East",D2:D100) |
Sums column D if C=East |
| What is the average deal size? | Average of numbers in a range. | =AVERAGE(D2:D100) |
Adds all deal values ÷ count |
| Who has the highest sales? | Return max value in a range. | =MAX(D2:D100) |
Largest sales in column D |
| Who has the lowest sales? | Return min value in a range. | =MIN(D2:D100) |
Smallest sales in column D |
| Can you show me John's salary? | Look up a value in a table. | =VLOOKUP("John",A2:D100,4,FALSE) |
Returns John's salary from column 4 |
| Can we use XLOOKUP instead? | Modern lookup for exact or approximate matches. | =XLOOKUP("John",A2:A100,D2:D100) |
Find John in A, return salary from D |
| Did anyone exceed target? | Return Yes/No based on condition. | =IF(D2>100000,"Yes","No") |
Yes if D2>100k, else No |
| How much commission did they earn? | Apply rate if sales exceed target. | =IF(D2>100000,D2*0.1,0) |
10% commission if sales>100k |
| What's the total expenses? | Sum a column of numbers. | =SUM(E2:E100) |
Adds all expense values |
| Can you rank employees by sales? | Rank numbers against each other. | =RANK(D2,D2:D100) |
Rank of D2 among sales |
| Who are the top 3 sales performers? | Return nth largest number. | =LARGE(D2:D100,3) |
3rd highest sale |
| What's today's date? | Return current system date. | =TODAY() |
Outputs today's date |
| What time is it now? | Return system date and time. | =NOW() |
Outputs current date + time |
| Can we add 6 months to a date? | Shift date by months. | =EDATE(A2,6) |
Adds 6 months to hire date |
| How many workdays between dates? | Count weekdays between two dates. | =NETWORKDAYS(A2,B2) |
Number of workdays |
| How to round numbers? | Round to decimal places. | =ROUND(A2,2) |
Rounds value to 2 decimals |
| How to always round up? | Force round upwards. | =ROUNDUP(A2,0) |
Rounds A2 up to nearest integer |
| How to always round down? | Force round downwards. | =ROUNDDOWN(A2,0) |
Rounds A2 down to nearest integer |
| How to find last day of month? | Return end of month date. | =EOMONTH(A2,0) |
Gives last day of month |
| What is the average attendance? | Average numeric range. | =AVERAGE(F2:F100) |
Mean attendance |
| How do I remove duplicates with a formula? | Return unique values from a list. | =UNIQUE(A2:A100) |
Returns only unique values |
| Top 10 Excel Errors | See the most common Excel error messages. | |
#DIV/0! #N/A #VALUE! #REF! #NAME? #NUM! #NULL! #SPILL! #CALC! #GETTING_DATA |
How can you count only cells containing numbers greater than 100?
Example: Column C: 50, 120, 200, 75, 150
=COUNTIF(C1:C5,">100")How can you extract the last name from a full name automatically?
Example: Column D: Jane Smith, John Doe, Alice Johnson
=RIGHT(D1,LEN(D1)-FIND(" ",D1))How can you calculate the average of only positive numbers?
Example: Column E: -5, 10, 15, -2, 20
=AVERAGEIF(E1:E5,">0")Click any shortcut to copy it, or copy all at once
Generate Excel formulas for conditional formatting. Select a rule, enter your values, and copy the formula directly into Excel's "Use a formula to determine which cells to format" box.
=A1>10 → highlights if value greater than 10=AND(A1>=5,A1<=10) → highlights if between 5 and 10=ISNUMBER(SEARCH("text",A1)) → highlights if contains "text"=COUNTIF(A:A,A1)>1 → highlights duplicatesEvery tool on this page is free and runs in your browser. Nothing to install, no account to create, no email required. They are built for the moment you are mid-task and stuck: a formula returned an error code you do not recognize, or you know what you want Excel to do but not which function does it.
If a cell shows #VALUE!, #REF!, #N/A, #DIV/0!, #NAME?, #SPILL! or another code, the Error Helper explains what it means, what caused it and how to correct it. Most Excel errors trace back to a small handful of causes: a broken reference, text where a number belongs, or a formula pointing at a deleted cell.
The Formula Finder works backwards from what you are trying to accomplish. Instead of recalling whether you need SUMIFS, COUNTIF, XLOOKUP or INDEX MATCH, you describe the task and get the function that handles it along with the syntax to copy.
The Pro Challenges are real Excel problems with answers hidden until you click. They are a fast way to find gaps in what you know, and each answer shows the working formula so you see the approach, not just the result.
Most spreadsheet frustration traces back to a few recurring issues. A lookup returns #N/A because the value is genuinely missing, or because one side has trailing spaces. A total comes out wrong because numbers were stored as text. A formula breaks after someone deletes a column and every reference shifts. A dynamic array returns #SPILL! because something sits in the cells it needs to fill.
Knowing the cause matters more than memorizing the fix, because that same handful of causes explains nearly every error you will hit. That is what these tools are for, and it is what the free courses go deeper on: understanding why Excel behaves the way it does, so you can debug your own files instead of searching each new error message.
Students working through Excel homework who need to understand an error rather than just clear it. Professionals who use Excel daily but learned it piecemeal and have gaps around lookups or cell references. Small business owners running orders, budgets and inventory in spreadsheets. Job seekers preparing for an Excel assessment, where the tested skills are almost always VLOOKUP or XLOOKUP, pivot tables and conditional formulas.
Self-paced learning