It’s 3:12 PM on a Tuesday. You just clicked the Excel icon in your Start menu — only to get a pop-up saying 'This app isn’t installed.' Your laptop came with 'Microsoft Office' preloaded, and you swore it included Excel. You open Settings, then Apps, then scroll past 47 entries — still no clue where Excel went.
The Setup
You’re supporting five regional sales teams. Each sent their Q2 revenue data as an Excel file — but three used .xlsx, one sent a .csv they claim is 'the same thing,' and another emailed a screenshot of a spreadsheet (yes, really). You need to merge all five into one master workbook, validate totals, and flag discrepancies before tomorrow’s finance sync.
Here’s what you actually received — raw, unformatted, inconsistent:
| Team | Region | Revenue | Date Submitted |
|---|---|---|---|
| North Sales | Northeast | $245,890 | 2024-04-11 |
| West Team | Pacific | 237450 | 4/12/2024 |
| South Group | Southeast | $218,032.50 | 2024/04/10 |
| Central Unit | Midwest | 225,780 | 04/13/24 |
| East Squad | Mid-Atlantic | $261,410.00 | 2024-04-12 |
| APAC Liaison | Asia-Pacific | ¥34,200,000 | 2024-04-09 |
| EMEA Lead | Europe/Middle East | €219,650 | 12/04/2024 |
| Canada Rep | Canada | C$278,100 | 2024-04-11 |
The Challenge
You can’t just copy-paste this into one sheet and hit AutoSum. The Revenue column mixes currencies, formats, and even a ¥ symbol — Excel won’t add ¥34,200,000 + $245,890 without throwing a #VALUE! error in cell C9. Dates are in four different layouts. One row says 'Northeast' and another says 'NE' — and yes, someone named their team 'North Sales' while the header says 'Team Name.' That inconsistency breaks Power Query’s auto-detection.
But first — does Microsoft Office include Excel at all? Because if it doesn’t, none of this matters. And that’s where most people get tripped up.
Office editions vary wildly. Microsoft 365 Business Standard includes Excel — but only as a cloud-connected app that downloads on first launch. Windows 11 Home sometimes ships with a 'Microsoft Office Starter Edition' — a crippled version with no Excel at all, just Word and Excel Viewer (read-only). And some Dell or HP laptops bundle 'Office 365 Personal' — which *does* include Excel, but only for one user, and expires after 12 months unless renewed.
To check: Press Alt + F2. That opens the 'Open' dialog — but more importantly, it confirms Excel is registered in Windows. If nothing happens, go to Settings > Apps > Installed apps, and search for 'Excel'. If it shows 'Microsoft Excel' but says 'Not installed', click it and choose 'Modify' > 'Online Repair'. If it’s missing entirely, you likely have Office Online (browser-only) or a trial that expired.
Walking Through It
We’ll fix the data — but only after confirming Excel is actually there. Here’s how we do both, step by step.
Step 1: Verify Excel is installed and licensed
Open any folder in File Explorer. Type excel.exe in the address bar and press Enter. If Excel launches, great — skip to Step 2. If you get 'Windows cannot find excel.exe', run this in PowerShell as Administrator:
Get-AppxPackage *Microsoft.Office.Desktop*
If it returns nothing, your device has no desktop Excel — only web apps. In that case, go to office.com, sign in, and use Excel for the web. It handles currency conversion and date parsing better than most realize — just paste the raw table above into a new sheet there.
Step 2: Normalize currency values (before)
In Excel Desktop (v16.0+), paste the full table starting at A1. Column C has mixed formats. Select C2:C9, then press Ctrl + H. In 'Find what', type $. Leave 'Replace with' blank. Click 'Replace All'. Do the same for ¥, €, and C$. Now all numbers are plain text — but still unsummarizable because of commas and decimals.
Next, select C2:C9 again. Press Alt + H + F + F (Home > Format > Format Cells). Choose 'Number', set Decimal places to 2, and click OK. Excel will now treat them as numbers — but only if they’re clean. So finally, select C2:C9 and press Alt + A + V + V (Data > Text to Columns > Delimited > Next > Next > Finish). This forces re-evaluation.
Before normalization (C2:C9)
| Raw Value |
|---|
| $245,890 |
| 237450 |
| $218,032.50 |
| 225,780 |
| $261,410.00 |
| ¥34,200,000 |
| €219,650 |
| C$278,100 |
After normalization (C2:C9)
| Clean Numeric |
|---|
| 245890.00 |
| 237450.00 |
| 218032.50 |
| 225780.00 |
| 261410.00 |
| 34200000.00 |
| 219650.00 |
| 278100.00 |
Step 3: Fix dates and standardize regions
Select D2:D9. Press Ctrl + 1, choose 'Date', and pick '3/14/2012' format. Excel will auto-convert most — but '12/04/2024' becomes April 12, not December 4. To catch those, insert a helper column E. In E2, enter:
=IF(ISNUMBER(D2),D2,DATEVALUE(SUBSTITUTE(SUBSTITUTE(D2,"/","-"),".","-")))
Then copy down. This catches European-style '12/04/2024' and converts it correctly. Finally, replace D2:D9 with values from E2:E9, delete column E, and rename D:D to 'Submitted'.
For Region, create a lookup table in Sheet2: A1:B8 with abbreviations (NE, SE, etc.) mapped to full names. Then in original sheet, column B2 becomes:
=XLOOKUP(B2,Sheet2!A:A,Sheet2!B:B,B2,0)
This preserves 'Asia-Pacific' if no match exists — avoiding #N/A errors.
The Result
Here’s the final cleaned dataset — ready for pivot tables, charts, or export to Power BI:
| Team | Region | Revenue (USD) | Submitted |
|---|---|---|---|
| North Sales | Northeast | 245,890.00 | 2024-04-11 |
| West Team | Pacific | 237,450.00 | 2024-04-12 |
| South Group | Southeast | 218,032.50 | 2024-04-10 |
| Central Unit | Midwest | 225,780.00 | 2024-04-13 |
| East Squad | Mid-Atlantic | 261,410.00 | 2024-04-12 |
| APAC Liaison | Asia-Pacific | 34,200,000.00 | 2024-04-09 |
| EMEA Lead | Europe/Middle East | 219,650.00 | 2024-04-12 |
| Canada Rep | Canada | 278,100.00 | 2024-04-11 |
What Could Go Wrong
Three mistakes I’ve seen derail this exact workflow — each time causing a 45-minute delay and a panicked Slack message to IT:
Mistake #1: Assuming 'Office' means 'Excel' — then pasting into Notepad first
You copy the messy table, paste into Notepad to 'clean it up', then paste into Excel. Big problem: Notepad strips all formatting — including hidden characters like non-breaking spaces (U+00A0) and zero-width spaces (U+200B). When you paste back, Excel sees '237450 ' (with invisible space) and treats it as text — SUM() returns 0. The fix? Paste directly into Excel, then use Alt + H + F + D (Find & Replace) with Ctrl+Shift+Space to find non-breaking spaces.
Mistake #2: Using 'Text to Columns' on currency before removing symbols
You select C2:C9 and hit Alt + A + V + V — but forget to strip $, €, ¥ first. Excel splits on commas *and* symbols, turning '$245,890' into three columns: '$245', '890', and blank. Now you’ve expanded your 8-row table into 24 columns. Recovery requires Undo (Ctrl+Z) — or deleting columns manually. Always clean symbols *before* Text to Columns.
Mistake #3: Applying DATEVALUE to already-numeric dates
You run DATEVALUE on column D, thinking it’s all text. But rows with '2024-04-11' are already serial numbers (45027). DATEVALUE(45027) returns #VALUE!. Worse: it corrupts the cell’s underlying value. Check first with =ISTEXT(D2). Only apply DATEVALUE where TRUE.
Here’s your quick-reference checklist before opening Excel next time:
| Check | How | Shortcut |
|---|---|---|
| Is Excel installed? | File Explorer → type excel.exe in address bar | — |
| Is license active? | File > Account → look for 'Product Information' | Alt+F+A |
| Are numbers truly numeric? | Select cells → Home tab → look at number format dropdown | Alt+H+9 |
| Is date column consistent? | =CELL("format",D2) returns 'D1' (date) or 'G' (general/text) | — |
