Microsoft Excel Blog: Tutorials and How-Tos

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

Excel - Turn on Multiple Filters in a PivotTable

Excel - Turn on Multiple Filters in a PivotTable

American Society of Administrative Professionals - Microsoft 365 - Popular topics from my November 2022 session

American Society of Administrative Professionals - Microsoft 365 - Popular topics from my November 2022 session

PivotTables - 3 Annoying Things FIXED!

PivotTables - 3 Annoying Things FIXED!

Excel Chart Maps used with the Geography Data Type

Excel Chart Maps used with the Geography Data Type

CTRL + Shift + V to Paste Plain Text in Excel - New feature coming soon

CTRL + Shift + V to Paste Plain Text in Excel - New feature coming soon

Excel - using the Scenario Manager to track house payments with skyrocketing mortgage rates

Excel - using the Scenario Manager to track house payments with skyrocketing mortgage rates

Excel Images - Two New Features -  IMAGE function and Data from Image

Excel Images - Two New Features - IMAGE function and Data from Image

Excel Image Function

Excel Image Function

Excel Highlight Every Nth Row with Conditional Formatting - Every 3rd, 4th, or 5th row.

Excel Highlight Every Nth Row with Conditional Formatting - Every 3rd, 4th, or 5th row.

Excel - Share a PivotTable without the Source Data or Underlying Data

Excel - Share a PivotTable without the Source Data or Underlying Data

Excel - How to find the Greater Common Divisor (GCD Function) and show as Ratios

Excel - How to find the Greater Common Divisor (GCD Function) and show as Ratios

Liquidity Ratio using Excel

Liquidity Ratio using Excel