Internship← Power BI & Excel learning pathPower BI & Excel · Module 1 of 10
Excel essentials
Organise and calculate data in spreadsheets.
📖 Key ideas
- Workbooks contain sheets made of rows, columns and cells (A1).
- Formulas start with =; functions like SUM, AVERAGE, MIN, MAX, COUNT.
- Relative vs absolute references ($A$1).
- Format as Table (Ctrl+T) for structured, auto-expanding data.
- Sort, filter and freeze panes to explore data.
💡 Real-life example: Excel is a giant digital register where every cell can do arithmetic for you.
Cell referenceAddress like B2
Absolute referenceFixed reference like $B$2
Excel TableStructured range with headers
Freeze panesKeep headers visible while scrolling