Microsoft Excel Virtual Training Series

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 11am-12pm PT every Tuesday. Grab your lunch and laptop and get ready to learn!!

Entire Course (25% savings): $300 non-members, $210 members

Individual Classes: $50 non-members, $35 members.

Class 1: VLOOKUP6

January 16, 11am – 12pm PT

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

January 23, 11am – 12pm PT

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

January 30, 11am – 12pm PT

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

February 6, 11am – 12pm PT

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

February 13, 11am – 12pm PT

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

February 20, 11am – 12pm PT

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

February 27 & March 5, 11am – 12pm PT

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.