Excel Shortcut: Create Quick Name Ranges From Large Tables of Data Using Ctrl+Shift+F3
Build a Quick Set of Name Ranges for your Fields Using This Excel Shortcut Let's keep this short and sweet and under 60 seconds. Type Ctrl+A to highlight your range of cells/table. Once all cells including the column headers are...
Excel Dynamic Dashboard Friday Freebie: Watching Inventory Valuation Trends
Using the Option Button Form Control To Build a Dynamic Inventory Valuation Trend Dashboard This week I decided to build an Excel Dynamic Dashboard using the option button. Reviewing inventory valuation trends using historical data is a great way to oversee and...
Excel Dynamic Charting: Comparing Product Categories By Total Units Sold
Let's Do this Backwards Excel dynamic charting is a great way to quickly answer questions without having to go through rows and rows of data. I've decided to start backwards this time by providing you guys with the final product/dashboard before giving you the...
Excel Custom Number Formatting: How To Conditionally Format Text Fields With Icon Sets Using Number Formatting
In this post, I will show you how apply Excel conditional formatting to text strings by assigning...
Excel Group Items Option: How to Build Different Time Parameters Into your Pivot Table
