Hands-on Excel Analytics | FREE Data Skills | Sydney
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 our next session 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 this session will be sent via email at the end of the full Skill Seeker series.
- 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.
