• Category: Business Productivity Tools
• Product Type: Online Course

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 sics 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 ... Read More