Excel Intermediate with a Focus on Finance

About Course:

Students will learn how to utilize Excel for a wide variety of financial purposes, such as naming conventions and methodologies, outlines, worksheet and cell protection, concatenation, array formulas, array functions, consolidation, filters, pivot tables, goal seek, data validation, conditional formatting, recording macros, editing macros, auditing tools, hyperlinks, LOOKUP functions, IF functions, DATE functions. All of these functions will be beneficial to those working with financial data.