Excel at Excel: Two Part Series | Online
9

November 9 – November 11
2 Sessions

$75 USD
Cost
$75 USD
Total

Questions? Read our FAQs

Excel at Excel: Two Part Series | Online | November 9

Johnson Dang Photo


Supply Chain Analyst, Nestle Australia Ltd

9

November 9 – November 11
2 Sessions

Online

Anywhere
Online
$75 USD
Cost
$75 USD
Total

Questions? Read our FAQs

About This Workshop Series

Gift the gift of learning this holiday! Use the code: FRIENDS30 to receive $30 off at checkout. Offer ends 30 November

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

Nov 9
Monday, 9 November 3 5 am EST Part 1: The Basics

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

Nov 11
Wednesday, 11 November 3 5 am EST 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

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.

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.