PDP Url

Excel 2013: PivotTables

This online training series explores Excel PivotTables. Weヒᄄᆱll take a look at these dynamic worksheets, which can be reorganized by the user with data generated from a database or a table.

Self-Paced

Learning Style

Intermediate

Difficulty

1 Hour

Course Duration

Course Info

Download PDF

Certificate

See Sample

About Individual Course:
  • Individual course plan gives you access to this course
New
On Sale!
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 841 other popular courses
On Sale!
Now Only $39.99 Regular Price $44.99
Now Only $39.99 Regular Price $44.99
/ Month
Team
Pricing
  • Buy 5-9 Enrollments And Save 68% ($12.74 monthly.)
  • Buy 10-19 Enrollments And Save 72% ($11.24 monthly.)
  • Buy 20-above Enrollments And Save 78% ($8.99 monthly.)
This online training series explores Excel PivotTables. Weヒᄄᆱll take a look at these dynamic worksheets, which can be reorganized by the user with data generated from a database or a table.

Course Information

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.

Course Objective:

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

Audience: 

This course is intended for:

  • Students looking to improve their Excel skills by using Pivot Tables.

Prerequisites:

  • Students should have basic understanding of MS Excel.

Suggested prerequisites courses:

Outline

More Information

More Information
Brand Microsoft
Subjects Business Productivity
Lab Access No
Technology Microsoft
Learning Style Self-Paced Learning
Difficulty Intermediate
Course Duration 1 Hour
Language English
VPA Discount VPA Discount

Reviews

Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account

Contact A Learning Consultant


click here