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.
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
- VLOOKUPS & HLOOKUPS
- INDEX / MATCH
- Pivot Tables and Charts
- Record Macros
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
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.