Let AGC of California know how we can best serve you!


Microsoft Excel Intermediate for Real World Use OnDemand

Most of us can work through Microsoft Excel basics. But, when it comes to getting a smarter worksheet though, one that will handle recurring data entry with reliable results, we either push it off to our IT folks or default back to pen/paper and calculators. Wouldn’t it be nice to be able to create your own worksheets that will easily handle the work you regularly do, with just a few lines of data entry, instead of spending hours figuring out the same things again and again, by hand? This Intermediate level class will show you exactly how simple Excel can be, when you get proper training that is focused on how to use the program in the real world.

Virtual Training

This Course is OnDemand

This course will be hosted at  https://lms.on-demand.academy/ Use your AGC/Atlas Login credentials in order to access your training courses. If you do not have AGC/Atlas Login credentials, please create an account in  https://lms.on-demand.academy/ using the same email address you used when purchasing the course to access the content.

It may take up to 45 minutes for your course to be ready and enrolled.

Contact training@agc-ca.org if you have questions or require assistance.

Course Curriculum

Session 1 – Working with Templates

• Using Excel Online Templates
• Creating Templates from a Worksheet
• Saving and Sharing Templates
• Editing Templates
• Using Templates to Start New Worksheets
• Template Best Practices

Session 2 – Data Controls

• Sorting Data
• Filtering Data
• Finding Data
• Working With Conditional Formatting
• Integrating Filters and Conditional Formatting

Session 3 – Conditional and Lookup Formulas
• Linking Workbooks and Worksheets Via Formulas
• Conditional Formulas & Functions
• Lookup Formulas & Functions
• Nesting Formulas
• Other Useful Formulas and Functions

Session 4 – Charts and Tables
• Chart Planning
• Creating Basic Charts and Tables
• Chart Types and Formats
• Pivot Tables
• Sharing Charts & Tables

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!

2024 Legacy Sponsors