Microsoft Excel Pivot Tables - Beginner to Advanced

Focused View

Kyle Pew

4:27:30

125 View

1. Microsoft Excel PivotTables - Beginner to Advanced Course Introduction

1. Microsoft Excel PivotTables - Beginner to Advanced Course Introduction.mp4

05:45

2.1 ExcelPivotTableExerciseFiles.zip

2. Excel PivotTable Course Exercise Files (DOWNLOAD).mp4

02:33

3. Excel PivotTable Course QA (ASK QUESTIONS).mp4

02:33

4. CHALLENGE 01 Post to the Course QA.html

2. Introduction to Excel PivotTables

1. Why Use an Excel PivotTable.mp4

04:33

2. Introduction to PivotTable Source Data.mp4

05:06

3. Inserting an Excel PivotTable.mp4

05:22

4. Working with the PivotTable Field List.mp4

05:55

5. CHALLENGE 02 Create an Excel PivotTable.html

6. Modify Excel PivotTable Field Layout.mp4

05:26

7. CHALLENGE 03 Modify PivotTable Summary.html

8. Refreshing an Excel PivotTable.mp4

03:15

9. BONUS TIP - Excel Table as PivotTable Source.mp4

07:38

3. Preparing Microsoft Excel Worksheet Data

1. Proper Microsoft Excel List Design and Layout.mp4

00:49

2. Microsoft Excel - Dos and Donts of Proper Excel List Design.mp4

06:55

3. Cleaning Up Excel List Data.mp4

04:11

4. Proper Excel List Headers.mp4

03:36

5. Removing Empty Excel List Rows.mp4

06:12

6. Microsoft Excel PROPER() Function.mp4

04:57

7. Microsoft Excel TRIM() Function.mp4

03:29

8. Microsoft Excel VALUE() Function.mp4

04:07

9. Microsoft Excel UPPER() Function.mp4

02:36

10. CHALLENGE 04 Cleaning Up Excel Data.html

11. Apply Excel Data Validation to List to Ensure Data Integrity.mp4

05:07

12. Highlight Invalid List data.mp4

03:29

13. Removing Duplicate Records from Excel List.mp4

05:58

14. Format Excel List as Table.mp4

02:25

15. CHALLENGE 05 Applying Validation to PivotTable Source Data.html

4. Microsoft Excel PivotTables Summary Values and Calculations

1. Excel PivotTable VALUE Defaults.mp4

07:24

2. Manage Value Field Settings.mp4

05:16

3. Show Values As Settings.mp4

06:12

4. Formatting PivotTable Values.mp4

05:15

5. CHALLENGE 06 PivotTable Value Field Settings.html

5. Grouping Excel PivotTable Data

1. Grouping PivotTable Date Values.mp4

09:00

2. Date Value Group Settings.mp4

03:03

3. Manually Grouping PivotTable Row Data.mp4

06:05

4. Excel PivotTable Multi-Level Row Groupings.mp4

03:26

5. CHALLENGE 07 PivotTable Grouping.html

6. Sorting and Filtering Excel PivotTable Data

1. Sorting Data in an Excel PivotTable.mp4

05:39

2. Using Custom Lists to Sort in an Excel PivotTable.mp4

06:29

3. Sorting PivotTable Column Headers.mp4

02:45

4. Filtering Data in an Excel PivotTable.mp4

07:12

5. Working with PivotTable Slicers to Filter Data.mp4

05:28

6. Removing a PivotTable Slicer.mp4

01:24

7. Working with Excel PivotTable Timeline Filters.mp4

03:46

8. Sorting and Filtering Excel PivotTable Data.html

7. Formatting Excel PivotTables

1. Working with Excel PivotTable Styles.mp4

03:10

2. Managing Excel PivotTable Subtotals.mp4

05:47

3. Managing Excel PivotTable Grand Totals.mp4

02:45

4. Formatting PivotTable Slicers.mp4

05:23

8. Excel Pivot Charts

1. Inserting an Excel Pivot Chart.mp4

03:09

2. Combining Charts with PivotTable Slicers.mp4

02:53

3. PivotTable and Pivot Chart Connection.mp4

03:39

4. Formatting a Pivot Chart with Chart Styles.mp4

02:51

5. Adding and Removing Chart Elements.mp4

05:33

9. Introduction to Microsoft Excel Power Query

1. Why Excel Power Query.mp4

04:00

2. Introduction to External Data Sources.mp4

02:56

3. Creating a New Query.mp4

04:04

4. Transform Power Query Data.mp4

02:58

