[ WebToolTip.com ] Complete Guide to Next Gen Excel Formulas for Data Analysts by Microsoft Press

File Name

Size

Get Bonus Downloads Here.url

180 B

~Get Your Files Here !/01. Introduction/01. Welcome to the course.mp4

9.4 MB

~Get Your Files Here !/01. Introduction/01. Welcome to the course.srt

3.2 kB

~Get Your Files Here !/02. 1. Build Structured Models with Excel Tables/01. Learning objectives.mp4

3.0 MB

~Get Your Files Here !/02. 1. Build Structured Models with Excel Tables/01. Learning objectives.srt

1.2 kB

~Get Your Files Here !/02. 1. Build Structured Models with Excel Tables/02. Tables The foundation of dynamic models.mp4

17 MB

~Get Your Files Here !/02. 1. Build Structured Models with Excel Tables/02. Tables The foundation of dynamic models.srt

6.4 kB

~Get Your Files Here !/02. 1. Build Structured Models with Excel Tables/03. Create and manage Excel tables.mp4

17 MB

~Get Your Files Here !/02. 1. Build Structured Models with Excel Tables/03. Create and manage Excel tables.srt

5.6 kB

~Get Your Files Here !/02. 1. Build Structured Models with Excel Tables/04. Write smarter formulas with structured references.mp4

18 MB

~Get Your Files Here !/02. 1. Build Structured Models with Excel Tables/04. Write smarter formulas with structured references.srt

6.0 kB

~Get Your Files Here !/02. 1. Build Structured Models with Excel Tables/05. Reference table data like a pro.mp4

12 MB

~Get Your Files Here !/02. 1. Build Structured Models with Excel Tables/05. Reference table data like a pro.srt

6.8 kB

~Get Your Files Here !/02. 1. Build Structured Models with Excel Tables/06. Filter faster with Slicers.mp4

20 MB

~Get Your Files Here !/02. 1. Build Structured Models with Excel Tables/06. Filter faster with Slicers.srt

6.6 kB

~Get Your Files Here !/02. 1. Build Structured Models with Excel Tables/07. Exercise Build and analyze with tables.mp4

14 MB

~Get Your Files Here !/02. 1. Build Structured Models with Excel Tables/07. Exercise Build and analyze with tables.srt

4.6 kB

~Get Your Files Here !/03. 2. Master Dynamic Arrays/01. Learning objectives.mp4

3.6 MB

~Get Your Files Here !/03. 2. Master Dynamic Arrays/01. Learning objectives.srt

1.2 kB

~Get Your Files Here !/03. 2. Master Dynamic Arrays/02. Explore the concept of dynamic array formulas.mp4

12 MB

~Get Your Files Here !/03. 2. Master Dynamic Arrays/02. Explore the concept of dynamic array formulas.srt

7.1 kB

~Get Your Files Here !/03. 2. Master Dynamic Arrays/03. Manage spill ranges effectively.mp4

9.4 MB

~Get Your Files Here !/03. 2. Master Dynamic Arrays/03. Manage spill ranges effectively.srt

5.1 kB

~Get Your Files Here !/03. 2. Master Dynamic Arrays/04. Build solutions with dynamic array formulas.mp4

15 MB

~Get Your Files Here !/03. 2. Master Dynamic Arrays/04. Build solutions with dynamic array formulas.srt

8.6 kB

~Get Your Files Here !/03. 2. Master Dynamic Arrays/05. Filter data dynamically with the FILTER function.mp4

17 MB

~Get Your Files Here !/03. 2. Master Dynamic Arrays/05. Filter data dynamically with the FILTER function.srt

8.1 kB

~Get Your Files Here !/03. 2. Master Dynamic Arrays/06. Sort data in arrays.mp4

15 MB

~Get Your Files Here !/03. 2. Master Dynamic Arrays/06. Sort data in arrays.srt

6.1 kB

~Get Your Files Here !/03. 2. Master Dynamic Arrays/07. Lookup values with XLOOKUP.mp4

14 MB

~Get Your Files Here !/03. 2. Master Dynamic Arrays/07. Lookup values with XLOOKUP.srt

7.3 kB

