[ DevCourseWeb.com ] Udemy - Master NEW Excel Functions in Office 365 and Office 2021

File Name

Size

Get Bonus Downloads Here.url

182 B

~Get Your Files Here !/01 - Before You Dive In/001 Course Structure & Outline.mp4

47 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 MB

~Get Your Files Here !/01 - Before You Dive In/002 Do You Have Excel Dynamic Arrays DO THIS TEST!_en.vtt

1.0 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

879 kB

~Get Your Files Here !/01 - Before You Dive In/20814776-Detailed-Course-Outline-Excel-DynamicArrays.xlsx

19 kB

~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S10_Dynamic_ArrayTheory.xlsx

92 kB

~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S10_Dynamic_ArrayTheory_START.xlsx

89 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 kB

~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S2_Dynamic_Array_Basics.xlsx

66 kB

~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S2_Dynamic_Array_Basics_START.xlsx

55 kB

~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S2_XLOOKUP.xlsx

18 kB

~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S2_XLOOKUP_START.xlsx

20 kB

~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S3_Dynamic_Array_LegacyFormulas.xlsx

70 kB

~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S3_Dynamic_Array_LegacyFormulas_START.xlsx

64 kB

~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S4_Dynamic_Array_Features.xlsx

60 kB

~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S4_Dynamic_Array_Features_START.xlsx

45 kB

~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S5_Dynamic_Array_MorePractice_Answers.xlsx

33 kB

~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S5_Dynamic_Array_MorePractice_Questions.xlsx

31 kB

~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S6_Dynamic_Array_AdvancedFilter.xlsx

54 kB

~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S6_Dynamic_Array_AdvancedFilter_START.xlsx

48 kB

~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S7_Dynamic_Array_ArrayConstant.xlsx

35 kB

~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S7_Dynamic_Array_ArrayConstant_START.xlsx

31 kB

~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S8_Dynamic_Array_InteractiveReports.xlsx

103 kB

~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S8_Dynamic_Array_InteractiveReports_START.xlsx

78 kB

~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S9_Dynamic_Array_DataAnalysis.xlsx

42 kB

~Get Your Files Here !/01 - Before You Dive In/SectionFiles/S9_Dynamic_Array_DataAnalysis_START.xlsx

36 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 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

12 kB

~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/004 SORT & SORTBY Functions in Excel.mp4

52 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 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 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.0 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 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

36 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 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 MB

~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/014 XLOOKUP - 5 Practical Examples_en.vtt

14 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

55 kB

~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/20786918-S2-Dynamic-Array-Basics.xlsx

66 kB

~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/20787344-PDF-DA-Rules-Recap.pdf

94 kB

~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/23372940-S2-XLOOKUP-START.xlsx

20 kB

~Get Your Files Here !/02 - Dynamic Arrays & Spill (hash) Behavior (What you need to know)/23372942-S2-XLOOKUP.xlsx

18 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

12 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 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

13 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

15 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 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.0 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 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.0 kB

~Get Your Files Here !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/006 IF Function & Excel Dynamic Arrays.mp4

40 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

43 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 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

56 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.0 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 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

11 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

64 kB

~Get Your Files Here !/03 - How Legacy Formulas are Impacted by Excel's NEW Calculation Engine/20787042-S3-Dynamic-Array-LegacyFormulas.xlsx

70 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

30 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

26 MB

~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/003 Excel Drop-down List (Excludes Blank Cells)_en.vtt

5.9 kB

~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/004 Dependent Drop-down Excel Data Validation (Unique & Sorted).mp4

41 MB

~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/004 Dependent Drop-down Excel Data Validation (Unique & Sorted)_en.vtt

5.7 kB

~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/005 Conditional Formatting & Excel Dynamic Arrays.mp4

97 MB

~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/005 Conditional Formatting & Excel Dynamic Arrays_en.vtt

13 kB

~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/006 Excel Charts with Dynamic Arrays.mp4

