Advanced Microsoft Excel tutorials

Excel compare two or more text strings

Excel compare two or more text strings

Year-Over-Year Growth - Excel PivotTable

Year-Over-Year Growth - Excel PivotTable

Excel PivotTable - Summarize data by Month or Day of the week

Excel PivotTable - Summarize data by Month or Day of the week

Excel DateDif function - difference between two dates

Excel DateDif function - difference between two dates

Future Value Function in Excel

Future Value Function in Excel

Annual Percentage Yield (APY) vs. Interest Rate

Annual Percentage Yield (APY) vs. Interest Rate

Excel for Office 365:  Fuzzy Matches with the Power Query Editor by Chris Menard

Excel for Office 365: Fuzzy Matches with the Power Query Editor by Chris Menard

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