Learn Excel Pivot Tables in 2 Hours with Dr. John Miko

LeeAndro · Jun 18, 2022

Creating Excel Pivot Tables: It's not splitting the atom

What you'll learn

Excel Pivot Table Basics

Filtering, Sorting, Grouping, and Pivoting

Using Slicers and lines

Working with Date fields

Building a Data Dashboard

Requirements

Familiarity with basic Excel and computer skills

Description

Excel Pivot Tables are an incredibly powerful feature of Excel that allows users to glean insights and understanding quickly from massive data files. While Pivot Tables are often thought of as an advanced feature of Excel because of the "Wow Factor", they are really not that difficult at all when broken down into their features and functions as done in this course. In 19 lectures, in under 2 hours, this course steps student through the most useful and powerful aspects of Excel Pivot Tables.

Course Sections

Section 1: INTRODUCTION AND WELCOME TO THE COURSE

Section 2: EXCEL PIVOT TABLE BASICS and MAKING YOUR FIRST PIVOT TABLE

Section 3: OVERALL TABLE DESIGN

Section 4: FIELD SETTINGS AND DESCRIPTIVE MEASURES

Section 5: SORTING, FILTERING, AND REFRESHING

Section 6: GROUPING ITEMS, DATE FIELDS, AND CALCULATED FIELDS

Section 7: PIVOT CHARTS AND BUILDING A DASHBOARD

Who this course is for:

Bner Excel users hoping to leverage the power of Pivot Tables

DOWNLOAD
uploadgig

https://uploadgig.com/file/download/54daf64Ee47827fe/yeTDLHSj_.LearnExcel.part1.rar
https://uploadgig.com/file/download/5b4FAdb6a9690619/yeTDLHSj_.LearnExcel.part2.rar

rapidgator

https://rapidgator.net/file/0eb3275eec32690ece576e72f13bff2b/yeTDLHSj_.LearnExcel.part1.rar.html
https://rapidgator.net/file/217c43cf9f4c2b54eaafb7792fc74011/yeTDLHSj_.LearnExcel.part2.rar.html

nitroflare

http://nitroflare.com/view/F7A2463CEB616B9/yeTDLHSj_.LearnExcel.part1.rar
http://nitroflare.com/view/27DF7DF1B60F82B/yeTDLHSj_.LearnExcel.part2.rar

Learn Excel Pivot Tables in 2 Hours with Dr. John Miko

LeeAndro

Trusted Editor