Excel Bootcamp | Online

About this workshop

This bootcamp is an excel class that is designed to provide beginner participants with a general overview of Excel topics and specifically a good understanding of several different functions. It combines most of the material and key topics from the two workshops into an intense one-day class. Given the short timeframe and large amount of topics covered, beginner participants are expected to be able to learn quickly. The bootcamp is designed for participants who can pick up material quickly and are looking to go from relatively little knowledge of Excel to being able to achieve complex tasks and complex problems 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 keyboard shortcuts and formulas for navigation and efficiency.
  • Work smarter and take advantage of the most helpful functions and features.
  • Enhance the presentation of your detailed data by adding charts and formatting to your excel spreadsheet.

Prereqs & Preparation

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

Coming up near you

Let’s Keep You Updated

Enter your email to start following

I have read and acknowledge General Assembly's Privacy Policy and Terms of Service. SMS message and data rates may apply.