Excel Bootcamp

Important Note about Online Classes: Registered students will be notified 48 hours in advance of this program with information on how to log in to the Zoom webinar and Slack messaging apps. Registration for this class will close 48 hours prior to class start in order to allow all students ample opportunity to have the technology enabled.

This Bootcamp is designed to provide participants 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, participants are expected to be able to learn quickly. The Bootcamp is designed for participants who can pick up the 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.

Preparation

• You will also want to set up a Gmail account as we may jump in and out of Google Spreadsheets during the workshop. It is also recommended (but not required) that you have a mouse, as if may make some exercises easier.
• You will need access to a laptop or computer with a working webcam and microphone as well as a strong internet connection, along with Excel, and a general familiarity with the program (including basic data entry, and copying & pasting).
• 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.