CERTIFICATE IN DATA ANALYSIS AND BUSINESS REPORTING TECHNIQUES USING EXCEL

COURSE OBJECTIVES

By completely attending this course, participants will be able to:

Competency I:

• Apply massaging and normalization techniques to unstructured data to prepare it for analysis.
• Identify and address data quality issues such as duplicates, missing values, and outliers.
• Use Excel tools and functions to clean, transform and restructure data.

Competency II:

• Create Pivot Tables to perform data analysis and produce insightful reports.
• Customize scorecards and management reports to meet specific needs.
• Use advanced Pivot Table features such as calculated fields, groupings, and slicers.

Competency III:

• Design dynamic reporting models using different modeling techniques, such as scenario analysis, forecasting, and trend analysis.
• Perform What-If-Analysis to explore various business scenarios and their potential outcomes
• Use Excel’s advanced charting and visualization tools to create dynamic and interactive reports.

Competency IV:

• Integrate Excel with various file types such as Access, web, text, SQL, and other databases.
• Use Excel’s built-in data connectors and import/export features to retrieve and update data automatically.
• Create automated reports that refresh and update data in real-time.

Competency V:

• Record and edit macros to automate repetitive tasks and increase efficiency.
• Use Excel’s VBA programming language to write customized code and automate complex tasks.
• Generate reports and perform data analysis efficiently by running and editing recorded macros.

Note

This course requires the use of laptops with Excel 2016/2019/365. Delegates must bring their own laptops with Windows-based Excel fully installed.