The course objective is to apply Excel functions to accounting scenarios and manipulate datasets to solve problems; conduct what-if analysis and make projections for a market by evaluating its portfolio value; analyze a client's budget and goals and present the client with an informed recommendation on capabilities and limitations; produce effective pivot tables to report financial data to decision makers; and organize and manage a database by creating macros to provide conceptual context and meaning. This course will prepare students for the Excel MOS certification