Tutorials (Blog)

Learn how to use Excel more efficiently with our in-depth articles & videos.

Revert to Original Sort Order 640

Revert to Original Sort Order in Excel

March 14, 2019

Good or Bad Pie Chart 640

Charts & Dashboards

A Pie Chart Alternative for Survey Data

February 27, 2019

Secret Excel Menu for Right Click Paste Values 640

Tips, Tips & Shortcuts

Paste Values with the Right-click & Drag Mouse Shortcut

February 21, 2019

5 Keyboard Shortcuts to Paste Values in Excel

Keyboard Shortcuts, Tips & Shortcuts

5 Keyboard Shortcuts to Paste Values in Excel

February 14, 2019

4 Ways to Automatically Sort Drop Down Lists Excel 640

Formulas, Macros & VBA, Power Pivot/Query/BI, Power Query, Tips, Tips & Shortcuts

How to Sort Drop Down Lists Automatically in Excel

February 6, 2019

How to Add Macro Buttons Video 640

How to Create Macro Buttons in Excel Worksheets

January 23, 2019

VBA Delete Rows Based on Condition YouTube Thumb 640

VBA Macro to Delete Rows Based on Cell Values

January 17, 2019

Copy Data to Another Workbook Using Macros Below Existing YouTube Thumb 640

How to Use VBA Macros to Copy Data to Another Workbook

January 9, 2019

Split Screen View Video Thumb 640

Tips, Tips & Shortcuts

Tips for Split Screen in Windows & Mac

January 3, 2019