Tabellab

Mid-course project: Mini Dashboard with Profit, Margin & Conditional Formatting

Lesson 8 of 20 Lab 🔒 Locked

Lessons in this course

  1. Your First Workbook: Data, Formulas & AutoSumLabFree
  2. Relative & Absolute References: Shares and a DiscountLab Locked
  3. SUM, AVERAGE, MIN & MAX: Six Months of SalesLab Locked
  4. IF: Let Excel Decide (Reorder & Bonus)Lab Locked
  5. SUMIF & COUNTIF: Totals by CategoryLab Locked
  6. XLOOKUP: Fill In Product and Price AutomaticallyLab Locked
  7. Your First Charts: Column and LineLab Locked
  8. Mid-course project: Mini Dashboard with Profit, Margin & Conditional FormattingLab Locked
  9. Percent Change & Running Totals: July to DecemberLab Locked
  10. SUMIFS & COUNTIFS: A Category × Channel TableLab Locked
  11. IF with AND & OR: Free Gifts and Priority PackingLab Locked
  12. Dates in Excel: Days to Ship & Late OrdersLab Locked
  13. Text Formulas: Clean Product Names and Build SKU CodesLab Locked
  14. Setting Prices: Markup, .90 Endings & MarginLab Locked
  15. An Error-Proof Order Form: IFERROR & Data ValidationLab Locked
  16. Repeat Customers: COUNTIF per Row, Duplicates & Revenue ShareLab Locked
  17. Charts for Parts of a Whole: Pie and Stacked ColumnsLab Locked
  18. Top Sellers: RANK, LARGE & a Bar Chart of All ProductsLab Locked
  19. Planning 2027: Assumptions, ROUND & What-IfLab Locked
  20. Final Project: The Second Half-Year DashboardLab Locked