Advanced Excel Training (Live Online)

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.TakeawaysVLOOKUPS & HLOOKUPSINDEX / MATCHPivot Tables and ChartsRecord MacrosPreparationA 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.Each individual course participant must have purchased a ticketRegistered 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.General Assembly’s classes, workshops and events are recreational and for avocational purposes only. No certificate is awarded.