How-to Easily Paste a Defined Name in Chart Dialog Box
As you are learning to use Excel to develop your Executive Dashboard Templates, you will quickly learn that Defining Names are your friend.
Defined names...
Find the Last Row or Last Column for Dynamic Excel Dashboards
In a previous post “This is the Bomb: or How I came to love the Offset function” I showed you all about the Offset...
How-to Make Excel STOP Selecting Range/Extending Range
While building your Excel Dashboard Templates, have you had the frustrating problem where Excel keeps highlighting a range of cells as you click on...
How-to Copy Charts and Change References to New Worksheet
Have you ever made a great chart for your Excel Dashboard and you wanted to reuse it for another set of data? Perhaps you...
This is the Bomb: or How I came to love the Offset function
Wouldn’t that be awesome if Excel can just change my chart every month or week when I add more data? This can happen for...
