Excel Bootcamp | Online
15

Monday, 14 December

6 pm – 12 am CST

GA Singapore (Online)

Online
Singapore
$220 SGD
Regular Ticket
$220 SGD
Total

Questions? Read our FAQs

Excel Bootcamp | Online | December 15

Toby Sullivan Photo


Theatrical Producer & Analyst

15

Monday, 14 December

6 pm – 12 am CST

GA Singapore (Online)

Online
Singapore
$220 SGD
Regular Ticket
$220 SGD
Total

Questions? Read our FAQs

About This Workshop


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
  • Formatting
  • Data Organisation
  • Conditional Formatting
  • Hiding and Grouping
  • Formulas
  • Functions
  • Basic Math Functions
  • Conditional Math Functions
  • Logical Functions
  • Reference Functions
  • Text Functions
  • Filling
  • Defined Name
  • PivotTables
  • Chart
  • Trendline
  • Secondary Axis
  • Auditing tools

Takeaways

  • Accelerate the internalisation of key time-saving keyboard shortcuts and formulas for navigation and efficiency.
  • Work smarter and take advantage of the most helpful functions and features.
  • Enhance the presentation of your detailed data by adding charts and formatting to your excel spreadsheet.

Preparation

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.

Please Note

  • This session is taken completely online using Zoom and Slack.
  • You will need access to a laptop or computer with a working webcam and microphone as well as a strong internet connection. .
  • Download Zoom. Zoom is the video conferencing tool we will use. It works a lot like Google Hangouts or Skype. You will need to create an account in order to join the call.
  • We will provide a link to the session via email 24 hours in advance - keep an eye on your inbox

This session will not be recorded, however slides will be shared following the class.

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.

Coming up near you

Let’s Keep You Updated

Enter your email to start following

By providing us with your email, you agree to the terms of our Privacy Policy and Terms of Service.