Masterclass Microsoft Excel 2013: Pivot Tables
- Offered byXLNC
Masterclass Microsoft Excel 2013: Pivot Tables at XLNC Overview
Duration | 6 months |
Total fee | ₹1,999 |
Mode of learning | Online |
Official Website | Go to Website  |
Credential | Certificate |
Masterclass Microsoft Excel 2013: Pivot Tables at XLNC Highlights
- Earn a certificate after completion of course from XLNC
Masterclass Microsoft Excel 2013: Pivot Tables at XLNC Course details
For Everyone who wants to be Master at Excel Formulas
Introduction to Pivot Tables in Excel 2013
Selecting and organizing data for Pivot Table creation
Customizing Pivot Table Layout and Design
Learn how to use the Sum, Count, Average, Max, and Min functions in Pivot Tables
How to create Pivot Tables from multiple worksheets and workbooks using the Data Model
The Masterclass Microsoft Excel 2013: Pivot Tables course is designed to provide users with the skills and knowledge needed to master one of Excel’s most powerful tools—Pivot Tables
Pivot Tables are essential for quickly summarizing, analyzing, and visualizing large sets of data, and they are widely used for reporting, data analysis, and business decision-making
Whether you're new to Pivot Tables or seeking to deepen your understanding, this course will teach you how to harness the full potential of Pivot Tables to analyze data more efficiently and effectively
Masterclass Microsoft Excel 2013: Pivot Tables at XLNC Curriculum
Welcome
Introduction
Versions of Excel
Reviewing the basics
Introduction to Pivots
Elements of a Pivot
Putting It Together
The pivot screen
Report Filter
Filter Search
Rows and Columns
Subtotals and Totals
Pivot options
Show Group on Ribbon
Screen View from Field List
Data and Action Menus
Pivot design
Layout and Style
Example of Formatting
Working with calculations
Calculated Fields
Percentage of Whole
Creating formulas
Creating a Custom Formula
Limitations
Slicers
Introduction to Slicers
Setting Up the Screen
Functionality
The Power of Slicers with Charts
Interaction of pivot tables
User Interaction
Keeping It Simple
Powerpivot
What PowerPivot Is
The PowerPivot Screen
PowerPivot Continued
Other courses offered by XLNC
Student Forum
Anything you would want to ask experts?