Complete Introduction to Excel Online Pivot Tables in 3 Hrs

Focused View

Ian Littlejohn

2:49:35

11 View

1. Introduction

1. Introduction.mp4

02:19

2. About the Course.mp4

01:42

3.1 Data.xlsx

3. Download the Training Data.html

4. Review of the Data.mp4

02:26

2. Create Pivot Tables

1. Introduction to Create Pivot Tables.mp4

00:35

2. Create Pivot Tables.mp4

07:08

3. Working with Dimensions.mp4

05:24

4. Working with Values.mp4

03:10

5. Formatting and Sorting Pivot Tables.mp4

04:08

6. Column Graphs.mp4

05:58

7. Practical Activity - Pivot Tables.html

8. Completed Activity - Pivot Tables.mp4

05:02

3. Methods of Aggregation

1. Introduction to Methods of Aggregation.mp4

00:45

2. Methods of Aggregation.mp4

04:07

3. Combining Methods.mp4

05:13

4. Practical Activity - Methods of Aggregation.html

5. Completed Activity - Methods of Aggregation.mp4

03:39

4. Filters and Slicers

1. Introduction to Filters and Slicers.mp4

01:13

2. Filtering Pivot Tables.mp4

04:32

3. Top 10 Analysis.mp4

02:38

4. Practical Activity - Filters.html

5. Completed Activity - Filters.mp4

03:44

6. Report Filters.mp4

02:44

7. Slicers to Filter Data.mp4

04:22

8. Practical Activity - Slicers.html

9. Completed Activity - Slicers to Filter Data.mp4

03:41

10. Slicers to Filter Multiple Pivot Tables.mp4

04:19

5. Trend and Date Analysis

1. Introduction to Trend and Date Analysis.mp4

00:58

2. Creating Fields for Trend Analysis.mp4

07:27

3. Line and Area Graphs.mp4

05:27

4. Practical Activity - Trend and Date Analysis.html

5. Completed Activity - Trend and Date Analysis.mp4

03:39

6. Sales Dashboard

1. Introduction to Sales Dashboard.mp4

00:40

2. Create Sales Dashboard.html

3. Sales Dashboard Part 1.mp4

09:01

4. Sales Dashboard Part 2.mp4

05:56

7. Analyzing Data with Advanced Calculations

1. Introduction to Advanced Calculations.mp4

00:54

2. Percentage Calculations.mp4

05:18

3. Pie Charts.mp4

04:02

4. Percentage Of.mp4

03:04

5. Difference From, Running Total and Ranking.mp4

05:49

6. Practical Activity - Advanced Calculations.html

7. Completed Activity - Advanced Calculations.mp4

04:40

8. Conditional Formatting

1. Introduction to Conditional Formatting.mp4

00:57

2. Conditional Formatting using Rules.mp4

04:24

3. Top 10 Formatting.mp4

04:00

4. Practical Activity - Conditional Formatting.html

5. Completed Activity - Conditional Formatting.mp4

04:42

6. Data Bars, Color Scales and Icons.mp4

05:28

9. Finance Dashboard

1. Introduction to Interactive Finance Dashboard.mp4

00:44

2. Create Finance Dashboard.html

3. Finance Dashboard Part 1.mp4

05:17

4. Finance Dashboard Part 2.mp4

04:30

10. Working with Power BI Data

1. Introduction to Connecting to Power BI.mp4

00:37

2. Connect to Power BI.mp4

02:39

11. Course conclusion

1. Course Conclusion.mp4

00:33

Description

Learn to create POWERFUL REPORTS and DATA ANALYSIS using Microsoft 365 Excel Online - all in 3 Hours

What You'll Learn?