63 MB

~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/006 Excel Charts with Dynamic Arrays_en.vtt

9.2 kB

~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/007 Challenge More Dynamic Dependent Data Validation Excel Report.html

961 B

~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/008 Answer More Dynamic Dependent Data Validation Excel Report.mp4

37 MB

~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/008 Answer More Dynamic Dependent Data Validation Excel Report_en.vtt

6.1 kB

~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/009 Bonus Interactive Excel Dashboards with Radio Buttons.mp4

37 MB

~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/009 Bonus Interactive Excel Dashboards with Radio Buttons_en.vtt

16 kB

~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/010 Conclusion DA Impact on Excel Features.mp4

3.1 MB

~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/010 Conclusion DA Impact on Excel Features_en.vtt

1.6 kB

~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/20787076-S4-Dynamic-Array-Features-START.xlsx

45 kB

~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/20787082-S4-Dynamic-Array-Features.xlsx

60 kB

~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/34298274-Bonus-Excel-Radio-Button-Chart.xlsx

27 kB

~Get Your Files Here !/04 - How Excel Features are Impacted by Dynamic Arrays/external-assets-links.txt

94 B

~Get Your Files Here !/05 - Becoming Advanced in Excel Dynamic Arrays/001 Congratulations! You Completed the Fundamentals!.mp4

8.2 MB

~Get Your Files Here !/05 - Becoming Advanced in Excel Dynamic Arrays/001 Congratulations! You Completed the Fundamentals!_en.vtt

1.8 kB

~Get Your Files Here !/05 - Becoming Advanced in Excel Dynamic Arrays/002 More Challenges & Practice Activities.html

190 B

~Get Your Files Here !/05 - Becoming Advanced in Excel Dynamic Arrays/003 Challenge Answers.html

244 B

~Get Your Files Here !/05 - Becoming Advanced in Excel Dynamic Arrays/20787108-S5-Dynamic-Array-MorePractice-Questions.xlsx

31 kB

~Get Your Files Here !/05 - Becoming Advanced in Excel Dynamic Arrays/20787150-S5-Dynamic-Array-MorePractice-Answers.xlsx

33 kB

~Get Your Files Here !/05 - Becoming Advanced in Excel Dynamic Arrays/20787198-PDF-Basics-Completed.pdf

175 kB

~Get Your Files Here !/06 - THE ONE Theory you NEED to Use Excel FILTER Function Like a Pro/001 Why THIS Excel Theory is Important.mp4

13 MB

~Get Your Files Here !/06 - THE ONE Theory you NEED to Use Excel FILTER Function Like a Pro/001 Why THIS Excel Theory is Important_en.vtt

2.0 kB

~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 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_en.vtt

4.8 kB

~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

40 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_en.vtt

6.9 kB

~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 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)_en.vtt

8.7 kB

~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

21 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)_en.vtt

3.9 kB

~Get Your Files Here !/06 - THE ONE Theory you NEED to Use Excel FILTER Function Like a Pro/006 Challenge Dynamic Array Filter Like a Pro.html

1.2 kB

~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 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_en.vtt

9.4 kB

~Get Your Files Here !/06 - THE ONE Theory you NEED to Use Excel FILTER Function Like a Pro/008 Conclusion How to Filter Like a Pro in Excel.html

676 B

~Get Your Files Here !/06 - THE ONE Theory you NEED to Use Excel FILTER Function Like a Pro/20787238-S6-Dynamic-Array-AdvancedFilter-START.xlsx

48 kB

~Get Your Files Here !/06 - THE ONE Theory you NEED to Use Excel FILTER Function Like a Pro/20787244-S6-Dynamic-Array-AdvancedFilter.xlsx

54 kB

~Get Your Files Here !/06 - THE ONE Theory you NEED to Use Excel FILTER Function Like a Pro/20812676-PDF-Conclusion-Filter-Pro.pdf

