CellWorks

Microsoft Excel · Professional

Lookups, conditional logic, tables and charts for everyday work.

Lessons

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