Friends and readers of Chandoo.org, my newest download, Excel Dashboard Templates are available for your consideration. Click on the Buy now button above to pick them up if you are ready. Read on to know more.

What are Excel Dashboard Templates?

As the name suggests, these are ready to use Excel templates for creating awesome, informative, easy to understand & quick dashboards with your data. You just enter your data, set up few calculation options, decide how your dashboard should look & bingo, a beautiful & insightful dashboard will be created for you. These dashboards are optimized to look great, convey key information & prompt correct action.

Who should buy these templates?

Analysts, managers, reporting professionals, business owners & executives. These templates are designed to help anyone preparing Excel based dashboards, scorecards or KPI reports.

Benefits for you

• Design awesome dashboards in minutes, not months: Don't waste hours trying to figure out formulas, chart settings and layouts. Instead focus on what your users want, how your business works and use those insights to tell the 'Excel Dashboard Template' what you want. Save time and look awesome.
• Accommodate change elegantly: People change. Businesses change. What your boss wanted last month is no longer what she wants today. So when someone asks you, "hmm, can you show me YTD data instead of last 13 months", or "Can I see top 10 KPIs instead of all", you just smile and tap a few clicks and bingo, the new dashboard will be ready. These templates are designed to handle change (data, requirements, design preferences and insights).
• Beautiful & Informative: These templates are designed with a delicate balance of beauty & insight. Everything is seamlessly designed, perfectly aligned and precisely calculated so that you & your boss can focus on the insights & decisions. Time tested and well honored visualization principles & guidelines are observed thru-out the reports.
• Built for starters, built for pros: Whether you are just starting with Excel or a seasoned pro, you can find the templates right up your alley. For advanced users, we have many customizations to whet your appetite. Want to build a custom calculation or include another type of sorting, you can do it by tinkering with 'calculations' sheet.

What you'll get:

Check out the templates: (click to enlarge)

The Excel Dashboard Templates comes in 2 flavors.

1. Excel Dashboard Templates
2. Excel Dashboard Templates Premium Pack

With Excel Dashboard Templates

You get Excel Dashboard Template workbook that can generate 16 different beautifully designed dashboards from single set of data. You also get a detailed user manual (17 pages), video tutorials on how to set up & use the dashboard. You will have 6 months of updates.

With Excel Dashboard Templates Premium Pack

You get 2 Excel Dashboard Template workbooks that can generate a total of 18 different beautifully designed dashboards. You will also get:

• Dashboard Chart Templates - Quickly create 5 types of custom charts for your reports or dashboards
• eBook on Dashboard Creation Process
• Audio book on Dashboard Creation Process
• Form controls for Dashboards - ebook
• Slicers for Dashboards - Video Guide
• Conditional Formatting for Dashboards - Video Guide
• Life time free updates of templates

About the simple dashboard template

Some times you just want to create a quick dashboard that compares current period performance with previous one. The Simple KPI dashboard template is designed to help you quickly enter data, set up some formatting & get 2 gorgeous, elegant & clean dashboards in a few minutes. Check them out in the images below (click to enlarge).

1. Supports up to 100 KPIs, products, stores, departments, projects or anything.
2. You can assign KPIs to various groups
3. Two layout choices - 2 column or 3 column
4. Visualize % change & target performance

About the bonus chart templates

Ever have the need to whip out a beautiful chart quickly? This template lets you create 5 very powerful, insightful & useful charts in a few minutes. Just enter your data, copy the chart & paste it in your presentation. You are ready to go. This template provides below 5 charts:

1. Thermo-meter chart (4 variants)
2. Tornado chart (3 variants)
3. Indexed chart
4. Funnel chart (2 variants)
5. Sparklines for Excel 2007 (4 variants)

Dashboard Creation Process - ebook & audio book

Creating a successful dashboard takes a lot of time & effort. In this 24 page eBook, I reveal the process you need follow to create a winning dashboard. The eBook includes theory, practical examples, tips & tricks from my years of experience creating dashboards & lots of interesting insights. The companion audio book is a concise version of the eBook explaining the process. Topics covered in this book:

• Overview of the Dashboard Creation Process
• Detailed chapters on 9 steps of dashboard creation
• Additional resources & material on dashboards

Form Controls for Dashboards eBook

Form controls help you create interactive, user friendly & powerful dashboards. Unfortunately, they are also a big mystery for many people. In this insightful, simple & fun eBook, learn how to use form controls for your dashboard. The book explains 5 most important form controls (combo box, scrollbar, option button, check box & list box) in detail. The book also includes additional tips & techniques for mastering form controls.

