Excel 2013 - Pivot Table by eduCBA - Online Course

by Jagranjosh

Excel 2013 - Pivot Table by eduCBA - 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...View more

Specification

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

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

You May Also Be Interested In
  • Rs. 999
  • Rs. 299
  • (70% Off)

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.

Best Sellers

Excel 2013 - Pivot Table by eduCBA - Online Course
Excel 2013 - Pivot Table by eduCBA - Online Course

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.

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

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

This website uses cookie or similar technologies, to enhance your browsing experience and provide personalised recommendations. By continuing to use our website, you agree to our Privacy Policy and Cookie Policy.OK