HLookup
VLookup Week at ExcelDashboardTemplates.com
Learn how to make and understand Excel Lookup Functions like Index/Match, Vlookup, Hlookup, Left VLookup
EXPLORE THE LIBRARY
Month
Column Chart
A Taxing Situation…
Cost of license plate vs compact car in china presented in an Excel Chart
Fun
Zombie Pie Chart in Excel – What would you do?
What would you do if there was a zombie apocalypse? Graph your thoughts with this Excel 2003 pie chart
Dashboard
How-to Format Trend Line Color in Excel Dynamically
Use a dynamic trend line to highlight dashboard trends in Excel templates with the use of color.
Banding Horizontal
Dashboards are Everywhere!
Look for dashboard designs in every day life to make your excel dashboards better and more useful.
Axis Formating
How-to Show Decades and Highlight a Year in the Horizontal Axis
This is the dashboard tutorial that will show you how to only show the horizontal axis categories that you want to show and how to highlight a specific value
Chart
How-to Make an Excel Chart Title Change Dynamically
Easy way tomake a dynamic chart title in Excel Chart and Graph
Pie Chart
Yoda Excel Chart!! NO WAY!
Someone sent me this graph and I thought it was great. I love Star Wars. I grew up on Star Wars. I lived and breathed Star Wars Trilogy as a child and I also loved the 2nd Star Wars trilo