For business users of Microsoft Excel Free guides and templates
Home > 

Windows & Mac Excel

Excel Training & Templates

Training and solutions for business users of Excel

by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

Dashboard Reporting with Excel—250-Page Ebook

The Excel dashboard you learn to create.If you want to "WOW!" your managers and other VIPs with your Excel skills—and help your career—then give them an Excel dashboard report that you've created from scratch. My ebook teaches you how.

At last count, Excel users in 149 countries have purchased my 250-page e-book to learn the secrets of dashboard reporting with Excel...and they've raved about it, as the testimonials on this page demonstrate.

My fully updated editions of the ebook are at the lowest price ever. And you can choose from either the edition for Excel 2010 (and Mac 2011) or for Excel 2013.
Learn more for all versions of Excel

Kyd War Room—Excel Dashboard Templates

Kyd WarRoom Excel DashboardsBy tomorrow, you can deliver professional Excel dashboard reports that delight your managers, clients, and other Very Important People.

Set up your Target data (if you have Target data) in one workbook; set up your Actual data in another. Then choose from 50 Excel dashboard templates to create any number of Excel dashboard reports.

To update your reports each period, just add new data to your Actual data workbook. Then open last period's report, change the report date, and distribute your updated reports.
Learn more for all versions of Excel

Excel dashboard color themesMy ebook, Dashboard Reporting with Excel,, teaches you how to create charts, tables, and dashboards for your Excel reporting. This Accelerator Kit contains working versions of most of the examples I use in the ebook.

For example, the kit contains the items shown here: An Excel chart similar to a Business Week display, a simple traffic light display, a chart that provides more information than gauges do, and the version of the Excel dashboard that the ebook teaches you to create.

Learn more for all versions of Excel

Charley's Swipe Files—Professional-Quality Charts

Charts for ExcelI created these 76 charts using only Excel. Use them to delight your business audience, expand your Excel charting skills, and improve your Excel reports, PowerPoint presentations, Word documents, and HTML figures.

  Learn more for all versions of Excel

Excel dashboard color themesChoose from 31 different color themes specifically designed for Excel dashboard reports. The themes also will work with any Microsoft Office product designed to use color themes.

  Learn more for all versions of Excel

Stage One—Excel Dashboard System

The Excel dashboard you learn to create.At only $7.00, Stage One is the lowest-priced, practical Excel dashboard reporting system you're going to find.

The Stage One system includes two data workbooks--one for Targets (if you have targets), and the other for Actuals. And it includes the workbook with the report shown here.

You can save any number of copies of this workbook to create any number of different reports...all linked to the same two data workbooks.

With this system, you can update your data workbooks once and then generate any number of different reports.
Learn more for all versions of Excel

 View Cart
More of Our Many Testimonials

"You're my hero! This is incredibly slick. I'm an independent consultant, and this should WOW a lot of clients."

Mark Johnson
Vector Group Services

"I learned more from your excel dashboards pdf in 1 day, than I learned in months at investment banking and management consulting."

Adam Altman
Chief Operating Officer
A strategic management company

"I purchased your dashboard reports and have used them with great success at my former job. The reports are easy to use and really turn heads and drop jaws in meetings.

"I have just changed companies and would like another copy of the dashboard reports sent to my home email address."

Stuart Strepman
An investment management firm

" of the most useful tools in my Excel tool belt. I have built several dashboards that had a positive impact on my career. Thank you!"

George Bryant
Acuren North Slope Project Manager
BP plc

"Your book is fantastic! Have learned more from that book than I have in 20 years of using spreadsheets."

Albert J Rossman
Senior Manager, Financial Integration
Abbott Laboratories

"I purchased your book and it has been an awesome tool. I was made aware of your resources while I was earning my MBA. I'm so glad I saved that link because this material is helping me complete this high profile task."

Warren Walker
Copy & Print Services Midwest Manager
Duke Energy

"All I can say is fabulous! It's unbelievable what I have been missing for years.

"The Camera functionality alone makes the small cost of your book and files worth every penny and more.

"Excellent, many thanks."

John Rixon
Assoc Business Manager
Kraft Foods Inc

"The dashboard e-book is absolutely awesome!

"I didn’t realize Excel could do what I wanted it do!

"I’ve started setting up our dashboards to update the look of our annual report."

Heidi L. Rockwood
Admin Assistant to the VP
University of Illinois

"Thank god I found this great tool on the web. Definitely a must have!"

Ralph Pollandt
Financial Planning Manager
LAN Airlines (Peru)

A Few of Our Many Testimonials

"You made me look like a superstar with this. Nice work."

Bill Lalor
National Manager of Technical Support
COSCO Container Lines Americas

"Your ebook is FANTASTIC!!! The techniques informed by you really break everything down to simple easy to understand steps, besides enhancing my knowledge of Excel (never heard of the camera tool before).

With just an initial reading (and cannibalizing from your dashboard!), I created a dummy dashboard in 2 days "

Manoj Kapashi
Cost Analyst
Musculoskeletal Transplant Foundation

"We are using the dashboards to daily track three key productivity measures at team levels. This allows us to perform visual trending analysis very, very quickly and determine if or where we might need to refocus our attention.

"Typically, these measures would have been reviewed at month-end, so having this capability keeps us from potentially wasting 1/12th of a year before we identify potential unfavorable trends.

"Needless to say, our Management Team loves these dashboards!"

Ron Barrett
Ocean Peace, Inc.

"We love your e-book and have deployed a good number of dashboard using it !!! Our Clients think we are gods..."

Paul Faust
Business Process Consultant
Wells Fargo Financial

"Thank You --
 Thank You --

"You’ve allowed me to WOW my boss by automating a lot of our invoice processing and all I had to do was cut and paste my info over yours in the data sheet.

"You saved me many hours of work and tons of frustration."

Kathy Grant
Project Administrator

"I must say that together with you book, your Dashboards are fantastic.

"I spent a day getting familiar with their inner logic in order to make them work with our existing Excel report that used scorecs scattered across several worksheets.

"And I am very, very happy with the result. This is going to have a great impact on our internal reporting.

"You have one more very happy customer here... in Cambodia!"

Michel Dauguet
DFDL Mekong

"With the help of your e-book, I was able to design automated scorecards that we’ve been using for 2 years now."

Marc Labrie
Senior Business Analyst
Mabe Canada

"I bought your e-book, "Dashboard Reporting With Excel" last year – a fantastic purchase!"

Kevin Hodge
Key Account Mgr
General Mills

"What a great book!

"Now I can apply my newfound charting skills to quickly create dashboards on how my trust line of business is performing."

Darryl Meyers
Senior VP
Wells Fargo Private Client Services

"A godsend! I wish I had purchased your ebook a lot sooner."

Peter Cassinelli
SCA Systems Ltd.

"The book is a joy! Your writing is simple, elegant, and clear. So mahalo nui loa, as we say in Hawai`i – thank you for your very great effort."

Toddy Hagans
Data Specialist
Hamakua Health Ctr

"Your book was of immense help to me. I produce dashboards on a regular basis in my life as a CFO and generally have reduced time in spreadsheet hell."

Shaun Spalding
(Moscow, Russia)

"I purchased your book this morning! Love it!"

Dallan Lax
Streamline Business Solutions, LLC

"Bought the book and the files. So far, wow-wee!"

Alex Ortolano
Marketing Product Manager
"I love the product!"

Jay Bryan

"All I can say is Wow! This is amazing! I have done dashboards before but never like these."

Jerry Kohl
Brighton Collections