Practice Excel Helps Learning

Practice Makes Perfect Excel Dashboards and Charts

2
I would strongly recommend that if you want to get better at building Excel Dashboard Charts and Graphs that you should try and recreate...

How-to Copy Charts and Change References to New Worksheet

28
Have you ever made a great chart for your Excel Dashboard and you wanted to reuse it for another set of data?  Perhaps you...

Add % Difference Data Labels to Excel Horizontal Tornado Chart

4
Okay, the client is always requesting changes.  How do you deal with these?  I suggest increasing the contracted hours.  In this case, I decided...

Case Study – Creating a Dynamic Chart in Excel Using Offset Formula

2
A YouTube video subscriber Mili, wanted to know more about creating a Dynamic Excel Column Chart using Offset function.  So Mili sent me the...

How-to Show Decades and Highlight a Year in the Horizontal Axis

4
Recently in an Excel Forum, a user had data similar to this format: Here is what he wanted to do:   How do I set the Horizontal...

Super Bowl Excel Dashboard Challenge

Here in the United States, we will have the Super Bowl a week from Sunday.  It is a really big deal for the country...
treadmill dashboard design for excel

Dashboards are Everywhere!

0
Dashboards Can Be Found Everywhere I am presently in Suzhou China working on a new project and I decided to go to the gymnasium.  I...

Budget Analysts – How would you answer this Excel Chart question?

0
Two months back there was a posting in the Mr. Excel forums that I thought most budget analysts might be asked by there executive...

Steve Williams Caddie Earnings After Tiger Woods Split – Mini Dashboard

1
Now, you may know that I am a PGA Tour Golf fan and you may also know that Tiger Woods has been doing very...

Olympic Medal Count Dashboard

0
So the summer Olympics start this week.  So I thought it would be a good time to visit how one might create an Olympic...