The Complete Excel 2013 Pivot Table course will take a student who knows nothing about Excel Pivot Tables to a competent and confident power user in no time.
We will be discussing topics such as
I will be right there with you throughout the entirety of the course. If you need anything, be sure to post in the course forum for your classmates and me to address any questions!
Let's get started by setting up your Quick Access Toolbar, and downloading the Data Workbook!
In this lecture we'll discuss the basic building blocks of the Pivot Table: Fields, Attributes, and Values. Gaining a firm grasp on these concepts now will pay dividends later, as you build and maintain your own Pivot Tables in analysis, reporting, or dashboards.
Here we will take a moment to broadly explain the Pivot Table, answering the following questions:
Finally! Let's explore the options we have available to create your very first Pivot Table. Also, this first table is what we will be working with the rest of the course!
There are a lot of Pivot Table-specific options available to us in Excel, so let's take a few minutes to ground ourselves in these new features, and begin working with the field list, including Filters, Columns, Rows, and Values.
Let's pause from the course lectures and make sure you have a firm understanding of Attributes and Values before we continue. Remember, this foundational knowledge will make your life much easier later on.
Creating custom groups and nesting attributes are just a couple of the many perks of using a Pivot Table. In this lecture, we will discuss exactly just how to do this.
Easily create a beautiful Pivot Table of your own after just 2 short minutes of instruction.
The Layout Group allows for incredible flexibility in your Pivot Table. Let's explore some of what we can do here.
Sum? Average? Count? Min? Max? The Pivot Table can display your data in many ways, and Field Settings serves as the control panel for your values.
Dynamically sort and filter any amount of data you'd like. And don't worry, when you update your Pivot Table, your sorting and filtering rules will still apply!
My favorite part about Pivot Tables, the Slicer allows for very flexible and very aesthetically pleasing multi-layered quick filtering.
The not too distant cousin of the Slicer, the Timeline creates a very dynamic way to filter dates in a Pivot Table.
One of the most useful aspects of the Pivot Table, here I will show you how to refresh data or add/delete data from the data source, all without losing your current Pivot Table's layout!
Everyone knows it's a mathematical faux-pas to average averages, so let the Pivot Table dynamically calculate functions for you, and style them any way you'd like!
Want to see absolute sales AND share of sales. Piece of cake when you use the Show Values As... functionality.
Never apply a conditional formatting rule more than once. The Pivot Table will take one rule, and intelligently apply it wherever you want, no matter how much data or what the layout is.
A brief introduction to creating and styling Pivot Charts to Pivot Tables: the gateway to beautiful, fully dynamic data dashboards.
I am a Microsoft Excel guru and I have a passion for teaching. I've been using my advanced technical skills for years in multiple facets of my life, and it is my pleasure to serve others through sharing this knowledge via the terrific platform Udemy has created. No matter what your goals are, my mission is to aid every student I teach in reaching their full potential.
I am currently teaching The Complete Excel 2013 Pivot Table course in order to aid you in improving your analytical and reporting prowess, especially if it will benefit your career. My goal for this course is to ensure every student can unleash the power of the Pivot Table to efficiently create stunning reports and dashboards to impress clients, supervisors, etc. I sincerely hope you find the course beneficial.