جلوبال لتكنولوجيا المعلومات - دورات وخدمات تكنولوجية عالمية

Financial Excel
MS Access 2007- 2010

This one-day course shows students how Excel’s™ advanced capabilities are used by financial institutions to solve a wide variety of problems. Students learn how Excel's™ powerful features - including goal seek, solver, specialized financial functions and statistical functions, charts, macros, scenario manager, data tables and pivot tables – greatly facilitate the solution of many financial problems, such as discounted cash flow (DCF) evaluation, portfolio optimization, pro-forma projections, stock screening, regression hedging, sensitivity analysis, scenario analysis and simulation-based forecasting. Students learn by building spreadsheets that use Excel’s™ advanced features to solve real-world financial problems. Students are also introduced to third-party add-ins, such as TreePlan and Crystal Ball, which further enhance Excel’s™ problem-solving abilities.

Financial Excel
MS Access 2007- 2010

Audience:

Investment bankers, mergers & acquisitions, leveraged finance and credit professionals. Private equity, buyout and venture capital professionals. Internal M&A and business development. CFO, VP Finance, Financial Analysts & related functions. New hires and those being groomed for management.

Prerequestes:

Attendees must have working knowledge of Excel™, and an elementary understanding of statistics, accounting and finance.

Objectives:

Students will be able to:

Apply various Excel™ tools, including: goal seek, solver, specialized financial and statistical functions, charts, macros, scenario manager, data tables, and pivot tables
Create spreadsheets that solve these financial problems: discounted cash flow (DCF) evaluation of bonds’ present value and yield, portfolio optimization, pro-forma projections, stock screening, regression hedging, sensitivity analysis and scenario analysis, and simulation-based forecasting

MOS certifications

Gain Microsoft Office Specialist (MOS) certification from our Microsoft authorised testing centres. The MOS certification is the only credential of its kind approved by Microsoft and demonstrates end-user proficiency with Microsoft Office products.

The MOS certificate illustrates a measurement of proficiency in Microsoft Office applications. Successful qualified candidates gain the recognition for having advanced desktop Office skills. Professionals and students will then be able to confirm their expertise in the Microsoft Office suite. After taking an advanced Access training course, why not cement your skills with the MOS certification.

Financial Excel
MS Access 2007- 2010

Introduction to Excel Functions, Add-ins and Macros

Distinctions between functions, add-ins and macros
When to use each feature
Best practices for creating financial models with Excel

Model I: Evaluating Individual Bonds and Stocks

Using IRR, NPV, and Yield to evaluate bonds and corporate projects
Using Excel’s statistical functions to compute stock returns, correlations, and betas
Creating regression hedges with Excel’s multiple regression add-in

Model II: Portfolio Optimization

Using Goal Seek and Solver to build optimal portfolios for known risk tolerances
Creating an efficient frontier array and chart with Excel’s data tables

Model III: Stock Screening

Analyzing relationships among historical stock prices, earnings and growth rates
Using pivot tables to indentify undervalued stocks, as measured by PE and PEG ratios

Model IV: Pro-Forma Projections

Creating pro-forma projections of balance sheets and income statements
Using Excel’s Match function and Solver add-in to build accurate projections

Model V: Pro-Forma Projection Analysis

Using Scenario Manager to perform sensitivity analysis, create Tornado charts and perform scenario analysis
Create simulation-based projections with Excel’s probability functions and macros