Mental Health Initiative

Multi-Course

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!! 

Multi-Course
March 15, 2022 (Tue) to
May 3, 2022 (Tue)
Virtual Training

 

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.

Share

Looking for other courses?

ProCore Learning Portal

AGC of California is excited to announce that we has partnered with Procore.org to provide our members with FREE access to Procore’s library of continuing education courses. The courses are designed for construction professionals that must complete units to fulfill the learning requirements for license renewals, certification renewals, and organizational memberships. Be sure to check back frequently for new courses and webinars.

Custom Courses

AGC offers customized trainings to member companies based on their needs and priorities. Past custom courses have included Lien Construction Law, Blueprint Reading, and more. Request your custom training course today!

2022 Legacy Sponsors

Nor-Cal Pipeline Services