Excel Pivot Tables A Quick Start Guide

Course Feature

Cost

Free
Provider

Udemy
Certificate

No Information
Language

English
Start Date

2022-06-11
Learners

No Information
Duration

No Information
Instructor

Dave M

Add to Favorites

4.2

4,486 Ratings

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.

Show All

Go to class

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!

Show All

Pros & Cons

Easy to follow

Lack of variety in examples

Show All

Recommended Courses

Advanced Pivot Table Techniques (to achieve more in Excel)

1.5

Youtube 1,668,273 learners

Learn More

Are you looking to get the most out of Microsoft Excel? Join 400,000+ professionals in our courses and learn the Top 10 Advanced Pivot Table Tips, Tricks & techniques to help you analyze your data and get better and faster insights. You'll learn how to create calculated fields, use conditional formatting, drill-down and view details of a value, generate multiple pivot table reports with one click, and more. Download the Pivot table sample file and start learning today!

You Wont Believe These Crazy PIVOT TABLE Hacks!

3.0

Youtube 294,551 learners

Learn More

Are you an Excel user looking to take your skills to the next level? Join 300,000+ professionals in our courses and learn the best Pivot Table hacks! In this video, you'll discover 10 pro tips to make the best use of Pivot Tables in Microsoft Excel. From hidden productivity tips to pivot table hidden tricks, you'll be amazed at the Excel tips and tricks you can learn. Don't miss out on this opportunity to become an Excel expert!

How to Create Pivot Table in Excel

2.5

Youtube 331,081 learners

Learn More

This course is perfect for beginners who want to learn how to create pivot tables in Microsoft Excel. With step-by-step instructions, you'll learn how to quickly and easily analyze data without needing to use any formulas or functions. You'll also learn how to sort, filter, insert charts, slicers, timelines, and more. By the end of this tutorial, you'll be confident using pivot tables in Excel. Click now to start learning and become an Excel expert!

Pivot Tables Excel: Detailed Beginners Pivot Table Tutorial

2.5

Youtube 228,130 learners

Learn More

This 2+ hour Excel tutorial video is the perfect way to learn all about Pivot Tables. With downloadable course files, you can follow along and practice what you learn as you go. Learn how to prepare your data, create and format Excel tables, and create Pivot Tables from scratch. You'll also learn how to add Pivot Table fields, summarize your data, group data, and lock the report layout. Master Pivot Tables in Excel with this detailed tutorial for beginners.