Excel Analytics – Data Analysis with Pivot-Tables and Charts

Excel Analytics – Data Analysis with Pivot-Tables and Charts, available at $19.99, has an average rating of 4.5, with 46 lectures, 3 quizzes, based on 115 reviews, and has 1007 subscribers.

You will learn about 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. This course is ideal for individuals who are Anyone using Excel and wants to dive into the world of Data Analysis It is particularly useful for Anyone using Excel and wants to dive into the world of Data Analysis.

Enroll now: Excel Analytics – Data Analysis with Pivot-Tables and Charts

Summary

Title: Excel Analytics – Data Analysis with Pivot-Tables and Charts

Price: $19.99

Average Rating: 4.5

Number of Lectures: 46

Number of Quizzes: 3

Number of Published Lectures: 46

Number of Published Quizzes: 3

Number of Curriculum Items: 50

Number of Published Curriculum Objects: 50

Number of Practice Tests: 2

Number of Published Practice Tests: 2

Original Price: $29.99

Quality Status: approved

Status: Live

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.

Who Should Attend

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

Target Audiences

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

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.

Course Curriculum

Chapter 1: Getting Started

Lecture 1: Course Introduction

Lecture 2: What is Data? (Defination/Categories/Types/Qualities)

Lecture 3: Data Types in Excel

Lecture 4: Auto-Filling

Lecture 5: Dataset Navigation

Lecture 6: How to find a free/public Dataset?

Chapter 2: Data Cleansing

Lecture 1: 5 Traits of Quality Data

Lecture 2: Identifying Duplicates and Blanks

Lecture 3: TRIM Function

Lecture 4: Proper, UPPER and lower Functions

Lecture 5: Nested Functions

Lecture 6: Data Type Formating

Lecture 7: Currency Data Type Formating

Lecture 8: Filter and Sort Features

Lecture 9: Text Concatenation

Lecture 10: Text to Column

Lecture 11: Flash Filling

Lecture 12: Substitute Function

Lecture 13: Formating data as a Table

Chapter 3: Data Manipulation

Lecture 1: Mean, Median and Mode

Lecture 2: Name Labeling

Lecture 3: Sum Function

Lecture 4: SumIF Function

Lecture 5: Operators

Lecture 6: Minimum and Maximum Value Functions

Lecture 7: Count Function(s)

Lecture 8: IF, Nested IF and IFS

Lecture 9: VLOOKUP Function

Lecture 10: HLOOKUP Function

Chapter 4: Data Analysis with Pivot-Tables

Lecture 1: Introduction to Pivot-Tables

Lecture 2: How to create a Pivot-Table?

Lecture 3: How to format data in a Pivot-Table?

Lecture 4: How to apply calculations on data in a Pivot-Table?

Lecture 5: How to Sort data in a Pivot-Table?

Lecture 6: Recommended Pivot-Tables

Lecture 7: Slicers

Chapter 5: Data Visualization (Charts and Graphs)

Lecture 1: Bar Charts

Lecture 2: Column Charts

Lecture 3: Line Charts and Combo Charts

Lecture 4: Pie and Doughnut Chart

Lecture 5: How to Create a Pivot-Chart?

Lecture 6: How to Apply A Slicer to a Pivot-Chart?

Lecture 7: How to manually Style your Pivot-Chart?

Chapter 6: Final Project (Step-By-Step)

Lecture 1: Step One: Prepare data for analysis

Lecture 2: Step Two: Data Extraction and Analysis

Lecture 3: Step Three: Dashboard and Data Visualization

Instructors

Moustafa Ahmed Abd El-Azim
Data Analytics Engineer
Blink Data
Data Virtual Organization

Rating Distribution

1 stars: 1 votes
2 stars: 2 votes
3 stars: 9 votes
4 stars: 34 votes
5 stars: 69 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu