Your first formulas

Formulas, totals and quick summaries of a list.

1. 1Your first formulasCells and formulasUp next
2. 2Adding up with SUMSUM and rangesNot started
3. 3Average, highest and lowestAVERAGE, MIN and MAXNot started
4. 4Counting what’s thereCOUNT and COUNTANot started

Fill a formula down a whole table, and make it decide things.

1. 5Filling formulas downAbsolute referencesNot started
2. 6Making decisions with IFIFNot started

Percent change, discounts, tax and running totals.

1. 7Percent change, discounts and taxPercent changeNot started
2. 8Locking just the row or columnMixed referencesNot started
3. 9Running totalsRunning totalsNot started

Totals and counts for just the rows you care about.

1. 10Totals with conditionsSUMIF and SUMIFSNot started
2. 11Counts with conditionsCOUNTIF and COUNTIFSNot started
3. 12Partial matches and exclusionsWildcards in criteriaNot started
4. 13Totals between datesDate ranges in criteriaNot started

Pull the right value from another table.

1. 14Find it with XLOOKUPExact-match lookupsNot started
2. 15VLOOKUP and INDEX/MATCHClassic lookupsNot started
3. 16Two-way lookupsTwo-way lookupsNot started
4. 17XLOOKUP’s hidden powersAdvanced XLOOKUPNot started

Split, clean and join the text that real data arrives in.

1. 18Pulling text apartLEFT, RIGHT and MIDNot started
2. 19Cleaning messy textTRIM and text caseNot started
3. 20Splitting at a markerFIND and text splittingNot started
4. 21Joining text togetherJoining textNot started
5. 22Replacing and formatting textSUBSTITUTE and TEXTNot started
6. 23TEXTBEFORE, TEXTAFTER and TEXTSPLITTEXTBEFORE and TEXTAFTERNot started
7. 24Numbers and dates stored as textVALUE and DATEVALUENot started

Schedules, deadlines, tenure and working days.

1. 25Taking dates apartDate partsNot started
2. 26Calculating with datesDate arithmeticNot started
3. 27Tenure and working daysDATEDIF and working daysNot started
4. 28Weekends and working daysWEEKDAY and WORKDAYNot started
5. 29Times and timesheetsTime calculationsNot started

Rules with several conditions, and sheets that handle errors.

1. 30Rules with several partsAND and ORNot started
2. 31Many outcomes with IFS and SWITCHIFS and SWITCHNot started
3. 32Handling errors and gapsIFERROR and IS functionsNot started
4. 33Finding duplicatesFinding duplicatesNot started

Middles, rankings, rounding and group statistics.

1. 34When the average misleadsMEDIAN and MODENot started
2. 35Top performers and rankingsLARGE, SMALL and RANKNot started
3. 36Rounding properlyRoundingNot started
4. 37Statistics for one groupConditional statisticsNot started
5. 38Multiply and add with SUMPRODUCTSUMPRODUCTNot started
6. 39Whole numbers and remaindersINT and MODNot started
7. 40Rounding to a stepMROUND, CEILING and FLOORNot started

Loans, savings and whether an investment pays off.

1. 41Loan paymentsLoan calculationsNot started
2. 42Savings and compound growthSavings and growthNot started
3. 43Is it worth investing?Investment appraisalNot started

One formula that returns a whole list.

1. 44UNIQUE and SORTUNIQUE and SORTNot started
2. 45The FILTER functionFILTERNot started
3. 46Readable formulas with LETLETNot started
4. 47SEQUENCE and SORTBYSEQUENCE and SORTBYNot started
5. 48FILTER with several conditionsFILTER with conditionsNot started
6. 49Top N, chosen columns and stacked listsTAKE, CHOOSECOLS and VSTACKNot started

Real jobs that take several skills at once.

1. 50Fixing and using imported dataCombining functionsNot started
2. 51A report that updates itselfBuilding reportsNot started
3. 52Budget against actualBudget analysisNot started
4. 53From timesheet to payPayroll calculationsNot started

Work faster, with Windows and Mac versions of every drill.

1. 54Moving around fastNavigation shortcutsNot started
2. 55Selecting without draggingSelection shortcutsNot started
3. 56Everyday editing shortcutsEditing shortcutsNot started
4. 57Formatting shortcutsFormatting shortcutsNot started