~Get Your Files Here !/03. 2. Master Dynamic Arrays/08. Return arrays using XLOOKUP.mp4

5.7 MB

~Get Your Files Here !/03. 2. Master Dynamic Arrays/08. Return arrays using XLOOKUP.srt

3.3 kB

~Get Your Files Here !/03. 2. Master Dynamic Arrays/09. Exercise Extract, sort, and return.mp4

13 MB

~Get Your Files Here !/03. 2. Master Dynamic Arrays/09. Exercise Extract, sort, and return.srt

5.6 kB

~Get Your Files Here !/04. 3. Shape and Slice Arrays/01. Learning objectives.mp4

2.9 MB

~Get Your Files Here !/04. 3. Shape and Slice Arrays/01. Learning objectives.srt

910 B

~Get Your Files Here !/04. 3. Shape and Slice Arrays/02. Use CHOOSE to specify columns in an array.mp4

19 MB

~Get Your Files Here !/04. 3. Shape and Slice Arrays/02. Use CHOOSE to specify columns in an array.srt

6.5 kB

~Get Your Files Here !/04. 3. Shape and Slice Arrays/03. Extract columns with CHOOSECOLS.mp4

12 MB

~Get Your Files Here !/04. 3. Shape and Slice Arrays/03. Extract columns with CHOOSECOLS.srt

5.5 kB

~Get Your Files Here !/04. 3. Shape and Slice Arrays/04. Retrieve columns dynamically with MATCH.mp4

7.6 MB

~Get Your Files Here !/04. 3. Shape and Slice Arrays/04. Retrieve columns dynamically with MATCH.srt

2.9 kB

~Get Your Files Here !/04. 3. Shape and Slice Arrays/05. Target rows dynamically.mp4

6.7 MB

~Get Your Files Here !/04. 3. Shape and Slice Arrays/05. Target rows dynamically.srt

2.7 kB

~Get Your Files Here !/04. 3. Shape and Slice Arrays/06. Explore XMATCH for next-level matching.mp4

20 MB

~Get Your Files Here !/04. 3. Shape and Slice Arrays/06. Explore XMATCH for next-level matching.srt

7.3 kB

~Get Your Files Here !/04. 3. Shape and Slice Arrays/07. TAKE what you need and DROP what you don’t.mp4

20 MB

~Get Your Files Here !/04. 3. Shape and Slice Arrays/07. TAKE what you need and DROP what you don’t.srt

8.9 kB

~Get Your Files Here !/04. 3. Shape and Slice Arrays/08. Exercise Pick the right pieces.mp4

11 MB

~Get Your Files Here !/04. 3. Shape and Slice Arrays/08. Exercise Pick the right pieces.srt

4.3 kB

~Get Your Files Here !/05. 4. Trim and Stack Ranges/01. Learning objectives.mp4

3.6 MB

~Get Your Files Here !/05. 4. Trim and Stack Ranges/01. Learning objectives.srt

1.1 kB

~Get Your Files Here !/05. 4. Trim and Stack Ranges/02. Apply the TRIMRANGE function.mp4

19 MB

~Get Your Files Here !/05. 4. Trim and Stack Ranges/02. Apply the TRIMRANGE function.srt

8.2 kB

~Get Your Files Here !/05. 4. Trim and Stack Ranges/03. Use the dot operator in formulas.mp4

4.6 MB

~Get Your Files Here !/05. 4. Trim and Stack Ranges/03. Use the dot operator in formulas.srt

1.8 kB

~Get Your Files Here !/05. 4. Trim and Stack Ranges/04. Stack Tables and trimmed ranges vertically.mp4

12 MB

~Get Your Files Here !/05. 4. Trim and Stack Ranges/04. Stack Tables and trimmed ranges vertically.srt

5.2 kB

~Get Your Files Here !/05. 4. Trim and Stack Ranges/05. Combine data with HSTACK.mp4

6.2 MB

~Get Your Files Here !/05. 4. Trim and Stack Ranges/05. Combine data with HSTACK.srt

2.7 kB

~Get Your Files Here !/05. 4. Trim and Stack Ranges/06. Exercise Clean and combine ranges.mp4

