Analyze Data using MS Excel Pivot Tables

OVERVIEW

Pivot Tables can help you sort and sift through large data sets to focus quickly on just the data elements that matter most to your specific needs.

In just one fast-paced and informative training session, you'll learn how to use PivotTables to sort your data more efficiently, create multiple customized reports in a few easy steps and gain a powerful new tool to help you make better business decisions.

In addition, you'll get tips on the easiest way to group your data.
Most importantly, when you use the power of PivotTables, you'll be saving time and making your job easier.

WHY SHOULD YOU ATTEND?

Attend the webinar to get an in-depth knowledge of PivotTables, including how the tool helps in making customized reports and how it helps in making better business decisions.

LEARNING OBJECTIVES

Create PivotTables and modify their structure
Filter and Sort the data in a PivotTable
Change the PivotTable calculations
Show pivoted data in terms of percentages
Refresh the PivotTable based on changes in the original database
Group date fields to view the data over different time periods
Format a PivotTable
Drill down to the source of data from a PivotTable
Use Slicers to make filtering a PivotTable simple
Create a PivotChart to see the data visually

AREAS COVERED

Why PivotTables are the hidden gems of Excel
How to analyze large data sets from different business perspectives
Create a PivotTable to summarize data
Make understanding the data easier for others
Use PivotTables to answer questions about the data
Analyze patterns in the data
Customize the summary by grouping data
Format PivotTables for easy viewing
Use a chart to view the summary visually

WHO WILL BENEFIT?

Business Owners
CEO's / CFO's / CTO's
Managers
Accountants
CPA's
Financial Consultants
IT Professionals
Auditors
Human Resource Personnel
Bookkeepers
Marketers
Anybody with large amounts of Data
Anybody who uses Microsoft Excel on a regular basis, and wants to be more efficient and productive

Purchase options

Option	Price
Recorded Link Only	$199
Recorded USB Only	$349
Corporate Recording (Upto 10 Attendees)	$599

*Training USB will be shipped within 7-10 working days. *Buy Now Pay Later option is available in the payment cart page.

Create inquiry

PLEASE CONFIRM THAT YOUR ARE NOT A ROBOT

Name

E-mail

Phone number

Job title

PLEASE CONFIRM THAT YOUR ARE NOT A ROBOT

Customer support

Email: support@myskilltrainer.com

Call: +1-855-202-3299

Cathy Horwitz

Microsoft Office Instructor & Consultant, PC Training and Consulting

About speaker

Cathy teaches classes on the Microsoft suite of application software including Excel, PowerPoint, Word, Access, and Outlook. Cathy has over 30 years of experience in the classroom and virtual training and has been an instructor of Microsoft Office since 1989.

Cathy Horwitz believes that when your employees know the capabilities of the software they use, they will demonstrate improved productivity, will be more efficient, and will be able to problem-solve more easily. Her strengths include customizing classes based on the needs of individual students and providing realistic business examples to complement the training. She is a high-energy trainer with a flair for training the Experienced student.

She holds the Modern Classroom Certified Trainer certification from Logical Operations which prepares instructors for all aspects of delivering a course using the latest training technologies and approaches.

When not teaching, Cathy enjoys shopping estate sales and refinishing mid-century furniture.