Excel Dashboard Templates

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 you if you come to love the Offset function in...

For almost every Excel Dashboard you will want to make a Chart template Dynamic.  Meaning that as you add new data, the chart updates itself.  Wouldn’t that be wicked cool? This is a major complaint...

I am a fan of the PGA and Tiger Woods.  So I was really excited when I saw this post from Paresh Shah of Visual Quest. http://www.visualquest.in/2011/08/sunday-brain-teaser-equilibrium.html  (See picture below)  This is the Chart presented by...

In my last post I showed the concepts of making a P/E (Price-to-Earnings) Excel Chart for your Dashboard Template. In this post I will walk you step-by-step how you can make your own P/E...

Here is a fun and easy Dynamic Excel Chart that you can use in your Excel Dashboard Template. This Excel Chart has many financial research, executive and company applications and it looks super cool. In an...

It may seem like a weird title, but I will explain. As you build your Excel Dashboard, you will want to use text for data descriptions, titles, labels, lists of issues or risks and other...

When building Excel Dashboard Templates, you will frequently refer to cells or ranges in formulas.  After which, you will typically copy those formulas to other like data points that are doing similar calculations.  So...

Learn Excel Quickly: Okay, when you are making your Excel Dashboard Templates you will spend a lot of time settin up formulas and copying them to other cells and ranges, so you probably want to...

This is my new blog dedicated to helping you learn and make your own Dynamic Microsoft Excel Executive Dashboard Templates and Charts. I have many spreadsheet tutorials planned that will teach you how to create...