How-To

Yesterday I presented a case study on assisting a mom in creating a chart for a science fair. You can read more about it here: Case...

While building your Excel Dashboard Templates, have you had the frustrating problem where Excel keeps highlighting a range of cells as you click on...

Create a Stacked Clustered Column Chart in Excel There is one type of chart that is always requested, however, Excel doesn’t offer this type of...

Here is a very simple solution to a common Excel Charting question when a user wants to graph “Three sets of data criteria on...

On Friday, I posted this challenge: https://www.exceldashboardtemplates.com/friday-challenge-find-unique-list-in-excel/ You can download the sample data set here:  Challenge Sample Data Check out the post and download / try it yourself before you...

Selecting Ranges in Excel Have you ever had an issue using your mouse to select a large set of data in your Excel spreadsheet?  Have...

Have you ever had a chart where your Horizontal Category Labels overlap each other and they are unreadable? Check out this chart to see what...

In my previous Friday Challenge, Tracey wanted to know how to split up email address text in Excel.  The sample text that Tracey wanted...

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...

  Learn how to make an accurate sales pipeline in Excel.  In previous posts, I have showed you how to make a sales funnel chart...