Microsoft Excel: A Beginners’ Guide to Pivot Tables in Excel

Focused View

Simon Sez IT

5:36:44

136 View

Chapter 1 Introduction to the Course

001. Course Introduction.mp4

05:12

002. What are Pivot Tables and Why are they Useful.mp4

06:24

Chapter 2 Preparing Data for Analysis

001. The Importance of Cleaning Data.mp4

03:07

002. Removing Blank Rows.mp4

05:33

003. Removing Duplicate Rows.mp4

02:40

004. Clearing Formatting.mp4

04:29

005. Applying Number Formatting.mp4

08:41

006. Changing the Case.mp4

09:18

007. Removing Spaces and Non-printing Characters.mp4

10:09

008. Merging and Splitting Columns.mp4

13:02

009. Convert Numbers Stored as Text.mp4

02:31

010. Finding and Replacing Text.mp4

06:09

011. Spell Check.mp4

04:00

012. Exercise 01.mp4

04:04

Chapter 3 The Importance of Excel Tables

001. Excel Tables versus Pivot Tables.mp4

05:26

002. Format Data as a Table.mp4

08:49

003. Exercise 02.mp4

02:02

Chapter 4 Creating a Basic Pivot Table Report

001. Using Recommended Pivot Tables.mp4

05:31

002. Creating a Pivot Table from Scratch.mp4

05:47

003. Pivot Table Ribbons and Fields.mp4

06:42

004. Pivoting the Fields.mp4

05:35

005. Adding Multiple Dimensions.mp4

02:49

006. Deleting Fields and Locking the Report Layout.mp4

03:43

007. Exercise 03.mp4

01:39

Chapter 5 Aggregation and Grouping

001. Methods of Aggregation.mp4

04:11

002. Combining Methods of Aggregation.mp4

05:39

003. Grouping and Ungrouping Data.mp4

09:48

004. Exercise 04.mp4

03:34

Chapter 6 Formatting Values

001. Applying Number Formatting.mp4

04:47

002. Handling Cells with No Data.mp4

04:03

003. Exercise 05.mp4

02:20

Chapter 7 Layout Options

001. Subtotals and Grand Totals.mp4

04:29

002. Choosing a Report Layout.mp4

04:46

003. Inserting Blank Rows.mp4

02:16

004. Exercise 06.mp4

02:11

Chapter 8 Formatting Pivot Tables

001. Applying Pivot Table Styles.mp4

04:17

002. Modifying Pivot Table Styles.mp4

04:22

003. Creating a Custom Pivot Table Style.mp4

05:39

004. Exercise 07.mp4

03:33

Chapter 9 Sorting and Filtering

001. Sorting Pivot Table Data.mp4

08:34

002. Filtering Pivot Table Data.mp4

07:23

003. Top 10 Filter.mp4

03:33

004. Exercise 08.mp4

02:09

Chapter 10 Creating Pivot Charts

001. Selecting the Right Chart Type.mp4

08:43

002. Clustered Column and Bar Charts.mp4

13:42

003. Line Charts.mp4

09:58

004. Pie and Donut Charts.mp4

11:33

005. Map Charts.mp4

08:49

006. Applying Chart Layouts.mp4

03:09

007. Exercise 09.mp4

04:09

Chapter 11 Formatting Pivot Charts

001. Adding a Slicer.mp4

07:41

002. Formatting a Slicer.mp4

06:25

003. Adding a Timeline.mp4

05:24

004. Connecting Slicers and Timelines.mp4

05:32

005. Exercise 10.mp4

03:12

Chapter 12 Applying Conditional Formatting

001. Highlight Cell Rules.mp4

05:39

002. Data Bars.mp4

04:11

003. Color Scales.mp4

03:23

004. Icon Sets.mp4

04:28

005. Exercise 11.mp4

01:32

Chapter 13 Updating Pivot Tables and Pivot Charts

001. Adding Data to the Dataset.mp4

02:39

002. Updating Pivot Tables and Pivot Charts.mp4

01:43

003. Exercise 12.mp4

01:51

Chapter 14 Course and Next Steps

001. Course and Next Steps.mp4

02:05

Description

We need to analyze data these days since we live in a very data-driven world. Therefore, data is important in any business, whether you are looking for trends or forecasting future business needs. As there is a lot of importance placed on data analysis, you must have the relevant skills to analyze data effectively. Pivot Tables is an essential Excel skill for jobs that involve analyzing and visualizing large amounts of data. Pivot Tables are an interactive way of quickly summarizing large amounts of data by grouping and aggregating data sets and analyzing data clearly and effectively. This course will discuss the importance of cleaning your data before creating your first Pivot Table. You’ll also learn how to create Pivot Charts and how to format your Pivot Tables and Charts. This course includes downloadable Excel data files that the instructor uses in the guide to follow along. By the end of this course, you'll learn the skills required to be able to clean the data, put it in the Pivot Table, analyse the data efficiently, and keep it updated with a single click. Therefore, by opting for this course, you’ll be able to take your own information and leverage Pivot Tables to answer questions with ease. All the resource files are uploaded on the GitHub repository at https://github.com/PacktPublishing/Microsoft-Excel-A-Beginners-Guide-to-Pivot-Tables-in-Excel

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Simon Sez IT

Instructor's Courses

Simon Sez IT has offered technical courses since 2008 for individuals, small businesses, and Fortune 500 companies with thousands of employees who can benefit from the easy-to-learn and hands-on software training. It offers over 8000 video tutorials on a range of software programs. Simon Sez IT ensures stress-free eLearning and enhanced employee productivity—whether you implement new software or a technological upgrade in your work environment. With over 600,000 students from 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses worldwide.

PacktPub

View courses PacktPub

Packt is a publishing company founded in 2003 headquartered in Birmingham, UK, with offices in Mumbai, India. Packt primarily publishes print and electronic books and videos relating to information technology, including programming, web design, data analysis and hardware.