Online Registration

Excel Intermediate, Level 2

Dates: September 20, 2022

Meets: Tue., Sep. 20, 8:30 a.m.-4:30 p.m.

Location: Zoom

Registration Fee & Materials: $249.00

Learn how to build and decipher Excel Functions (fx) in simplified terms.

Learn skills to increase your productivity by eliminating data entry and redundancy errors.
In-class exercises provide an opportunity to create automating processes with common Excel functions including VLookup, HLookup, Transpose, Split Text, Combine Data, Remove Duplicates, and how to design a drop down list within cells. You will also learn how to utilize built-in Excel features in order to easily manage large spreadsheets. This includes using multiple windows, freezing rows/columns, splitting windows, auditing formulas, watch unique cells, and designing macros to further automate redundant processes.

IN-CLASS EXERCISES INCLUDE:

  • Working through a functional spreadsheet and adding formulas and Excel features to automate an entire spreadsheet
  • Creating a simple macro to automate a complex and repetitive formula and redundant formatting tasks.
Fee: $249.00
Hours:6.00
CEUs:0.60

Call us at (208) 426-1709 to see if you qualify for a discount on this course.

Zoom