print logo
Main Content Anchor

Training Registration

Click the title of a class to see all available sessions with time, date, and locations. Choose a session or sessions, and fill out the form below to register. You will receive a confirmation email within 24 hours of registering. Please note: sessions that are full may continue to appear up until the date the event takes place.

To sign up for a session, mark the checkbox corresponding to the session you wish to attend.

Overview

Excel is a powerful data analysis application used for manipulating large amounts of numerical data. Knowing Excel functions beyond Sum and Average will aid you in processing complex data. In this course, you will use lookup and reference functions to pull values from different sheets and workbooks for data analysis and reporting.

Objectives

Upon successful completion of this course, students will be able to:

  • Use the VLOOKUP, HLOOKUP and LOOKUP functions in various simple and complex scenarios.
  • Use the INDEX and MATCH functions for flexible lookups.
  • Use the OFFSET function for unlimited data range setting.
  • Use the CHOOSE function for logical lookups.

Intended Audience

This course is meant for those desiring to gain advanced skill sets necessary utilizing Excel. These tools will allow the participant to maximize their performance and productivity using Excel.

Tuition

$200 per participant

 SIDDateTimeCityLocationSeats RemainingTitleOwner
9548Mar 25, 2020 8:30AM- 4:30PMSacramentoCalHR Computer Lab - 4th Floor
1810 16th Street
412N - A1
0Excel Level 3 (Formulas - Lookup and Reference Functions)Training Registration
10647Apr 30, 2020 8:30AM- 4:30PMSacramentoCalHR Computer Lab - 4th Floor
1810 16th Street
412N - A1
0Excel Level 3 (Formulas - Lookup and Reference Functions)Training Registration
10710May 14, 2020 8:30AM- 4:30PMSacramentoCalHR Computer Lab - 4th Floor
1810 16th Street
412N - A1
25Excel Level 3 (Formulas - Lookup and Reference Functions)Training Registration

Please fill in the following fields to complete your registration. All fields are required.

One Column Page
Link Back to Top