Relative & Absolute References: Shares and a Discount
Lessons in this course
- Your First Workbook: Data, Formulas & AutoSumFree
- Relative & Absolute References: Shares and a Discount Locked
- SUM, AVERAGE, MIN & MAX: Six Months of Sales Locked
- IF: Let Excel Decide (Reorder & Bonus) Locked
- SUMIF & COUNTIF: Totals by Category Locked
- XLOOKUP: Fill In Product and Price Automatically Locked
- Your First Charts: Column and Line Locked
- Mid-course project: Mini Dashboard with Profit, Margin & Conditional Formatting Locked
- Percent Change & Running Totals: July to December Locked
- SUMIFS & COUNTIFS: A Category × Channel Table Locked
- IF with AND & OR: Free Gifts and Priority Packing Locked
- Dates in Excel: Days to Ship & Late Orders Locked
- Text Formulas: Clean Product Names and Build SKU Codes Locked
- Setting Prices: Markup, .90 Endings & Margin Locked
- An Error-Proof Order Form: IFERROR & Data Validation Locked
- Repeat Customers: COUNTIF per Row, Duplicates & Revenue Share Locked
- Charts for Parts of a Whole: Pie and Stacked Columns Locked
- Top Sellers: RANK, LARGE & a Bar Chart of All Products Locked
- Planning 2027: Assumptions, ROUND & What-If Locked
- Final Project: The Second Half-Year Dashboard Locked