Lessons › Excel & Google Sheets

20 free lessons

Excel & Google Sheets lessons

Spreadsheet lessons for data analysts: formulas, SUMIFS, IFS, XLOOKUP, pivot tables and reports.

• SUMAdd up a column
• ArithmeticAdd, subtract, multiply, divide
• PercentagesMargin, share and change
• AVERAGE, MIN, MAXTypical, lowest, highest
• COUNT and COUNTIFHow many, and how many match
• SUMIF and AVERAGEIFTotals for one store or product
• SUMIFSTotals that match two conditions
• COUNTIFSCount rows that match two conditions
• IFLabel rows with a rule
• IF with AND and ORTwo tests at once
• IFSMore than two answers
• Absolute referencesLock a cell with $ and fill down
• XLOOKUPPull a price from another table
• IFERRORShow something useful when a formula fails
• Cleaning textTRIM, PROPER, LEFT and joining
• DatesDays between, weekdays, months
• Sort and filterReorder, narrow down, remove duplicates
• Pivot tablesTotals by group, in a few taps
• Charts and highlightingShow the story
• Weekly reportPut it all together