Introduction to PivotTables and PivotCharts in Excel

Loading the player ...

Introduction to PivotTables and PivotCharts in Excel

DURATION: 1h 53m
VIDEOS: 23
LEVEL: Intermediate

READY TO GET STARTED WITH SIMON SEZ IT?

Get immediate access to the entire library!

Description
Course Resources

Welcome to “Introduction to PivotTables and PivotCharts in Excel.” This course teaches you the essentials of organizing and visualizing data using PivotTables and PivotCharts. You’ll grasp the fundamentals of PivotTables, including creating them from scratch, applying subtotals, and formatting data effectively. Then, you’ll delve into PivotCharts, mastering the art of creating and formatting dynamic visual representations of your data.

By the end of the course, you should be able to understand how to add interactivity to your PivotTables and charts using slicers and timelines, enhancing your ability to analyze and present data efficiently. Whether you’re a beginner seeking to streamline data analysis or a professional aiming to improve your Excel skills, this course equips you with invaluable data management and visualization tools. Join us and unlock the power of PivotTables and PivotCharts in Excel.

In this course, you will learn how to:

Create PivotTables from scratch for data organization.
Apply subtotals and grand totals for data summarization.
Format PivotTable data with number formatting techniques.
Generate PivotCharts to visualize data effectively.
Insert and format slicers for interactive data filtering.
Update PivotTable data dynamically for real-time analysis.

WHAT YOU GET

Certificate of Completion

Earn a certificate each time you complete a course.
Showcase your commitment to continuous growth and professional development.
Impress potential employers.
Enhance your professional profile.
Available in PDF format to Download or Print.

The course comes with course files compressed into .zip format. You will need to download the .zip file to your PC or Mac (the file is not compatible with a mobile device) and unzip it. Once unzipped, all of the course files will reside in one folder.

Click on the below link to download the zip file.

What Our customers say

With over 1,000,000 learners we have achieved an average rating of 4.5 out of 5 stars.

4.5 /5

See more reviews

This has already helped me set up my project better and gives me the confidence that I’ll be able to keep tracking the project using the software.

Ann Lauzau

Enrolling in Simon Sez IT’s Microsoft Project for beginner course really helped me become proficient with Microsoft Project and project management. I now think more critically with my projects.

Patrick Loyola

I actually came to your courses because I want to master the IT aspects of project management. The course was very detailed. I will be recommending this course to other aspiring PMPs.

Frank Uchegbu

I enjoyed the logical structure of course. It helps beginners to follow easily.

Charlenee Huynh

I have always used Excel at work, but because I learned to use it on my own, I had never been able to make use of all the possibilities that the software offers. I have learned a lot thanks to...

Blanca Esteban

Simon Sez IT has trained me how to use Microsoft Project to create and manage my own projects in just 2 days. Exactly the training I was looking for! Its been an amazing experience would recommend to anyone who wishes...

Haroon Riaz

I enrolled in Simon Sez IT to use the Microsoft Excel for beginners course. I enjoyed every bit of the course and easy to understand and the pattern of teaching was top-notch. I will recommend this course to others including...

Umar Abdulqadir