Excel Analytics - Data Analysis with Pivot-Tables and Charts

Focused View

Moustafa Ahmed Abd El-Azim,Blink Data

2:35:10

19 View

1. Getting Started

1.1 iMDbTop250Movies.csv

1.2 vgsales1.csv

1. Course Introduction.mp4

12:09

2. What is Data (DefinationCategoriesTypesQualities).mp4

06:12

3. Data Types in Excel.mp4

01:39

4. How to find a freepublic Dataset.mp4

02:46

5. Auto-Filling.mp4

05:18

6. Dataset Navigation.mp4

03:35

7. Section 1 Quiz.html

2. Data Cleansing

1. 5 Traits of Quality Data.mp4

02:30

2. Identifying Duplicates and Blanks.mp4

05:53

3. TRIM Function.mp4

03:52

4. Proper, UPPER and lower Functions.mp4

03:22

5. Nested Functions.mp4

01:57

6. Data Type Formating.mp4

02:40

7. Currency Data Type Formating.mp4

01:53

8. Filter and Sort Features.mp4

05:20

9. Text Concatenation.mp4

02:49

10. Text to Column.mp4

03:15

11. Flash Filling.mp4

01:35

12. Substitute Function.mp4

06:22

13. Formating data as a Table.mp4

04:01

14. Data Cleansing Practice Test.html

3. Data Manipulation

1. Mean, Median and Mode.mp4

03:42

2. Name Labeling.mp4

01:38

3. Sum Function.mp4

02:51

4. SumIF Function.mp4

03:14

5. Operators.mp4

01:35

6. Minimum and Maximum Value Functions.mp4

01:39

7. Count Function(s).mp4

06:04

8. IF, Nested IF and IFS.mp4

11:29

9. VLOOKUP Function.mp4

04:56

10. HLOOKUP Function.mp4

03:19

11. Data Manipulation Practice Test.html

4. Data Analysis with Pivot-Tables

1. Introduction to Pivot-Tables.mp4

01:37

2. How to create a Pivot-Table.mp4

05:27

3. How to format data in a Pivot-Table.mp4

01:10

4. How to apply calculations on data in a Pivot-Table.mp4

02:38

5. How to Sort data in a Pivot-Table.mp4

01:51

6. Recommended Pivot-Tables.mp4

01:40

7. Slicers.mp4

05:43

5. Data Visualization (Charts and Graphs)

1. Bar Charts.mp4

03:06

2. Column Charts.mp4

02:58

3. Line Charts and Combo Charts.mp4

01:56

4. Pie and Doughnut Chart.mp4

01:45

5. How to Create a Pivot-Chart.mp4

04:14

6. How to Apply A Slicer to a Pivot-Chart.mp4

01:34

7. How to manually Style your Pivot-Chart.mp4

01:56

Description

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

What You'll 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.

Who is this for?

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

What You Need to Know?

Microsoft Excel 2014 and Above

For Mac Users, You might find a different interface when it comes to Pivot-Table Panel

More details

