Hands-on Excel Analytics | FREE Data Skills | Online
About this class
With the right questions and a clean dataset in-hand, the time has finally come to find the answers to your questions with data analysis in Excel.
This free, two-hour session gives you hands-on practice applying some of the most commonly used Excel actions like regular tables, PivotTables, VLOOKUP, charts, and conditional formatting to your dataset to extract the answers to your questions — and maybe prompt some new questions.
With freshly analyzed data in-hand, make sure to join us for day four of Data Week where you’ll take your findings from our Excel analysis and Visualize that Data in Tableau. We’ll see you there.
Takeaways
- Understand when, why, and how to use regular tables and VLOOKUP.
- Learn how PivotTables work, and how to use them to quickly create dynamic aggregations, slices, and filters.
- Get hands-on practice with common Excel visualizations like bar graphs, pie charts, line charts, and conditional formatting.
Prereqs & Preparation
- This is a beginner-friendly series, so no prior knowledge is necessary.
- You’ll need an Excel account if you’re 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. Keep in mind, this part is optional.
- A recording of every session from Data Week will be shared within a few business days after the week’s end.
- This session will be held in a Zoom webinar, so your mic and camera will be off. We’ll interact through the chat, Q&A, and reactions.
