How this Excel track works
- Read-focused — practice locally —
execution_profile: none. Type formulas in Microsoft Excel, Google Sheets, or LibreOffice Calc—no in-browser spreadsheet runner. - Workbook habit — keep
excel-practice.xlsxopen while learning; rebuild every example and check totals manually. - Prerequisites — basic computer literacy; SQL and Data Science pair well for metrics at scale.
- Pair with — Pandas for large tables, Python for automation, finance/ops teams for real-world review.
Avoid destructive experiments on work files—practice copies only. macOS uses ⌘ where Windows lessons say Ctrl.
Install on your device (macOS, Linux, Windows)
Install a desktop spreadsheet—lessons are read-focused; practice in a real workbook.
macOS
- Microsoft Excel (Microsoft 365) or LibreOffice Calc (free).
Linux
sudo apt install -y libreoffice-calcor use Excel Online in a browser.
Windows
- Microsoft Excel (common on Windows) or
winget install LibreOffice.LibreOffice.
Verify: Create excel-practice.xlsx and enter =SUM(1,2) in a cell.
Microsoft Excel is a spreadsheet application for organizing data, calculating with formulas, summarizing with pivot tables, and communicating with charts. Analysts, finance teams, and engineers exchange Excel files daily—even when warehouses run on SQL.
How this track works
Read lessons here; type formulas and build tables in your own spreadsheet app. We use Excel syntax (also largely compatible with Google Sheets and LibreOffice).
Pair with SQL for warehouse queries, Data Science and Pandas for larger pipelines, and Python for automation.
What you will learn
- Workbooks, worksheets, tables, formatting, and navigation
- Formulas, references, IF/IFS, text functions, and error handling
- Lookups (VLOOKUP, XLOOKUP preview), sort/filter, validation, conditional formatting
- Pivot tables, charts, and light dashboard patterns
- Power Query preview, CSV import/export, bridges to Python/SQL
First steps
A1: Revenue
B1: 1200
A2: Cost
B2: 800
A3: Profit
B3: =B1-B2Practice: Open Microsoft Excel, Google Sheets, or LibreOffice Calc and recreate each example in a scratch workbook named excel-practice.xlsx. This track is read-focused (execution_profile: none)—no in-browser spreadsheet runner.
Cell B3 should show 400 when B1 and B2 are numbers.
Important interview questions and answers
- Q: Why Excel for developers?
A: You debug exports, validate business logic in models, and speak the same language as stakeholders. - Q: Why no playground?
A: Spreadsheet UI cannot run safely in a shared browser lab—local practice is the right default.
Self-check
- Name two related tracks linked from this intro.
- What should B3 display in the starter example?
Challenge
Build the profit mini-sheet
- Open a new workbook
excel-practice.xlsx. - Enter Revenue 1200 and Cost 800 in column B.
- In B3 type
=B1-B2and confirm profit 400.
Done when: cell B3 shows 400 with your formula.
Tip: Create excel-practice.xlsx and rebuild every example—muscle memory beats reading alone.
Interview prep
- Practice how?
Local Excel/Sheets workbook—execution_profile: none.
- Pair with SQL?
SQL for warehouse truth; Excel for stakeholder models and quick analysis.