Excel at Excel: Two Part Series | Online
28

June 28 – June 30
2 Sessions

Manchester (Online)

£75 GBP
Total

Questions? Read our FAQs

Excel at Excel: Two Part Series | Online | June 28

Toby Sullivan Photo


Theatrical Producer & Analyst

28

June 28 – June 30
2 Sessions

GA London (Livestream)

Online Class
Livestream
£75 GBP
Regular Ticket
£75 GBP
Total

Questions? Read our FAQs

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)

Schedule

Jun 28
Monday, 28 June 9:30 11:30 am BST Part 1: The Basics

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

Jun 30
Wednesday, 30 June 9:30 11:30 am BST Part 2: Intermediate to Advanced Functions & Techniques

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

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

Preparation

This workshop will be completely live and online. In preparation, please download Zoom and Slack.

You will need a laptop or computer with access to Excel for this workshop.

Please note: This session is not recorded, however you will receive the instructor's slides after 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.

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.