Master Excel Pivot Tables – Excel 365 and Excel 2019

سرفصل های دوره

Master Microsoft Excel Pivot Tables in an afternoon! Excel 365, Excel 2019, and Excel 2016 Pivot Tables.

01 - Course Overview and Files

001 Introduction

002 Course Files

002 JonCo-Sales.xlsx

002 Pivot-Tables-Examples.xlsx

02 - Pivot Table Basics

001 Creating a pivot table

002 Formatting Data

003 Summing values

004 Changing Items

03 - Value Field Settings - Summarize Values By

001 Overview and Summarize by Count

002 Nested Fields

003 Nested Fields and Drill Down

004 Summarize by Average

005 Summarize by Min and Max

006 Other Ways to Summarize

04 - Selecting, Moving, and Clearing Pivot Tables

001 Selecting, Moving, and Clearing

05 - Pivot Table Design

001 Design Overview

002 Subtotals and Grand Totals

003 Report Layout and Blank Rows

06 - Value Field Settings - Show Values As

001 Overview

002 % of Another Number

003 % of

004 % of Parent Total

005 Difference From and Rank Order

006 Running Totals

007 Index

008 Practice - % of Another Number - Problem 1

009 Practice - % of Another Number - Problem 2

010 Practice - % of Another Number - Problem 3

011 Practice - % of Another Number - Problem 4

012 Practice - Difference From

013 Practice - Misc 1

014 Practice - Misc 2

07 - Filtering

001 Filtering Basics

002 Multiple Filters

003 Slicers

004 Slicer Options

005 Timeline

006 Timeline Options

007 Report Filter Pages

08 - Grouping

001 Manual Grouping

002 Automatic Grouping

003 Automatic Grouping with Ranges

09 - Calculated Fields & Items

001 Calculated Fields

002 Calculated Items

10 - Other Pivot Table Concepts

001 Referencing Pivot Table Cells

002 Sparklines

003 Pivot Charts

004 Refreshing Pivot Table Data

11 - Homework Practice Problems

001 Master-Pivot-Tables-Course-Homework-Practice-Problems.xlsx

001 Overview and File

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy