Excel Advanced Pivot Tables: Integrating Power Pivot for Extraordinary Data Analysis

    /Neil   /Malekspeaker of Training Doyensinvite
    Speaker: Neil Malek
    Date: Thursday, May 28th
    Time: 01:00 PM EDT | 10:00 AM PDT


    More Trainings by this Expert
    Duration: 60 Minutes
    Product Code: 51233
    Level: Beginner

CEU Approved

Training Doyens is recognized by SHRM to offer Professional Development Credits (PDCs) for SHRM-CP or SHRM-SCP. This program is valid for 1 PDC for the SHRM-CP or SHRM-SCP. For more information about certification or recertification, please visit shrmcertification.org.


Our Easter Sale is live! Use code TDES20 and get flat 20% off on your purchase.

OVERVIEW

Power Pivot is a new Add-In for Microsoft Excel that gives you sophisticated Data Modeling tools. Bringing in data from different tabs, files, or even databases, you can establish relationships between those sources. For example, you can connect a list of customers from a spreadsheet to your sales database, or connect a list of employees to their completed training courses. With those relationships established, our Pivot Table can now calculate and filter information from these connected sources with no additional effort.

Additionally, this data model provides an entire suite of calculations that use those relationships to create filtered reports in a flash. These calculations – like CALCULATE and ALL – give Pivot Tables all the tools users have been looking for in the last 20 years.

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 Power Pivot 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

• Advanced Excel data analysis using Power Pivot
• Using Power Query to pull data from various sources
• Using Power Pivot to establish relationships between data tables
• Creating advanced calculations with DAX in Power Pivot
• Creating advanced data visualizations using Power Pivot calculations

LEARNING OBJECTIVES

Pivot Tables are a powerful, dynamic way to analyze and visualize data in Microsoft Excel, but they have their limitations. The two big concerns are analyzing data across multiple tables, and creating more sophisticated calculations – and those are exactly the two things Power Pivot is extraordinary at!

Power Pivot is a modern superpower for Microsoft Excel Pivot Tables that can make your analysis faster, easier, and more powerful.

WHO WILL BENEFIT

• Business Analysts
• Managers
• Financial Professionals
• Administrative Professionals
• HR Professionals

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.

View all trainings by this speaker

Purchase Options

Live Session

For One Participant

$159

info icon

Corporate Live Session

Unlimited Participants from one Location. (For Multiple Location Please Contact Our Customer Support Team)

$449

info icon

Recorded Session

Get Unlimited Access to the webinar link for Six Months. Login information will be shared 24 hours after the completion of Live Webinar

$199

Training DVD or USB Flash Drive

Free shipment within 96 Hours, from the date of webinar completion

$379

Super Combo Offer 1

Live Webinar and Recorded webinar for $299 only!

$399

$299

info icon

Super Combo Offer 2

Live Webinar and Training DVD / USB Flash Drive for $429 only!

$529

$429

info icon
refer friend

Approved Enablers of your
Continuing Education Credits

shrmhrci
View all CEU Approved Webinars  

View Similar Trainings

In Cross Industry Functions

  Larry Johnson Time: 01:00 PM EDT | 10:00 AM PDT
  Teri Morning Time: 01:00 PM EDT | 10:00 AM PDT
  Mike Thomas Time: 01:00 PM EDT | 10:00 AM PDT
  Tom Fragale Time: 03:00 PM EDT | 12:00 PM PDT