For business users of Microsoft Excel.

Home >  


Excel Training, Templates, & Add-Ins

by Charley Kyd
Microsoft Excel MVP

 

Excel Dashboard Training

 

E-Book: Dashboard Reporting With Excel
  More than 25,000 Excel users have purchased  this 200-page e-book (150 pages for Excel 2003) to learn the secrets of dashboard reporting with Excel. Learn how to create mini-charts, how to use Excel's Camera tool to create flexible tables, how to set up Excel databases, how to display PivotTable data in dashboards, how to create Excel databases, and more.
 
 
 

E-Book Support Files
  This package contains all the files discussed in the dashboard e-book.
 
 
 

Charley's Swipe Files
  Use this growing collection of professionally designed Excel charts and tables to advance your Excel skills and to improve your Excel reports, PowerPoint presentations, Word documents, and HTML figures.
 
 

Excel Dashboard Templates

Display your data in professional-quality Excel dashboard reports, using only Excel. Because these templates are linked to spreadsheets with data ("Excel databases"), you can update your reports quickly. Just update your Excel database, change the report date, and print.
 
 

IncSight DB
  Set up Excel dashboard reports in less than an hour. Add any number of reports. Update your reports in seconds because they're linked to an Excel database. Choose from 20 Excel templates, plus 20 color schemes.  This is our most powerful set of dashboard templates.
 
 
 

IncSight QnE
  Set up reports in less than 10 minutes, choosing among 16 portrait and 18 landscape dashboard templates. This is the quickest and easiest way to generate the high-impact dashboard reports that today's managers need.
 
 
 

IncSight Color Schemes
  Get a selection of 35 color schemes for your Excel dashboards.
 
 

Office Color Theme Management

It's much easier to recognize great color combinations than to create them! These tools make it possible for you to choose great color combinations from millions of interchangeable colors. 
 
 

Kyd Palette
  Each time you click a button in this Excel add-in, you see another of the 40,320 color combinations that every Office color theme offers. When you find a great combination, use it in your workbook or save it as a custom theme that you can use in any Office document. If you want your Office documents to look great, you need this inexpensive Excel add-in.
 
 
 

Plaid Palette Plus
  When you're trying to choose a color theme for a new report, Excel provides virtually no visual help. This workbook shows you 25 possible color combinations you could use with any color theme.
 
 

Excel Worksheet-Formula Add-Ins

Your worksheet formulas can change chart settings. This add-in gives you the power to do it. (Yes, I know. Everyone says that's impossible to do. But you can do it anyway.) This add-in also returns information from charts.
 
 
 

Kyd Web
  Since the economy causes so many business problems, why do your reports and analyses ignore it? Link formulas in your Excel reports and analyses to data on the Web. Return text, calculations, tables, single values, and more. Just recalculate to update your reports.
 
 
 

Kyd Series
  Use worksheet formulas to change chart types, set chart colors, change line widths, adjust transparencies, assign marker types, change marker size, hide or reveal data points or markers, manage data labels, and more.
 
 
 

Kyd Axes
  Use worksheet formulas to set the maximum and minimum values for your chart axes, change tick-label spacing, set the number format of tick labels, set the number of units between tick marks, automatically change number formats so your chart always displays the correct number of decimal points, and more.
 
 
 
 
Great Charts -- Learn from these professionally designed Excel displays and improve your Excel reports, Word documents, PowerPoint presentations, and HTML figures.

 
Excel Dashboards--These two Excel dashboard reports from IncSight DB show two of its 20 reports, which use two of its 20 color themes.

 
Traffic-Light Charts -- Worksheet formulas using Kyd Series functions can manage the color and thickness of line segments, and turn ordinary charts into traffic light charts.

 
Great Colors -- It's much easier to recognize great color combinations than to create them. Now, with one click each, you can generate 40,320 color combinations for any Office color theme.

 


Excel Dashboard--This Excel dashboard report from IncSight QnE shows one of its 18 landscape reports. QnE also includes 16 portrait reports.
 

ExcelUser, Inc.
http:///www.ExcelUser.com

Copyright © 2004 - 2009 by Charles W. Kyd, all rights reserved. Content, graphics, and HTML code are protected by US and International Copyright Laws, and may not be copied, reprinted, published, translated, hosted, or otherwise distributed by any means without explicit permission. Terms of Use | Privacy Policy | Earnings Policy.