Excel Pivot Tables - A Comprehensive Guide

99.00 9.99
$99.00 $9.99
PRICE PER USER
$
X
USERS


=
SUBTOTAL
$
  • Course Delivery: On Demand
  • Duration: 10 
  • Audience: New, Beginner and Intermediate MS Excel users

Chat Live | Contact Us | Toll Free: (888) 360-8764

What this course has for you!

  • Join over 11,400 people who have enhanced their Excel skills by taking this course!
  • Your ideal first step about getting better at Excel.
  • Tiniest investment with a realistic expectation of results.
  • Stand out from your colleagues and improve your professional development to achieve greater opportunities
 

Description

This is the Ultimate Excel Pivot Table course which has 217 short and precise tutorials. It also expands in to Charts, Conditional Formatting, Macros and Excel Shortcut Tips!

No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single tool that is available in an Excel Pivot Table. The course is designed for Excel 2007, 2010, 2013 and 2016.

There are 14 different chapters so you can work on your weaknesses and enhance your strengths. Each chapter was designed to improve your Pivot Table skills with extra time saving Tips and real life business Case Studies.

In no time you will be able to analyze lots of data and tell a story in a quick and interactive way, learn how to build stunning Dashboards and get noticed by top management & prospective employers.

Audience:

New users, beginners and intermediates Excel users. Professionals working in the corporate/government sector or small business owners.

 

Topics Covered

This course will cover the following topics:

  • CUSTOMISE YOUR PIVOT TABLE
  • VALUE FIELD SETTINGS > SUMMARIZE VALUES BY
  • VALUE FIELD SETTINGS > SHOW VALUES AS
  • GROUPING
  • SORT
  • FILTER
  • SLICERS (NEW IN EXCEL 2010)
  • CALCULATED FIELDS & ITEMS
  • PIVOT CHARTS
  • CONDITIONAL FORMATTING PIVOT TABLES
  • GETPIVOTDATA formula
  • MACROS
  • DATA MANAGEMENT
  • BONUS VIDEOS
 

Prerequisites

This course was recorded using Excel 2010 but all the concepts taught are compatible with:

  • Excel for Windows: 2003*, 2007*, 2010, 2013, 2016
  • Excel for Mac: 2011*, 2016

* Slicers and some Pivot table calculations are not available in these versions

 

Subject Matter Expert

Hello, my name is John Michaloudis and I am the founder of www.MyExcelOnline.com

 

Additional Information

Access to the Excel workbook that is shown in the training video, so you can follow along and practice the new tricks learned.

Got questions? Contact us below or call 877-881-2235

Why Choose 360training.com?

  • Fast and easy courses completion
  • Get an education faster than at traditional colleges!
  • 100% online - No classroom attendance required.
  • Unlimited 24x7 online customer support
  • Over 500,000+ certified nationwide.