16 MB

~Get Your Files Here !/05. 4. Trim and Stack Ranges/06. Exercise Clean and combine ranges.srt

6.9 kB

~Get Your Files Here !/06. 5. Perform Iterative Calculations with BYROW, MAP, and SCAN/01. Learning objectives.mp4

3.9 MB

~Get Your Files Here !/06. 5. Perform Iterative Calculations with BYROW, MAP, and SCAN/01. Learning objectives.srt

1.2 kB

~Get Your Files Here !/06. 5. Perform Iterative Calculations with BYROW, MAP, and SCAN/02. Aggregate values by column.mp4

14 MB

~Get Your Files Here !/06. 5. Perform Iterative Calculations with BYROW, MAP, and SCAN/02. Aggregate values by column.srt

7.4 kB

~Get Your Files Here !/06. 5. Perform Iterative Calculations with BYROW, MAP, and SCAN/03. Make calculations dynamic with the dot operator.mp4

4.5 MB

~Get Your Files Here !/06. 5. Perform Iterative Calculations with BYROW, MAP, and SCAN/03. Make calculations dynamic with the dot operator.srt

2.1 kB

~Get Your Files Here !/06. 5. Perform Iterative Calculations with BYROW, MAP, and SCAN/04. Iterate down a column using BYROW.mp4

8.8 MB

~Get Your Files Here !/06. 5. Perform Iterative Calculations with BYROW, MAP, and SCAN/04. Iterate down a column using BYROW.srt

4.4 kB

~Get Your Files Here !/06. 5. Perform Iterative Calculations with BYROW, MAP, and SCAN/05. Apply the MAP function.mp4

9.3 MB

~Get Your Files Here !/06. 5. Perform Iterative Calculations with BYROW, MAP, and SCAN/05. Apply the MAP function.srt

5.2 kB

~Get Your Files Here !/06. 5. Perform Iterative Calculations with BYROW, MAP, and SCAN/06. Choose when to use BYROWBYCOL or MAP.mp4

14 MB

~Get Your Files Here !/06. 5. Perform Iterative Calculations with BYROW, MAP, and SCAN/06. Choose when to use BYROWBYCOL or MAP.srt

7.2 kB

~Get Your Files Here !/06. 5. Perform Iterative Calculations with BYROW, MAP, and SCAN/07. Format spill ranges effectively.mp4

9.1 MB

~Get Your Files Here !/06. 5. Perform Iterative Calculations with BYROW, MAP, and SCAN/07. Format spill ranges effectively.srt

4.6 kB

~Get Your Files Here !/06. 5. Perform Iterative Calculations with BYROW, MAP, and SCAN/08. Generate running totals with SCAN.mp4

14 MB

~Get Your Files Here !/06. 5. Perform Iterative Calculations with BYROW, MAP, and SCAN/08. Generate running totals with SCAN.srt

9.7 kB

~Get Your Files Here !/06. 5. Perform Iterative Calculations with BYROW, MAP, and SCAN/09. REDUCE iterations to a single result.mp4

20 MB

~Get Your Files Here !/06. 5. Perform Iterative Calculations with BYROW, MAP, and SCAN/09. REDUCE iterations to a single result.srt

10 kB

~Get Your Files Here !/06. 5. Perform Iterative Calculations with BYROW, MAP, and SCAN/10. Exercise Iterate and calculate.mp4

25 MB

~Get Your Files Here !/06. 5. Perform Iterative Calculations with BYROW, MAP, and SCAN/10. Exercise Iterate and calculate.srt

14 kB

~Get Your Files Here !/07. 6. Optimize Formulas with LET and Names/01. Learning objectives.mp4

4.1 MB

~Get Your Files Here !/07. 6. Optimize Formulas with LET and Names/01. Learning objectives.srt

1.3 kB

~Get Your Files Here !/07. 6. Optimize Formulas with LET and Names/02. Recognize why LET is so useful.mp4

6.1 MB

~Get Your Files Here !/07. 6. Optimize Formulas with LET and Names/02. Recognize why LET is so useful.srt

2.3 kB

