Saturday, January 26, 2008

10 tips to improve your Excel dashboard

Jorge Camoes offers some tips on using Excel for Business Intelligence (summarising and analysing business data). But these tips are general enough to help any project that uses Excel. A couple of surprising tips: (1) don't use formulas; and (2) abuse PivotTables. Read on to see why.

1 comment:

Ben said...

Also take a look at www.ExcelDashboardWidgets.com for examples of dashboards using Microsoft Excel.