Online Registration

Excel Intermediate, Level 2

Dates: September 17, 2024

Meets: Tue., Sep. 17, 9 a.m.-4 p.m.

Location: Zoom

Registration Fee & Materials: $299.00

OR

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: $299.00
Hours:7.00
CEUs:0.70

Zoom