1. Form controls - What are they & why use them?
2. How to insert form controls?
3. Combo box control
4. Scrollbar control
5. Option buttons
6. Check boxes
7. List box control
8. Other form controls
9. Ninja-level tips for form controls
10. Other types of interactivity
11. Examples, case studies & tutorials

Slicers for Dashboards - video guide

Slicers, a new feature introduced in Excel 2010 are a fun, powerful & interesting way to explore data & gain insights on-demand. In this detailed video guide (35 minutes), learn how to set up slicers, use them with pivot charts, pivot tables, regular charts. The video also explains some advanced techniques & tricks like using slicers for chart modification, styling slicers etc.

This video guide comes with a practice workbook so that you can learn these techniques better.

Conditional Formatting for Dashboards - video guide

Conditional formatting is a very powerful & incredibly handy feature of Excel. But it is surprising that not many users exploit it's fullest potential. In this in-depth video guide, learn 5 conditional formatting tricks that will transform your dashboard. This video explains:

1. Why conditional formatting for dashboards?
2. Trick 1: Telling the % change story
3. Trick 2: Light weight bars
4. Trick 3: Alerts to grab user attention
5. Trick 4: Highlight what matters most
6. Trick 5: Build a project tracker quickly

This video guide comes with a practice workbook so that you can learn these tips better.

Update policy

• With Excel Dashboard Templates: You will get updates (new versions, bug-fixes etc.) for 6 months from date of purchase
• With Excel Dashboard Templates Premium pack: You will get life long updates (new versions, bug-fixes etc.)

Supported Versions of Excel

• Office 365
• Excel 2016
• Excel 2013
• Excel 2010
• Excel 2007

Get your copy of Excel Dashboard Templates

Excel Dashboard Templates What you get? Excel Dashboard Template (16 dashboards) 6 Months free updates 30 day money-back guarantee All for just $50 Purchase Alternative Payment Links for all customers for all customers for Indian Customers

Excel Dashboard Templates - Premium What you get? Excel Dashboard Template (16 dashboards) Simple Dashboard Template (2 dashboards) Dashboard Chart Templates (5 charts) eBook on Dashboard Creation Process Audio book on Dashboard Creation Process Form controls for Dashboards - ebook Slicers for Dashboards - Video Guide Conditional Formatting for Dashboards - Video Guide Life time free updates 30 day money-back guarantee All for just $100 Purchase Alternative Payment Links for all customers for all customers for Indian Customers

The awesomeness guarantee

I strongly believe that these templates can help you create awesome dashboards with little or no modification. I made these because I wanted you to be awesome. So for any reason, if you do not like the templates, please send me an e-mail (chandoo.d@gmail.com) and I will refund your money. You have un-conditional money back guarantee for 30 days.

What Happens when you Purchase?

Frequently asked questions

Are the files editable?

Yes, they are unlocked and 100% editable. The included user manual explains how you can make many common customizations (changing colors, adjusting currency formats, modifying titles etc.) You can see & change all the calculations & formulas too.

How easy it is to add or change data?

As simple as copy pasting or typing. The template is designed to let you easily add or change data. All the data for dashboard sits in "Data" tab which is accessible from everywhere. Just go to the last row & start typing your numbers. All the calculations will magically change & your dashboards will be ready.

Does it work in Excel 20xx?

These templates are designed to work with Office 365, Excel 2016, 2013, 2010 & 2007. If you are using an older version of Excel (like 2003 or 2000), then you cannot apply this template.

Can I remove portions of a dashboard & add something on my own?

Of course yes. The included user manual explains the process for editing the files. Please take backups to ensure you do not loose functionality.

Is my purchase safe?

Your purchase is 100% safe & secure. We use industry leading card payment solutions like PayPal, 2Checkout, Gumroad & EBS so that you can safely transact.

Quantity Discounts & Licenses?

Each purchase gives you 2 licenses by default - one for office usage and one for personal usage. If need more licenses, please click here.

So what are you waiting for?

Go ahead and pick up a copy of the templates. See what awesome things you can achieve with these. click here to pick them up.

About Chandoo

Hi there, at Chandoo.org, we have one goal - "to make you awesome in Excel and Charting". I have started writing about Excel & Charting in year 2007. Since then I have learned hundreds of things about using excel, becoming productive and shared them with our little community here. I have received prestigious MVP award from Microsoft for contributions made to Excel community for 6 years in a row (2009-2014).

@r1c1 downloaded last night. Produced a KPI sales dashboard at work today. Boss was blown away. Cheers for the product!

— Liam Teske (@LiamTeske) November 14, 2014

Customer Testimonials
for other products