IconLogoc IconLogoc

Excel Pivot Tables Training

Excel Pivot Tables Training

Course Date Course Time Price Seats
May 14 2019 11:30am - 12:30pm ET
$49.00

Excel Pivot Tables Training

PivotTables have become one of the most important features of Excel! They manage to take a long list of raw data and summarize it in an easy-to-read report format where you can easily compare patterns or trends in your data. Learn the basics of PivotTables in this 1-hour class!

Who should attend this class?

Intermediate users of any version of Excel. Knowledge of how to navigate Excel, basic text editing and formatting skills, and a knowledge of formulas and functions are necessary.

Where is this class held?

This is a live, online class led by a field expert; and just like an in-person class, it is fully interactive and engaging. The difference between an online and onsite class? No travel! You can participate from anywhere in the world with an Internet connection. Many of our students choose to stay home from work on these training days, some never even changing out of their slippers! Where applicable, students are able to speak with and hear from the instructor and other participants throughout the course as they work in real-time to complete activities.

Need something a little more personal?

We understand your team might have specific training needs and we would love to work with you. We offer both online and on-site instructor-led, fully customizable courses tailored to your training needs.

Email us so we can discuss your needs and set up your custom training »

Anyone who wants to learn more about the formatting of a website. All you need is a basic text editor such as Notepad (PC) or TextEdit (Mac) and a browser. Knowledge of basic HTML codes is mandatory.

Topics covered include, but not limited to:

  • Create, modify, and format basic PivotTables

PivotTables are called PivotTables because you can pivot your data very quickly and easily to display the data in many different ways. Sorting, filtering, formatting, and the different styles of PivotTables are discussed. We will also cover how to refresh the data in your PivotTables.

  • Slicers

You will learn the difference between report filters and slicers. Slicers offer an interactive control that allows you to quickly and powerfully filter your data!

  • Dates

Learn how to group dates to display the time periods you want.

  • Drill down

Learn just how powerful PivotTables can be when you drill down into the details and specific records of certain data!


About Your Instructor

Rosemary McCracken is a computer trainer with over 25 years of experience in the classroom. She teaches all levels of Microsoft Word, Excel, PowerPoint, Access, Visio, and Outlook. In addition to Microsoft products, she also teaches QuickBooks, InDesign, HTML/CSS, and WordPress. Rosemary has a B.S. from James Madison University. She is Microsoft Office Expert Certified and is also a Certified Online Training Professional.

Be the first to review this course.

Write Your Own Review

Only registered users can write reviews. Please, log in or register

Anita was professional, clear, concise and very engaging (Adobe Captivate: States and Motion Paths in Captivate 9)
David Burnham