DATA VISUALIZATION AND DEVELOPING INSIGHTS IN EXCEL

COURSE OVERVIEW
As more and more industries and organizations harness the power of big data, the ability to illustrate trends and patterns within a data set has become invaluable. In this course, you will lean to apply Excel pivot tables and charts, to develop dynamic dashboards to contribute to strategic decision-making process of your organization. You will learn to use data visualization techniques that effectively communicate your analysis to your audience.

TOPIC TO BE COVERED
 Databases and Data models
 Pivot Tables, Formulas and Charts
 Interactive Dashboards

KEY LEARNING OUT COME
– Learn how to develop elaborative excel based databases: extracting, cleaning, sorting, tables
– Use of pivot tables and pivot charts
– Learn advanced Excel tools like automated dashboards, dynamic formats, and more
– Learn how to communicate data charts and developing inferences
Duration: 3 hours

Participants
It is essential to have basic Excel knowledge for the training. The course is designed for audience with variety of professional backgrounds and experience levels — including
– Students
– Analysts
– Accountants
– Finance professional
– Planers