Section 1: Basics Of Pivot Table
Data Formatting
Create Pivot Table
Adjusting Fields
Consolidation Sheets
Managing Pivot Table
Section :2 Summarizing Data Using Pivot Table
Totals Display
Summary Display
Multiple Data Field
Data Grouping
Drill Down Data
Calculated Field
Section 3 : Data Filtering
Pivot Data Sorting
Customised Sorting
Limited Data Display
Rule Based Sorting
Data Slicer
Slicer Formatting
Filter Area
Removing Filter
Section 4 :Basics Pivot Table Formatting
Formatting Pivot Table
Layouts In Pivot Table
Section 5 : Advanced Pivot Table Formatting
Rule Based Conditional Formatting
Top Bottom Rule Based
Data Bars
Adding Color Scales
Icon Indicators
Section 6 : Introduction Of Pivot Chart
Basic Pivot Chart
Pivoting Pivot Chart
Filter Pivot Chart Data
Formatting Pivot Chart
Different Chart Types
Section 7 : How To Print The Pivot Table
Print Table Part 1
Print Table Part 2
Print Separate
Print Headers
Section 8 : Using Macros In Pivot Tables
First Macro
Executing The Macro
Section 9 : Introduction Of Power Pivot
Starting With Power Pivot
Linked Table
Creating Relationships Between Tables
Pivot Tablein Power Pivot
Get External Datain Power Pivot
Section 10 : Dax In Power Pivot
Introduction To Dax
Reference To Dax Functions
Adding Calculated Column
Adding Calculated Field
Type of Delivery - Self Paced Learning
Course Duration - 2 Hours
Course Duration - Lifetime Validity
Certification - Yes
How to use? (Steps to use Study Material)
Step 1 - eduCBA sends the redemption coupon along with the registration link.
Step 2 - Student will register with his register email id and coupon
Step 3 - Student receive the course access and password on his/her email id
Step 4 - Login using your email id and password and start learning
Promo Code SAVE25
Use promocode SAVE25 to get upto 25% discount on offer price Minimum Order value - Rs 50/-. Offer is valid for all Jagran Josh products.
Section 1: Basics Of Pivot Table
Data Formatting
Create Pivot Table
Adjusting Fields
Consolidation Sheets
Managing Pivot Table
Promo Code SAVE25
Use promocode SAVE25 to get upto 25% discount on offer price Minimum Order value - Rs 50/-. Offer is valid for all Jagran Josh products.
Section 1: Basics Of Pivot Table Data Formatting Create Pivot Table Adjusting Fields Consolidation Sheets Managing Pivot Table Section :2 Summarizing Data Using Pivot Table Totals Display Summary Display Multiple Data Field Data Grouping Drill Down Data Calculated Field Section 3 :&nb ... Read More
© 2023 Josh Shop. All Rights Reserved.