Description

This 8-part course is designed for those looking to take their Excel skills to the next level. For those already comfortable working in Excel and using basic functions, this course will introduce time-saving skills and also help make Excel a better tool for analysis and reporting. Only the final two classes build upon each other; so you are free to pick and choose which topics you need the most or sign up for the entire course. Enrollment includes practice datasets that will be used during the class, the answer key, and access to the instructor for future questions about applying what you have learned to your situation. This virtual training fits easily into busy schedules with classes being hosted from 8am-9am every Tuesday. Grab your laptop and get ready to learn!!

Class 1: VLOOKUP

Learn a quick and easy way to link tables that will save countless hours of manual input. VLOOKUP allows you to have the computer do the work of looking up data from different tables. This class will help you learn the nuances of using the function and identify examples of applications.

Class 2: Keyboard Shortcuts 

August 27, 2024 8:00 AM - 9:00 AM (HST)

Learn easy ways to speed up your work by avoiding extra time pointing and clicking with the mouse. After learning the shortcuts from this class, you’ll wonder how you ever lived without them.

Class 3: IF  

September 3, 2024 8:00 AM - 9:00 AM (HST)

Learn all about the IF logic formulas within Excel. This class will cover IF, IFERROR, SUMIF, COUNTIF, SUMIFS, and COUNTIFS. Discover new ways to quickly analyze and classify your data.

Class 4: Text Formulas

September 10, 2024 8:00 AM - 9:00 AM (HST)

Find new ways to look at your data using Excel’s text formulas. This class will show how to use TRIM, LEFT/RIGHT, LEN, UPPER/LOWER, &/CONCAT, and combinations of these functions. Presenting useful data in Excel just got easier.

Class 5: Conditional Formatting

September 17, 2024 8:00 AM - 9:00 AM (HST)

Turn ordinary spreadsheets into colorful reports that attract the eye to the key points. This class will also show how to use Conditional Formatting to automate formatting for recurring reports.

Class 6: Subtotals 

September 24, 2024 8:00 AM - 9:00 AM (HST)

Create drill-down reports within Excel. This class will provide the skills to make reports that help managers see the big picture at a glance while giving them the flexibility to dig into the details where needed.

Class 7: Pivot Tables Part I and Class 8: Pivot Tables Part II 

October 1, 2024 8:00 AM - 9:00 AM (HST)

Learn the basics of how to create a pivot table. This two-part class will help you identify pivot table applications and learn how to navigate one of Excel’s most powerful tools.

Class 8: Pivot Tables Part II 

October 8, 2024 8:00 AM - 9:00 AM (HST)

Learn the basics of how to create a pivot table. This two-part class will help you identify pivot table applications and learn how to navigate one of Excel’s most powerful tools.