This workshop is scheduled for Australian Eastern Standard Time (AEST), which may appear to be an unusual time in your local timezone. Please check the workshop time and timezone carefully to make sure you have the correct timing.
Use the code: bootcamp50 to receive 50% off at checkout.
This bootcamp is an excel class that is designed to provide beginner participants with a general overview of Excel topics and specifically a good understanding of several different functions. It combines most of the material and key topics from the two workshops into an intense one-day class. Given the short timeframe and large amount of topics covered, beginner participants are expected to be able to learn quickly. The bootcamp is designed for participants who can pick up material quickly and are looking to go from relatively little knowledge of Excel to being able to achieve complex tasks and complex problems in just one day.
Agenda (Not necessarily taught in the order below):
Terminology and Navigation
Hiding and Grouping
Basic Math Functions
Conditional Math Functions
This workshop is highly interactive with group activities and discussions throughout. To participate you will need to:
Be in a quiet, well-lit space with minimal distractions
Strong internet connection
In preparation, please download Zoom and Slack
You'll need a laptop loaded with Microsoft Excel, and a general familiarity with the excel class and program. You will also want to set up a Gmail account as we may jump in and out of a Google spreadsheet during the class.
This session is not recorded however you will receive the instructors slides following the session.
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.
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.