Explore the many formulas and functions that Excel has to offer! Formulas and functions will expand the capabilities of your Excel workbooks and save you time. Start with a review of basic formula creation, using automation features such as AutoSum, AutoComplete, Flash Fill, Function Library, Insert Function, cell protection, and formula auditing/verification. Dive deeper to explore advanced functions such as Linking Workbooks/Worksheets, IF statements, SUMIF, IF AND, and IF OR statements to perform conditional calculations, and VLOOKUP, MATCH and INDEX for extracting information. Text functions and date/time functions will also be covered. Textbook is included. Prerequisite: Excel Level One course or equivalent experience.