Excel Pivot Tables 101 - Detailed Data Analysis with Pivot Tables: Calculating Sums, Averages, Counts and More

Posted By : User Ref No: WURUR56591 0
  • Image
  • TypeWebinar
  • Image
  • Location Denver, Colorado, United States
  • Price
  • Date 15-04-2020
Excel Pivot Tables 101 - Detailed Data Analysis with Pivot Tables: Calculating Sums, Averages, Counts and More, Denver, Colorado, United States
Webinar Title
Excel Pivot Tables 101 - Detailed Data Analysis with Pivot Tables: Calculating Sums, Averages, Counts and More
Event Type
Webinar
Webinar Date
15-04-2020
Last Date for Applying
15-04-2020
Location
Denver, Colorado, United States
Organize and Presented By
Training Doyens
Sponsored By
Training Doyens
Organizing/Related Departments
Human Resources
Organization Type
Organization/Company
WebinarCategory
Both (Technical & Non Technical)
WebinarLevel
All (State/Province/Region, National & International)
Related Industries

Business Development

Finance

Employment/Jobs/Recruitment

Placement/Carriers

Accounting/Financial/Banking/Insurance

Location
Denver, Colorado, United States

OVERVIEW

Microsoft Excel Pivot Tables are one of the most powerful and easy-to-use features in Excel, but most people are intimidated by them. These tables allow users to take a large set of data – rows of data about things like customers, products, sales, locations, employees, anything at all – and build reports to make real business decisions. But how exactly do you make a powerful Pivot Table?

In this session, we’ll review everything from the fundamentals like how to create pivot table in Excel to techniques that allow them to be used for dashboards and other visualizations. Neil will help you analyze and visualize essentially any kind of data in Microsoft Excel. He will share how Pivot Tables can immediately give you an insight into any part of your business. With just a couple of clicks, you can build a report and charts around your employees, your sales, your tasks – anything that’s relevant to you.

WHY SHOULD YOU ATTEND

Unlike many webinars, Neil’s sessions are 100% hands-on real-world examples of the skills he’s presenting. After this Microsoft Excel Pivot Table tutorial, you’ll have a screenshot-laden step-by-step guide to performing the techniques we cover. You’ll be able to apply these skills directly to your work with almost no adjustment, and with a very short learning curve.

AREAS COVERED

• Data Layout best practices
• Formatting data as a Table
• How to create Pivot Table in Excel
• Calculating sums, averages, counts, and more
• Filtering by date, region, or other relevant factors
• Creating charts to illustrate your insights
• Drill into your data for detailed analysis
• Format and create a presentation
• Linking multiple tables through relationships

LEARNING OBJECTIVES

In business, the data we base our decisions on is kept in databases and spreadsheets in list form. The list by itself is essential, but useless without summaries, reports, and visualizations. A Microsoft Excel Pivot Table is an incredibly dynamic and easy-to-use tool for this kind of reporting and data visualization. It is a must-use tool in Excel for any job role.

WHO WILL BENEFIT

• Business owners
• Executives
• Managers
• Business analysts
• Financial professionals
• Support representatives
• Information workers of all kinds

SPEAKER

Years of Experience: 20+ years

Areas of Expertise: Microsoft Products

Neil Malek is principal at Knack Training, a software training company specializing in Microsoft products. For nearly two decades, Neil has been working with non-profits, governments, and Fortune 500 companies to identify and address skills gaps.

Neil is a Microsoft Certified Trainer, Adobe Certified Instructor, and CompTIA Certified Technical Trainer from Orlando, FL. His career, spanning from the Center from Instructional Technology and Training at the University of Florida to his current business, has led him to train on products from Microsoft Office, SharePoint, Teams, and OneDrive to Adobe Acrobat and Creative Cloud, to the Google Suite for Business, and includes professional development topics like presentation design and delivery.

Neil’s work currently focuses on using Office power tools to analyse information, present it effectively, and automate business processes that would otherwise rob us of time, energy, and enthusiasm.

Use Promo Code TDES20 and get flat 20% discount on all purchases.

To Register (or) for more details please click on this below link:

http://bit.ly/2W5ZrcM

Email: [email protected]

Toll Free: +1-888-300-8494

Tel: +1-720-996-1616

Fax: +1-888-909-1882

Others Details

Learn how to perform data analysis using Microsoft Excel Pivot Tables. The webinar discusses how to create Pivot Table in Excel, data formatting, linking multiple tables through relationships, and more.

Registration Fees
Available
Registration Fees Details
Live Session for one participant $159 Corporate Live Session Group - Max 10 Participants from one Location. $449 Recorded Session Get unlimited access to the link for six months. $199 Training DVD or USB Flash Drive Free shipment within 72 Hours, from the date of webinar completion $379 Super Combo Offer 1 Live and Recorded webinar $299 Super Combo Offer 2 Live and Training DVD / USB Flash Drive $429
Registration Ways
Email
Phone
Website
Other
Address/Venue
  26468 E Walker Dr, Aurora, Colorado 80016-6104  Pin/Zip Code : 80016
Landmark
CO
Official Email ID
Contact
Training Doyens

26468 E Walker Dr, Aurora, Colorado 80016-6104

[email protected]

   Fax No: 80016
Training Doyens

26468 E Walker Dr, Aurora, Colorado 80016-6104

[email protected]

   Fax No: 80016