From Beginner to Master of Pivot Tables – Best Tool in Excel

From Beginner to Master of Pivot Tables – Best Tool in Excel, available at $44.99, has an average rating of 4.35, with 45 lectures, based on 104 reviews, and has 1547 subscribers.

You will learn about Extensive productivity skills that and how to solve complex solutions for with Excel First Step Towards Microsoft Excel Specialist Certification Improve Productivity Immediately Apply Skills to your Job Create PivotTables Format Data into Tables Analyze Data in PivotTables Filter Data based on desired Information Extract Data using Formulas Create PivotCharts based on PivotTables Reformat PivotCharts Rename, Rearrange, Delete Worksheet Tabs Insert Columns into a worksheet Maintain PivotTables with current data using Refresh This course is ideal for individuals who are People working towards Microsoft Excel Specialist Certification or Project Management Professionals (PMP's) Looking to Satisfy PDU Requirements or Course can be completed by all levels of experience with Excel or Beginners can follow this course easily or Intermediate Users can Learn Advanced Techniques such as Dashboards or Anyone who wants to make themselves more valuable in the workplace or Anyone who wants to advance their professional careers It is particularly useful for People working towards Microsoft Excel Specialist Certification or Project Management Professionals (PMP's) Looking to Satisfy PDU Requirements or Course can be completed by all levels of experience with Excel or Beginners can follow this course easily or Intermediate Users can Learn Advanced Techniques such as Dashboards or Anyone who wants to make themselves more valuable in the workplace or Anyone who wants to advance their professional careers.

Enroll now: From Beginner to Master of Pivot Tables – Best Tool in Excel

Summary

Title: From Beginner to Master of Pivot Tables – Best Tool in Excel

Price: $44.99

Average Rating: 4.35

Number of Lectures: 45

Number of Published Lectures: 45

Number of Curriculum Items: 45

Number of Published Curriculum Objects: 45

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Extensive productivity skills that and how to solve complex solutions for with Excel
First Step Towards Microsoft Excel Specialist Certification
Improve Productivity
Immediately Apply Skills to your Job
Create PivotTables
Format Data into Tables
Analyze Data in PivotTables
Filter Data based on desired Information
Extract Data using Formulas
Create PivotCharts based on PivotTables
Reformat PivotCharts
Rename, Rearrange, Delete Worksheet Tabs
Insert Columns into a worksheet
Maintain PivotTables with current data using Refresh

Who Should Attend

