Loading…
Log in to see this page
Your dashboard and settings are part of your free FormulaDojo account.
FormulaDojo Premium
Lesson 1 is open to everyone and lesson 2 is free with an account. Premium opens every lesson after that.
- Every lesson after lesson 2: 49 lessons today, plus the ones we add
- The course certificate of completion, with a public link to verify it
- Cancel a subscription any time from your dashboard
Lessons in Premium today
- Move with the keyboard
- Select with the keyboard
- AutoSum & fill shortcuts
- Absolute references
- Percentages
- Project: household budget
- SUM
- AVERAGE
- MIN & MAX
- SMALL, LARGE & MEDIAN
- COUNTA & COUNTBLANK
- SUMIF
- SUMIFS
- COUNTIF
- COUNTIFS
- SUMPRODUCT
- Project: monthly sales report
- IF
- AND & OR
- Nested IF & IFS
- SWITCH & XOR
- IFERROR
- ISBLANK, ISNUMBER & ISTEXT
- CONCATENATE
- TEXTJOIN & CONCAT
- LEFT, RIGHT & MID
- TRIM & cleaning text
- TEXT
- Project: clean a customer list
- VLOOKUP
- HLOOKUP
- XLOOKUP
- MATCH
- INDEX + MATCH
- Work across sheets
- Project: order invoice
- ROUND
- CEILING & FLOOR
- TODAY & dates
- DATEDIF
- EOMONTH
- NETWORKDAYS
- Project: project schedule
- Drop-down list
- Conditional formatting
- Tables
- FILTER
- Pivot table
- Project: sales dashboard
You have Premium.
Checkout couldn’t start. Please try again.