Sort Left to Right

Jul 10, 2017 | Excel, General, Miscellaneous Excel Tips, Worksheet Design

Who knew how many different ways there are to sort? Let’s talk about changing the Sort Option Orientation. Typically you don’t have to change the orientation of sorting as the default works just fine. However, everyone in awhile, you have that one...

Dashboard Design

Feb 8, 2017 | Excel, Miscellaneous Excel Tips, Worksheet Design

I just finished updating my Excel Dashboards course, Drive Your Dashboard with Excel,  and thought I would share an excerpt. Dashboard Design Creating a dashboard is NOT the same things as creating an Excel spreadsheet. By this, I mean that people tend to open an...

Worksheet Design Tips

Aug 25, 2015 | Worksheet Design

Excel Tips on Entering Data and Formatting Brian Cane’s Excel Tips show how to effectively enter information and to format more effectively. His source – a public domain Ibbotson (the famous Nobel Laureate) workbook. Please click on the attached sheet to...

Formatting Alternate Rows

Aug 20, 2015 | Formatting, General, Worksheet Design

Formatting alternate Rows Thanks to Diana Lawless for sending in this Excel tip. Using the Shift key and the Format Painter icon together allows you to format an entire worksheet quickly. If you are formatting alternate rows or columns quickly and do want not mess...