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

Standard

Excel 2016 Intermediate

Students will learn to manipulate multiple Worksheets and Workbooks; create, modify, and analyze charts; and utilize Advanced Functions and Formatting.

July 16, 2024 (Tue)
8:00 AM - 3:30 PM
Virtual Training

Summary: Students will learn to manipulate multiple Worksheets and Workbooks; create, modify, and analyze charts; and utilize Advanced Functions and Formatting.

Experience Needed: Excel 2016 – Introduction, or relevant experience.

Course Content:

Using Multiple Worksheets and Workbooks

  • Using Multiple Worksheets
  • Inserting New Worksheets
  • Creating Multiple Views
  • Navigating in Multiple Workbooks
  • Moving and Copying Data between Worksheets
  • Linking Data Between Worksheets
  • And more

Charting

  • Using Charts
  • Creating a Chart
  • Changing Chart Type and Style
  • Add Data to an Existing Chart
  • Change the Data in an Existing Chart
  • Managing Chart Objects
  • And more

Advanced Functions

  • Creating and Using Functions
  • Using Built-in Functions
  • Using Dates and Times
  • Using Dates in Calculations
  • Auditing Worksheets
  • Unedifying the Auditing Commands
  • And more

Advanced Formatting

  • Using Comments in a Worksheet
  • Reviewing, Showing, and Hiding Comments
  • Working with Styles
  • Using Format Paining
  • Conditional Formats
  • Clear Conditional Formats
  • And more

Students will receive an email confirming their registration for requested course. Two business days before the scheduled class, students will each receive their electronic course and materials and their Microsoft Teams link used to join their training class. After class ends, students will receive a certificate of completion along with their class evaluation.

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