Microsoft Excel · Essentials
Navigate, enter data and write your first formulas.
Lessons
- 1Getting Started with ExcelFind your way around the Excel window — ribbon, Name Box, formula bar, worksheet and sheet tabs — and enter your first household budget items.Not startedPremium lesson10 min
- 2Cells, Rows & ColumnsRead cell addresses and ranges, navigate with the keyboard and update a gym class timetable by address.Not startedPremium lesson11 min
- 3Entering & Formatting DataEnter text and numbers correctly, edit existing entries and use Bold and Number format to make a travel expense report easy to read.Not startedPremium lesson12 min
- 4Introduction to FormulasPrepare a weekly purchase order: select cells, use the formula bar, format amounts and total the order with AutoSum.Not startedPremium lesson12 min
- 5Basic Functions & AutoSumSummarise a bakery’s weekly sales with AutoSum, SUM, AVERAGE, MAX, MIN and COUNT.Not startedPremium lesson13 min
- 6Working with TablesTurn a plain sales-lead list into an Excel table with Insert › Format as Table, add records and total the pipeline.Not startedPremium lesson13 min
- 7Relative & Absolute ReferencesPrice a print shop’s orders with one shared VAT rate, locking it with $ so every formula points to the right cell.Not startedPremium lesson14 min
- 8Calculating PercentagesWork out each department’s share of a monthly energy bill and the change from last month.Not startedPremium lesson14 min
- 9Rounding Numbers with ROUNDSplit a team dinner bill fairly and round each share to whole cents with ROUND.Not startedPremium lesson13 min
- 10Combining Functions in One FormulaAnalyse a running club’s training log by placing functions inside other functions and calculations.Not startedPremium lesson15 min
- 11Planning a Savings GoalBuild a small what-if model for a holiday savings goal with input cells, locked references and rounded results.Not startedPremium lesson16 min
- 12Final Assessment: Monthly Household BudgetPractical assessment: complete a household budget using data entry, formatting, functions, locked references, percentages and ROUND.Not startedPremium lesson20 min
