Microsoft Excel · Professional
Lookups, conditional logic, tables and charts for everyday work.
Lessons
- 1Decisions with IFAward delivery bonuses automatically with IF, comparison operators and text results.Not startedPremium lesson15 min
- 2AND, OR & Nested IFClassify suppliers as Approved, Review or Rejected by combining AND, OR and a nested IF.Not startedPremium lesson16 min
- 3COUNTIF, SUMIF & AVERAGEIFSummarise a helpdesk ticket log by team and status with conditional counting, summing and averaging.Not startedPremium lesson15 min
- 4SUMIFS & COUNTIFS with Several CriteriaAnswer sales questions that combine region, product, rep and value thresholds.Not startedPremium lesson16 min
- 5VLOOKUP with Exact MatchFill an office-supply order form with product names and prices from a price list.Not startedPremium lesson16 min
- 6XLOOKUPSearch an employee directory in any direction and handle missing IDs gracefully with XLOOKUP.Not startedPremium lesson16 min
- 7INDEX & MATCH Two-Way LookupsFind a shipping rate by weight band and zone with a two-way INDEX/MATCH lookup.Not startedPremium lesson18 min
- 8Cleaning Text DataClean an imported customer list with TRIM, PROPER, LOWER, FIND and MID.Not startedPremium lesson17 min
- 9Working with DatesPlan a website project with date arithmetic, NETWORKDAYS and MONTH.Not startedPremium lesson17 min
- 10Error-Proof Formulas with IFERRORCalculate sales commissions that survive missing rates and zero orders using IFERROR.Not startedPremium lesson17 min
- 11Building a Summary ReportTurn a café’s raw transactions into a category report with totals, shares, ranks and the top seller.Not startedPremium lesson20 min
- 12Final Assessment: Inventory Reorder ReportPractical assessment: build a warehouse reorder report with IF, ROUND, COUNTIF, SUMIF, SUMIFS and XLOOKUP.Not startedPremium lesson25 min
