• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Excel custom views

by on
in Excel Training,Office Technology

Q. I want to set up some monthly dashboard reports where I have a template of multiple graphs and tables on one page. Can this be done with Pivot Tables?

A. There are several options to set up Dashboards in Excel. The best source for dashboard layouts will be found in Templates.

In Excel 2007, choose Templates from Office Online and type Dashboard as your search Criteria. In Excel 2010, the Search Box will appear on the Backstage view when you click File and New.

{ 1 comment… read it below or add one }

Avi March 13, 2012 at 5:30 pm

Take a look at dashboardPlus (www.dashboardmore.com), the ultimate TRUE dashboard Excel based creator

Avi

Reply

Leave a Comment