Introduction to Advanced Pivot Tables | Hankab

Course Content

Introduction and overview

0/1

Introduction to Advanced Pivot Tables

Prepare Data

0/2

Format Data as table

More About Excel Tables

Inserting Pivot Table

0/2

Inserting Pivot Table

Recomended Pivot Table

Understanding Pivot Table Interface

0/3

Pivot Table Report

Reorganize Pivot Table Fields

Understand How to use Pivot Table Field Area

Building a Pivot Table Report

0/13

Add Data to your pivot table

Format Numbers as Currency

Show top 5 or bottom 5 items of your data

Sort Data in Ascending or Descending Order

Move Rows of data by drag and drop within Pivot Table

Auto Fit Column Width on Update

Expanding or Collapsing Fields for better viewing details

Adjusting fields and filling Empty Cells

Showing Sales by continent

Adding Calculated Field

Move Pivot Table Report to anywhere within the page

Generate Multiple Pivot Report from one pivot table on one click

Formatting Pivot Table Report

0/2

Adding Styles and Custom Styles

Add Data Bars to Your Pivot Table

Reviewing Completed Pivot Table Report like A boss

0/1

How Your Boss review Your Pivot Table Report Details

Using Slicers with Pivot Tables

0/9

Introduction to slicers

Using Slicers on Excel Tables

Introduction to Using Slicers with Pivot Tables

Inserting Slicers in pivot Table

Move Slicer and select items

Inserting Multiple slicers at once

Increase Columns of Slicers

One Slicer for multiple Pivots (Report Connection)

Formmating Slicers

Excel for accounting and Finance

0% Complete