Excel Bootcamp | Online | December 4

$199 AUD each
Friday, 3 December, 2021
8 pm – 1 am EST
Melbourne (Online)

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

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.

About the Instructor

Wayne Wong Photo

Product Analyst, Google

Wayne is a data analyst with Google’s Admob team, applying data science to drive developer acquisition at scale globally. Wayne is passionate about solving business problems using data and analytics techniques. He was previously with Unilever, where he was a pioneering member of the data science team there, developing analytics products for sales and finance teams across Southeast Asia. Wayne graduated from the National University of Singapore, majoring in Finance.

Out of office, you can find him in the gym, or tinkering with cryptocurrency-related side projects.

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.