Excel Data Analysis using Pivot Tables and Pivot Charts

Focused View

Nasiru Musa

3:49:31

129 View

1. Basics of the Pivot Table

1.1 country sales sample data for pivot table course for data cleaning.xlsx

1. Getting your data ready for Pivot Table.mp4

04:23

2. Creating the Pivot Table.mp4

03:31

3. Grouping and Ungrouping in Pivot Tables.mp4

03:09

4. Collapsing and Expanding in Pivot tables.mp4

01:37

5. Field Settings in Pivot Tables.mp4

04:40

6. Introduction to Slicers in Pivot Tables.mp4

07:18

7. Introduction to Timeline in Pivot Table.mp4

06:42

8.1 sales dataset homework section 1 for upload.xlsx

8. End of Section Practice Exercise.html

9. Solution to the Review Homework.mp4

02:13

2. Applying Filters in Pivot Tables

1. Date Filters in Pivot tables.mp4

06:04

2. Value Filters in Pivot Tables.mp4

03:37

3. Label Filters in Pivot Tables.mp4

03:52

4.1 sales dataset homework Section 2.xlsx

4. End of Section Practice Exercise.html

5. Solution to the Review Homework.mp4

06:40

3. More on the Pivot Table Ribbon

1. Selecting, Clearing, Moving & Copying Pivot Tables.mp4

03:38

2. Refreshing & Updating Pivot Tables.mp4

03:29

3. Layout group on the ribbon.mp4

04:18

4. Layout in Pivot tables.mp4

00:52

5. Style options in Pivot Tables.mp4

02:11

6. Calculated field in Pivot Tables.mp4

01:48

7. Calculated field items in Pivot Tables.mp4

03:24

8.1 sampledatafoodsales homework section 3.xlsx

8. End of Section Practice Exercise.html

9. Solution to the Review Homework.mp4

07:10

4. Conditional Formatting in Pivot Tables

1. Introduction to Conditional formatting in Pivot Tables.mp4

01:02

2. Highlight cells rules.mp4

01:34

3. Top Bottom rules.mp4

01:21

4. Data bars, Color Scales and Icon Sets.mp4

02:00

5. New rule, clear rules and manage rules.mp4

03:51

6.1 sampledatafoodsales homework section 4.xlsx

6. End of Section Practice Exercise.html

7. Solution video to the review exercise.mp4

07:01

5. Practice Exercise HR Dataset

1. Introduction to the exercise.mp4

00:53

2. Exercise Video 1.mp4

05:44

3. Exercise Video 2.mp4

06:12

4. Exercise Video 3.mp4

05:36

6. Creating Dashboards in Pivot Tables

1. Introduction to Excel pivot table dashboards.mp4

02:05

2. Dashboard exercise video 2.mp4

04:55

3. Dashboard exercise video 3.mp4

05:30

4. Dashboard exercise video 4.mp4

04:04

5. Dashboard exercise (putting it all together).mp4

05:48

7. Pivot Charts

1. Introduction to Pivot Charts.mp4

00:38

2. Inserting Pivot Charts.mp4

04:38

3. Combining pivot charts.mp4

02:38

4. Changing chart types in pivot charts.mp4

02:10

5. Basic data filtering in pivot charts.mp4

02:42

6. Formatting in pivot charts.mp4

08:01

7.1 sales dataset homework section 7.xlsx

7. End of Section Practice Exercise.html

8. Solution video to the review exercise.mp4

14:28

8. Case Study Exercises

1. Case Study 1 US Mass Shootings Dataset.mp4

13:18

2. Case Study 2 Olympics Athletes Dataset.mp4

17:53

3. Case Study 3 US Police Officer Deaths Dataset.mp4

13:46

4. Case Study 4 Work Safety Dataset.mp4

11:07

Description

Utilize real-world case studies to master Excel pivot tables and pivot charts for data analysis.

What You'll Learn?

Learn beginner to advance Excel Pivot Table Analysis Skills
Learn how to combine Pivot Tables and Pivot Charts for data analysis.
Master pivot table analysis step by step with homework and case study exercises at the end of each section
Test your skills with real world Pivot Table case studies

Who is this for?

Anyone who works with Excel on a regular basis and wants to learn how to use Pivot Tables in Data Analysis

Anyone looking to pursue a career in data analysis or business intelligence

Excel users with basic skills who want to improve their data analysis abilities

Students who want to opt their skill levels in using Excel for Data Analysis

More details

Description
Excel Pivot Tables are a must-have tool for anyone who works with data in Excel.
Pivot tables allow you to quickly summarize and analyze data, revealing trends and valuable insights into your data that you would not have discovered otherwise. Excel Pivot tables will provide quick, accurate, and intuitive answers to the most difficult analytics questions.
This course will provide a thorough understanding of Excel Pivot Tables through a hands-on approach with real-world simple but highly effective case studies, ensuring that skills learned can be immediately applied to any Excel data analysis tasks. To accomplish this, I will walk you through interactive, hands-on demos and Excel exercises along the way.
I will start by taking you through everything you need to know in Excel Pivot tables which will include:
1) The data structure in Excel
2) Pivot Table layouts & styles
3) Design & formatting options
4) Sorting, filtering, & grouping tools
5) Calculated fields, items & values
6) Pivot Charts, slicers & timelines
7) Interactive Excel dashboards
We will then do some exercises to reinforce the skills we have learned by using some real-world sample Excel datasets, such as:
1) US mass shooting Data
2) Food Sales Data
3) Workplace Safety Data
4) Sales Data
5) Human Resources Data
6) Olympic Athlete Data

Without a doubt, the world has become increasingly data-driven. Data analysis skills are in short supply and high demand. If you want to improve your Excel skills or become someone who transforms data into meaningful insights, this course is for you. Enroll in this course and begin your journey to becoming an Excel data analysis expert.
Hope to see you in class

Who this course is for:
Anyone who works with Excel on a regular basis and wants to learn how to use Pivot Tables in Data Analysis
Anyone looking to pursue a career in data analysis or business intelligence
Excel users with basic skills who want to improve their data analysis abilities
Students who want to opt their skill levels in using Excel for Data Analysis

User Reviews

Rating

average 0

Total votes0

Focused display

Nasiru Musa has a BSc In Accounting from ABU Zaria (Nigeria) , MSc Information systems from the university of Liverpool and a Post graduate certificate in corruption studies from the Hong Kong University, he is also a certified anti money laundering specialist (CAMS), he has several years of experience in Auditing, Financial Investigation, Information systems and Law enforcement intelligence analysis. He has worked for over 8 years in the Nigerian Financial Intelligence Unit, where he has led several teams in cases bordering on Corruption, Human trafficking, illicit drug financial investigations, Money laundering and Terrorist financing. He was also a trainer and a training administrator with the training academy of the prestigious economic and financial crimes commission (EFCC) in Nigeria. He is an Excel and Power tools specialist who has built and educated numerous financial analysts, law enforcement officials, and analysts in the use of analytical tools and techniques in money laundering, terrorist financing and financial crime investigations and intelligence analysis.He was also a certified fraud examiner (CFE), certified information systems auditor (CISA), and a certified information security manager (CISM) from 2008 to 2015Feel free to contact him on LinkedIn for more information on any of his current or upcoming courses.

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.