~Get Your Files Here !/07. 6. Optimize Formulas with LET and Names/03. Simplify a formula with the LET function.mp4

13 MB

~Get Your Files Here !/07. 6. Optimize Formulas with LET and Names/03. Simplify a formula with the LET function.srt

5.7 kB

~Get Your Files Here !/07. 6. Optimize Formulas with LET and Names/04. Apply good practices for names.mp4

4.3 MB

~Get Your Files Here !/07. 6. Optimize Formulas with LET and Names/04. Apply good practices for names.srt

1.8 kB

~Get Your Files Here !/07. 6. Optimize Formulas with LET and Names/05. Extend LET to the next level.mp4

17 MB

~Get Your Files Here !/07. 6. Optimize Formulas with LET and Names/05. Extend LET to the next level.srt

9.1 kB

~Get Your Files Here !/07. 6. Optimize Formulas with LET and Names/06. Troubleshoot complex formulas with LET.mp4

5.1 MB

~Get Your Files Here !/07. 6. Optimize Formulas with LET and Names/06. Troubleshoot complex formulas with LET.srt

2.0 kB

~Get Your Files Here !/07. 6. Optimize Formulas with LET and Names/07. Understand why to name a formula.mp4

2.6 MB

~Get Your Files Here !/07. 6. Optimize Formulas with LET and Names/07. Understand why to name a formula.srt

921 B

~Get Your Files Here !/07. 6. Optimize Formulas with LET and Names/08. Reuse calculations by naming a formula.mp4

20 MB

~Get Your Files Here !/07. 6. Optimize Formulas with LET and Names/08. Reuse calculations by naming a formula.srt

11 kB

~Get Your Files Here !/07. 6. Optimize Formulas with LET and Names/09. Avoid pitfalls with named formulas.mp4

5.0 MB

~Get Your Files Here !/07. 6. Optimize Formulas with LET and Names/09. Avoid pitfalls with named formulas.srt

1.8 kB

~Get Your Files Here !/07. 6. Optimize Formulas with LET and Names/10. Exercise Simplify with LET and names.mp4

9.8 MB

~Get Your Files Here !/07. 6. Optimize Formulas with LET and Names/10. Exercise Simplify with LET and names.srt

3.8 kB

~Get Your Files Here !/08. 7. Create Single-Cell Reports with GROUPBY and PIVOTBY/01. Learning objectives.mp4

3.2 MB

~Get Your Files Here !/08. 7. Create Single-Cell Reports with GROUPBY and PIVOTBY/01. Learning objectives.srt

1.1 kB

~Get Your Files Here !/08. 7. Create Single-Cell Reports with GROUPBY and PIVOTBY/02. Summarize data with GROUPBY.mp4

19 MB

~Get Your Files Here !/08. 7. Create Single-Cell Reports with GROUPBY and PIVOTBY/02. Summarize data with GROUPBY.srt

9.7 kB

~Get Your Files Here !/08. 7. Create Single-Cell Reports with GROUPBY and PIVOTBY/03. Build formula-based PivotTables with PIVOTBY.mp4

11 MB

~Get Your Files Here !/08. 7. Create Single-Cell Reports with GROUPBY and PIVOTBY/03. Build formula-based PivotTables with PIVOTBY.srt

6.8 kB

~Get Your Files Here !/08. 7. Create Single-Cell Reports with GROUPBY and PIVOTBY/04. Compare GROUPBY and PIVOTBY.mp4

13 MB

~Get Your Files Here !/08. 7. Create Single-Cell Reports with GROUPBY and PIVOTBY/04. Compare GROUPBY and PIVOTBY.srt

6.6 kB

~Get Your Files Here !/08. 7. Create Single-Cell Reports with GROUPBY and PIVOTBY/05. Add subtotals to your reports.mp4

10 MB

~Get Your Files Here !/08. 7. Create Single-Cell Reports with GROUPBY and PIVOTBY/05. Add subtotals to your reports.srt

5.5 kB

~Get Your Files Here !/08. 7. Create Single-Cell Reports with GROUPBY and PIVOTBY/06. Format GROUPBY and PIVOTBY results.mp4

18 MB

