Section1:Basics of Pivot Table
Lecture1:Data Formatting
Lecture2:Creating Pivot Table
Lecture3:Recommended Data Table
Lecture4:Pivoting Pivot Table
Lecture5:External Data
Lecture6:Consolidation Sheets
Lecture7:Managing Pivot Table
Lecture8:Basics of Pivot Table Without Solution
Lecture9:Basics of Pivot Table With Solution
Section2:Summarizing Data Using Pivot Table
Lecture10:Totals Display
Lecture11:Summary Display
Lecture12:Multiple Data Field
Lecture13:Data Grouping
Lecture14:Drill Down Data
Lecture15:Calculated Field
Lecture16:Summarizing Data Using Pivot Table Without Solution
Lecture17:Summarizing Data Using Pivot Table With Solution
Section3:Data Filtering
Lecture18:Pivot Data Sorting
Lecture19:Customised Sorting
Lecture20:Limited Data Display
Lecture21:Rule Based Sorting
Lecture22:Data Slicer
Lecture23:Slicer Formatting
Lecture24:Filter Area
Lecture25:Removing Filters
Lecture26:Data Filtering Without Solution
Lecture27:Data Filtering With Solution
Section4:Basics Pivot Table Formatting
Lecture28:Formatting Pivot Table
Lecture29:Layouts In Pivot Table
Lecture30:Basics Pivot Table Formatting Without Solution
Lecture31:Basics Pivot Table Formatting With Solution
Section5:Advanced Pivot Table Formatting
Lecture32:Rule Based Conditional Formatting
Lecture33:Top Bottom Rule Based
Lecture34:Data Bars
Lecture35:Adding Color Scales
Lecture36:Icon Indicators
Lecture37:Conditional Formatting
Section6:Session 6-Introduction of Pivot Chart
Lecture38:Basic Pivot Chart
Lecture39:Pivoting Pivot Chart
Lecture40:Filter Pivot Chart Data
Lecture41:Formatting Pivot Chart
Lecture42:Different Chart Types
Lecture43:Pivot Chart without Solution
Lecture44:Pivot Chart with Solution
Section7:How to Print the Pivot Table
Lecture45:Print Table Part 1
Lecture46:Print Table Part 2
Lecture47:Print Separate
Lecture48:Print Headers
Lecture49:Printing Table With Headers
Lecture50:Print Table
Section8:Using Macros In Pivot Tables
Lecture51:First Macro
Lecture52:Executingthe Macro
Lecture53:Using Macros In Pivot Tables Without Solution
Lecture54:Using Macros In Pivot Tables With Solution
Section9:Introduction of Power Pivot
Lecture55:Starting With Power Pivot
Lecture56:Why Use Power Pivot
Lecture57:Adding Table To Power Pivot
Lecture58:Creating Relationships Between Tables
Lecture59:Pivot TableIn Power Pivot
Lecture60:Get External DataIn Power Pivot
Lecture61:Introduction of Power Pivot Without solution
Lecture62:Introduction of Power Pivot With solution
Section10:DAX in Power Pivot
Lecture63:Introduction To DAX
Lecture64:Reference To Dax Functions
Lecture65:Adding Calculated Column
Lecture66:Adding Calculated Field
Lecture67:Power Pivot Calculated Field Without Solution
Lecture68:Power Pivot Calculated Field With Solution
Lecture69:Power Pivot Calculated Column with solution
Section11:Introduction of Power View
Lecture70:Introduction To Power View
Lecture71:Displaying Data Using Different Controls Part 1
Lecture72:Displaying Data Using Different Controls Part 2
Lecture73:Formatting Of Controls
Lecture74:Filters In Power View
Lecture75:Data Display Using Charts In Power View
Lecture76:Data Display Using Maps
Lecture77:Introduction of Power View Without Solution
Lecture78:Introduction of Power View With Solution
Type of Delivery - Self Paced Learning
Course Duration - 3 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.
Section1:Basics of Pivot Table
Lecture1:Data Formatting
Lecture2:Creating Pivot Table
Lecture3:Recommended Data Table
Lecture4:Pivoting 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.
Section1:Basics of Pivot Table Lecture1:Data Formatting Lecture2:Creating Pivot Table Lecture3:Recommended Data Table Lecture4:Pivoting Pivot Table Lecture5:External Data Lecture6:Consolidation Sheets Lecture7:Managing Pivot Table Lecture8:Basics of Pivot Table Without Solution Lecture9:Ba ... Read More
© 2021 Josh Shop. All Rights Reserved.