Past Locations for this Workshop

Stay up to date

About this workshop

This bootcamp is designed to provide students with a general overview of Excel topics and specifically more knowledge of several different functions. It combines most of the material from the two workshops into an intense one-day session. Given the short timeframe and large amount of topics covered, students are expected to be able to learn quickly. The bootcamp is designed for students who can pick up material quickly and are looking to go from relatively little knowledge of Excel to being able to achieve complex tasks in just one day.

Agenda (Not necessarily taught in the order below):

Terminology and Navigation

Formatting

Data Organization

Conditional Formatting

Hiding and Grouping

Formulas

Functions

Basic Math Functions

Conditional Math Functions

Logical Functions

Reference Functions

Text Functions

Filling

Defined Name

PivotTables

Chart

Trendline

Secondary Axis

Auditing tools

Takeaways

Accelerate the internalization 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.

Prereqs & Preparation

A laptop loaded with Excel, and a general familiarity with the program. You will also want to set up a Gmail account as we may jump in and out of Google Spreadsheets during the workshop.

Let’s Keep You Updated

Thanks

You’re following Excel Bootcamp.

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.