Data Analysis & Dashboard Reporting in Excel - Informa Connect Middle East
Contact for Queries: +971 4 407 2500
Select Page

*red highlight indicates mandatory fields

Area Code
Phone Number

For further information on our privacy and cookies policies, click here.
Data Analysis & Dashboard Reporting in Excel - Informa Connect Middle East
Home > Training > Business Operations > Data Analysis & Dashboard Reporting in Excel
Data Analysis & Dashboard Reporting in Excel Training Course | Business Operations Training Course

Data Analysis & Dashboard Reporting in Excel

06 September - 09 September 2020
The Address Hotel, Dubai Marina, Dubai, UAE

Level: Essential

In-Company Training   REGISTER FOR THE COURSE  

Course Director

Peter Hofmann | Course Director

Peter Hofmann

MFX Options and Solutions (Pty) Ltd

Education Partner:
Continuing Professional Development (CPD)

Education Partners

Continuing Professional Development (CPD) | Education Partner – Informa Middle East
Course Schedule
  • 06 Sep 2020 Dubai


The VisiCalc row-and-column-based layout introduced in 1978 is what we know as spreadsheets today. These have evolved to become powerful business tools that are widely used across business functions. Step into any of the various departments in a business and you will find some business processes that are supported using Excel. Excel’s current advanced functionality together with its formatting and visual design capabilities creates a basis for its extensive use as a data analysis and business reporting tool.

The Data Analysis & Dashboard Reporting in Excel course will provide you with an understanding of the fundamental concepts appropriate to data analysis and Excel dash-boarding techniques. The course involves pivot tables, the most important tool in performing data reporting, analysis and reconciliation. The course will give you high-level modelling techniques, integration and report visualisation, and automation.

Who Should Attend

  • Finance Managers
  • Financial Controllers
  • Management Accountants
  • Financial Analysts
  • Business Analysts
  • Professionals involved in data analysis and dashboard reporting using Excel

Benefits of Attending

  • Understand the principles of data analysis
  • Discover the tools to analyse data and build reports using your existing Excel skills
  • Know how to use visual effects to improve reports and presentations
  • Explore how to summarise, present and communicate data clearly and concisely
  • Improve the efficiency of performing routine tasks through recording, writing and editing powerful macros
  • Learn the principles of good dashboard design and how to present data graphically

Data Analysis & Dashboard Reporting in Excel