Pivot Tables for Microsoft Excel

Through this training you are going to understand how to use Pivot tables for better data visualization and analysis using excel.

12

 20m | 3 Videos | 55965 Views |   Intermediate

Pivot Tables in Depth For Microsoft Excel 2016:

The course is an online course. It being one of the most interesting usage of excel you might be excited to learn to simplify your work and make it more interesting. Through this training you are going to understand how to use Pivot tables for better data visualization and analysis using excel.

Following is the part of training;

1. What are Pivot tables?

2. Managing Calculations and more with Value Field Setting and Field Settings

3. Filters, Slicers and Timelines

4. Formatting Pivot Tables with the Design Tab

5. Grouping items

6. Calculated Fields & Calculated Items

7. Pivot Table Options

8. Pivot Charts

9. Miscellaneous features

10. Online Analytical Processing (OLAP)

Target Customers:

• Commerce students
• Students from the business administration
• Working professionals who go through the hectic working schedule of same repetitive work every day

Pre-Requisites:

• Advanced familiarity with Excel 2016 interface
• Ability to apply basic formulas and functions
• Basic knowledge of custom and conditional formatting

Back to top ?