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
Course Features
- Lectures 0
- Quizzes 0
- Duration 50 hours
- Skill level All levels
- Language English
- Students 0
- Assessments Yes