We use cookies on our website to improve our service to you, by continuing you agree to our use of cookies. However you are able to update your settings at any time.

Continue Cookie Settings

Cookie Policy

A cookie, also known as an HTTP cookie, web cookie, or browser cookie, is a piece of data stored by a website within a browser, and then subsequently sent back to the same website by the browser. Cookies were designed to be a reliable mechanism for websites to remember things that a browser had done there in the past, which can include having clicked particular buttons, logging in, or having read pages on that site months or years ago.

Strictly Necessary Cookies

These cookies cannot be disabled

These cookies are necessary for the website to function and cannot be switched off. They are normally set in response to your interactions on the website e.g. logging in etc.

Cookies:
  • .ASPXANONYMOUS
  • .DOTNETNUKE
  • __RequestVerificationToken
  • authentication
  • CV_Portal
  • CV_Store_Portal_Cart_0
  • CV_USER
  • dnn_IsMobile
  • language
  • LastPageId
  • NADevGDPRCookieConsent_portal_0
  • userBrowsingCookie

Performance Cookies

These cookies allow us to monitor traffic to our website so we can improve the performance and content of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited or how you navigated around our website.

Cookies:
  • _ga
  • _gat
  • _gid

Functional Cookies

These cookies enable the website to provide enhanced functionality and content. They may be set by the website or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.

Cookies:

Currently we are not utilizing these types of cookies on our site.

Targeting Cookies

These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.

Cookies:

Currently we are not utilizing these types of cookies on our site.

  • 0
    Cart Summary
    {{item.Name}}
    		{{item.LineTotalFormatted}}
    {{cart.FormattedSubTotal}}
    View my Cart Checkout
    You do not currently have any items in your cart.
/Portals/0/NADevEventsImages/excel-256_80.png

Excel Guru II: Intro to Pivot Tables

Date & Time:

Course Length: 2 hours

Average Rating: (4 reviews)

Course Tuition: $197.00 USD

Book Now

Are Pivot Tables a mystery for you? Are you self-taught, and would like to learn how to use Pivot Tables properly? In this foundational course, you'll get the skills you need to create, edit, and develop Pivot Tables in Excel. Topics will include how to setup your data correctly, how to create and edit Pivot Tables, how to Pivot your data, and also how to create exciting interactive Pivot Charts. You'll learn how to group and sort data in powerful ways, how to use and create calculations, as well as many other topics that will help you be successful with Pivot Tables. Take this course today to master the beast: Pivot Tables!

  • Introduction to Pivot Tables
  • How to set up your data correctly for Pivot Tables
  • Create and Edit Pivot Tables
  • Common Pitfalls and How to Avoid them
  • Pivot your data!
  • Create interactive Pivot Charts
  • Group and Sort Data
  • Generate Sums, Averages, and Counts
  • Use Slicers
  • Discover the Drill Down feature!
  • Use bulit-in Calculations to display data in new ways
  • Create your own calculations
  • Much more!

When you take a course from us, you are getting a ton of cool and helpful resources to make your learning as easy and complete as possible!

You'll get:

  • A world-class, live online course delivered by a top instructor with years of experience
  • Hands-on exercises - you will not just be watching, but provided you have the software on your computer, you will also be doing the exercises too!
  • A downloadable training manual, customized just for the course you are taking - free!
  • An optional recording of your session for downloading within 24 hours of your session. You can play it back as many times as you wish!
  • Free repeat privileges for the course, FOREVER! Just contact us when you'd like to retake, and we'll set you up!
  • 100% money-back guarantee, for an entire YEAR!
  • Our commitment to you, that your experience will be the best you've ever had in a training session. Our instructors are caring, knowledgeable, funny, and they like people. You'll have fun too!

Why should I pay for something I get free on YouTube or other video training sites?

Excellent question.

For one thing, you can't get what we offer free on YouTube or even on video training websites.

Our training is much more than "just a webinar". See why our training solution offers you the best of all possible worlds - from our 1-year 100% money back guarantee, to our FREE REPEAT policy - you will be pleased with your results with us!

Click here to read all the benefits of training with us.

Bart Jameson

Great introduction to Pivot Tables! Who knew all the power available! Will def be taking the dashboard class. Keep up the great work

Bill Jones

This is one of the best classes I've taken in a long time. I was nervous that it was an online course, because I've taken webinars before that were not engaging. I can honestly say they made it thoroughly enjoyable, and I was able to follow along just fine with the instructor. If you're one the fence about taking a class from these folks because they are mostly webinars - don't be. The instructors are live (not just a pre-recorded video), they answer questions, and you actually get to do the exercises during the class too. Plus my teacher was funny. Win-win!

Mindy Kaja

Very well executed course. I learned a lot, and felt it was worth the money. Knocking off one star because I like to do classes in-person. But this was as close to a live in-person class as you could get, and I liked not having to drive somewhere and could learn at home. I would take another class from PC Training Experts!

Susan Gilmore

Super course! I learned so much about Pivot Tables, to help me analyze my large datasets. This is going to help me so much in my job! Highly recommended!

Add a Review

Book Now Save To Calendar Save To PDF Add To My Wish List