Excel Training, Templates, & Add-Ins

by Charley Kyd
Microsoft Excel MVP

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 or save as a PDF file.

New! IncSight Medley Series of Excel Dashboard Templates

For Windows or Mac Excel, 2007 and after

The IncSight Medley series adds new designs and new features to Excel dashboard templates. Like IncSight DB and QnE, IncSight Medley (IM) uses worksheet formulas to return numbers from Excel data worksheets. So when you change the report date, your dashboard updates automatically. But IM adds two new features...

Excel dashboard reports from the IncSight Medley series of Excel dashboard templates

First, IM adds the ability to maintain multiple units, like divisions, departments, regions, and so on. So your dashboard can update automatically whenever you change the date, the unit, or both.

Second, IM gives you the ability to update text in addition to your numeric data. Now, automatically, you can change introductions, chart captions, chart titles, and so on... just as you can update numbers and charts.

IncSight DB for Windows or Mac Excel, any version

Choose among portrait and landscape templates that contain charts of various sizes and small tables. Update your reports in seconds because they're linked to Excel data worksheets.

IncSight QnE for Windows or Mac Excel, any version

Choose among portrait and landscape dashboard templates with the same number of charts in matrix, from 4 charts through 28. With so many dashboards to choose from, you're sure to find the high-impact dashboard report that can display your measures. Update your reports in seconds because they're linked to Excel data worksheets.

IncSight Custom Office Color Themes, any version

Get custom color themes for your Excel dashboard reports.

Excel Chart and Dashboard Training


	*E-Book: Dashboard Reporting With Excel, any version*
	More than 25,000 Excel users have purchased my 200-page e-book 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.

	Charley's Swipe Files, any version
	I created these 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.

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.

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.

	Great Charts -- Learn from these professionally designed Excel displays and improve your Excel reports, Word documents, PowerPoint presentations, and HTML figures.
	Excel Dashboards--IncSight DB Excel dashboard reports include charts and tables of various sizes, using formulas linked to data worksheets. These Excel dashboards show two of DB's 20 reports.
	Excel Dashboard--IncSight QnE Excel dashboard reports fill the page with charts of various sizes, using formulas linked to data worksheets. This "7x4" page is one of 34 that QnE provides.
	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.

ExcelUser, Inc.

http:///www.ExcelUser.com

Copyright © 2004 - 2012 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.