Past Locations for this Workshop

Stay up to date

About this workshop

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 students 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

Prereqs & 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)

Let’s Keep You Updated

Thanks

You’re following Advanced Excel Training.

Start following any program. No need to enter your email again.

General Assembly is a pioneer in education and career transformation, specializing in today’s most in-demand skills. The leading source for training, staffing, and career transitions, we foster a flourishing community of professionals pursuing careers they love.