Excel 2010 - Pivot Table by eduCBA - Online Course

by Jagranjosh

Excel 2010 - Pivot Table by eduCBA - Online Course

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 Su...View more

Specification

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

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

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 2010 - Pivot Table by eduCBA - Online Course
Excel 2010 - Pivot Table by eduCBA - Online Course

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.

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

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

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