Advanced Excel for Finance

COURSE DESCRIPTION:
Students will master intermediate and advanced Excel tools to enable them to predict, forecast, and run a
business from an Excel Worksheet.

COURSE OBJECTIVES:
Through this course, students will be able to easily determine how to adapt Microsoft Excel tools to their
needs, and build their capacities to learn new functionalities on their own. They will learn how to use
appropriate strategies in Excel to solve real business problems, build attractive and functional data
presentations, and master advance tools in Excel to analyze and predict current and future business trends.

EXPECTED LEARNING OUTCOMES:
Upon completion of this course students should be able to:
- Create and manipulate Excel spreadsheets and graphs to represent data in an easily understandable
form
- Create and edit charts with Excel
- Transform raw data into desired results with the aid of Excel built-in functions, formulas, and
functionalities
- Design an Excel tool for a given task
- Use Macros to automate tasks
- Work with other Microsoft Office applications within Excel
- Perform business intelligence analysis
- Create business forecasts and visualizations