People working towards Microsoft Excel Specialist Certification
Project Management Professionals (PMP's) Looking to Satisfy PDU Requirements
Course can be completed by all levels of experience with Excel
Beginners can follow this course easily
Intermediate Users can Learn Advanced Techniques such as Dashboards
Anyone who wants to make themselves more valuable in the workplace
Anyone who wants to advance their professional careers

Target Audiences

People working towards Microsoft Excel Specialist Certification
Project Management Professionals (PMP's) Looking to Satisfy PDU Requirements
Course can be completed by all levels of experience with Excel
Beginners can follow this course easily
Intermediate Users can Learn Advanced Techniques such as Dashboards
Anyone who wants to make themselves more valuable in the workplace
Anyone who wants to advance their professional careers

Over 1500+ enrolled since January 2016! One of Udemy’s fastest growing courses!

In today’s job market Excel proficiency is required. The ability to not only fluently use Excel but implement it into the daily routine is increasingly mandatory. A majority of employers requires Excel proficiency but lack any real on-the-job training in this software.

Pro tip: Want to improve your Resume? Become a Microsoft Certified Excel Specialist! This course is the first step towards becoming certified! It will prepare you in a core aspect of the certification and set you on the path towards one of the most valuable Professional Certifications you can earn!

Excel 2010 Certification Exam Offered via Microsoft Learning Exam #77-882
See Promo Video for Link!

There are numerous ways to learn, yet many lack the real world application you desire. You need to be able to take data sets your job uses and turn them into user-friendly, easy-to-analyze reports that your boss and even his bosses can read to use to make real-time decisions. Today’s industries are more data driven than ever; will you be the one to shine?

This is comprehensive PivotTable course will provide you with a step-by-step guide into developing and using PivotTables. It is designed in a way that even the most basic beginner to an experienced user can follow along and take away valuable knowledge and skills you can immediately apply to your job. These are Excel’s most important tools. Quite literally, all analysis stems from PivotTables. In short, they are a summarizing tool to the basic user. But developed by an ace, they can literally shape the decisions a company makes!

By the end of this course you will be able to not only be well versed in Excel PivotTables, but empowered with the skills to develop and implement powerful, real-time reports your bosses, even executives would be impressed with!

This course covers:

Formatting data as a table
Optimizing your Workbook
Using logic functions to extract information
Applying filters and sorts
Creating multiple PivotTables
Applying PivotTable Styles
Drilling down details
Presenting sales data
Using Advanced Formulas
- GetPivotData
- IfError
- Left & Right
Manipulating and configuring data for real-time decision making
Refreshing you PivotTables
Fixing Common Errors
Creating PivotCharts
Advanced PivotChart Formatting
Building & Using PivotChart Dashboards

Mastering PivotTables is a massive leap forward to mastering Excel, this is the solution!

Course Curriculum

Chapter 1: Overview

Lecture 1: Overview

Chapter 2: Workbook Setup

Lecture 1: Tutorial 2 – DATA TABLE SETUP – Inserting Columns

Lecture 2: Tutorial 3 – DATA TABLE SETUP – Extract Data With Formulas

Lecture 3: Tutorial 4 – DATA TABLE SETUP – Autofill

Lecture 4: Tutorial 5 – DATA TABLE SETUP – Format as a Table

Lecture 5: Tutorial 6 – DATA TABLE SETUP – Table Filters & Sorts

Chapter 3: Data Analysis & Reporting

Lecture 1: Tutorial 7 – DATA ANALYSIS – Making PivotTables

Lecture 2: Tutorial 8 – DATA ANALYSIS – Formatting Values

Lecture 3: Tutorial 9 – DATA ANALYSIS – Drilling Down Details

Lecture 4: Tutorial 10 – DATA ANALYSIS – Expand & Collapse PivotTables

Lecture 5: Tutorial 11 – DATA ANALYSIS – Report Filters

Lecture 6: Tutorial 12 – DATA ANALYSIS – Refreshing PivotTables

Lecture 7: Tutorial 13 – DATA ANALYSIS – Advanced Filters

Lecture 8: Tutorial 14 – DATA ANALYSIS – Sorting PivotTables

Lecture 9: Tutorial 15 – DATA ANALYSIS – PivotCharts

Chapter 4: Formatting the Workbook

Lecture 1: Tutorial 16 – FORMATTING WORKBOOK – Rearrange, Rename, Delete Worksheet Tabs

Chapter 5: Worksheet Formatting

Lecture 1: Bonus Tutorial 17 – Inserting Rows

Lecture 2: Bonus Tutorial 18 – Merging Cells

Lecture 3: Bonus Tutorial 19 – Applying PivotTable Styles

Lecture 4: Bonus Tutorial 20 – Row Heights

Lecture 5: Bonus Tutorial 21 – Columns Widths

Lecture 6: Bonus Tutorial 22 – Fonts, Fills, Formats

Lecture 7: Bonus Tutorial 23 – Format Painter

Chapter 6: Advanced Workbook Formatting

Lecture 1: Tutorial 24 – Worksheet Tab Colors

Lecture 2: Tutorial 25 – Naming Ranges

Chapter 7: Advanced Pivot Table Techniques

Lecture 1: Tutorial 26 – Changing The Data Source

Lecture 2: Tutorial 27 – PivotTable Report Layouts

Lecture 3: Tutorial 28 – Subtotals & Repeating Labels

Lecture 4: Tutorial 29 – PivotTable on a PivotTable

Lecture 5: Tutorial 30 – GetPivotData Formula

Lecture 6: Tutorial 31 – IfError Formula

Lecture 7: Tutorial 32 – Data Validation & Drop Down Menus

Lecture 8: Tutorial 33 – Moving PivotTables

Lecture 9: Tutorial 34 – Overlapping PivotTables

Lecture 10: Tutorial 35 – Validate Dataset Errors

Lecture 11: Tutorial 36 – Percentage PivotTables

Lecture 12: Tutorial 37 – Percentage PivotCharts

Chapter 8: PivotChart Dashboard

Lecture 1: Tutorial 38 – Dashboard – The Setup

Lecture 2: Tutorial 39 – Dashboard – Create PivotChart 1

Lecture 3: Tutorial 40 – Dashboard – Create PivotChart 2

Lecture 4: Tutorial 41 – Dashboard – Create PivotChart 3

Lecture 5: Tutorial 42 – Dashboard – Create PivotChart 4

Lecture 6: Tutorial 43 – Dashboard – Create PivotChart 5

Lecture 7: Tutorial 44 – PivotChart Dashboard – Place PivotTables on Dasboard

Lecture 8: Tutorial 45 – Dashboard – Add & Use Slicers

Instructors

Logan Spiers
Certified Excel Specialist, Professional Development Trainer

Rating Distribution

1 stars: 0 votes
2 stars: 1 votes
3 stars: 9 votes
4 stars: 42 votes
5 stars: 52 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu