~Get Your Files Here !

  01 - Before You Dive In

   001 Course Structure & Outline_en.vtt

   002 Do You Have Excel Dynamic Arrays DO THIS TEST!_en.vtt

   004 Summary of Updates to Excel's Calculation Engine.mp4

   005 DOWNLOAD Course Files HERE.mp4

   006 Course Outline for Quick Reference.html

   20814776-Detailed-Course-Outline-Excel-DynamicArrays.xlsx

   SectionFiles

    S10_Dynamic_ArrayTheory_START.xlsx

    S11_Dynamic_Array_AdvancedReports_START.xlsx

    S2_Dynamic_Array_Basics_START.xlsx

    S2_XLOOKUP_START.xlsx

    S3_Dynamic_Array_LegacyFormulas_START.xlsx

    S4_Dynamic_Array_Features_START.xlsx

    S5_Dynamic_Array_MorePractice_Questions.xlsx

    S6_Dynamic_Array_AdvancedFilter_START.xlsx

    S7_Dynamic_Array_ArrayConstant_START.xlsx

    S8_Dynamic_Array_InteractiveReports_START.xlsx

    S9_Dynamic_Array_DataAnalysis_START.xlsx

  02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)

   001 Introduction & Glossary of Modern Excel Terms_en.vtt

   002 Formulas Spill & Other Excel Dynamic Array Characteristics_en.vtt

   003 Excel FILTER Function (The New Excel Power Multi-Lookup)_en.vtt

   004 SORT & SORTBY Functions in Excel_en.vtt

   005 UNIQUE Function (Get a Unique List of Values in Excel)_en.vtt

   006 Practical Combination of UNIQUE, SORT & FILTER in Excel_en.vtt

   007 SEQUENCE Function in Excel_en.vtt

   008 RANDARRAY Function in Excel_en.vtt

   009 '@ Prefix for Compatibility (in Excel Formulas)_en.vtt

   011 Answer Create an Excel Summary Report FAST.mp4

   012 NEW XLOOKUP in 2020 for Excel Office 365.html

   013 XLOOKUP Basics - The New Power Lookup Formula in 2020_en.vtt

   014 XLOOKUP - 5 Practical Examples_en.vtt

   20786916-S2-Dynamic-Array-Basics-START.xlsx

   20787344-PDF-DA-Rules-Recap.pdf

   23372942-S2-XLOOKUP.xlsx

  03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine

   001 Introduction - DA impact on Excel Formulas_en.vtt

   002 Backward & Forward Compatibility with Excel Dynamic Arrays_en.vtt

   003 Absolute & Mixed Cell Referencing - No Longer Needed in Excel_en.vtt

   004 SUMIFS & COUNTIFS Improved! (More than one criteria in the same column)_en.vtt

   005 VLOOKUP with Excel Dynamic Arrays_en.vtt

   006 IF Function & Excel Dynamic Arrays_en.vtt

   007 Referencing Spilled Data Ranges in Other Excel Sheets_en.vtt

   008 TRANSPOSE & FREQUENCY Functions Made Easier with Excel DA_en.vtt

   009 Do Excel Dynamic Arrays Make Spreadsheets Slow_en.vtt

   011 Answer Data Analysis with Legacy Excel Formulas & Dynamic Arrays.mp4

   012 Conclusion Impact of Dynamic Arrays on Legacy Excel Formulas.mp4

   20787040-S3-Dynamic-Array-LegacyFormulas-START.xlsx

   external-assets-links.txt

  04 - How Excel Features are Impacted by Dynamic Arrays

   001 Introduction - DA Impact on Excel Features_en.vtt

   002 Data Validation List using Spill Range (and Excel Table)_en.vtt

   003 Excel Drop-down List (Excludes Blank Cells)_en.vtt

   004 Dependent Drop-down Excel Data Validation (Unique & Sorted)_en.vtt

   005 Conditional Formatting & Excel Dynamic Arrays_en.vtt

   006 Excel Charts with Dynamic Arrays_en.vtt

   008 Answer More Dynamic Dependent Data Validation Excel Report.mp4

   009 Bonus Interactive Excel Dashboards with Radio Buttons.mp4

   010 Conclusion DA Impact on Excel Features.mp4

   20787076-S4-Dynamic-Array-Features-START.xlsx

   34298274-Bonus-Excel-Radio-Button-Chart.xlsx

  05 - Becoming Advanced in Excel Dynamic Arrays

   001 Congratulations! You Completed the Fundamentals!_en.vtt

   003 Challenge Answers.html

   20787150-S5-Dynamic-Array-MorePractice-Answers.xlsx

  06 - THE ONE Theory you NEED to Use Excel FILTER Function Like a Pro

   001 Why THIS Excel Theory is Important_en.vtt

   002 Boolean Logic (TRUE & FALSE) in Excel Formulas Explained_en.vtt

   003 Excel FILTER to Exclude Blanks, Zero-Value Cells & Text_en.vtt

   004 FILTER Function for Multiple Criteria (AND Logical Test in Excel)_en.vtt

   005 FILTER Formula for Either Value (OR Logical Test in Excel)_en.vtt

   007 Answer Dynamic Array Filter Like a Pro.mp4

   008 Conclusion How to Filter Like a Pro in Excel.html

   20787244-S6-Dynamic-Array-AdvancedFilter.xlsx

  07 - Excel Array Logic & Array Constants in Excel Formulas

   001 Debugging Trick & Excel Array Syntax - Comma versus Semicolon_en.vtt

   003 Named Array Constants for Quick Report Setup in Excel.mp4

   004 FILTER Function with Array Constants for IF EMPTY Argument.mp4

   005 Top 3 Values with Excel LARGE Function.mp4

   006 Custom Dynamic Sort with Multiple Columns in Excel.mp4

   007 Conclusion Use the Correct Array Syntax in Excel Formulas.html

   20787368-S7-Dynamic-Array-ArrayConstant.xlsx

  08 - Interactive Reports Made Easy with Excel Dynamic Arrays

   001 Introduction - Interactive Excel Reports Made Easy_en.vtt

   002 Easy Pivot Table-Style Reports with Dynamic Arrays_en.vtt

   003 Pivot Table (Style) Report with Row & Column Selection (INDEX MATCH & DAs)_en.vtt

   004 Interest Paid per Month & Year with Excel SEQUENCE Function_en.vtt

   005 Loan Amortization Table in Excel (Interest, Principal) with SEQUENCE_en.vtt

   006 Dynamic Excel Calendar with SEQUENCE_en.vtt

   007 Shrinking Data Validation - Hide Used Items in Excel_en.vtt

   008 Searchable Data Validation Drop-down List in Excel_en.vtt

   010 Answer Interactive KPI Selection Excel Report.mp4

   26846416-S8-Dynamic-Array-InteractiveReports-START.xlsx

   external-assets-links.txt

  09 - Advanced Data Analysis in Excel

   001 Introduction - Advanced Data Analysis with Excel Dynamic Arrays_en.vtt

   002 Multiple Match Results Across Columns (Excel FILTER Function)_en.vtt

   003 Multiple Match Results in Single Cell (Excel TEXTJOIN)_en.vtt

   004 Lookup Approximate Match with Excel FILTER Function_en.vtt

   005 Find Top n Largest Categories & Values (FILTER) in Excel_en.vtt

   007 Answer Top 3 Salaries & Employees by Department.mp4

   20787448-S9-Dynamic-Array-DataAnalysis.xlsx

  10 - Advanced to Expert How Excel Arrays Really Work

   001 Introduction - How Arrays Work in Excel_en.vtt

   002 Lifting & Pairwise Lifting (Excel Arrays)_en.vtt

   003 Broadcasting Excel Array Behavior_en.vtt

   004 Implicit Intersection - The Main Legacy Excel Problem_en.vtt

   005 Are Excel CSE Formulas No Longer Needed_en.vtt

   20787470-S10-Dynamic-ArrayTheory.xlsx

  11 - More Advanced Excel Dynamic Array Examples

   001 Introduction - More Advanced Excel Dynamic Array Examples_en.vtt

   002 Unique Values From Nonadjacent Columns in Excel_en.vtt

   003 FILTER for BOTH Criteria or EITHER Criteria (AND, OR Together in Excel)_en.vtt

   004 Split Text & Numbers From 1 Cell to 2 Columns in Excel_en.vtt

   006 Answer Filter Values From Non-Adjacent Columns in Excel.mp4

   20787716-S11-Dynamic-Array-AdvancedReports-START.xlsx

  12 - Final Words & More Learning

   001 Final Words_en.vtt

   external-assets-links.txt