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

    Learning Style
  • Intermediate

    Difficulty
  • 1 Hour

    Course Duration
Pricing
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, PLUS:

  • 620+ high impact technical, end user and leadership courses
  • Peer to peer learning and access to expert mentors
  • Learner and Manager Analytics
  • Access to Cognitive Learning Research platform to troubleshoot project issues
7-Day FREE Trial
On Sale!
Now Only $14.99 Regular Price $24.99
Now Only $14.99 Regular Price $24.99
/ Month
Team
Pricing
  • Buy 5-9 Enrollments And Save 15% ($12.74 monthly.)
  • Buy 10-19 Enrollments And Save 25% ($11.24 monthly.)
  • Buy 20-above Enrollments And Save 40% ($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.

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:

More Information
Brand Microsoft
Lab Access No
Technology Microsoft
Learning Style Self-Paced Learning
Difficulty Intermediate
Course Duration 1 Hour
Language English
Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account
Sales Support

Sales (866) 991-3924

Mon-Fri. 8am-6pm CST

Have Questions? Ask Us.

Why QuickStart

Turn Training Into A Personalized Learning Experience


  • Problem Solving through ExpertConnect & Peer-To-Peer Learning
  • Find The Quickest Path To Learn With Career Paths
  • Access All Courses With Master Subscription
  • Manage Your Team With Learning Analytics
  • Virtual Classroom Training & Self-Paced Learning
  • Integrate With Your LMS Through API's