Person sitting at computer with the words "LIVE & INTERACTIVE: Excel VLookups & Pivot Tables"
Course

Excel: Lookups & Pivot Tables (September 2024)

Time limit: 2 days

Sorry! The enrollment period is currently closed. Please check back soon.

Full course description

DESCRIPTION

DATE: September 17 & 19, 2024

TIME: 5 pm - 7 pm

LOCATION: Virtual

Attendees must be at least 18 years of age.

This course is taught in TWO 2-hour sessions: Tues 09/17 and Thur 09/19. You are signing up to attend both sessions.

Class size is limited to 15 people.

For those attending, please have a computer with Excel installed.

The instructor prefers registrants attend via computer with with two screens, one to view the class and one to work in Excel in real time.

In addition to your confirmation email, you will receive a separate email with an Excel file needed for this class.

This training WILL NOT be recorded.

OBJECTIVES

At the end of this course, you’ll be able to:

  • Recognize a wide range of problems/situations that can be solved with the combination of IF functions, VLookup functions, Pivot Tables, and Pivot Charts; and
  • Creatively apply these concepts to your unique work statements through hands-on practice and coaching.

NOTE: This course is limited to Lookup and Pivot Table tools and functions within the basic Excel program. This course DOES NOT cover, PowerPivot, Power Query, VBA, Python, SQL, MATLAB/Simulink, etc.

course Instructor

Chris Carhart

CHRIS CARHART

Test Engineer,
Boeing Test & Evaluation

Chris has been with Boeing for 10 years and is an expert in the production of commercial airplane test systems. He is currently performing Model-based systems engineering (MBSE) pilot-projects as part of Boeing’s “Digital Transformation” effort.

Chris has a Master’s degree in Mechanical Engineering from Northwestern University and a Master’s degree in Systems Engineering from the University of Southern California. He is also a licensed private pilot and an active member of the International Council on Systems Engineering (INCOSE).

 

 

SPEEA ACE Logo