Business Data Analysis Using Microsoft Excel: Part 2

categories: Technology, Science & Productivity

Data

Analytics

MS Excel

SDG 9: Industry, Innovation and Infrastructure

By the end of this course, you will be able to

How to use pivot table tool in Microsoft Excel to get information, data needed, graphs and diagrams, which enable you to analyze data obviously and easily.
The basic concepts of the tool, solving common problems, making the best use of these orders and getting skills from practising on several real and interesting case studies.
How to read any report to get clear insight and how to choose the suitable diagram or graph to present data to the decision makers of the company.

Course details

3 h 47 m/57 lessons
Last updated: 9/2/2021
1 learning resources
Course completion certificate

Course Content

Free lessons

The Magic of The Pivot Table

3 Minutes

Structuring Source Data to Enable a Much Greater Level of Data Analysis

3 Minutes

Different Methods to Create Your First Pivot Table

3 Minutes

How the Pivot Table Understands

4 Minutes

Manipulating the Pivot Table Field List

2 Minutes

How Excel Pivot Tables ACTUALLY Work!

4 Minutes

1. Business Data Analysis Using Microsoft Excel: Part 2

The Magic of The Pivot Table

3 Minutes

Structuring Source Data to Enable a Much Greater Level of Data Analysis

3 Minutes

Different Methods to Create Your First Pivot Table

3 Minutes

How the Pivot Table Understands

4 Minutes

Manipulating the Pivot Table Field List

2 Minutes

How Excel Pivot Tables ACTUALLY Work!

4 Minutes

Clearing, Selecting, Moving & Copying Pivot Tables

5 Minutes

Refreshing, Updating Pivot Tables & Dealing with Growing Source Data

6 Minutes

Removing & Reviving Data from the Pivot Table Cache

5 Minutes

10.

Separating Each Item on the Report in a New Sheet

3 Minutes

11.

Changing Pivot Table Number Formats

2 Minutes

12.

Formatting Empty Pivot Table Cells & Pivot Table Styles

5 Minutes

13.

Configuring Pivot Table Layouts

2 Minutes

14.

Using Tabular Pivot Tables & Insert Blank Line After Each Item

2 Minutes

15.

Using Tabular Pivot Tables to Create New Source Data

2 Minutes

16.

Applying Basic Conditional Formats to Pivot Tables: Part 1

4 Minutes

17.

Applying Basic Conditional Formats to Pivot Tables: Part 2

3 Minutes

18.

Adding Data Bars with Invisible Text

2 Minutes

19.

Applying Advanced Conditional Formats to Pivot Tables

3 Minutes

20.

Advanced Data Sorting to Help Decision-Makers Make their Decisions

4 Minutes

21.

Data Sorting In-Depth

3 Minutes

22.

Fixing Incorrect Alphabetical Sorting

2 Minutes

23.

Filtering Data with Pivot Table Selection Filters

3 Minutes

24.

Customizing Filtering Data with Pivot Table Label Filters

2 Minutes

25.

Pivot Table Label Filters with Wildcards

4 Minutes

26.

Filtering Data with Pivot Table Value Filters

2 Minutes

27.

Enabling Multiple Pivot Table Filters Per Field

3 Minutes

28.

Grouping & Segmenting Data with Pivot Tables

4 Minutes

29.

Enabling & Disabling Automatic Date Grouping

3 Minutes

30.

Control Your Report Using Slicer: Part 1

3 Minutes

31.

Control Your Report Using Slicer: Part 2

2 Minutes

32.

Advanced Slicer || Report Connection

4 Minutes

33.

Filtering Data with Pivot Table Timelines

3 Minutes

34.

Breaking Out Pivot Table Report Filter Pages

2 Minutes

35.

Aggregating & Summarizing Data with Pivot Tables

3 Minutes

36.

Defining Value Calculations with Pivot Tables

6 Minutes

37.

Calculating Pivot Table Values: Percentage of Column/Row

2 Minutes

38.

Calculating Pivot Table Values: Percentage of Grand Total

3 Minutes

39.

Calculating Pivot Table Values: Percentage of Parent Column

3 Minutes

40.

Calculating Pivot Table Values: Difference From & Percentage Difference From

6 Minutes

41.

Calculating Pivot Table Values: Running Total & Percentage Running Total

2 Minutes

42.

Calculating Pivot Table Values: Rank

2 Minutes

43.

Defining & Creating Calculated Fields with Pivot Tables

5 Minutes

44.

Creating ROI Calculated Fields with Pivot Tables

4 Minutes

45.

Introduction to Excel Pivot Charts

2 Minutes

46.

Pivot Chart: Column Chart

2 Minutes

47.

How to Make an Advanced Enhancement in Your Column Chart!

4 Minutes

48.

Pivot Chart: Pie & Donut Charts

5 Minutes

49.

Pivot Chart: Clustered Bar Chart (Two Charts in One)

2 Minutes

50.

Pivot Chart: Bar Chart (100% Stacked Bar)

3 Minutes

51.

Preventing Charts from Resizing with Cells

2 Minutes

52.

Pivot Chart: Line Chart (Years Trend)

3 Minutes

53.

Pivot Chart: Stacked Area Chart Vs. Line Chart

2 Minutes

54.

Applying Slicers & Timelines to Multiple Pivot Charts

4 Minutes

55.

Preparing an Interactive Excel Dashboard

9 Minutes

56.

Make an Advanced Enhancement to the Dashboard

4 Minutes

57.

Case Study: Analyzing Stock Market Data

13 Minutes

learning resources

About this course

Excel Pivot Tables are an absolutely essential tool for anyone working with data in Excel. Not only for providing intuitive insights but also for giving accurate answers and saving a lot of time. This course gives you a deep and 100% comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts. It will show you when, why, and how to use Excel Pivot Tables, besides introducing you to advanced sorting, filtering, and calculation tools. Moreover, it will cover interactive step-by-step demo methods and various Excel training exercises.