Tutorials (Blog)

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

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

Conditional Formatting for Pivot Tables Video Thumb 640

How to Apply Conditional Formatting to Pivot Tables

December 12, 2018

7 Tips for Zoom and Text Size in Power BI 640

Power BI, Power Pivot/Query/BI

How to Change the Page Zoom and Text Size in Power BI Desktop

December 5, 2018

Best Practices for Using Pie Charts

Charts & Dashboards, Tips, Tips & Shortcuts

When to Use Pie Charts – Best Practices

November 13, 2018