Intro to Excel

Course content

Three skills, built through practice

Start with cell references, then use the same spreadsheet skills to answer business questions.

1. 01

   Relative and absolute references

   Price an order correctly, even when quantities or discounts change.

   4 exercises

   Inside this lesson

   1. Calculate the first line total
   2. Copy relative references down
   3. Keep one discount cell fixed
   4. Repair a shifted packing charge
   Start lesson: Relative and absolute references
2. 02

   SUMIF by region

   Turn a mixed invoice list into a regional sales total.

   4 exercises

   Inside this lesson

   1. Add NSW sales
   2. Add VIC sales
   3. Use a region selector
   4. Include the newly added invoice
   Start lesson: SUMIF by region
3. 03

   Exact-match VLOOKUP

   Find the right price and spot product codes that need checking.

   4 exercises

   Inside this lesson

   1. Retrieve a product price
   2. Repair the return column
   3. Remove an approximate-match trap
   4. Keep a missing supply code visible
   Start lesson: Exact-match VLOOKUP