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 - Dublin, Wicklow and Ireland | Brendan Moran

↑ Return to Excel Spreadsheets

Excel Dashboards

Excel Dash­boards

Excel Dash­boards are reports that allow senior man­age­ment to get high-lev­el overview of the busi­ness or organ­i­sa­tion. I pro­duce Excel Dash­boards for senior man­age­ment in Dublin, Wick­low and Ire­land.

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
  • Data Min­ing
  • Insert­ing slicers
  • Record­ing a macro
  • Edit­ing VBA code
  • Inte­grat­ing Microsoft Excel and Microsoft Access
  • Improv­ing the user expe­ri­ence