CellWorks

Microsoft Excel · Essentials

Navigate, enter data and write your first formulas.

Lessons

  1. 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 started10 min
  2. 2Cells, Rows & ColumnsRead cell addresses and ranges, navigate with the keyboard and update a gym class timetable by address.Not started11 min
  3. 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 started12 min
  4. 4Introduction to FormulasPrepare a weekly purchase order: select cells, use the formula bar, format amounts and total the order with AutoSum.Not started12 min
  5. 5Basic Functions & AutoSumSummarise a bakery’s weekly sales with AutoSum, SUM, AVERAGE, MAX, MIN and COUNT.Not started13 min
  6. 6Working with TablesTurn a plain sales-lead list into an Excel table with Insert › Format as Table, add records and total the pipeline.Not started13 min
  7. 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 started14 min
  8. 8Calculating PercentagesWork out each department’s share of a monthly energy bill and the change from last month.Not started14 min
  9. 9Rounding Numbers with ROUNDSplit a team dinner bill fairly and round each share to whole cents with ROUND.Not started13 min
  10. 10Combining Functions in One FormulaAnalyse a running club’s training log by placing functions inside other functions and calculations.Not started15 min
  11. 11Planning a Savings GoalBuild a small what-if model for a holiday savings goal with input cells, locked references and rounded results.Not started16 min
  12. 12Final Assessment: Monthly Household BudgetPractical assessment: complete a household budget using data entry, formatting, functions, locked references, percentages and ROUND.Not started20 min