Tips

Learn time-saving tips & shortcuts that will help you get your job done faster and make you look like an Excel superstar!

5 Tips for Formulas in Excel YouTube Thumb 640-2

Formulas, Tips, Tips & Shortcuts

5 Formula Editing Tips for Excel

May 15, 2019

Text to Time Values Challenge Video Thumb 640

Tables & Data, Tips, Tips & Shortcuts

Data Cleansing Challenge: Convert Text to Time Values

April 24, 2019

Gridlines Freeze Panes Lost in New Window Video Thumb 640

Macros & VBA, Tips, Tips & Shortcuts

Gridlines & Freeze Panes Settings Lost in New Window – How to Fix It

April 10, 2019

Lock Cells Protect Formulas Video Thumb 640

Tips, Tips & Shortcuts

How to Lock Cells for Editing and Protect Formulas

April 4, 2019

View 2 Sheets Side by Side in Same Workbook 640

Tips, Tips & Shortcuts

View Two Sheets Side-by-Side in the Same Workbook

March 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

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