Description
Why should you enroll in this course?
This course covers all aspects of Excel Analytics starting from downloading a dataset to analyzing and creating a full project.
It covers the fundamentals of Data and Quality data to have a good basis before getting into data analysis.
It's suitable for beginner and intermediate levels to up their skills to advanced.
It covers all business categories therefore, No matter what industry you're working in/want to work in, This course is for you.
As a result of this course, you will be able to work on Excel Analytics projects on your own and make money freelancing.
On-Video and Off-Video full project, Step-by-Step, in addition to practice tests.
All your queries and questions will be answered by the instructor directly.
Finally, This course is updated regularly to match the latest updates in regard to data analysis and Excel in particular.
What will you learn in this course?
1- Data
Data Analysis surely starts with Data, Hence, During Section 1, You will learn
What's Data? Starting with its definition up to categories and qualities
What are the Data Types in Excel?
How to find a dataset?
How to Navigate through a dataset?
How to Autofil Data in Excel?
2- Data Cleansing
Data Cleansing is the process of clearing a dataset of any duplicates, blanks, or inconsistencies and making sure your dataset contains quality data
What are the traits of quality data?
How to identify duplicates and blanks?
Essential excel formulas (TRIM, UPPER, lower, Proper, Substitute, Concatenation)
Filter and Sort Features
How to change Data Types
Text to Column
How to Format data as a table?
3- Data Manipulation
Data Manipulation is the process of manipulating data to extract relevant and key information from your dataset
Statistical Formulas or Functions (Mean, Median, Mode, Min, Max, Average)
Data Manipulation formulas (SUM, VLOOKUP, HLOOKUP)
Logical Functions (IF, IFS, SUMIF, COUNT, COUNTIF, COUNTIFS, COUNTBLANKS)
4- Analyze Data
Stage 4 is analyzing data using Pivot-Tables to gain more insights by creating a pivot table based on different rows/columns/filters and calculations
Introduction to Pivot-tables to understand what it is and why it is important
How to create a Pivot-Table?
How to Format Data in a Pivot-Table?
How to apply calculations on data in a Pivot-Table?
How to Sort Data in a Pivot-Table?
What are Slicers?Â How to use them and Why they are important?
How to create automated recommended Pivot-Tables?
5- Data Visualization
Finally Data Visualization, This is the final stage where you get to present your insights and analysis using Charts and Graphs, Charts are important as each Chart Type could identify hidden patterns and trends
Introduction to important Chart Types such as (Bar Charts, Column Charts, Line Charts, Combo Charts, Pie Charts, and Doughnut Charts)
How to create a Pivot-Chart?
How to Apply a Slicer to a Pivot-Chart?
How to Manually Style your Pivot-Chart?
6- Final Project (Step-by-Step)
In the final section of the course, we will run through a hands-on data analysis project where you will make use of the knowledge you have gained throughout the course.

What makes this course different from the other courses?
This course is complete and precise, Hence, You won't have to take another course in Excel Analytics.
This course teaches you everything about data analysis and guides you through your first data analysis project.
Less than 8 hours avg response time (By the instructor)
Assessment (First Project) evaluation in less than 24 hours by the instructor
It offers auto-generated subtitles in more than 3 languages including (Arabic, Hindi, and Spanish)
Regularly updated downloadable resources.
What our students say about this course:
I would say this course is just straight to the point and exactly as described, i would definitely recommend it to any one who looks to start learning data analysis using Excel, Thank you Moustafa!
I like it so far very to the point and basic so anyone can catch on. I am doing work to up my career skills and finding this course was exactly what I needed!
awesome course. The course materials are easy to follow even for novices and the instructor teaches very well explained. I will recommend this class to whom want to learn data analytics with excel.

This course is complete as you will learn all that you need to get your hands dirty in the field of Data Analysis, You will obtain the important intellectual and technical skills to start your first project.
Enroll with us, We're looking forward to becoming a part of your success.

Who this course is for:
Anyone using Excel and wants to dive into the world of Data Analysis

User Reviews

Rating

average 0

Total votes0

Focused display

Hi, I'm Moustafa, a data analyst with significant experience in increasing comprehension of reports, research, and complex problem-solving.Throughout my career, I've helped international organizations find hidden opportunities through data analysis and make the most accurate and successful decisions possible.Moreover, I've taught data analysis to hundreds of students worldwide in person and online, My main objective is to make learning fun and easy by being there step-by-step with students and being reachable most of the time.Feel free to contact me anytime.

Blink Data

Instructor's Courses

Blink Data is a virtual organization created by Moustafa Ahmed Abd El-Azim that aims to create online courses related to Data from all aspects whether from an intellectual or a technical perspective.The main goal for Blink Data is to simplify Data learning by making engaging, easy-to-understand, Step by Step courses with hands-on practical assignments.Moreover, We will always be there for you with your first project and any questions you might have.Not Ready to Enroll? Favorite our courses to find them easier when you're ready.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.