What you'll learn:
What PivotTables are and what you can do with them
How to create a new PivotTable
Rearrange the structure of a PivotTable
Update your data and change the data source
Group and subtotal data
"Drill down" into the data behind totals and subtotals
Sort and filter, including inserting Slicers
Format PivotTables
Use layouts and styles
Analyze data with Pivot Charts
Create calculated fields
Access and change Pivot Table Options
Requirements
Basic knowledge of Excel
Be able to create simple formulas
Be able to create standard charts
Description
In a world full of data, one of the most common problems is, not how to get the data, but how to make sense of it, how to see the big picture , how to understand what's really going on.
Often, individuals are handed an enormous amount of data and told "we need this compiled into a report by next week "and end up spending hours and hours manually calculating totals and subtotals and averages, then cutting and pasting and formatting everything to create a formatted and acceptable report.
Using Pivot Tables eliminates that frustration and lets you deliver a first rate report in a fraction of the time.
In this course you will learn to:
Create a new Pivot Table
Rearrange the structure of a Pivot Table
Update your data and change the data source
Group and subtotal data
Drill down into the data behind totals and subtotals
Sort and filter including inserting slicers
Format Pivot Tables
Use layouts and styles
Analyze data with pivot charts
Create calculated fields
Use Pivot Table options
Each section includes a hands-on assignment that allows you to put your new knowledge to use in a realistic way.
What do you need to know going in?
You should have a working knowledge of Microsoft Excel, and be comfortable with common, basic skills, including:
Selecting and formatting cells
Creating simple formulas
Navigating an Excel workbook
Who should take this course?
This course is designed for individuals who are brand new to Pivot Tables, but need to begin using Pivot Tables as soon as possible. Whether you need to deliver a report to your manager, take on a new role, or obtain the necessary skills to get a job, this course can help!
Who this course is for
Office workers who need to start using Pivot Tables
Experienced users who need to refresh their knowledge
Job seekers who want to improve their skills
Homepage
https://www.udemy.com/course/analyzing-data-with-pivottables/

Related Downloads :

{related-news}