Demystifying Excel Pivot Tables

  • 110.00 Dollar US$
  • Published date: May 27, 2019
    • Fremont, California, United States

Overview
We'll begin by helping you ensure that your data is in the right shape to create a pivot table. This is the place most people stop on their journey.

Some of the fixes are so simple you'll be amazed. Then, onto actually creating pivot tables, understanding how they are connected and how they interact with the source data from which they are created.

From there, you'll learn how to activate features like GETPIVOTDATA functions, charts, graphs, calculated fields, filtering and sorting, and more!

Why should you Attend
Data is not getting any smaller. And, the information we're being asked to provide isn't getting any less complicated. So, why are Pivot Tables so important to our work? Well, Pivot Tables can help you aggregate, calculate and format large volumes of data in easy to understand tables and charts, and do it quickly! Traditional tools like sort, filter, grouping and subtotaling can only get you so far.

And the nature of these tools means that you're either making multiple copies of the same data (almost always a bad idea), or designing reporting processes that are so manually intensive that errors are almost a guarantee! If they had called Pivot Tables a "custom table writer," you may have clicked on it years ago! But, that's exactly what it is.

And, you can create visually impactful reports from them. The flexibility and feature richness of Pivot Tables make them a must have tool in your toolbox for information analysis and reporting.

Areas Covered in the Session
Optimal data structures for Pivot Tables
Easy fixes to ugly data to get you on your way
Creating and Modifying Pivot Tables
Creating interactivity in Pivot Tables with Report Filters, Slicers, filtering and sorting
The impact of refreshing your pivot tables
How create charts
Calculating with pivoted data
Who Will Benefit
Administrative Professionals
Business Analysts
Managers
Supervisors
Data Analysts
Business Process
Analysts
Executives
Executive Assistants
Administrative Assistants
Financial Analysts
Accountants
Compliance Analysts

Speaker Profile
Melissa Esquibel specializes in transforming those confused by technology into empowered users of their software tools. As a Microsoft Certified Trainer (MCT) with more than 30 years in business application technology, Melissa has a unique ability to make learning programs enjoyable AND valuable.

Result 0 votes
Joseph Wilcox
0 votes

Useful information

  • Avoid scams by acting locally or paying with PayPal
  • Never pay with Western Union, Moneygram or other anonymous payment services
  • Don't buy or sell outside of your country. Don't accept cashier cheques from outside your country
  • This site is never involved in any transaction, and does not handle payments, shipping, guarantee transactions, provide escrow services, or offer "buyer protection" or "seller certification"

Related listings

  • 3-Hour Virtual Seminar on FDA Imports Require Precision in 2019

    3-Hour Virtual Seminar on FDA Imports Require Precision in 2019

    Quality Control, Safety & Security Fremont (California) May 23, 2019 290.00 Dollar US$

    Overview: After attending this 3-Hour Virtual Seminar, you will have great understanding of how FDA and Customs and Border Protection (CBP) operate a joint program. Why should you Attend: If you understand FDA's and CBP's import program, your busines...

  • OSHA's Final Rule: Worker Exposure to Respirable Crystalline Silica

    OSHA's Final Rule: Worker Exposure to Respirable Crystalline Silica

    Quality Control, Safety & Security Fremont (California) May 23, 2019 150.00 Dollar US$

    Overview: The webinar highlights steps which employers are required to take to protect employees, including assessing workplace exposures, establishing written exposure control plans and providing worker training. Why should you Attend: If employers ...

  • Overcoming Obstacles of the Canadian Drug Regulatory Landscape

    Overcoming Obstacles of the Canadian Drug Regulatory Landscape

    Quality Control, Safety & Security Fremont (California) March 28, 2019 150.00 Dollar US$

    Overview: Through this presentation, you will develop a comprehensive understanding of the Drug Approval Process and in parallel examine major misconceptions and misunderstandings. Why should you Attend: We will share insights and practical examples ...