FREE Workshop | Excel Analytics Basics

With the right questions and a clean dataset in-hand, the time has finally come to find the answers to your questions with analysis in Excel.

This free, 2-hour workshop gives you hands-on practice with data analysis in Excel. You’ll practice applying some of the most commonly used Excel actions like Regular Tables, Pivot Tables, VLOOKUP, Charts, and Conditional Formatting to your dataset to extract the answers to your questions - and maybe prompt some new questions.

Make sure to join us next week where you’ll turn your findings from Excel into easily communicated visualizations when we Visualize Data in Tableau. We’ll see you there.

You’ll leave this workshop knowing:

• When, why and how to use regular tables and VLOOKUP
• How pivot tables work, and how to use them to quickly create dynamic aggregations, slices, and filter
• Common Excel visualizations like bar charts, pie charts, line charts, and conditional formatting

• This is an entry level workshop, so no prior knowledge is necessary.
• You’ll need an Excel account if you are planning to follow-along live. If you don’t have one already, you can sign-up for a Free 1-Month Trial of Microsoft 365
• If anything prevents you from following-along live, the recording will be shared after the series so you can review the content anytime.
• Your mic and camera will be off for the duration of the workshop.
• Interact with your instructor and fellow classmates through the Chat and Q&A.

Vaughn is a Brooklyn born, father of two, serial entrepreneur who is currently on a mission to organize the world's sports data. Before launching his sports data platform Ballstar, Vaughn served as associate director of Alumni affairs for Prep for Prep and later as an Alum Trustee. Using data to build community, make connections, and to better focus fundraising efforts Vaughn is most proud of the work he has done to nurture niche communities of Alums like those in the arts and tech communities. Now Vaughn uses data to bring together the global Basketball community.