Excel Intermediate, Level 2
Dates: September 17, 2024
Meets: Tue., Sep. 17, 8:30 a.m.-4:30 p.m.
Location: Zoom
Registration Fee & Materials: $299.00
Sorry, we are no longer accepting registrations for this course. Please contact our office to find out if it will be rescheduled, or if alternative classes are available.
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