Data Analysis Using Excel – Effective Analytics and Simple Calculated Fields (Part 2)

Presentation Date: 6/1/2022 at 3:00pm
Duration: 1 Hour

Effective Analytics are imperative for an organization’s success, but often research analysts and data scientists are not always available to evaluate your data. Expanding from the Excel Tricks and Tips – 30 Tricks in 60 Minutes, you will work collaboratively and perform some simple calculated fields such as the VLOOKUP, FIND, and EXACT functions. You will also learn how to deduplicate (dedup) data based on a common field while also rapidly identifying duplicated data. Finally, after transforming the data you will create dashboards and charts to understand the structure and trends of the data. This session will also be interactive and group work will be performed to enhance the learning experience.

Presentation Documents:
Worksheet (XLS)