Excel 1-Day Fundamentals Workshop

$199 AUD each
Tuesday, 28 February, 2023
8 pm – 1 am EST
Sydney (Online)

About This Workshop

Whether you are in business, management, or simply interested in getting more organized, this Excel 1-Day Fundamentals Workshop will cover the tools and functions you need to automate and enhance the way you analyze and restructure your data. Dive into formula writing, combining formulas, creating basic to intermediate charts, and, of course, leveraging the ultra-powerful PivotTable in Microsoft Excel.

This 5-hour Excel 1-Day Fundamentals Workshop is the interactive and hands-on way to start learning to leverage your data. You will dive head first into Excel, skill up with exercises, and by the end of the day you'll know how to ask — and answer — the right questions of your data sets.

Takeaways

  • Apply basic formula logic using absolute or relative references.
  • Quickly pull necessary information out of large data sets.
  • Execute advanced Excel functions, such as VLOOKUP and IF variants such as SUMIF and COUNTIF.
  • Combine formulas to clean, edit, or analyze data sets with greater efficiency, compiling accurate spreadsheets.
  • Build and modify PivotTables to quickly and effectively analyze large quantities of data.
  • Create visualizations to clearly communicate insights.

Preparation

  • This workshop is for beginners. No prior knowledge or experience required.
  • Install Mircosoft Excel.
  • You will need access to a laptop or computer with a working webcam and microphone as well as a strong internet connection.
  • This class will occur completely online using Zoom.
  • Class setup information will be emailed to all students signed up around 24 hours before (and again an hour before) your class launches.
  • Each individual class participant must have purchased a ticket.
  • NOTE: Some domains block our automated emails, so If you don’t receive sign-in instructions within 1 hour of the livestream, please reach out to help@generalassemb.ly and we’ll send sign-in instructions right away! This class will not be recorded, however, slides will be sent within 7 days following the session. If you have any questions please reach out to help@generalassemb.ly

About the Instructor

Toby Sullivan Photo

Theatrical Producer & Analyst

Toby Sullivan is a theatrical producer who has produced and consulted for some of Australia’s largest live production houses and highest profile Festivals, in which roles he has frequently smashed Excel and SQL together to develop sophisticated sales tracking and forecasting models, as well as gain valuable insights into audience profiles and behaviour.

The arts can’t afford expensive software or training so Toby has learnt how to make his way through the analytics process using basic, freely available tools. If you’re at the start of a journey bringing analytics to your role or your organisation, or are trying to demonstrate their value to justify further investment, Toby may help you overcome inertia and scepticism and get some quick, free, wins.

Toby originally trained in econometrics, holds a Masters in IT and will remain three quarters through a Masters of Analytics for the foreseeable future. During a midlife career spasm he also worked as a Pricing Analyst for a travel company, and an Insights Analyst for a corporate fitness provider.

Refund Policy

We understand that, sometimes, plans change. If you can no longer make it to a class or workshop, please email us at least 7 days before the scheduled event date. No refunds will be given to cancellations made within a week of the class or workshop.

Community Code of Conduct

Your registration for or attendance at any General Assembly offering indicates your agreement to abide by this Community Code of Conduct policy and its terms.

Join Us
By providing us with your email, you agree to General Assembly’s Terms of Service, and to receive email updates on courses, special events and GA news. You can change your mind at any time and unsubscribe from GA marketing emails by clicking the "unsubscribe" link located at the bottom of every marketing email or by emailing no.marketing@ga.co.
Can't Make It?
Follow this workshop to get an email the next time it’s scheduled.
Sign-up not required
Follow
Spread the Word

You May Also Like

Can't Make It?

Follow this workshop to get an email the next time it’s scheduled.

By providing us with your email, you agree to the terms of our Privacy Policy and Terms of Service.
Join Us
By providing us with your email, you agree to General Assembly’s Terms of Service, and to receive email updates on courses, special events and GA news. You can change your mind at any time and unsubscribe from GA marketing emails by clicking the "unsubscribe" link located at the bottom of every marketing email or by emailing no.marketing@ga.co.