~Get Your Files Here !/01 - Before You Dive In/001 Course Structure & Outline.mp4
47.1 MB
~Get Your Files Here !/01 - Before You Dive In/001 Course Structure & Outline_en.vtt
3.9 KB
~Get Your Files Here !/01 - Before You Dive In/002 Do You Have Excel Dynamic Arrays DO THIS TEST!.mp4
10.3 MB
~Get Your Files Here !/01 - Before You Dive In/002 Do You Have Excel Dynamic Arrays DO THIS TEST!_en.vtt
1 KB
~Get Your Files Here !/01 - Before You Dive In/003 Availability of Dynamic Arrays & NEW EXCEL Functions (FILTER, XLOOKUP, SORT...).html
677 B
~Get Your Files Here !/01 - Before You Dive In/004 Summary of Updates to Excel's Calculation Engine.mp4
25 MB
~Get Your Files Here !/01 - Before You Dive In/004 Summary of Updates to Excel's Calculation Engine_en.vtt
2.8 KB
~Get Your Files Here !/01 - Before You Dive In/005 DOWNLOAD Course Files HERE.mp4
4.1 MB
~Get Your Files Here !/01 - Before You Dive In/005 DOWNLOAD Course Files HERE_en.vtt
1.7 KB
~Get Your Files Here !/01 - Before You Dive In/006 Course Outline for Quick Reference.html
468 B
~Get Your Files Here !/01 - Before You Dive In/20786910-Excel-DynamicArrays-CourseNotes.pdf
878.9 KB
~Get Your Files Here !/01 - Before You Dive In/20814776-Detailed-Course-Outline-Excel-DynamicArrays.xlsx
19.4 KB
~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S10_Dynamic_ArrayTheory.xlsx
92.3 KB
~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S10_Dynamic_ArrayTheory_START.xlsx
88.7 KB
~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S11_Dynamic_Array_AdvancedReports.xlsx
47 KB
~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S11_Dynamic_Array_AdvancedReports_START.xlsx
38.5 KB
~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S2_Dynamic_Array_Basics.xlsx
66.5 KB
~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S2_Dynamic_Array_Basics_START.xlsx
54.8 KB
~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S2_XLOOKUP.xlsx
17.8 KB
~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S2_XLOOKUP_START.xlsx
19.7 KB
~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S3_Dynamic_Array_LegacyFormulas.xlsx
70.1 KB
~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S3_Dynamic_Array_LegacyFormulas_START.xlsx
63.7 KB
~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S4_Dynamic_Array_Features.xlsx
59.8 KB
~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S4_Dynamic_Array_Features_START.xlsx
44.6 KB
~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S5_Dynamic_Array_MorePractice_Answers.xlsx
33.3 KB
~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S5_Dynamic_Array_MorePractice_Questions.xlsx
31.2 KB
~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S6_Dynamic_Array_AdvancedFilter.xlsx
54.4 KB
~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S6_Dynamic_Array_AdvancedFilter_START.xlsx
48.1 KB
~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S7_Dynamic_Array_ArrayConstant.xlsx
34.6 KB
~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S7_Dynamic_Array_ArrayConstant_START.xlsx
31.4 KB
~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S8_Dynamic_Array_InteractiveReports.xlsx
103.4 KB
~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S8_Dynamic_Array_InteractiveReports_START.xlsx
78.4 KB
~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S9_Dynamic_Array_DataAnalysis.xlsx
42.4 KB
~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S9_Dynamic_Array_DataAnalysis_START.xlsx
35.7 KB
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/001 Introduction & Glossary of Modern Excel Terms.mp4
17 MB
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/001 Introduction & Glossary of Modern Excel Terms_en.vtt
2.9 KB
~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 MB
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/002 Formulas Spill & Other Excel Dynamic Array Characteristics_en.vtt
9.1 KB
~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.3 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)_en.vtt
11.8 KB
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/004 SORT & SORTBY Functions in Excel.mp4
51.6 MB
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/004 SORT & SORTBY Functions in Excel_en.vtt
12.1 KB
~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.5 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)_en.vtt
9 KB
~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.5 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_en.vtt
8.1 KB
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/007 SEQUENCE Function in Excel.mp4
35.8 MB
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/007 SEQUENCE Function in Excel_en.vtt
9.5 KB
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/008 RANDARRAY Function in Excel.mp4
20.5 MB
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/008 RANDARRAY Function in Excel_en.vtt
8.8 KB
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/009 '@ Prefix for Compatibility (in Excel Formulas).mp4
22 MB
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/009 '@ Prefix for Compatibility (in Excel Formulas)_en.vtt
6.1 KB
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/010 Challenge Create an Excel Summary Report FAST.html
820 B
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/011 Answer Create an Excel Summary Report FAST.mp4
9.3 MB
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/011 Answer Create an Excel Summary Report FAST_en.vtt
4.1 KB
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/012 NEW XLOOKUP in 2020 for Excel Office 365.html
974 B
~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
21 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_en.vtt
8.3 KB
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/014 XLOOKUP - 5 Practical Examples.mp4
93.4 MB
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/014 XLOOKUP - 5 Practical Examples_en.vtt
13.5 KB
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/015 Conclusion Dynamic Array Rules Recap.html
1.3 KB
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/20786916-S2-Dynamic-Array-Basics-START.xlsx
54.6 KB
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/20786918-S2-Dynamic-Array-Basics.xlsx
66.5 KB
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/20787344-PDF-DA-Rules-Recap.pdf
93.6 KB
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/23372940-S2-XLOOKUP-START.xlsx
19.7 KB
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/23372942-S2-XLOOKUP.xlsx
17.8 KB
~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/external-assets-links.txt
59 B
~Get Your Files Here !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/001 Introduction - DA impact on Excel Formulas.mp4
11.7 MB
~Get Your Files Here !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/001 Introduction - DA impact on Excel Formulas_en.vtt
4.2 KB
~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.4 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_en.vtt
12.9 KB
~Get Your Files Here !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/003 Absolute & Mixed Cell Referencing - No Longer Needed in Excel.mp4
14.9 MB
~Get Your Files Here !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/003 Absolute & Mixed Cell Referencing - No Longer Needed in Excel_en.vtt
6.9 KB
~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.3 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)_en.vtt
9 KB
~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/005 VLOOKUP with Excel Dynamic Arrays_en.vtt
7 KB
~Get Your Files Here !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/006 IF Function & Excel Dynamic Arrays.mp4
39.6 MB
~Get Your Files Here !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/006 IF Function & Excel Dynamic Arrays_en.vtt
4.5 KB
~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.8 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_en.vtt
7.3 KB
~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 !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/008 TRANSPOSE & FREQUENCY Functions Made Easier with Excel DA_en.vtt
6.4 KB
~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 !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/009 Do Excel Dynamic Arrays Make Spreadsheets Slow_en.vtt
7 KB
~Get Your Files Here !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/010 Challenge Data Analysis with Legacy Excel Formulas & Dynamic Arrays.html
1.1 KB
~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.2 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_en.vtt
10.6 KB
~Get Your Files Here !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/012 Conclusion Impact of Dynamic Arrays on Legacy Excel Formulas.mp4
4.4 MB
~Get Your Files Here !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/012 Conclusion Impact of Dynamic Arrays on Legacy Excel Formulas_en.vtt
2.5 KB
~Get Your Files Here !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/20787040-S3-Dynamic-Array-LegacyFormulas-START.xlsx
63.7 KB
~Get Your Files Here !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/20787042-S3-Dynamic-Array-LegacyFormulas.xlsx
70.1 KB
~Get Your Files Here !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/external-assets-links.txt
308 B
~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/001 Introduction - DA Impact on Excel Features.mp4
6.3 MB
~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/001 Introduction - DA Impact on Excel Features_en.vtt
1.5 KB
~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.9 MB
~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/002 Data Validation List using Spill Range (and Excel Table)_en.vtt
6.8 KB
~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/003 Excel Drop-down List (Excludes Blank Cells).mp4