EX-07-56 — Random Sampling with Excel’s Analysis ToolPak
2:37
EX-07-56 — Random Sampling with Excel’s Analysis ToolPak
EX-07-55 — Finding Data Relationships with the CORREL Function
5:28
EX-07-55 — Finding Data Relationships with the CORREL Function
EX-07-54 — Multi-Period Moving Averages & Trendline Smoothing
6:37
EX-07-54 — Multi-Period Moving Averages & Trendline Smoothing
EX-07-53 — Moving Averages with AVERAGE Function in Excel
10:15
EX-07-53 — Moving Averages with AVERAGE Function in Excel
EX-07-52 — Ranking & Percentile Analysis in Excel
7:12
EX-07-52 — Ranking & Percentile Analysis in Excel
EX-07-51 — Histograms & Descriptive Statistics in Excel
6:53
EX-07-51 — Histograms & Descriptive Statistics in Excel
EX-07-50 — Frequency Distribution Using the FREQUENCY Function
9:16
EX-07-50 — Frequency Distribution Using the FREQUENCY Function
EX-07-49 — Predict Future Data Trends with the Forecast Tool in Excel
10:16
EX-07-49 — Predict Future Data Trends with the Forecast Tool in Excel
EX-07-48 – Solver Troop Deployment: Optimal Movement with Cost Controls
5:27
EX-07-48 – Solver Troop Deployment: Optimal Movement with Cost Controls
EX-07-47 – Solver for Logistics: Minimize Delivery Costs from Plants to Warehouses
9:29
EX-07-47 – Solver for Logistics: Minimize Delivery Costs from Plants to Warehouses
EX-07-46 – Solver for Sales Projections: Align Revenue to Profit Targets
5:41
EX-07-46 – Solver for Sales Projections: Align Revenue to Profit Targets
EX-07-45 – Solver for Fabrication: Minimize Waste in Sheet Metal Optimization
8:40
EX-07-45 – Solver for Fabrication: Minimize Waste in Sheet Metal Optimization
EX-07-44 – Solver for Retail Inventory: Maximizing Profit on Opening Stock
7:38
EX-07-44 – Solver for Retail Inventory: Maximizing Profit on Opening Stock
EX-07-43 – Solver for Manufacturing: Optimize Product Mix with Inventory & Margin Constraints
9:01
EX-07-43 – Solver for Manufacturing: Optimize Product Mix with Inventory & Margin Constraints
EX-07-42 – Solver for Production Planning: Maximizing Profit Under Constraints
13:23
EX-07-42 – Solver for Production Planning: Maximizing Profit Under Constraints
EX-07-41 – Production Matrix: Solving Real-World Mix Models with MMULT & MINVERSE
7:30
EX-07-41 – Production Matrix: Solving Real-World Mix Models with MMULT & MINVERSE
EX-07-40 – Scenario Manager: Building Multi-Outcome Models in Excel
19:22
EX-07-40 – Scenario Manager: Building Multi-Outcome Models in Excel
EX-07-39 – Goal Seek: Solving Backwards with Excel’s Built-In Forecasting Tool
15:49
EX-07-39 – Goal Seek: Solving Backwards with Excel’s Built-In Forecasting Tool
EX-07-38 – Mapping Country Data from PivotTables Using Excel’s Geo Chart
14:42
EX-07-38 – Mapping Country Data from PivotTables Using Excel’s Geo Chart
EX-07-37 – Advanced Slicer Filtering with Custom SUBTOTAL Metrics
7:20
EX-07-37 – Advanced Slicer Filtering with Custom SUBTOTAL Metrics
EX-07-36 – Slicer Filtering with Real-Time Totals in Excel Tables
9:55
EX-07-36 – Slicer Filtering with Real-Time Totals in Excel Tables
EX-07-35 – Multi-Slicer Filtering Across Large Tables for Interactive Dashboards
6:10
EX-07-35 – Multi-Slicer Filtering Across Large Tables for Interactive Dashboards
EX-07-34 – Slicers: Dynamic Filtering for Tables and Disbursement Lists
13:48
EX-07-34 – Slicers: Dynamic Filtering for Tables and Disbursement Lists
EX-07-33 – Color Banding Rows by Criteria Using Conditional Formatting
15:20
EX-07-33 – Color Banding Rows by Criteria Using Conditional Formatting
EX-07-32 – Patterned Color Banding with Conditional Formatting Formulas
13:52
EX-07-32 – Patterned Color Banding with Conditional Formatting Formulas
EX-07-31 – Excel Database Functions: Dynamic Filtering with Calculated Results
16:51
EX-07-31 – Excel Database Functions: Dynamic Filtering with Calculated Results
EX-07-30 – Unlocking the Advanced Filter Tool: Excel’s Most Underrated Power Filter
25:29
EX-07-30 – Unlocking the Advanced Filter Tool: Excel’s Most Underrated Power Filter
EX-07-29 – SUBTOTAL Function for Filtered Data: Accurate, Dynamic Calculations
10:40
EX-07-29 – SUBTOTAL Function for Filtered Data: Accurate, Dynamic Calculations
EX-07-28 – Mastering the SUBTOTAL Tool for Instant Grouped Summaries
19:16
EX-07-28 – Mastering the SUBTOTAL Tool for Instant Grouped Summaries
EX-07-27 – Sorting Horizontally & Vertically: Row and Column Sort Mastery
7:32
EX-07-27 – Sorting Horizontally & Vertically: Row and Column Sort Mastery