IconLogoc IconLogoc

Excel Pivot Tables Training

Excel Pivot Tables Training

Course Date Course Time Price Seats
Sep 27 2019 1:30pm - 2:30pm ET

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

Greatly appreciated AJ's delivery style and ability to keep participant interest and interaction going for a 3 hour class [Optimizing PowerPoint Design for eLearning & Presentations]! I'll be recommending we use IconLogic for some Train the Virtual Trainer courses. Very well done!
Michele Friesen