View All Online Data

Advanced Excel Training | May 24

Johnson Dang Photo

Supply Chain Analyst, Nestle Australia Ltd
Advanced Excel Training
Monday, 24 May, 2021
4 7 am EDT
Online (Online)
$ 50
USD


Total
$ 50
USD
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

Advanced Excel Training | May 24

Johnson Dang Photo

Supply Chain Analyst, Nestle Australia Ltd

About This Workshop

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.

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put participants in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help you organize and analyze data and go through situational overviews of time-saving shortcuts to improve your efficiency dramatically.

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

  • VLOOKUPS & HLOOKUPS
  • INDEX / MATCH
  • Pivot Tables and Charts
  • Record Macros

Preparation

In preparation, please download Zoom.

A strong working knowledge of Excel is mandatory. Relative and absolute cell references, nested formulas, and functional understanding of Excel formatting. You do need a laptop w/ Excel loaded. (Google Sheets is an ok substitute, but not preferred)

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

About the Instructor

Johnson Dang Photo

Supply Chain Analyst, Nestle Australia Ltd

With over 10 years of experience as a Data Analyst, Johnson has used his skills to prepare, analyse and draw insights from large and complex data sets. His work provides key stakeholders and business leaders with the information and recommendations they need to support critical decisions.

Johnson has worked in industries such as business advisory, pharmaceuticals, sporting goods and FMCG. He discovered his passion for data and analytics when undertaking his Commerce degree at Macquarie University, majoring in Applied Statistics, where he attributes his strong academic performance to a genuine interest in the field.

With a passion for learning and teaching, Johnson is able convey complex statistical concepts in a manner which is easy to understand and gets a lot of joy from seeing people developing skills in data analytics.

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.

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

Total
$ 50
USD

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.