EX-05-48 – Math Mayhem: Solving Quadratics and Multi-Level Matrices with Excel Array Power
18:58
EX-05-48 – Math Mayhem: Solving Quadratics and Multi-Level Matrices with Excel Array Power
EX-05-47 – Frequency Function for Sales Data: Revenue and Cost Grouping Without the COUNTIFS Mess
8:37
EX-05-47 – Frequency Function for Sales Data: Revenue and Cost Grouping Without the COUNTIFS Mess
EX-05-46 – Frequency Distributions with FREQUENCY: A Smarter Alternative to COUNTIFS
7:39
EX-05-46 – Frequency Distributions with FREQUENCY: A Smarter Alternative to COUNTIFS
EX-05-45 – Measuring Variance: Find the Most Consistent Performer with VAR.P
9:40
EX-05-45 – Measuring Variance: Find the Most Consistent Performer with VAR.P
EX-05-44 – Intro to HLOOKUP: Horizontal Lookups for Row-Based Data
8:43
EX-05-44 – Intro to HLOOKUP: Horizontal Lookups for Row-Based Data
EX-05-43 – Replacing Nested IFs: VLOOKUP for Grading with Letter Tiers
3:44
EX-05-43 – Replacing Nested IFs: VLOOKUP for Grading with Letter Tiers
EX-05-42 – Conditional VLOOKUP: Switching Lookup Tables Based on Rep Tenure
7:30
EX-05-42 – Conditional VLOOKUP: Switching Lookup Tables Based on Rep Tenure
EX-05-41 – VLOOKUP with Approximate Match: Calculating Tiered Sales Commissions
6:34
EX-05-41 – VLOOKUP with Approximate Match: Calculating Tiered Sales Commissions
EX-05-40 – Fixing Lookup Errors: When VLOOKUP or XLOOKUP Breaks Due to Formatting
14:13
EX-05-40 – Fixing Lookup Errors: When VLOOKUP or XLOOKUP Breaks Due to Formatting
EX-05-39 – VLOOKUP with External Files: Pulling Totals from Another Workbook
4:23
EX-05-39 – VLOOKUP with External Files: Pulling Totals from Another Workbook
EX-05-38 – XLOOKUP vs. VLOOKUP: Real-World Head-to-Head Comparison
23:28
EX-05-38 – XLOOKUP vs. VLOOKUP: Real-World Head-to-Head Comparison
EX-05-37 – VLOOKUP in Complex Workbooks: Navigating Multi-Sheet Chaos
22:56
EX-05-37 – VLOOKUP in Complex Workbooks: Navigating Multi-Sheet Chaos
EX-05-36 – VLOOKUP Across Worksheets: Linking Data from Separate Sheets
6:48
EX-05-36 – VLOOKUP Across Worksheets: Linking Data from Separate Sheets
EX-05-35 – Classic VLOOKUP Applications for Multi-Field Lookups
11:51
EX-05-35 – Classic VLOOKUP Applications for Multi-Field Lookups
EX-05-34 – INDEX + MATCH for Smarter, Cleaner Lookup Workflows
15:29
EX-05-34 – INDEX + MATCH for Smarter, Cleaner Lookup Workflows
EX-05-33 — Unique Random Assignments Using Excel Functions
8:24
EX-05-33 — Unique Random Assignments Using Excel Functions
EX-05-32 — Dynamic Totals with SUBTOTAL for Filtered Data
15:08
EX-05-32 — Dynamic Totals with SUBTOTAL for Filtered Data
EX-05-31 — Filtered Weighted Averages with SUMPRODUCT
8:57
EX-05-31 — Filtered Weighted Averages with SUMPRODUCT
EX-05-30 — Conditional Sales Summaries with Date Ranges
10:10
EX-05-30 — Conditional Sales Summaries with Date Ranges
EX-05-29 — Aging Analysis with SUMIF/SUMIFS for Receivables
25:53
EX-05-29 — Aging Analysis with SUMIF/SUMIFS for Receivables
EX-05-28 — Advanced Summary Functions: SUMIF, COUNTIF, AVERAGEIFS & More
19:58
EX-05-28 — Advanced Summary Functions: SUMIF, COUNTIF, AVERAGEIFS & More
EX-05-27 — IF Logic for Threshold Alerts & Return Controls
9:06
EX-05-27 — IF Logic for Threshold Alerts & Return Controls
EX-05-26 — IF Statements for Shipping Timelines & Sales Bonuses
10:43
EX-05-26 — IF Statements for Shipping Timelines & Sales Bonuses
EX-05-25 — IF & IFS Functions: Handling Multiple Outcomes with Grade Logic
15:54
EX-05-25 — IF & IFS Functions: Handling Multiple Outcomes with Grade Logic
EX-05-24 — Flash Fill: Instant Data Cleanup Without a Single Formula
23:28
EX-05-24 — Flash Fill: Instant Data Cleanup Without a Single Formula
EX-05-23 — Mastering Text to Columns: Split Data & Convert Text to Values
7:53
EX-05-23 — Mastering Text to Columns: Split Data & Convert Text to Values
EX-05-22 — Clean and Convert with DATE, SUBSTITUTE & REPLACE Functions
17:11
EX-05-22 — Clean and Convert with DATE, SUBSTITUTE & REPLACE Functions
EX-05-21 — TEXTJOIN vs CONCAT: Smarter Ways to Combine Text in Excel
14:03
EX-05-21 — TEXTJOIN vs CONCAT: Smarter Ways to Combine Text in Excel
EX-05-20 — Data Reconstruction with Text Functions: CONCAT, MID, LEFT, RIGHT & FIND
17:13
EX-05-20 — Data Reconstruction with Text Functions: CONCAT, MID, LEFT, RIGHT & FIND
EX-05-19 — Data Cleanup Essentials: UPPER, LOWER, TRIM & PROPER Functions
7:05
EX-05-19 — Data Cleanup Essentials: UPPER, LOWER, TRIM & PROPER Functions