Creating dashboards in Excel

Creating dashboards in Excel

Create your own dashboard, instantly generating a series of graphs for any selected LA and/or school, incorporating the measures that matter to you, from various data sets, combined within a single workbook.

The source data for the charts will be gathered using a series of Vlookups that combine both LA and school level data.

Upon completion of this session, you’ll be familiar with:

  • Combining datasets
  • Creating data entry lists
  • Generating charts based on dynamic data
  • Referencing named cells
  • Creating 3D formulas (formulas that ‘see into’ other workbooks)
  • Merging multiple cell values to form unique text strings
This is the course for you if you’d like to make a tailored, easily manageable, well presented, dynamic heads-up view out of the heaps of data available for each school and LA.