View All Online Business

Unleashing Productivity with Excel: Essential Formulas & Functions | Online | June 3

Beverly Pao Photo

Data Scientist, Airbnb

About This Workshop

If you have the basics of Excel down, and you want to start taking your knowledge to the next level, then this class is for you. In this class — ideal for people working in business, management, or simply interested in getting more organized — you’ll learn everything you need to perform at a high level in Excel. This includes formula writing, combining formulas, creating basic to intermediate charts, and of workshop the ultra-powerful Pivot Tables. This class will give you the tools to be a more desirable job candidate and a more productive worker.

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

  • A review of basic formula writing, including when to use Absolute & Relative references
  • Intermediate Formulas, such as VLookup, If, Sumif, and variants such as Sumifs and HLookup
  • How to create and modify Pivot Tables to analyze large quantities of data
  • Improved chart functionality, including Trendlines, multi-axis charts, and dynamic charts

Preparation

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

Please note: This session will not be recorded, however slides will be shared following the class.

About the Instructor

Beverly Pao Photo

Data Scientist, Airbnb

Beverly is currently a data scientist at Airbnb, focusing on Tools and Operational Analytics. She started out as a fraud operations specialist, picked up technical skills on the job, and eventually moved into the Data space. She has over 5 years of experience in the Trust and Safety realm, and has taught classes in Airbnb's Data University program.

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.

Unleashing Productivity with Excel: Essential Formulas & Functions | Online
Thursday, 3 June, 2021
5 7:30 am EDT
Online (Online)
$ 60
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.

Total
$ 60
USD
Can't Make It?
Follow this workshop to get an email the next time it’s scheduled.
Sign-up not required
Follow

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.
Spread the Word

You May Also Like

Total
$ 60
USD