Sample File of Excel Template Dashboard Tutorial Offset Function

This is the Bomb: or How I came to love the Offset function

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

How-to Make Dynamic Excel Dashboard Charts Using Tables

1
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...
Chart of Tiger Woods Victories on PGA Tour and in Majors

Tiger Woods PGA Tour and Major Championship Chart

3
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...
Excel Dashboard Template Step-by-Step Tutorial and Sample File

Step-by-Step Tutorial: How-to: Make a Company and Industry P/E (Price to Earnings) Line Chart

1
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...
How to make a Dashboard Template for a P/E Price-to-Earnings Excel Chart

Company and Industry P/E (Price to Earnings) Line Chart – 2 Ways

2
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...
This how Not to use Concatenate Template Formulas in Excel for Dashboards

How NOT to use Concatenate Function to build Dynamic Text in your Excel Dashboard...

0
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...
How to use relative and absolute references in Excel for a Dashboard Template

Referring to Ranges in Formulas for your Excel Dashboard Templates

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

QUICKLY Change Microsoft Excel Dashboard Template Cell References

1
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...
The best place to learn how to make Excel Templates for Executive Dashboards

Welcome to the New Microsoft Excel Dashboard Templates Blog where you will learn how...

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