Beginner to Advanced Excel Pivot Tables and Pivot Charts

Beginner to Advanced Excel Pivot Tables and Pivot Charts, available at Free, has an average rating of 4.53, with 52 lectures, based on 88 reviews, and has 1194 subscribers.

You will learn about Learn how to create and use the various features of the Pivot Table Learn what Excel Pivot Table can do for you in data analysis Master Excel Pivot Table step by step with hands on engaging homework at the end of each section Discover how to make and utilise Pivot Charts for Analysis in Excel. This course is ideal for individuals who are Anyone who works with Excel on a regular basis and wants to refresh or update their skills. or Anyone wishing to work in data analysis, where proficiency with Excel is necessary, or Students whose academic work requires proficiency in Excel It is particularly useful for Anyone who works with Excel on a regular basis and wants to refresh or update their skills. or Anyone wishing to work in data analysis, where proficiency with Excel is necessary, or Students whose academic work requires proficiency in Excel.

Enroll now: Beginner to Advanced Excel Pivot Tables and Pivot Charts

Summary

Title: Beginner to Advanced Excel Pivot Tables and Pivot Charts

Price: Free

Average Rating: 4.53

Number of Lectures: 52

Number of Published Lectures: 37

Number of Curriculum Items: 52

Number of Published Curriculum Objects: 37

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

Learn how to create and use the various features of the Pivot Table
Learn what Excel Pivot Table can do for you in data analysis
Master Excel Pivot Table step by step with hands on engaging homework at the end of each section
Discover how to make and utilise Pivot Charts for Analysis in Excel.

Who Should Attend

Anyone who works with Excel on a regular basis and wants to refresh or update their skills.
Anyone wishing to work in data analysis, where proficiency with Excel is necessary,
Students whose academic work requires proficiency in Excel

Target Audiences

Anyone who works with Excel on a regular basis and wants to refresh or update their skills.
Anyone wishing to work in data analysis, where proficiency with Excel is necessary,
Students whose academic work requires proficiency in Excel

Excel Pivot Tables are a must-have tool for anyone who works with data in Excel.

Pivot tables allow you to quickly summarize and analyze data, revealing trends and valuable insights into your data that you would not have discovered otherwise. Excel Pivot tables will provide quick, accurate, and intuitive answers to the most difficult analytics questions.

This course will provide a thorough understanding of Excel Pivot Tables through a hands-on approach , ensuring that skills learned can be immediately applied to any Excel data analysis tasks.

I will start by taking you through everything you need to know in Excel Pivot tables which will include:

1) The data structure in Excel

2) Pivot Table layouts & styles

3) Design & formatting options

4) Sorting, filtering, & grouping tools

5) Calculated fields, items & values

6) Pivot Charts, slicers & timelines

The course is structured so that, depending on your learning needs, each section can be completed independently.

I chose to use both Excel 2007and 365 to demonstrate that the course is applicable to any version of Excel.

If you want to improve your Excel skills or become someone who can turn data into meaningful insights, this course is for you. Enrol in this course and start your journey to becoming an Excel data analysis expert.

Hope to see you in class.

Course Curriculum

Chapter 1: Basics of the Pivot Table

Lecture 1: Introduction & Course Content

Lecture 2: Getting your data ready for Pivot Table

Lecture 3: Creating the Pivot Table

Lecture 4: Grouping and Ungrouping in Pivot Tables

Lecture 5: Collapsing and Expanding in Pivot tables

Lecture 6: Field Settings in Pivot Tables

Lecture 7: Introduction to Slicers in Pivot Tables

Lecture 8: Introduction to Timeline in Pivot Table

Lecture 9: End of Section Practice Exercise

Lecture 10: Solution to the Review Homework

Chapter 2: Applying Filters in Pivot Tables

Lecture 1: Date Filters in Pivot tables

Lecture 2: Value Filters in Pivot Tables

Lecture 3: Label Filters in Pivot Tables

Lecture 4: End of Section Practice Exercise

Lecture 5: Solution to the Review Homework

Chapter 3: More on the Pivot Table Ribbon

Lecture 1: Selecting, Clearing, Moving & Copying Pivot Tables

Lecture 2: Refreshing & Updating Pivot Tables

Lecture 3: Layout group on the ribbon

Lecture 4: Layout in Pivot tables

Lecture 5: Style options in Pivot Tables

Lecture 6: Calculated field in Pivot Tables

Lecture 7: Calculated field items in Pivot Tables

Lecture 8: End of Section Practice Exercise

Lecture 9: Solution to the Review Homework

Chapter 4: Conditional Formatting in Pivot Tables

Lecture 1: Introduction to Conditional formatting in Pivot Tables

Lecture 2: Highlight cells rules

Lecture 3: Top Bottom rules

Lecture 4: Data bars, Color Scales and Icon Sets

Lecture 5: New rule, clear rules and manage rules

Lecture 6: End of Section Practice Exercise

Lecture 7: Solution video to the review exercise

Chapter 5: Pivot Charts

Lecture 1: Introduction to Pivot Charts

Lecture 2: Inserting Pivot Charts

Lecture 3: Combining pivot charts

Lecture 4: Changing chart types in pivot charts

Lecture 5: Basic data filtering in pivot charts

Lecture 6: Formatting in pivot charts

Instructors

Nasiru Musa
Intelligence Analyst and Trainer

Rating Distribution

1 stars: 2 votes
2 stars: 3 votes
3 stars: 4 votes
4 stars: 33 votes
5 stars: 46 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