Tips

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

Split Screen View Video Thumb 640

Tips, Tips & Shortcuts

Tips for Split Screen in Windows & Mac

January 3, 2019

Best Practices for Using Pie Charts

Charts & Dashboards, Tips, Tips & Shortcuts

When to Use Pie Charts – Best Practices

November 13, 2018

Tips for Tabs - Time Saving Shortcuts for Sheets in Excel Workbooks

Keyboard Shortcuts, Tips, Tips & Shortcuts

7 Shortcuts for Working with Worksheet Tabs in Excel

October 17, 2018

Custom Keyboard Shortcuts to Select the First or Last Sheet in Excel

Macros & VBA, Tips, Tips & Shortcuts

Create Keyboard Shortcuts to Select the First or Last Sheet in Excel

October 17, 2018

Excel Hash Episode 1 Contenders

Charts & Dashboards, Tips, Tips & Shortcuts

Excel Hash: Episode 1 – Dynamic Histogram

September 5, 2018

7 Keyboard Shortcuts Cells Ranges YouTube Thumb 640

Keyboard Shortcuts, Tips, Tips & Shortcuts

7 Keyboard Shortcuts for Selecting Cells and Ranges in Excel

August 20, 2018

Add New Items to Drop-down Lists Automatically Thumb 640

Tables & Data, Tips, Tips & Shortcuts

How to Add New Rows to Drop-down Lists Automatically – Dynamic Data Validation Lists

August 13, 2018

Excel Tutorial Drop Down Lists in Cells

Tables & Data, Tips, Tips & Shortcuts

How to Create Drop-down Lists in Cells – Data Validation Lists

August 8, 2018