| ~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/002 Easy Pivot Table-Style Reports with Dynamic Arrays.mp4 | 113.7 MB |
| ~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/003 Pivot Table (Style) Report with Row & Column Selection (INDEX MATCH & DAs).mp4 | 97.58 MB |
| ~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/005 Conditional Formatting & Excel Dynamic Arrays.mp4 | 96.78 MB |
| ~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/014 XLOOKUP - 5 Practical Examples.mp4 | 93.38 MB |
| ~Get Your Files Here !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/011 Answer Data Analysis with Legacy Excel Formulas & Dynamic Arrays.mp4 | 76.21 MB |
| ~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/003 Excel FILTER Function (The New Excel Power Multi-Lookup).mp4 | 74.33 MB |
| ~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/008 Searchable Data Validation Drop-down List in Excel.mp4 | 66.3 MB |
| ~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/006 Excel Charts with Dynamic Arrays.mp4 | 63.32 MB |
| ~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/006 Dynamic Excel Calendar with SEQUENCE.mp4 | 60.94 MB |
| ~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/010 Answer Interactive KPI Selection Excel Report.mp4 | 57.15 MB |
| ~Get Your Files Here !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/005 VLOOKUP with Excel Dynamic Arrays.mp4 | 56.1 MB |
| ~Get Your Files Here !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/009 Do Excel Dynamic Arrays Make Spreadsheets Slow.mp4 | 55.9 MB |
| ~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/004 SORT & SORTBY Functions in Excel.mp4 | 51.55 MB |
| ~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/002 Formulas Spill & Other Excel Dynamic Array Characteristics.mp4 | 51.05 MB |
| ~Get Your Files Here !/11 - More Advanced Excel Dynamic Array Examples/003 FILTER for BOTH Criteria or EITHER Criteria (AND, OR Together in Excel).mp4 | 50.45 MB |
| ~Get Your Files Here !/06 - THE ONE Theory you NEED to Use Excel FILTER Function Like a Pro/007 Answer Dynamic Array Filter Like a Pro.mp4 | 50.31 MB |
| ~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/007 Shrinking Data Validation - Hide Used Items in Excel.mp4 | 49.29 MB |
| ~Get Your Files Here !/06 - THE ONE Theory you NEED to Use Excel FILTER Function Like a Pro/004 FILTER Function for Multiple Criteria (AND Logical Test in Excel).mp4 | 48.28 MB |
| ~Get Your Files Here !/01 - Before You Dive In/001 Course Structure & Outline.mp4 | 47.09 MB |
| ~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/004 Interest Paid per Month & Year with Excel SEQUENCE Function.mp4 | 45.3 MB |
| ~Get Your Files Here !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/007 Referencing Spilled Data Ranges in Other Excel Sheets.mp4 | 42.84 MB |
| ~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/006 Practical Combination of UNIQUE, SORT & FILTER in Excel.mp4 | 42.46 MB |
| ~Get Your Files Here !/09 - Advanced Data Analysis in Excel/007 Answer Top 3 Salaries & Employees by Department.mp4 | 41.69 MB |
| ~Get Your Files Here !/11 - More Advanced Excel Dynamic Array Examples/002 Unique Values From Nonadjacent Columns in Excel.mp4 | 41.22 MB |
| ~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/004 Dependent Drop-down Excel Data Validation (Unique & Sorted).mp4 | 41.03 MB |
| ~Get Your Files Here !/06 - THE ONE Theory you NEED to Use Excel FILTER Function Like a Pro/003 Excel FILTER to Exclude Blanks, Zero-Value Cells & Text.mp4 | 39.99 MB |
| ~Get Your Files Here !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/006 IF Function & Excel Dynamic Arrays.mp4 | 39.56 MB |
| ~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/005 UNIQUE Function (Get a Unique List of Values in Excel).mp4 | 38.53 MB |
| ~Get Your Files Here !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/008 TRANSPOSE & FREQUENCY Functions Made Easier with Excel DA.mp4 | 38.4 MB |
| ~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/009 Bonus Interactive Excel Dashboards with Radio Buttons.mp4 | 37.15 MB |
| ~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/008 Answer More Dynamic Dependent Data Validation Excel Report.mp4 | 37.05 MB |
| ~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/007 SEQUENCE Function in Excel.mp4 | 35.77 MB |
| ~Get Your Files Here !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/004 SUMIFS & COUNTIFS Improved! (More than one criteria in the same column).mp4 | 32.27 MB |
| ~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/005 Loan Amortization Table in Excel (Interest, Principal) with SEQUENCE.mp4 | 31.59 MB |
| ~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/002 Data Validation List using Spill Range (and Excel Table).mp4 | 29.89 MB |
| ~Get Your Files Here !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/002 Backward & Forward Compatibility with Excel Dynamic Arrays.mp4 | 29.42 MB |
| ~Get Your Files Here !/11 - More Advanced Excel Dynamic Array Examples/006 Answer Filter Values From Non-Adjacent Columns in Excel.mp4 | 27.98 MB |
| ~Get Your Files Here !/07 - Excel Array Logic & Array Constants in Excel Formulas/006 Custom Dynamic Sort with Multiple Columns in Excel.mp4 | 27.14 MB |
| ~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/003 Excel Drop-down List (Excludes Blank Cells).mp4 | 25.97 MB |
| ~Get Your Files Here !/09 - Advanced Data Analysis in Excel/005 Find Top n Largest Categories & Values (FILTER) in Excel.mp4 | 25.54 MB |
| ~Get Your Files Here !/11 - More Advanced Excel Dynamic Array Examples/004 Split Text & Numbers From 1 Cell to 2 Columns in Excel.mp4 | 25.42 MB |
| ~Get Your Files Here !/01 - Before You Dive In/004 Summary of Updates to Excel's Calculation Engine.mp4 | 24.96 MB |
| ~Get Your Files Here !/07 - Excel Array Logic & Array Constants in Excel Formulas/001 Debugging Trick & Excel Array Syntax - Comma versus Semicolon.mp4 | 22.36 MB |
| ~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/009 '@ Prefix for Compatibility (in Excel Formulas).mp4 | 22.01 MB |
| ~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/013 XLOOKUP Basics - The New Power Lookup Formula in 2020.mp4 | 20.95 MB |
| ~Get Your Files Here !/06 - THE ONE Theory you NEED to Use Excel FILTER Function Like a Pro/005 FILTER Formula for Either Value (OR Logical Test in Excel).mp4 | 20.57 MB |
| ~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/008 RANDARRAY Function in Excel.mp4 | 20.51 MB |
| ~Get Your Files Here !/07 - Excel Array Logic & Array Constants in Excel Formulas/004 FILTER Function with Array Constants for IF EMPTY Argument.mp4 | 18.95 MB |
| ~Get Your Files Here !/06 - THE ONE Theory you NEED to Use Excel FILTER Function Like a Pro/002 Boolean Logic (TRUE & FALSE) in Excel Formulas Explained.mp4 | 17.4 MB |
| ~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/001 Introduction & Glossary of Modern Excel Terms.mp4 | 16.99 MB |