Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /homepages/21/d169681724/htdocs/francomusso/wp-content/plugins/gravityforms/common.php on line 1125

Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /homepages/21/d169681724/htdocs/francomusso/wp-content/plugins/gravityforms/common.php on line 1162

Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /homepages/21/d169681724/htdocs/francomusso/wp-content/plugins/gravityforms/common.php on line 1166

Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /homepages/21/d169681724/htdocs/francomusso/wp-content/plugins/gravityforms/common.php on line 1190

Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /homepages/21/d169681724/htdocs/francomusso/wp-content/plugins/gravityforms/common.php on line 2859

Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /homepages/21/d169681724/htdocs/francomusso/wp-content/plugins/gravityforms/common.php on line 2866

Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /homepages/21/d169681724/htdocs/francomusso/wp-content/plugins/gravityforms/common.php on line 2879

Warning: sizeof(): Parameter must be an array or an object that implements Countable in /homepages/21/d169681724/htdocs/francomusso/wp-content/plugins/wordpress-firewall-2/wordpress-firewall-2.php on line 300

Warning: sizeof(): Parameter must be an array or an object that implements Countable in /homepages/21/d169681724/htdocs/francomusso/wp-content/plugins/wordpress-firewall-2/wordpress-firewall-2.php on line 300

Warning: Declaration of mysiteDescriptionWalker::start_el(&$output, $item, $depth, $args) should be compatible with Walker_Nav_Menu::start_el(&$output, $item, $depth = 0, $args = Array, $id = 0) in /homepages/21/d169681724/htdocs/francomusso/wp-content/themes/awake/lib/classes/menu-walker.php on line 45

Warning: Declaration of mysiteResponsiveMenuWalker::start_lvl(&$output, $depth) should be compatible with Walker_Nav_Menu::start_lvl(&$output, $depth = 0, $args = Array) in /homepages/21/d169681724/htdocs/francomusso/wp-content/themes/awake/lib/classes/menu-walker.php on line 87

Warning: Declaration of mysiteResponsiveMenuWalker::end_lvl(&$output, $depth) should be compatible with Walker_Nav_Menu::end_lvl(&$output, $depth = 0, $args = Array) in /homepages/21/d169681724/htdocs/francomusso/wp-content/themes/awake/lib/classes/menu-walker.php on line 87

Warning: Declaration of mysiteResponsiveMenuWalker::start_el(&$output, $item, $depth, $args) should be compatible with Walker_Nav_Menu::start_el(&$output, $item, $depth = 0, $args = Array, $id = 0) in /homepages/21/d169681724/htdocs/francomusso/wp-content/themes/awake/lib/classes/menu-walker.php on line 87

Warning: Declaration of mysiteResponsiveMenuWalker::end_el(&$output, $item, $depth) should be compatible with Walker_Nav_Menu::end_el(&$output, $item, $depth = 0, $args = Array) in /homepages/21/d169681724/htdocs/francomusso/wp-content/themes/awake/lib/classes/menu-walker.php on line 87
Creating dashboards in Excel

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.