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

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