Excel 2013: PivotTables
About Individual Course:
Now Only $10.00 Regular Price $49.00
Now Only $10.00 Regular Price $49.00/ Each
When you subscribe, you get:
Learn Subscription plan gives you access to this course and over 836 other popular courses
Now Only $39.99 Regular Price $44.99
Now Only $39.99 Regular Price $44.99/ Month
About this course:
First let’s have a quick flashback at excel. Shall we? MS Excel is a spreadsheet programme developed by Microsoft in 1985, with the sole purpose of helping businesses compile all their financial data, yearly credit, and yearly debit sheets. Fast forward to the future after 31 years, it is now the most commonly used program for creating graphs and pivot tables. So excited to learn MS Excel? Then you are at the right place! In this course, you'll develop a whole new appreciation for the information in your spreadsheets by analyzing data to gain insights into what it might mean. You'll also learn how to create PivotCharts, Sparklines, and other elements to better represent your data visually.
This online training for Excel 2013 Pivot Tables explores dynamic worksheets that can be reorganized by the user, with data generated from a database or a table. You will learn how to develop a whole new appreciation for the information in your spreadsheets and gain insights into what it might mean. You will also learn how to create Pivot Charts, Sparklines and other elements to better visually represent your data.
After completing this course, students will have a working understanding of:
- Understanding the benefits of a Pivot Table
- Understanding Pivot Table terminology
- Selecting appropriate data for a Pivot Table
- Using the new Quick Analysis tool
- Laying out a Pivot Table manually
- Using the new Recommended Pivot Table feature
- Using the classic Pivot Table layout in the grid
- Changing how empty cells are displayed
- Formatting a Pivot Table
- Sorting a Pivot Table
- Viewing data detail for an item
- Viewing detail for a data cell
- Excluding row or column items from the data summary
This course is intended for:
- Students looking to improve their Excel skills by using Pivot Tables.
- Students should have basic understanding of MS Excel.
Suggested prerequisites courses:
|Learning Style||Self-Paced Learning|
|Course Duration||1 Hour|
|VPA Discount||VPA Discount|