Excel Pivot Tables A Quick Start Guide

4.2

Learners: 4,486

Instructor: Dave M

Duration:

This course is perfect for anyone looking to learn the fundamentals of Excel Pivot Tables and gain the analytical skills employers crave. It covers topics from basic Pivot Table fundamentals to advanced formulas, slicers, charts, and more. With easy to follow videos, you'll be able to quickly learn the skills needed to join the exclusive 5% of Excel users who know how to make Pivot Tables. So don't miss out on this opportunity to give your career the extra advantage it needs. ▼▲

Course Feature Course Overview Pros & Cons Course Provider Discussion and Reviews

Go to class

Course Feature

Cost:

Free

Provider:

Udemy

Certificate:

No Information

Language:

English

Start Date:

2022-06-11

Course Overview

❗The content presented here is sourced directly from Udemy platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [July 18th, 2023]

This course provides an overview of Excel Pivot Tables and is designed to help users gain a comprehensive understanding of the powerful tool. It starts by introducing the fundamentals of Pivot Tables and presents the topics in short, fun, easy to follow videos. The course then moves into working with calculations/ formulas, the ever cool slicer, charting and concludes with some miscellaneous topics.

No previous experience with Excel is required to take this course, as long as the user is able to select cells on a spreadsheet, has a basic understanding of formulas in Excel, is able to navigate between sheets and is somewhat familiar with sorts and filters. The course was created using Excel 2019, but can be used with Excel 2016/ 2019 or Office 365 (primarily for PC/Windows). Mac users are welcome, but be aware their screen will be somewhat different.

By the end of the course, users will have the skills to read and analyze data, and be competent with Pivot Tables, which can give them the extra advantage in developing their career.

Course Syllabus

Course Intro and Format | Important! :)

Pivot Tables | The Fundamentals

Working with calculations in pivot tables

Intro to slicers

Pivot Table Charts

Miscellaneous, yet relevant topics :)

The 4 Minute Dashboard

Homework?? And thank you so very much!

Pros & Cons

Pros Cons

Easy to follow: Users appreciate the course for being easy to follow and understand. The teacher's explanations are clear and relatable, making it easier for learners to grasp the concepts. Practical and applicable knowledge: The course provides practical knowledge and tips for using pivot tables effectively. Users mention that they gained a good grip on pivot tables and learned how to manipulate and customize them beyond the standard templates.

Lack of variety in examples: Some users mention that while the examples provided in the course are good, there could be more variety in the types of data and scenarios covered. This would help learners apply pivot tables to different real-life situations. Limited scope: Although the course covers the most useful parts of pivot tables, some users feel that it could have delved deeper into advanced techniques and functionalities. They would have liked to learn more advanced features and tricks to enhance their pivot table skills.