116 kB

~Get Your Files Here !/07 - Excel Array Logic & Array Constants in Excel Formulas/001 Debugging Trick & Excel Array Syntax - Comma versus Semicolon.mp4

22 MB

~Get Your Files Here !/07 - Excel Array Logic & Array Constants in Excel Formulas/001 Debugging Trick & Excel Array Syntax - Comma versus Semicolon_en.vtt

9.0 kB

~Get Your Files Here !/07 - Excel Array Logic & Array Constants in Excel Formulas/002 Note on Array Syntax for European & None-US Regional Settings.html

3.1 kB

~Get Your Files Here !/07 - Excel Array Logic & Array Constants in Excel Formulas/003 Named Array Constants for Quick Report Setup in Excel.mp4

7.5 MB

~Get Your Files Here !/07 - Excel Array Logic & Array Constants in Excel Formulas/003 Named Array Constants for Quick Report Setup in Excel_en.vtt

3.0 kB

~Get Your Files Here !/07 - Excel Array Logic & Array Constants in Excel Formulas/004 FILTER Function with Array Constants for IF EMPTY Argument.mp4

19 MB

~Get Your Files Here !/07 - Excel Array Logic & Array Constants in Excel Formulas/004 FILTER Function with Array Constants for IF EMPTY Argument_en.vtt

3.2 kB

~Get Your Files Here !/07 - Excel Array Logic & Array Constants in Excel Formulas/005 Top 3 Values with Excel LARGE Function.mp4

14 MB

~Get Your Files Here !/07 - Excel Array Logic & Array Constants in Excel Formulas/005 Top 3 Values with Excel LARGE Function_en.vtt

5.3 kB

~Get Your Files Here !/07 - Excel Array Logic & Array Constants in Excel Formulas/006 Custom Dynamic Sort with Multiple Columns in Excel.mp4

27 MB

~Get Your Files Here !/07 - Excel Array Logic & Array Constants in Excel Formulas/006 Custom Dynamic Sort with Multiple Columns in Excel_en.vtt

4.1 kB

~Get Your Files Here !/07 - Excel Array Logic & Array Constants in Excel Formulas/007 Conclusion Use the Correct Array Syntax in Excel Formulas.html

735 B

~Get Your Files Here !/07 - Excel Array Logic & Array Constants in Excel Formulas/20787366-S7-Dynamic-Array-ArrayConstant-START.xlsx

31 kB

~Get Your Files Here !/07 - Excel Array Logic & Array Constants in Excel Formulas/20787368-S7-Dynamic-Array-ArrayConstant.xlsx

35 kB

~Get Your Files Here !/07 - Excel Array Logic & Array Constants in Excel Formulas/20812712-Conclusion-S7-Array-Syntax.pdf

140 kB

~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/001 Introduction - Interactive Excel Reports Made Easy.mp4

13 MB

~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/001 Introduction - Interactive Excel Reports Made Easy_en.vtt

979 B

~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/002 Easy Pivot Table-Style Reports with Dynamic Arrays.mp4

114 MB

~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/002 Easy Pivot Table-Style Reports with Dynamic Arrays_en.vtt

15 kB

~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

98 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)_en.vtt

17 kB

~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 MB

~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/004 Interest Paid per Month & Year with Excel SEQUENCE Function_en.vtt

10 kB

~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/005 Loan Amortization Table in Excel (Interest, Principal) with SEQUENCE.mp4

32 MB

~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/005 Loan Amortization Table in Excel (Interest, Principal) with SEQUENCE_en.vtt

9.0 kB

~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/006 Dynamic Excel Calendar with SEQUENCE.mp4

61 MB

~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/006 Dynamic Excel Calendar with SEQUENCE_en.vtt

14 kB

~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/007 Shrinking Data Validation - Hide Used Items in Excel.mp4

49 MB

~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/007 Shrinking Data Validation - Hide Used Items in Excel_en.vtt

