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