Tag: Excel

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

It is time for another Friday Challenge.  This is based on actual scenario from a recent project. A user had a large list of values in...

Recently, a healthcare company employee contacted me about a chart he wanted to create.  The company that he works for is trying to save...

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

Lots of users use Excel for lists or you may receive reports from other people or systems and sometimes those files contain Wild Cards...

In previous posts, I have espoused the virtues of the Pivot Tables in Excel and that you should always think in terms of a...

If you have the yellow bar show up at the top of your Excel Spreadsheet "! Security Warning - Automatic update of links has...

In this previous post: Stopping Excel Pivot Chart Columns from Overlapping When Moving Data Series to the Second Axis I had a fan question - How...

Many users have mixed reactions about this secondary axis overlap fix.  You can see the post here: Stop Excel From Overlapping the Columns When Moving...

Like most Excel users, one of the first formulas that you ever learned to master was the Concatenate Function. But how do you add other...