For full functionality of this site it is necessary to enable JavaScript. Here are the instructions how to enable JavaScript in your web browser.

Excel: Pivot Tables Crash Course

Andy is a computer "nerd" and has been training individuals and groups since 1995. She has taught computer VoTech classes at both Boise State Univ. and the College of Western Idaho and is the owner of a computer consulting business. She is a Certified Microsoft Office Specialist and trains most Microsoft programs. With 20+ years' experience in the computer industry, Andy focuses every class on using software to solve common workflow issues. Be prepared to learn more than you bargained for in her class. Andy always teaches the 5 Super Secrets to computers and believes firmly in efficiency train........

Read More

This Webinar qualifies for a recertification credit hour that may be counted toward SHRM-CP and SHRM-SCP recertification from SHRM.
This Lecture contains 1 Credit


Excel Pivot Tables Pivots were designed to summarize big data as an alternative to complicated formulas. But Pivots can be a little confusing unless you learn a couple handy tips that will bolster your confidence when summarizing data. Attend this webinar for a crash course in Pivot Tables and you'll be amazed how often you use Pivots afterwards.

Why should you attend?

If you are tasked with summarizing data for reports, and are frustrated with the process, attend this class! You will save time and your sanity when you understand the power of the Pivot Table!

Areas Covered in the Session:

  • How to begin a Pivot Table
  • Work with the Pivot task pane
  • Work with fields, adding, moving, deleting
  • Summarize the data into totals, averages, or percentages
  • Customize the view of the Pivot table
  • Add a Slicer to filter the results
  • Add a Chart to visualize the results
  • Learn the tips and tricks to make sure your Pivots keep their layouts

Who can Benefit:

Anyone that is tasked with handling data: organizing, calculating, compiling in any matter. This covers a full range of careers.
  • Accountants
  • Accounts
  • Audit
  • Aviation
  • Banking
  • CFOs
  • Controllers
  • CPAs
  • Education
  • Energy
  • FDA
  • Finance
  • Financial consultants
  • Human Resource
  • Insurance
  • Investments
  • IT
  • Logistics & Supply Chain
  • Marketing
  • Medical Devices
  • Pharmaceutical
  • Retail
  • Sales
  • Telecom
Webinar Id: DBISP83

Duration: 60 mins

No reviews yet!!


Refund Policy

Webinars of Andy Lanning
Excel: Pivot Tables Crash Course
Presenter: Andy Lanning

View Anytime
Price: $167
Status: Archived

Excel - Creating High Impact Business Repor...
Presenter: Andy Lanning

View Anytime
Price: $231
Status: Archived

Webinars of Soft Skills
Leadership Development for Executive Assist...
Presenter: Rebecca Staton-Reinstein

View Anytime
Price: $301
Status: Archived

Zap! You're a manager: getting off on the r...
Presenter: Rebecca Staton-Reinstein

View Anytime
Price: $167
Status: Archived