Excel Analytics – Data Analysis with Pivot-Tables and Charts

Learn Data Analysis from A to First Project with Pivot-Tables, Pivot-Charts and Advanced Formulas All In One Course.

Created by: Moustafa Ahmed Abd El-Azim
Data Analytics Engineer

Created by: Blink Data
Data Virtual Organization

What Will I Learn?

• Write advanced formulas including lookup functions and Dynamic Arrays.
• Get used to the course content by practicing through the different assignments included in the course.
• A Full Project guidance step-by-step on a real-life databaset
• How to analyze any data step by step
• Understand How spreadsheets can be used as a data analysis tool.
• Gain an immersive understanding of Data (Defination, Categories, Types and Qualities).
• Understand the differences between Big Data and Traditional Data.
• Easy Guidance on how to find free datasets for practice.
• Obtain Knowledge on Data Clearning (Importance and different methods of Data Cleaning).
• Obtain Knowledge on Data Manipulation (How to extract information out of a dataset).
• How to use Pivot-Tables and gain an undestanding of its different features.
• Learn the different types of charts and how to use them properly.

Requirements

• Microsoft Excel 2014 and Above
• For Mac Users, You might find a different interface when it comes to Pivot-Table Panel

Target audience

• Anyone using Excel and wants to dive into the world of Data Analysis