MedTech I.Q.

The Cutting Edge of Medical Technology Content, Community & Collaboration

Demystifying Excel Pivot Tables

Event Details

Demystifying Excel Pivot Tables

Time: March 1, 2021 from 10am to 11am
Location: Online Event
Street: Online Event
City/Town: Fremont
Website or Map:…
Phone: 5109628903
Event Type: online, event
Organized By: Joseph Wilcox
Latest Activity: Feb 9, 2021

Export to Outlook or iCal (.ics)

Event Description

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 you should 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.

Comment Wall


RSVP for Demystifying Excel Pivot Tables to add comments!

Join MedTech I.Q.

Attending (1)

© 2023   Created by CC-Conrad Clyburn-MedForeSight.   Powered by

Badges  |  Report an Issue  |  Terms of Service