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