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.
4.50 (116 reviews)
Udemy
platform
English
language
Microsoft
category
Excel Analytics - Data Analysis with Pivot-Tables and Charts
1,008
students
3 hours
content
Nov 2022
last update
$19.99
regular price

What you will 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.

Screenshots

Excel Analytics - Data Analysis with Pivot-Tables and Charts - Screenshot_01Excel Analytics - Data Analysis with Pivot-Tables and Charts - Screenshot_02Excel Analytics - Data Analysis with Pivot-Tables and Charts - Screenshot_03Excel Analytics - Data Analysis with Pivot-Tables and Charts - Screenshot_04
4694226
udemy ID
5/19/2022
course created date
6/11/2022
course indexed date
Bot
course submited by