Excel PivotTables - Analyze lists in a flash with PivotTables - NASBA CPE- 1.5

  • Speaker:Dennis Taylor
  • Duration:90Min
  • Product Code:GRC-90255

HRCI Credits: 1.5

hrci_logo

$279

refer

Refer Friend's


Live Session - How it works

  • Username and Password will be sent to you 24 hours prior to the webinar.
  • Presentation handouts in pdf format will be mailed to you.
  • Login to the session using the username and password provided to you.
  • Get answer to your queries through interactive Q&A sessions via chat.
  • Please let us know your thoughts and views at the end of webinar, your valuable feedback will help us improve.
  • Get certification of attendance.

Recorded Session - How it works

  • Login Information with Password to view the webinar, 24 hours after the Live webinar (link valid for 6 months).
  • A link will be provided to you upon purchase of the recorded session.
  • Please click on the link to access the session.
  • Presentation handouts in pdf format will be mailed to you.
  • Get certification of attendance.

Training CD - How it works

  • Free shipment within 72 Hours, from the date of webinar completion.

(More about our products contact +1- 248-233-2049)

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. You can access the recording of the webinar for 6 months. Contact our support for any clarifications. 

Description:

Although Excel has many tools, like sorting and filtering, to manage large lists of data, if you need to analyze all that data and do it fast, there’s no better feature than a PivotTable. You can quickly create a compact summary report (based on tons of data) without needing to write complex formulas or rely on lengthy command sequences.

A PivotTable is perhaps Excel’s best analytical tool and in addition to its speed, you get amazing flexibility that lets you quickly change the data interrelationships you’re viewing. A PivotTable is a visually-oriented feature based on displaying fields in different locations and you’ll be amazed to see how, in very little time, you can create a complete summary report based on tons of data and you won’t need to write complex formulas and rely on obscure techniques.

Key Learning Objectives of your Topic :
You will learn the best ways to create PivotTables and Pivot Charts, including these capabilities:
•    comparing  two or more fields in a variety of layout styles
•    sorting and filtering results
•    performing ad-hoc grouping of information
•    using Slicers instead of filters to identify which field elements are being displayed
•    drilling down to see the details behind the summary
•    categorizing date/time data in multiple levels
•    creating a Pivot Chart that is in sync with a PivotTable
•    adding calculated fields to perform additional analysis
•    hiding and revealing detail and summary information with a simple click
•    dealing with dynamic source data and the “refresh” concept
•    creating a PivotTable based on data from multiple worksheets

The Areas you will be touching during the Session:
•    Pre-requisites for source data – preparing data so that it can be analyzed by PivotTables
•    Creating PivotTables with just a few steps, including the a new Recommended PivotTables option introduced in Excel 2013
•    Manipulating the appearance of a PivotTable via dragging and command techniques
•    Using Slicers to accentuate fields currently being shown (and which ones are not)
•    Using the new (in Excel 2013) Timeline feature
•    Creating ad hoc and date-based groupings within a PivotTable
•    Exploring the best techniques for updating PivotTables

Who will benefit:

If you are familiar with many of Excel’s features, but have little or no experience with using PivotTables, you are a good candidate for this course. Also, those users familiar with PivotTables but new to Excel 2013 will also benefit from this session. Although widely used with financial data, you can create a PivotTable based on a variety of source data – the feature is potentially valuable to nearly all Excel users.

  • HR
  • Finance
  • Payroll
  • Accounting
  • Banking
  • Anyone who is interested in improving excel skills

Instructor Profile : 

Dennis Taylor has taught thousands of Excel seminars and classes since the early 90’s, is the author/presenter of over 600 Excel webinars, and authored or co-authored six books on spreadsheet software. He has taught hundreds of public Excel seminars in the US and Canada since 2006 and has recorded over 100 Excel courses both for online and DVD distribution.

Available Options

Recording: Access the training Recording for 6 months from any location

$279

CD: Shipped within 2 working days

$389

5 Member Group: 5 can Attend Live Meeting Online from any location globally

$1,829

10 Member group: 10 can Attend Live Meeting Online from any location globally

$3,429

Related Products

Excel Data Management Features Manage Data with Sorting, Filtering and other tools

Excel Data Management Features Manage Data with Sorting, Filtering and other tools

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com.NASBAGroup Internet Based | 1.5 (1CPE for 50 minutes) | Specialized Knowledge (1.5 CPE) | Intermediate | Prerequisites - Comfortable working with Excel; some knowledge of sort and filter is helpful, but not re..

$269

Excel Tips, Tricks, and Shortcuts Work more efficiently - NASBA CPE - 1.5

Excel Tips, Tricks, and Shortcuts Work more efficiently - NASBA CPE - 1.5

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com. NASBA: Group Internet Based | 1.5 (1 CPE for 50 minutes) | Specialized Knowledge - (1.5 CPE) | Basic to Intermediate| Prerequisites: Must have basic Excel Knowledge| Advanced Preparation: Must have basic Excel Knowledge.Descrip..

$279

How to Analyze Financial Statements - HRCI - 1.5 & NASBA - 1.5 CPE

How to Analyze Financial Statements - HRCI - 1.5 & NASBA - 1.5 CPE

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. You can access the recording of the webinar for 6 months. Contact our support for any clarifications.NASBA CPE: 1.5Delivery Method: Group Internet Based, Field of Study: Finance and Accounting, Level: Basic, Intermediate, Prerequisites: None, Advanced Preparations - None.Background:How did your business unit perform last year?  What’s the trend over the last three to five years?  How..

$269

Business Email Etiquette: Learn to Process, Route, and Respond in a Timely Manner - NASBA 1.5 CPE

Business Email Etiquette: Learn to Process, Route, and Respond in a Timely Manner - NASBA 1.5 CPE

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. You can access the recording of the webinar for 6 months. Contact our support for any clarifications.NASBA CPE - 1.5Group Internet Based | 1.5 (1 CPE for 50 minutes) | Specialized Knowledge - (1.5 CPE) | Basic to Intermediate| Prerequisites: Must have basic Knowledge| Advanced Preparation: Must have basic Knowledge.Topic Description: Don’t let email be the bane of your daily work existence. Optim..

$269

Dealing With Difficult People: The 5 Most Difficult Types of People And How To Effectively Approach Them - HRCI 1.5

Dealing With Difficult People: The 5 Most Difficult Types of People And How To Effectively Approach Them - HRCI 1.5

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com. HRCI CPE - 1.5HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recer..

$269

Outlook on Steroids: Tips and Techniques for the Advanced User - NABSA HR CPE - 1.5

Outlook on Steroids: Tips and Techniques for the Advanced User - NABSA HR CPE - 1.5

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com. NASBA CPE - 1.5 | Field - HRDescription:Outlook is a powerful productivity tool and can be treated as a programming tool. The savvy users of Outlook can program its features to be more productive – taking into account their job desc..

$179

Effective Manager's Communication Skills: Active Listening, Constructive Feedback, Conflict Resolution and Coaching Work For You and Your Team

Effective Manager's Communication Skills: Active Listening, Constructive Feedback, Conflict Resolution and Coaching Work For You and Your Team

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com. HRCI CPE - 1.5HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recer..

$269