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
 
View Cart

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



Kyd War Room—Excel Dashboard-System Bundle

This bundle of 50 Excel dashboard reports gives you a wide variety of report designs from which to choose...

…Some are landscape; some are portrait. Some have big charts; some have little charts; some have both. Some have tables. Just choose the report you need. But all are linked to the same two data workbooks

Not only will your new reports be much easier for your managers, clients, and other VIPs to read and remember…but your dashboards will reduce your Excel busy-work, because Learn more for all versions of Excelyou can update them in seconds.


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 Learn more for all versions of Excelfigures.



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



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 Learn more for all versions of Excelteaches you to create. 


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

 



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
Principal
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
Director
An investment management firm


"...one 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)

View Cart
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
CFO
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 --
 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
CEO
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
Analyst/Programmer
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
CFO
Autolocator
(Moscow, Russia)


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

Dallan Lax
Owner
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
Controller
FixFunding

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

Jerry Kohl
Owner
Brighton Collections