Microsoft Excel Blog: Tutorials and How-Tos

Post covering sorting, filters, getting started with Excel, Excel functions, subtotals, PivotTables, and other Excel features.

8000 royalty-free images are available in Office 365 - April 2020 update

8000 royalty-free images are available in Office 365 - April 2020 update

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

Keyboard shortcuts for Paste Values in Excel

Keyboard shortcuts for Paste Values in Excel

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