Excel
Excelsior
Lessons
Shortcuts
Tips
Pricing
Log in
Log in
Lessons
Shortcuts
Tips
Pricing
Lessons
1
Your first formulas: SUM, AVERAGE, MAX
Total a retailer's year-to-date operating costs, find the monthly run-rate and the peak month, and watch formulas update themselves.
2
Copying formulas and locking references with $
Translate regional revenue from AUD to USD with one FX rate, copy the formula down, and see why $G$1 stays put.
3
Percentages and GST: from till takings to revenue
Strip GST out of store sales, split out the GST component, and work out each store's share of revenue.
4
Shortcuts: move, select and sum without the mouse
Jump to the end of a 20-store revenue table, select a whole column of revenue and total it with AutoSum, all from the keyboard.
With the pass
+5
Foundations
5 lessons
+4
Counting and summing with conditions
4 lessons
+1
Logic
1 lesson
Reference
⌨
Shortcut reference
Every shortcut, for your keyboard
★
Set-up tips
KeyTips, function keys and other settings