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: VLOOKUP
March 15, 2022, 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
March 22, 2022, 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
March 29, 2022, 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
April 5, 2022, 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
April 12, 2022, 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
April 19, 2022, 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
April 26 & May 3, 2022, 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.