5. Loading a Query to an Excel Worksheet.mp4

03:13

6. Updating the Original Source Data.mp4

03:07

7. Creating a PivotTable based on the Query.mp4

04:22

8. Introduction to Excel Table Relationships.mp4

05:38

9. Append Multiple Queries through Power Query.mp4

07:32

10. Merge Multiple Queries through Power Query.mp4

09:17

11. Create a PivotTable based on Multiple Datasets.mp4

03:14

10. Congratulations

1. Congratulations on Completing the Excel PivotTables Beginner to Advanced Course.mp4

01:38

Description

Quickly calculate, summarize and analyze large data sets with Microsoft Excel Pivot Tables

What You'll Learn?

Prepare Microsoft Excel data for PivotTable reporting
Connect PivotTables to various data sources
Create and manage PivotTable calculations
Format PivotTables for presentations
Update PivotTable source data
Create and manage Excel Data Models to pull in data from multiple sources
Create and manage data relationships
Create Dashboard elements in a PivotTable

Who is this for?

This course is intended for users familiar with working in Microsoft Excel but wish to master working with Excels PivotTable feature.

Microsoft Excel users who want to become more efficient in summarizing and reporting on large datasets within Excel

More details

Description
WHYÂ EXCELÂ PIVOT TABLES
Mastering Microsoft Excel PivotTables will change the way you approach reporting. Through a few clicks of the mouse Excel PivotTables allow you to quickly and efficiently summarize large data sets.
COURSEÂ DESIGNEDÂ TOÂ HELPÂ YOUÂ SUCCEED
This Microsoft Excel PivotTables - Beginner to Advanced course will take your skills from absolute PivotTable beginner to Advanced PivotTable user. Each section of the course has been designed to focus on a specific skill set. Once that skill set is mastered, then you will move to the next section that builds upon the previous skill set. After completing the first few sections of the course you will feel like you can conquer the world with the reports you can create, but there's more.
Each section contains instructor lead lectures with step-by-step instruction and encouragement to try the various topics for yourself, using the course provided exercise files. Each section also contains mini challenges where you can practice the skill you are mastering with additional exercises and quizzes on the topics.
WHATÂ YOU'LLÂ LEARN
Create dynamic reports that will help with making intelligent business decisions
Capture data from a single source or from multiple related sources
Apply proper list design techniques to make reporting a breeze
Summarize data with built in Excel functions and custom calculations
Format your report for clear presentation
JOINÂ ME
Enroll now and learn to harness the power of Microsoft Excel PivotTables.

Who this course is for:
This course is intended for users familiar with working in Microsoft Excel but wish to master working with Excels PivotTable feature.
Microsoft Excel users who want to become more efficient in summarizing and reporting on large datasets within Excel

User Reviews

Rating

average 0

Total votes0

Focused display

Qualifications: Kyle is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 20+ years on various computer applications, including;Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013 Excel, Word, PowerPoint, Outlook, Access and VisioSharePoint End-User 2007, 2010, 2013VBA (Excel and Access)Adobe Suite Photoshop, Illustrator, InDesignMaya (Modeling and Animation)Unity3d (Game Design)HTML, CSS and JavaScriptCrystal ReportsKyle is a graduate of the San Francisco Art Institute in the Media Arts and Animation Program. He has worked as a Game Designer for Electronic Arts, designing on games such as Nerf N-Strike, Nerf N-Strike Elite, both for the Wii, and a Sims 3 Expansion Pack for the PC.Kyle has facilitated courses that range from 1-on-1 interactions to large scale groups of 100+ participants, including; live in person classes, webinar style classes online and live online full courses. He is consistently ranked top in reviews for each of the courses he teaches.Some of the clients Kyle has provided training for include:BrocadeChevronGenentechFacebookLevi StraussPMI Mortgage InsuranceState FundBank of the WestVISAWalmartand many more...What Students have said about Kyle:"Kyle was off the chart "GOOD"""ONE OF THE BEST COURSES THAT I'VE HAD... (IN 12+ YEARS).""Awesome trainer because I'm computer "stupid" and he helped me understand it.""Kyle Pew is very knowledgeable and presented information with exceptional skill."Teaching Philosophy: Kyle believes that student’s best learn through the application of real-life business situations through exercises. Allowing students to guide the class with their specific situations allows for the quickest and easiest adaptation to new technology and skills.In His Spare Time: Kyle enjoys spending time with his family (6 children). When he’s not busy entertaining his kids, you will find him cheering on his favorite hockey team, the San Jose Sharks, this is their year!

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.