Advertisements   
   

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

Advertisements   
   

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

What you’ll learn

  • Excel Pivot Table Basics
  • Filtering, Sorting, Grouping, and Pivoting
  • Using Slicers and Timelines
  • Working with Date fields
  • Building a Data Dashboard

Requirements

  • Familiarity with basic Excel and computer skills
  • No experience with Pivot Tables needed.

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

Advertisements   
   

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:

  • Beginner Excel users hoping to leverage the power of Pivot Tables

Learn Excel Pivot Tables in 2 Hours with Dr. John Miko, Free Tutorials Download

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

Go to Download Tutorials Page Go to HomePage Tutorials

Password : freetuts.download

Author: Ho Quang Dai

I am Ho Quang Dai, from Vietnam – A country that loves peace. I share completely free courses from major academic websites around the world. Hope to bring free knowledge to everyone who can’t afford to buy


Related Courses

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments

Report Link Die

Please provide the most detailed information, we will re-upload as soon as possible