9.2 kB

~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/008 Searchable Data Validation Drop-down List in Excel.mp4

66 MB

~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/008 Searchable Data Validation Drop-down List in Excel_en.vtt

11 kB

~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/009 Challenge Interactive KPI Selection Excel Report.html

1.1 kB

~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/010 Answer Interactive KPI Selection Excel Report.mp4

57 MB

~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/010 Answer Interactive KPI Selection Excel Report_en.vtt

9.2 kB

~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/26846416-S8-Dynamic-Array-InteractiveReports-START.xlsx

78 kB

~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/26846422-S8-Dynamic-Array-InteractiveReports.xlsx

103 kB

~Get Your Files Here !/08 - Interactive Reports Made Easy with Excel Dynamic Arrays/external-assets-links.txt

52 B

~Get Your Files Here !/09 - Advanced Data Analysis in Excel/001 Introduction - Advanced Data Analysis with Excel Dynamic Arrays.mp4

5.3 MB

~Get Your Files Here !/09 - Advanced Data Analysis in Excel/001 Introduction - Advanced Data Analysis with Excel Dynamic Arrays_en.vtt

1.2 kB

~Get Your Files Here !/09 - Advanced Data Analysis in Excel/002 Multiple Match Results Across Columns (Excel FILTER Function).mp4

13 MB

~Get Your Files Here !/09 - Advanced Data Analysis in Excel/002 Multiple Match Results Across Columns (Excel FILTER Function)_en.vtt

4.2 kB

~Get Your Files Here !/09 - Advanced Data Analysis in Excel/003 Multiple Match Results in Single Cell (Excel TEXTJOIN).mp4

11 MB

~Get Your Files Here !/09 - Advanced Data Analysis in Excel/003 Multiple Match Results in Single Cell (Excel TEXTJOIN)_en.vtt

4.8 kB

~Get Your Files Here !/09 - Advanced Data Analysis in Excel/004 Lookup Approximate Match with Excel FILTER Function.mp4

15 MB

~Get Your Files Here !/09 - Advanced Data Analysis in Excel/004 Lookup Approximate Match with Excel FILTER Function_en.vtt

7.6 kB

~Get Your Files Here !/09 - Advanced Data Analysis in Excel/005 Find Top n Largest Categories & Values (FILTER) in Excel.mp4

26 MB

~Get Your Files Here !/09 - Advanced Data Analysis in Excel/005 Find Top n Largest Categories & Values (FILTER) in Excel_en.vtt

6.7 kB

~Get Your Files Here !/09 - Advanced Data Analysis in Excel/006 Challenge Top 3 Salaries & Employees by Department.html

1.0 kB

~Get Your Files Here !/09 - Advanced Data Analysis in Excel/007 Answer Top 3 Salaries & Employees by Department.mp4

42 MB

~Get Your Files Here !/09 - Advanced Data Analysis in Excel/007 Answer Top 3 Salaries & Employees by Department_en.vtt

9.4 kB

~Get Your Files Here !/09 - Advanced Data Analysis in Excel/20787448-S9-Dynamic-Array-DataAnalysis.xlsx

42 kB

~Get Your Files Here !/09 - Advanced Data Analysis in Excel/24172996-S9-Dynamic-Array-DataAnalysis-START.xlsx

36 kB

~Get Your Files Here !/10 - Advanced to Expert How Excel Arrays Really Work/001 Introduction - How Arrays Work in Excel.mp4

7.2 MB

~Get Your Files Here !/10 - Advanced to Expert How Excel Arrays Really Work/001 Introduction - How Arrays Work in Excel_en.vtt

1.5 kB

~Get Your Files Here !/10 - Advanced to Expert How Excel Arrays Really Work/002 Lifting & Pairwise Lifting (Excel Arrays).mp4

12 MB

~Get Your Files Here !/10 - Advanced to Expert How Excel Arrays Really Work/002 Lifting & Pairwise Lifting (Excel Arrays)_en.vtt

