Advanced Microsoft Excel tutorials

Create a dynamic two color column chart in Excel to show increases and decreases

Create a dynamic two color column chart in Excel to show increases and decreases

Excel: Get & Transform Data - Unpivot Columns

Excel: Get & Transform Data - Unpivot Columns

SORTBY Function in Excel - Dynamic Array Function

SORTBY Function in Excel - Dynamic Array Function

XLOOKUP function in Excel

XLOOKUP function in Excel

SUMIFS Function in Excel

SUMIFS Function in Excel

Find the lowest / highest values for rows or columns with conditional formatting in Excel

Find the lowest / highest values for rows or columns with conditional formatting in Excel

Break-even in Accounting - Cost Volume Profit Analysis

Break-even in Accounting - Cost Volume Profit Analysis

Getting Started with IF functions in Excel

Getting Started with IF functions in Excel

The Rule of 72 answers

The Rule of 72 answers "When will my investment double?"

Covert date to fiscal quarter in Excel

Covert date to fiscal quarter in Excel

Be careful when averaging percentages

Be careful when averaging percentages

Use What-If Analysis with Data Tables in Excel

Use What-If Analysis with Data Tables in Excel