~Get Your Files Here !/08. 7. Create Single-Cell Reports with GROUPBY and PIVOTBY/06. Format GROUPBY and PIVOTBY results.srt

7.8 kB

~Get Your Files Here !/08. 7. Create Single-Cell Reports with GROUPBY and PIVOTBY/07. Stack multiple aggregation functions.mp4

10 MB

~Get Your Files Here !/08. 7. Create Single-Cell Reports with GROUPBY and PIVOTBY/07. Stack multiple aggregation functions.srt

5.6 kB

~Get Your Files Here !/08. 7. Create Single-Cell Reports with GROUPBY and PIVOTBY/08. Filter report results dynamically.mp4

9.2 MB

~Get Your Files Here !/08. 7. Create Single-Cell Reports with GROUPBY and PIVOTBY/08. Filter report results dynamically.srt

4.4 kB

~Get Your Files Here !/08. 7. Create Single-Cell Reports with GROUPBY and PIVOTBY/09. Use Slicers with GROUPBY and PIVOTBY.mp4

25 MB

~Get Your Files Here !/08. 7. Create Single-Cell Reports with GROUPBY and PIVOTBY/09. Use Slicers with GROUPBY and PIVOTBY.srt

9.5 kB

~Get Your Files Here !/08. 7. Create Single-Cell Reports with GROUPBY and PIVOTBY/10. Exercise Build a formula-driven report.mp4

16 MB

~Get Your Files Here !/08. 7. Create Single-Cell Reports with GROUPBY and PIVOTBY/10. Exercise Build a formula-driven report.srt

6.7 kB

~Get Your Files Here !/09. 8. Create Custom Functions with LAMBDA/01. Learning objectives.mp4

3.4 MB

~Get Your Files Here !/09. 8. Create Custom Functions with LAMBDA/01. Learning objectives.srt

1.2 kB

~Get Your Files Here !/09. 8. Create Custom Functions with LAMBDA/02. Explore the LAMBDA function with an example.mp4

12 MB

~Get Your Files Here !/09. 8. Create Custom Functions with LAMBDA/02. Explore the LAMBDA function with an example.srt

6.1 kB

~Get Your Files Here !/09. 8. Create Custom Functions with LAMBDA/03. Convert a formula into a custom LAMBDA.mp4

14 MB

~Get Your Files Here !/09. 8. Create Custom Functions with LAMBDA/03. Convert a formula into a custom LAMBDA.srt

6.6 kB

~Get Your Files Here !/09. 8. Create Custom Functions with LAMBDA/04. Save and manage named LAMBDA functions.mp4

4.8 MB

~Get Your Files Here !/09. 8. Create Custom Functions with LAMBDA/04. Save and manage named LAMBDA functions.srt

2.4 kB

~Get Your Files Here !/09. 8. Create Custom Functions with LAMBDA/05. Use your custom LAMBDA function.mp4

8.8 MB

~Get Your Files Here !/09. 8. Create Custom Functions with LAMBDA/05. Use your custom LAMBDA function.srt

4.8 kB

~Get Your Files Here !/09. 8. Create Custom Functions with LAMBDA/06. Modify an existing LAMBDA.mp4

19 MB

~Get Your Files Here !/09. 8. Create Custom Functions with LAMBDA/06. Modify an existing LAMBDA.srt

10 kB

~Get Your Files Here !/09. 8. Create Custom Functions with LAMBDA/07. Share LAMBDA functions across workbooks.mp4

16 MB

~Get Your Files Here !/09. 8. Create Custom Functions with LAMBDA/07. Share LAMBDA functions across workbooks.srt

8.1 kB

~Get Your Files Here !/09. 8. Create Custom Functions with LAMBDA/08. Exercise Create and reuse your own function.mp4

18 MB

~Get Your Files Here !/09. 8. Create Custom Functions with LAMBDA/08. Exercise Create and reuse your own function.srt

6.9 kB

~Get Your Files Here !/10. Conclusion/01. Course summary and next steps.mp4

7.9 MB

~Get Your Files Here !/10. Conclusion/01. Course summary and next steps.srt

2.5 kB

~Get Your Files Here !/Bonus Resources.txt

70 B