Certificate in Data Analysis & Dashboard Reporting in Excel

Course Overview

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.

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

Who Should Attend

• Professionals involved in data analysis and dashboard reporting
• Strategic planners
• Business Analysts
• Business Unit Managers
• Data Analysts
• Financial Controllers

Certification Criteria

You must meet two criteria to be eligible for an Informa Connect Academy Certificate of Completion:

• Satisfactory attendance: You must attend all sessions of the course. If, for any reason, you miss more than 2 hours of the course sessions, you will not be eligible to sit the course assessment
• Successful completion of the course assessment: Assessments will be ongoing and based on in-class participation and activities

Course Methodology

The course is participative and practical and will grow your knowledge and experience in a collaborative environment

Participants are provided with Excel workbooks that are used over the four days to provide a meaningful basis for practice and application of the knowledge shared

Delivered by Peter

Peter is a business management consultant and professional skills management trainer. He is an Executive Director of a South African based consulting practice, which he established in 2004 using the extensive experience gained through his exposure to the holistic corporate financial services environment, where he spent the first twenty years of his career.

Certified by CPD UK

The CPD Certification Service is an independent accreditation centre working across all sectors, disciplines and further learning applications and supports policies of institutional and professional organisations globally.

Run this course in-house

Informa Connect Academy’s customised training solutions have helped organisations deliver tailored learning in different languages to suit every requirement