Microsoft Excel Blog: Tutorials and How-Tos

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

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?"

Snap a picture of an Excel table with your smart phone and edit the spreadsheet

Snap a picture of an Excel table with your smart phone and edit the spreadsheet

Covert date to fiscal quarter in Excel

Covert date to fiscal quarter in Excel

Be careful when averaging percentages

Be careful when averaging percentages