Pivot Tables Hands-on!
Pivot Tables Hands-on!
Pivot Tables,Office Productivity
Lectures -57
Duration -1.5 hours
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
![Pivot Tables Hands-on! Pivot Tables Hands-on!](https://d3mxt5v3yxgcsr.cloudfront.net/courses/13913/course_13913_image.png)
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
![Tutorialspoint](/market/public/assets/images/loader.gif)
Data Filtering
8 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Basics Pivot Table Formatting
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Advanced Pivot Table Formatting
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Session 6-Introduction of Pivot Chart
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
How to Print the Pivot Table
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Using Macros In Pivot Tables
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Introduction of Power Pivot
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
DAX in Power Pivot
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Introduction of Power View
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Corporate Bridge Consultancy Private Limited](https://www.tutorialspoint.com/assets/profiles/555285/profile/200_81015-1692449117.jpg)
Corporate Bridge Consultancy Private Limited
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
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![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)