Microsoft Excel 2016: Data Analysis with PivotTables
4.5 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
177 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2016: Data Analysis with PivotTables to your Wishlist.

Add to Wishlist

Microsoft Excel 2016: Data Analysis with PivotTables

Enable data-driven business decisions that have a better chance for success for everyone involved!
4.5 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
177 students enrolled
Last updated 10/2016
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Upon successful completion of this course, you will be able to use Excel 2016 advanced PivotTable functionality to analyze your raw data.
  • Analyze data by using PivotTables.
  • Work with PivotCharts.
View Curriculum
Requirements
  • To ensure your success in this course, you should have experience working with Excel 2016 and PivotTables.
  • You should already understand spreadsheet concepts and be comfortable creating basic PivotTables.
Description

The need to analyze data and gain actionable insight is greater than ever - turn your data into Business intelligence.

You already have experience working with Excel and creating basic PivotTables to summarize data. But Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. 

This leads to data-driven business decisions that have a better chance for success for everyone involved! 

Learn techniques and tools for the acquisition and transformation of raw data into meaningful and useful information for business analysis purposes!

Who is the target audience?
  • Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
21 Lectures
01:17:12
+
Introduction
1 Lecture 01:20

After you take this course, you will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved! Lets take a look at the list of topics for this course!


Preview 01:20
+
Preparing Data and Creating Pivot Tables
6 Lectures 31:47

In order to create a PivotTable that will effectively answer your questions, you need to ensure your data is in a format that will yield the desired results. 

Preview 00:37

In order to create a PivotTable that will effectively answer your questions, you need to ensure your data is in a format that will yield the desired results. Taking time to prepare your data before you create a PivotTable will help ensure you can drill down into your raw data and provide actionable intelligence for company leaders. By properly preparing your data for PivotTable analysis, you'll save yourself time and effort when it comes to actually analyzing that data. (Local Data Sources, Transactional Data, The need for Clean Data, Gap and Blank Cell Considerations) 

Preview 05:35

You can quickly create a basic PivotTable from a table or range within a workbook as the source data for your report. 

Preview 06:41

A PivotTable is a dynamic Excel data object that enables you to perform data analysis by reorganizing and summarizing data. (What are Pivot Tables, The Create PivotTable Dialog Box, The PivotTable Fields Task Pane, The PivotTable Tools Contextual Tab) 

Create a PivotTable from a Local Data Source
05:37

A PivotTable is a dynamic Excel data object that enables you to perform data analysis by reorganizing and summarizing data. (What are Pivot Tables, The Create PivotTable Dialog Box, The PivotTable Fields Task Pane, The PivotTable Tools Contextual Tab) 

Create a PivotTable from Multiple Local Data Sources
06:36

You won't always have source data in Excel ready to create a PivotTable. Many times, your source data is stored outside of Excel. Fortunately, Excel provides a way to create PivotTables from data sources outside of Excel. (Limitations of Excel as a Database, External Data Sources, The Select Data Source Window, The Import Data Dialog Box)

Create a PivotTable from an External Data Sources
06:41
+
Analyzing Data by Using PivotTables
9 Lectures 29:08

If you're looking for more than a sum or a count of the items in your fields or want to total only certain data in your PivotTable, you can customize how your data is presented and calculated using Value Field Settings.

Summarize PivotTable Data - Introduction
00:39

When you create a PivotTable, Excel automatically totals the data by either summarizing or counting the items, using the SUM or COUNT function, respectively. In addition to these default functions, Excel provides other summary options through two tabs in the Value Field Settings dialog box. (The Value Field Settings Dialog Box, The Show Values As Tab, The Insert Calculated Field Dialog Box) 

Summarize Pivottable Data
07:17

Excel makes it easy to adjust the display of PivotTable data to meet your business analysis needs. In this topic, you will summarize PivotTable data in various ways. 

Organize PivotTable Data - Introduction
00:38

For a PivotTable to be truly useful, you need to be able to read it and make sense of it quickly, so that you can make meaningful decisions from the data, sometimes it means simply to sort the data. (Sorting, The Expand and Collapse Feature, The Group and Ungroup Feature)

Organize PivotTable Data
04:08

Filtering PivotTable data comes in handy when you are analyzing a subset of your data and want to ignore all data that is not relevant to your current analysis. (The FILTERS Area, Slicers, The Insert Slicers Dialog Box, The Slicer Tools Contextual Tab, Timelines, The Timeline Tools Contextual Tab)

Filter Pivottable Data
06:52

Often, a well-constructed PivotTable can draw attention to issues and help springboard solutions. In this topic, you will format a PivotTable. 

Format a PivotTable - Introduction
00:28

After you've manipulated your PivotTable data, you're ready to present it in the best way. When you format a PivotTable, it's important to align the design efficiently to meet the business needs in question. Often, a well- constructed PivotTable can draw attention to issues and help springboard solutions. (Subtotals and Grand Totals, Styles)

Format a PivotTable
02:35

In this topic, you will refresh and change your PivotTable data, a necessary step if what if your source data changes. 

Refresh and Change PivotTable Data - Introduction
00:22

By default, a PivotTable will not automatically update itself when the source data changes. Learn how to manually update the data in a PivotTable. (The Refresh Menu, The Change PivotTable Data Source Dialog Box, The Connection Properties Dialog Box)

Refresh and Change PivotTable Data
06:09
+
Working with PivotCharts
5 Lectures 14:57

Examining data visually helps you to easily see the story in the data. In this topic, you will create a PivotChart. 

Create a PivotChart - Introduction
00:41

A PivotChart is an interactive, graphical representation of numeric values and relationships among those values. Master examining data visually that helps you to easily see the story in the data. (PivotCharts, The Insert Chart Dialog Box, Chart Types) 

Create a PivotChart
03:53

Instead of working with the PivotTable all the time to alter your PivotChart, you could just work directly in the PivotChart. (The PivotChart Fields Task Pane, The PivotChart Tools Contextual Tab) 

Manipulate PivotChart Data
04:11

With PivotCharts, you are summarizing your data visually, so it's important to use layouts and colors that represent your data in ways that make it easy for users to interpret what the charts are portraying. (The PivotChart Tools Design and Format Tabs, Chart Formatting Buttons, The Format Task Pane) 

Format a PivotChart
04:58

Whats the next step in becoming a real master of Microsoft Excel? (Microsoft® Office Excel® 2016: Data Analysis with PowerPivot) 

Course Follow-Up
01:14

PivotTables and PivotCharts - Quiz
11 questions
About the Instructor
SONIC - High Quality Training for Over 20 Years
4.4 Average rating
358 Reviews
6,232 Students
51 Courses
Training Company

SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review.