November 2021
Beginner
5h 37m
English
Closed Captioning available in English
Overview
In this 5 hr course, you'll master the foundational skills needed to work with Pivot Tables and Charts in Microsoft Excel, taught by expert instructors from Simon Sez IT. You'll explore how to prepare your data, create and format Pivot Tables, and utilize Pivot Charts for effective data visualization, complete with hands-on practice and real-world examples.
What I will be able to do after this course
- Understand the basics of creating Pivot Tables and gain the ability to present summarized and organized data.
- Learn how to clean and prepare datasets to ensure accurate and consistent data analysis.
- Develop skills in creating Pivot Charts to visually interpret large data sets efficiently.
- Master the techniques to update Pivot Tables with new data to maintain dynamic reports.
- Gain proficiency in using aggregation methods and multiple dimensions in data analysis.
Course Instructor(s)
Simon Sez IT is a team of experienced instructors specializing in software training, with a focus on Excel and data analysis. They have helped thousands of learners acquire useful technical skills through clearly structured and accessible courses. Their teaching philosophy emphasizes practical examples and hands-on learning.
Who is it for?
This course is ideal for beginners who want to use Pivot Tables to enhance their Excel skills or professionals looking to sharpen their data analysis techniques. It is perfect for individuals with basic familiarity with Excel who wish to upgrade their expertise to manage and analyze large datasets effectively. Whether you've never used Pivot Tables or wish to strengthen your knowledge on this topic, this course caters to your needs and goals.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Watch now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.