Notice: The called constructor method for WP_Widget in collapsCatWidget is deprecated since version 4.3.0! Use
__construct()
instead. in /var/www/vhosts/121/242034/webspace/siteapps/WordPress-56954/htdocs/wp-includes/functions.php on line 4718
Excel Dashboards - Computer training in Dublin, Wicklow and Ireland. | Brendan Moran

«

»

Excel Dashboards

Excel Dash­boards Train­ing

Excel Dash­boards are reports that allow senior man­age­ment or direc­tors to get high-lev­el overview of the busi­ness or organ­i­sa­tion.

Excel Dashboard

Excel is an excel­lent tool to make pow­er­ful dash­boards that can pro­vide analy­sis, insight and alert man­agers in time­ly man­ner.

You will learn how to explore and analyse your data by cre­at­ing an inter­ac­tive dash­board in Excel using piv­ot tables and Visu­al Basic for Appli­ca­tions. You can cre­ate a dynam­ic tem­plate to gen­er­ate reports for Direc­tors, Senior Man­age­ment or cus­tomers and to bet­ter under­stand your own data. You will learn how to import exter­nal data, design a tem­plate using piv­ot tables, and add slicers, macros, and action but­tons to make the tem­plate more inter­ac­tive. I will also shares some basic prin­ci­ples of visu­al design to guide you in devel­op­ing an easy-to-use and visu­al­ly appeal­ing report.

Top­ics include:

  • Defin­ing your require­ments
  • Prepar­ing Your Data
  • Set­ting up data
  • Adding ref­er­ence tables
  • Design­ing Your Visu­al Lay­out
  • Cre­at­ing hier­ar­chy in the lay­out
  • Choos­ing colour and typog­ra­phy
  • Design­ing the Report
  • Import­ing data
  • Insert­ing slicers
  • Record­ing a macro
  • Advanced slicers
  • Edit­ing VBA code
  • Improv­ing the user expe­ri­ence