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.