What you'll get
- 20m
- 3 Videos
- Course Level - Intermediate
- Course Completion Certificates
- One-Year Access
- Mobile App Access
Curriculum:
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
Training 5 or more people?
Get your team access to 5,000+ top courses, learning paths, mock tests anytime, anywhere.
Drop an email at: [email protected]
20m | 3 Videos | 
Intermediate 
