Pivot Tables Hands-on!
Pivot Tables Hands-on!
Updated on Jun, 2025
Language - English
Office Productivity,Microsoft,Pivot Tables Data Analysis
Lectures -57
Duration -1.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Excel 2013 – Pivot Table is an influential method to analyze huge amount of data with huge number of variables. Through this course on Excel 2013 pivot table you will learn to summarize the data in an intelligent way by creating the Pivot tables. Further, you will learn in detail how Pivot Tables work and the structure that must be followed to create useful reports and charts.
This training is vital to gaining the most from this powerful feature of Excel. This course assumes that you have some basic concepts of Excel. This course is structured in a way to only focus on the most important elements of creating and working with Pivot tables. Pivot Table is a very useful and powerful method for Financial Analysts, Investment Bankers, Marketing Professionals, Team Leaders, students and professionals working with vast amount of data with different variables. In this course, we will be covering the following modules:
- Basics of Pivot Table
- Summarizing Data Using Pivot Table
- Data Filtering
- Basics Pivot Table Formatting
- Advanced Pivot Table Formatting
- Introduction of Pivot Chart
- How to Print the Pivot Table
- Using Macros In Pivot Tables
- Introduction of Power Pivot
- DAX in Power Pivot
- Introduction of Power View
Who this Course is For:
- Students, Marketing Professionals, Analysts.
- Anyone working with lists of data, filtering or sorting that data.
- Those with some knowledge of Excel who are new to Pivot Tables
Goals
- Learn to summarize the data in an intelligent way by creating the Pivot tables
- Learn Basics of Pivot Table
- Learn Summarizing Data Using Pivot Table, Data Filtering, Basic and Advanced Pivot Table Formatting
- Learn Pivot Chart, Printing Pivot Tables, Using Macros in Pivot Tables
- Learn Power Pivot, DAX in Power Pivot, Introduction of Power View
Prerequisites
- Basic knowledge of Excel
- A Computer with Internet
Curriculum
Check out the detailed breakdown of what’s inside the course
Basics of Pivot Table
8 Lectures
-
Pivot tables Practice files
06:28
06:28
-
Data Formatting
02:40
02:40
-
Creating Pivot Table
02:52
02:52
-
Recommended Data Table
01:41
01:41
-
Pivoting Pivot Table
02:52
02:52
-
External Data
01:46
01:46
-
Consolidation Sheets
05:06
05:06
-
Managing Pivot Table
02:52
02:52
Summarizing Data Using Pivot Table
6 Lectures
Data Filtering
8 Lectures
Basics Pivot Table Formatting
2 Lectures
Advanced Pivot Table Formatting
5 Lectures
Session 6-Introduction of Pivot Chart
5 Lectures
How to Print the Pivot Table
4 Lectures
Using Macros In Pivot Tables
2 Lectures
Introduction of Power Pivot
6 Lectures
DAX in Power Pivot
4 Lectures
Introduction of Power View
7 Lectures
Instructor Details
Corporate Bridge Consultancy Private Limited
Corporate Bridge Consultancy Private Limited - EDUCBA is an initiative by IIT IIM Graduates, We are one of the leading providers of skill-based education addressing the needs of 1,000,000+ members across 70+ Countries. With more the 15+ years of experience in Training and Development, our expertise lies in Self-paced learning, Digital Learning content, Corporate Training, Content Development and Consultancy.
Our Vision:
To be a leading and progressive partner with our clients in their journey of progress.
"We are passionate about our work. We believe in empowering and improving our members’ lives with skill-based, hands-on training programs."
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now