View All Online Data

Excel at Excel: Two Part Series | Online | October 5

$80 USD each
Tuesday, 5 October -
Thursday, 7 October
3:30 5:30 am EDT
Online

About This Workshop Series

For most professionals, the ability to organise information is quickly becoming a fundamental part of the job description. Whether you already consider yourself an expert or are just getting started with spreadsheets, this hands-on workshop will allow you to take your skills to the next level and become a "power" user.

We’ll start with the absolute basics, and quickly move on to lesser known shortcuts, functions, and features that you will be able to immediately put to use on the job. You will build confidence in your basic excel skills and gain knowledge of other useful/impressive Excel features.

Topics include:

  • Formatting and Conditional Formatting
  • Advanced Copy and Paste Options
  • Handling Text and Dates
  • Basic and Nested Formulas
  • Logical Functions
  • Lookup Functions (basic understanding)
  • Pivot Tables (basic understanding)
  • Basic Charting (basic understanding) return

Please note:

This workshop is highly interactive with group activities and discussions throughout. To participate you will need to:

  • Have your camera turned on for the entire session
  • Have an accessible microphone
  • Be in a quiet, well-lit space with minimal distractions
  • Strong internet connection

Takeaways

  • Accelerate the internalisation of key time-saving shortcuts for navigation and editing.
  • Work smarter and take advantage of the most helpful functions and features.
  • Enhance the presentation of your data by adding charts and formatting.
  • Learn some of the more challenging Excel formulas and functions (i.e. VLookup and Pivot Tables).

Schedule

Oct
5
Part 1: The Basics
Tuesday   3:30 5:30 am EDT

Get introduced to the basic functions of Excel with some simple, yet practical exercises.

Oct
7
Part 2: Intermediate to Advanced Functions & Techniques
Thursday   3:30 5:30 am EDT

Start learning some more advanced functions and data analysis techniques with hands-on exercises.

Preparation

You will need a laptop or computer with access to Excel for this workshop. Excel is preferred over Google Sheets.

In preparation, please download Zoom.

This session is not recorded however, you will receive the instructor’s slides following the session.

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.

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 series 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 series 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.