Excel
The most widely used spreadsheet tool for data entry, analysis, and reporting.
CurrentbeginnerBeginner-friendlyGuide only -- no course yet
Overview
Excel remains the most common tool for small-to-medium data analysis, financial modeling, and reporting, particularly outside engineering teams. Formulas, pivot tables, and charts cover a large share of everyday data-analysis needs without writing code.
- What it is
- A spreadsheet application for tabular data entry, formulas, and visualization.
- Why it's used
- It's near-universal in business contexts and handles common analysis (sums, lookups, pivot tables) without any programming.
- Where it fits
- Often the first tool for exploring a small dataset, before a task grows large or repetitive enough to justify Python/Pandas.
Core concepts
- Formulas (SUM, VLOOKUP/XLOOKUP, IF)
- Pivot tables
- Charts
- Conditional formatting
Example
SUMIF is a conditional aggregation -- the same idea as a SQL 'WHERE ... GROUP BY' or a Pandas groupby, expressed as a spreadsheet formula instead of code.
=SUMIF(A2:A100, "Books", C2:C100)
// Sums column C where the matching row in column A equals "Books"Common use cases
- Financial modeling
- Small dataset analysis and reporting
- Quick ad-hoc calculations
Project ideas
- Build a small budget tracker using SUMIF and a pivot table to summarize spending by category