Excel Dashboards

IncSight DB


IncSight DB

IncSight DB lets you set up professional Excel dashboards linked to an Excel database. Set up your first Excel dashboard report in less than an hour. Add any number of reports. You can update your reports in seconds because they're linked to an Excel database. Choose from 20 Excel templates, plus 20 color schemes. These dashboards use only Excel workbooks. Nothing is hidden or protected, and there's nothing to install.


IncSight QnE


IncSight QnE

IncSight QnE is our quickest and easiest Excel dashboard product yet. It lets you go from fuzzy data to professional dashboards in less than ten minutes.

Just copy and paste your organization's data to an Excel data template. Enter your chart titles. Choose among 16 portrait and 18 landscape dashboard templates. Then print professional-looking Excel dashboard reports. Excel dashboard reports will give your readers much more insight than your standard Excel reports. And it will give them insight much more quickly. IncSight QnE is the quickest and easiest way we know to generate the high-impact dashboard reports that today's managers need.


Chandoo's Dashboard Tutorial

Chandoo also offers a downloadable video tutorial which teaches you how to recreate the spectacular dashboards featured below.

dashboard image

Takeaways

Here is what you will learn:

  • Dashboard design principles
  • Data arrangement & cleaning
  • Using Pivot Tables to summarize data
  • Word clouds in Excel
  • Using Form controls to add interactivity to dashboards
  • Using VBA to add interactivity to dashboards
  • Using Picture links & conditional formatting to make an impression

Includes:

  • Creating a static website dashboard – 65 minute lesson
  • Creating an interactive dashboard (non-VBA) to report a forum statistics – 45 minute lesson
  • Creating an interactive dashboard (VBA) to report Cricket Worldcup statistics – 35 minute lesson
  • Website Dashboard – 2 files
  • Interactive Dashboard (Forum Statistics) – 1 file
  • Interactive Dashboard (World-cup Stats) – 1 file
  • On-Demand charts in Excel – 1 file

As a bonus, Chandoo has added the following to the download package:

  • 90 minute lesson: Introduction to Excel
  • 40 minute lesson: Interactive charts with VBA

Dashboard Reporting with Excel (E-Book)


Dashboard Reporting With Excel

The Dashboard Reporting With Excel e-book kit teaches you how to create your own Excel dashboard reports, starting from scratch. Learn how to create mini-charts, how to use Excel's Camera tool, how to set up Excel databases, and a lot more.


Charley's Swipe Files

Charley's Swipe Files

These workbooks offer a quick and inexpensive way to create professionally designed charts and tables for Word, PDF, PowerPoint, Web, and Excel presentations.

Each figure comes with two sets of documentation, an eight-page "Getting Started" PDF file, and a two-page PDF file about the figure. So you can learn what it takes to create great-looking Excel figures.

The files are available for all versions of Excel, PC or Mac, from Excel 97 through 2010.


Kyd Series Add-in for Excel 2007-2010

Kyd Series Add-in for Excel 2007-2010    Kyd Series Add-in for Excel 2007-2010

Kyd Series Add-in for Excel 2007-2010

These Unique Excel Add-Ins Do the 'Impossible' To Deliver Extraordinary Power to Excel Charts!

These Excel add-ins allow worksheet formulas to change chart settings. For the first time ever, your formulas can create traffic-light charts, highlight chart elements, assign number formats, and much more.


Note: These are affiliate links. You can Become an ExcelUser Affiliate too!
For even more dashboards, templates and add-ins, visit the Shop or Charley Kyd's website: ExcelUser.com Dashboards, Add-Ins and Templates.

Site last updated: May 17, 2012

Excel School