This course is designed to provide participants with a detailed and up-to-date overview of Excel dashboard. It covers the insertion of graphics for a dashboard; inserting a simple chart, using sparklines with dashboards, using table to dynamically link charts and lists and linking charts across worksheets; the special functions and formulas covering OFFSET function, nested IF statements using the AND OR operators, VLOOKUPs and the MATCH function; and the dashboard navigation, creating bespoke navigation bars and dashboard links and using named objects.
During this interactive course, participants will learn to prepare workbook’s layout and structure; organize data in data tables using Ifs; use table formulas to make dynamic charts, conditional formatting, OFFSETs, VLOOKUPs and name range lists; use Excel objects for specialist dashboard views; adding data bar into your dashboards and create a window chart, advanced comparison chart and timeline chart; use macros and VBA with dashboards; and configure controls using macros.