A Complete Course to Understand, Clean, Manipulate, Analyze and Visualize Data using Excel’s Pivot-Tables and Charts.
What you will learn
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.
Write advanced formulas including lookup functions and Dynamic Arrays.
Understand How spreadsheets can be used as a data analysis tool.
Get used to the course content by practicing through the different assignments included in the course.
Description
Microsoft Excel is an essential tool for data analysis as it helps corporates understand, evaluate and analyze data to make critical decisions, Moreover, Identify patterns and trends to find key hidden opportunities.
With over 400+ built-in functions and different data analysis tools such as pivot tables in Excel, It became a powerful tool to analyze data.
Hence, This course is created to help you
- Understand Data from all aspects including its definition, categories, types, and qualities.
- Get to learn the whole data analysis process from start to finish.
- Learn How to clean data and make it ready for information extraction through different functions such as TRIM, CAPITALIZE, REMOVING DUPLICATES, IDENTIFYING BLANKS, and more.
- Learn Data Wrangling and how to sort and format data.
- Learn How to manipulate data to extract insights and findings using various functions such as IF, COUNT, VLOOKUP, HLOOKUP, MEAN, MEDIAN, MODE, and more.
- Learn How to analyze structured data using Pivot-tables using its different functionalities, In addition to filters, and sort features, Moreover how to apply calculations in Pivot-Tables
- Grasp a great understanding of Data Visualization and charts and what type of charts to choose.
By the end of this course you will be able to:
- Understand and explain different aspects of Data.
- Use different Excel functionalities that are essential for data analysis.
- Learn how to clean your dataset in order to be structured and ready to be analyzed.
- Manipulate data in order to extract key important facts from your dataset.
- Analyze datasets using pivot-tables various functionalities.
- Visualize your insights and analysis using Excel Charts to showcase your analysis outcome.
- Gather what you’ve learned to create a dashboard using Pivot-Tables and Charts to showcase your findings and analysis
This course is not directed towards a specific business category such as HR, or Finance yet it is focused on performing data analysis on any dataset in any business category.
Check out my other course on Data Privacy and Data Protection Fundamentals by visiting my profile page.
Content