Professional Course

Easily Master Microsoft® Excel® PivotTables®

Pryor Learning, Online
Price
99 USD
Next course start
9 July, 2024 (+8 start dates)
Delivery
Virtual Classroom
Price
99 USD
Next course start
9 July, 2024 (+8 start dates)
Delivery
Virtual Classroom

Course description

As one of Microsoft Excel’s most powerful and intimidating tools, a PivotTable takes large sets of complex data from a more extensive table and groups that information together in a simplified and meaningful way. Learn to easily create, use, manipulate and draw insights from PivotTables with this 3-hour interactive seminar for users of Microsoft Excel.

PivotTables summarize data to allow exploration of trends based on input information. The tool gets its name from the user’s ability to manipulate, or pivot, data in the table in order to view it from different perspectives to reveal useful information and glean relevant conclusions from bulk data more easily. Whether you’re tasked with submitting a large budget analysis, or developing insights from a colleague’s data set, gain the knowledge and the confidence needed to create, organize and use PivotTables confidently and independently.

Upcoming start dates

Choose between 8 start dates

9 July, 2024

  • Virtual Classroom
  • Online

9 July, 2024

  • Virtual Classroom
  • Online

17 July, 2024

  • Virtual Classroom
  • Online

17 July, 2024

  • Virtual Classroom
  • Online

23 July, 2024

  • Virtual Classroom
  • Online

23 July, 2024

  • Virtual Classroom
  • Online

1 August, 2024

  • Virtual Classroom
  • Online

1 August, 2024

  • Virtual Classroom
  • Online

Training content

  • Discover what PivotTables are, along with when and how to use them.
  • Recognize how PivotTables are integral to simplifying data analysis.
  • Understand common terminology and features, along with how best to prepare worksheet data.
  • Create PivotTables and PivotCharts® from scratch, as well as change data, perform calculations and design compelling reports.
  • Explore how to group Text, Numeric, Date and Time Values, along with Sort and Filter options.
  • Add Slicers and a Timelines and turn boring data into an easier to read visual.
  • Review new tools to analyze data.
  • How to create a compelling and easily understood knockout report.

Contact this provider

Contact course provider

Fill out your details to find out more about Easily Master Microsoft® Excel® PivotTables®.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Pryor Learning

Pryor Learning

Founded more than 50 years ago when Fred Pryor pioneered the "one-day seminar", Pryor Learning has become one of the nation's leading corporate training providers, offering in-person and online training to millions of individuals and organizations — from small and...

Read more and show all training delivered by this supplier

Ads