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.

Looking for other courses?

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!

Maximize Your Leadership Potential with Industry-Focused Programs

AGC of California, in partnership with UC Davis, offers leadership development programs designed specifically for construction professionals. From emerging leaders to seasoned executives, our courses provide actionable skills and strategies tailored to the challenges of the construction industry. Learn more and take the next step in your leadership journey.

2024 Legacy Sponsors