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 automated 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.