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