Excel Deep Dive Pivot Tables Workshop
What you’ll learn
Master Excel Pivot Tables
Learn to Harness these skills to get a raise
Solve World Hunger
Requirements
A smile and a computer with Excel ’07 or ’10
Description
Master Excel Pivot Tables and save the world!
This course discusses one of the most powerful tools of the Office Ninja’s arsenal, Excel Pivot Tables and how to use pivot tables. It’s potential for analyzing and summarizing data is legnendary, but few have mastered its intricacies. Through a series of easy to follow lessons on how to use pivot table in excel, you will be introduced to the concepts, techniques and powerful features of this mysterious excel tool, and can follow along with each step with the included sample file.
We will cover:
● Pivot Table Concepts
● Creating A Pivot Table
● Modifying Pivot Table Elements
● Filtering Extraneous Data (the Slicer tool)
● Creating Multiple Pivot Tables
● Creating Pivot Charts
● Advanced Analysis Techniques
Learn how to use pivot table in excel today.
Overview
Section 1: section 1
Lecture 1 Welcome to Office Ninja Training
Section 2: Introduction
Lecture 2 EXERCISE FILES
Section 3: White Belt Training
Lecture 3 Subtotals
Lecture 4 Exercise: Subtotals
Lecture 5 Answer: Subtotals
Lecture 6 Pivot Table Concept
Lecture 7 Creating Your First Pivot Table
Lecture 8 Exercise: Create a Pivot Table
Lecture 9 Answer: Create a Pivot Table
Lecture 10 Changing The Values Field Settings
Lecture 11 Exercise: Changing the Values Field Settings
Lecture 12 Answer: Changing Value Field Settings
Lecture 13 Drill To Feature
Lecture 14 Answer: Drill-To Feature
Lecture 15 Formatting And Pivot Table Design
Lecture 16 Exercise: Formatting and Pivot Table Design
Lecture 17 Answer: Formatting and Pivot Table Design
Section 4: Black Belt Training
Lecture 18 Adding And Manipulating Multiple Fields
Lecture 19 Exercise: Adding and Manipulating Multiple Fields
Lecture 20 Answer: Adding and Manipulating Multiple Fields
Lecture 21 Filtering And Slicing Pivot Data
Lecture 22 Exercise: Filtering and Slicing Pivot Data
Lecture 23 Answer: Filtering & Slicing Pivot Data
Lecture 24 Creating Pivot Table Dashboards
Lecture 25 Exercise: Creating Pivot Dashboards
Lecture 26 Answer: Creating Pivot Dashboards
Lecture 27 Pivot Charts
Lecture 28 Exercise: Pivot Charts
Lecture 29 Answer: Pivot Charts
Lecture 30 Putting It All Together
Lecture 31 Answer: Putting It All Together
Anyone who has a lot of data in Excel
Course Information:
Udemy | English | 1h 42m | 1.28 GB
Created by: Alex Mozes
You Can See More Courses in the Office Productivity >> Greetings from CourseDown.com