Macrordinary - VideoAndMovie

Using PIVOTBY ... to pivot Text!

5:53

Using PIVOTBY ... to pivot Text!

Stop Using Nested IF! Use IFS and XLOOKUP Instead.

5:18

Stop Using Nested IF! Use IFS and XLOOKUP Instead.

Building a Multiple Criteria Lookup with LAMBDA in Excel

7:21

Building a Multiple Criteria Lookup with LAMBDA in Excel

Using XLOOKUP with Multiple Criteria

4:50

Using XLOOKUP with Multiple Criteria

Building a Lookup Returning Multiple Values with LAMBDA

7:18

Building a Lookup Returning Multiple Values with LAMBDA

Multiple Values - One Lookup (with BYROW / FILTER)

5:12

Multiple Values - One Lookup (with BYROW / FILTER)

Adding Dynamic New Fields for Variance Analysis in Excel

4:26

Adding Dynamic New Fields for Variance Analysis in Excel

Variance Analysis with the BYROW Function

3:22

Variance Analysis with the BYROW Function

Excel FILTER() - AND / OR and Adding Headers

5:26

Excel FILTER() - AND / OR and Adding Headers

Getting Started with the FILTER Function in Excel

6:30

Getting Started with the FILTER Function in Excel

Additional uses of the SUM Function in Excel

3:55

Additional uses of the SUM Function in Excel

Working with Multiple Users in Power Query

8:29

Working with Multiple Users in Power Query