6.4 kB

~Get Your Files Here !/10 - Advanced to Expert How Excel Arrays Really Work/003 Broadcasting Excel Array Behavior.mp4

13 MB

~Get Your Files Here !/10 - Advanced to Expert How Excel Arrays Really Work/003 Broadcasting Excel Array Behavior_en.vtt

5.9 kB

~Get Your Files Here !/10 - Advanced to Expert How Excel Arrays Really Work/004 Implicit Intersection - The Main Legacy Excel Problem.mp4

4.6 MB

~Get Your Files Here !/10 - Advanced to Expert How Excel Arrays Really Work/004 Implicit Intersection - The Main Legacy Excel Problem_en.vtt

2.3 kB

~Get Your Files Here !/10 - Advanced to Expert How Excel Arrays Really Work/005 Are Excel CSE Formulas No Longer Needed.mp4

9.5 MB

~Get Your Files Here !/10 - Advanced to Expert How Excel Arrays Really Work/005 Are Excel CSE Formulas No Longer Needed_en.vtt

2.3 kB

~Get Your Files Here !/10 - Advanced to Expert How Excel Arrays Really Work/20787466-S10-Dynamic-ArrayTheory-START.xlsx

89 kB

~Get Your Files Here !/10 - Advanced to Expert How Excel Arrays Really Work/20787470-S10-Dynamic-ArrayTheory.xlsx

92 kB

~Get Your Files Here !/10 - Advanced to Expert How Excel Arrays Really Work/external-assets-links.txt

399 B

~Get Your Files Here !/11 - More Advanced Excel Dynamic Array Examples/001 Introduction - More Advanced Excel Dynamic Array Examples.mp4

4.9 MB

~Get Your Files Here !/11 - More Advanced Excel Dynamic Array Examples/001 Introduction - More Advanced Excel Dynamic Array Examples_en.vtt

1.5 kB

~Get Your Files Here !/11 - More Advanced Excel Dynamic Array Examples/002 Unique Values From Nonadjacent Columns in Excel.mp4

41 MB

~Get Your Files Here !/11 - More Advanced Excel Dynamic Array Examples/002 Unique Values From Nonadjacent Columns in Excel_en.vtt

8.0 kB

~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 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)_en.vtt

10 kB

~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 MB

~Get Your Files Here !/11 - More Advanced Excel Dynamic Array Examples/004 Split Text & Numbers From 1 Cell to 2 Columns in Excel_en.vtt

12 kB

~Get Your Files Here !/11 - More Advanced Excel Dynamic Array Examples/005 Challenge Filter Values From Non-Adjacent Columns in Excel.html

1.1 kB

~Get Your Files Here !/11 - More Advanced Excel Dynamic Array Examples/006 Answer Filter Values From Non-Adjacent Columns in Excel.mp4

28 MB

~Get Your Files Here !/11 - More Advanced Excel Dynamic Array Examples/006 Answer Filter Values From Non-Adjacent Columns in Excel_en.vtt

5.0 kB

~Get Your Files Here !/11 - More Advanced Excel Dynamic Array Examples/20787716-S11-Dynamic-Array-AdvancedReports-START.xlsx

38 kB

~Get Your Files Here !/11 - More Advanced Excel Dynamic Array Examples/20787722-S11-Dynamic-Array-AdvancedReports.xlsx

47 kB

~Get Your Files Here !/12 - Final Words & More Learning/001 Final Words.mp4

17 MB

~Get Your Files Here !/12 - Final Words & More Learning/001 Final Words_en.vtt

1.8 kB

~Get Your Files Here !/12 - Final Words & More Learning/002 Next Steps - BONUS.html

5.1 kB

~Get Your Files Here !/12 - Final Words & More Learning/external-assets-links.txt

251 B

~Get Your Files Here !/Bonus Resources.txt

386 B