Advanced Excel Training

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.

Takeaways

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

Preparation

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)

• You will need access to a laptop or computer with a working webcam and microphone as well as a strong internet connection.
• This course will occur completely online using Zoom and Slack.
• Course set up information will be emailed to all students signed up around 24 hours before (and again an hour before) your course launches.

The well-being of our employees, students, clients, instructors, and guests is our number one priority here at General Assembly. We are monitoring COVID-19 very carefully and are adjusting delivery of our programs.

Due to the current health concerns, all GA short-form events, workshops & bootcamps will temporarily be held online - including this one.

Registered participants will be notified 24 hours in advance of this program with information on how to log in to the Zoom Meeting Room and other tools you’ll need for the session. Registration for this offering will close 2 hours prior to the session start in order to allow all students ample opportunity to have the technology enabled.