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