About This Workshop
We’ve all heard of Microsoft Excel, and yet a surprising number of people have little to no experience using it. In this class — ideal for people working in business, management, or simply interested in getting more organized — you’ll learn the basics of the application, including calculation, formatting, and charts. The class will also 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. 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 in just one day.
Agenda (Not necessarily taught in the order below):
- Terminology and Navigation
- Data Organization
- Conditional Formatting
- Hiding and Grouping
- Basic Math Functions
- Conditional Math Functions
- Logical Functions
- Reference Functions
- Text Functions
- Defined Name
- Secondary Axis
- Auditing tools
- 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.
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.
About the Instructor
Chelsey Lew UXDI Instructional Associate,
Chelsey is a UX designer focused on bridging the gap between people and technology. As a GA alum, Chelsey has had hands on experience with both sides of participating in the program. She is ecstatic to share her formulas, matrices, and love of UX with the next wave of designers!