Learn to use the most POWERFUL tool in Microsoft Excel Online to easily summarize and create reports from your data
Enjoy CLEAR, CONCISE and LOGICAL step by step instructions from a best selling Excel and Power BI Udemy Instructor
In SECONDS create aggregated and summarized tables of data from VAST quantities of spreadsheet data
At the click of a mouse, create percentages, running totals, difference from and ranking calculations with no formulas!
Learn to use filters and slicers to display INTERACTIVE views of data with no complex coding or VBA
Get COMPREHENSIVE understanding of trends within data with a few clicks of the mouse

Who is this for?

Excel users who want to learn Online Excel Pivot Table capabilities

Excel users who want to summarize and aggregate data

Excel users who want to learn how to create professional reports

What You Need to Know?

Require access to Online Microsoft 365 Excel

You should be able to work with data in Excel and do basic reporting

More details

Description
Looking for a course that will get you up and running with Excel Pivot Tables without wasting your time?Â Looking for a course that makes sense and builds your knowledge up in a logical fashion?Â That's exactly what this course delivers.Â Get the crucial foundation you need to become a Pivot Table expert, using Excel 365 Online.
Microsoft 365 Online Excel provides you with access to the powerful Pivot Tables features that can summarize and aggregate your data in a few clicks of the mouse.
ABOUT THEÂ COURSE
Skills in data analysis, reporting and the creation of dashboardsÂ are HIGHLYÂ valued in today's business environment.Â Excel is now recognized as the most commonly used data analysis tool in the world for the development of reports, data analysis and dashboards.
In this course you will learn the INCREDIBLEÂ power of Pivot Tables to analyze and summarize data in seconds.Â Pivot Tables are without doubt the most powerful feature in Microsoft Excel.Â
In this course you will cover:
Introduction and Course Content
Creating Pivot Tables
Methods of Aggregation including Sum, Average, Min, Max and Count
Filtering and Slicing Pivot Tables
Trend Analysis
Create an Interactive Sales Dashboard
Advanced Calculations including Difference From, Running Total and Ranking
Conditional Formatting
Finance Interactive Dashboard
Excel and Power BI
* Life time access to course materials and practice activities. *
ABOUTÂ THEÂ TRAINER
Ian Littlejohn has been a top-rated trainer on the Udemy platform for over 5 years and has more than 10 years' experience in training & management consulting. He specialises in Data Analysis, covering Excel, Power BI, Google Data Studio and Amazon Quicksight.
Ian has over 250,000 students and with an average course rating of over 4.5. He has a reputation for delivering excellent, logically structured courses which are easy to follow and get the point across without wasting learners' time.
We look forward to having you on our course as we learn and explore the incredible power of Excel Pivot Tables and Pivot Charts.
Please note that this course is the third course in a series of three courses for the ExcelÂ Master ClassÂ series.Â Search for my instructor profile to purchase these other courses.
Course 1 - Complete Introduction to Excel Power Query
Course 2 - Complete Introduction to Excel Power Pivot
Course 3 - Excel Interactive Dashboards and Data Analysis
Who this course is for:
Excel users who want to learn Online Excel Pivot Table capabilities
Excel users who want to summarize and aggregate data
Excel users who want to learn how to create professional reports

User Reviews

Rating

average 0

Total votes0

Focused display

Ian is a trainer that specializes in Microsoft Power BI, Excel Pivot Tables, Power Pivot, Power Query, Google Data Studio and AWS QuickSight. Ian is an experienced trainer that teaches techniques and tools making it easy for learners to harness the power of business intelligence tools to easily turn data into insight and intelligence.Ian has been training learners on these powerful technologies for over 10 years making it easy for business users to easily create management reports, develop interactive dashboards and generate new insight and intelligence from business data. Ian has over 10 years of Management Consulting experience and he brings this knowledge and skills to his training course showing Excel and Google Data Studio users how to easily create sophisticated management reports, perform data analysis and create amazing interactive dashboards without using any complex programming or specialized tools. Ian has consulted and worked with major organizations in the Banking, Insurance, Manufacturing, Telecommunications and Logistics industries across a number of countries and continents.

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.