Training: Excel – Formulas and functions for financial management

Ref. MOE-33

Download PDF

Duration:

0.5

day

Exam:

Not certifying

Level:

Expert

Funding:

Eligible

Home > Trainings > Office Automation > Spreadsheet > Excel – Formulas and functions for financial management

Description

This course will provide participants with the knowledge and skills necessary to use Excel for financial management calculations. In particular, they will see how to use the scenario manager and goal seeking function.

Participant Profiles

Users who perform financial calculations in Excel

Objectives

Use the financial functions of Excel
Create a stock chart
Forecasting with Goal seeking the scenario manager

Prerequisites

Good knowledge of Excel

Course Content

Module 1: Financial functions

Use the financial functions: VPM(), NPM(), RATE()
Use the amortization functions : AMORLIN(), AMORDEGRC()
Use the Consolidate function

Module 2: Stock Market Charts

Organize your data to create a stock chart
Create a stock chart
Set up and format a chart

Module 3: Forecasting

Designing an assumption table
Use the Scenario Manager
Analyze data with the solver
Manage variable and target cells, constraints, results
Create a forecast sheet

Documentation

Digital course material included

Lab / Exercises

Practice exercises will be given at the end of each module

Complementary Courses

Eligible Funding

ITTA is a partner of a continuing education fund dedicated to temporary workers. This fund can subsidize your training, provided that you are subject to the “Service Provision” collective labor agreement (CCT) and meet certain conditions, including having worked at least 88 hours in the past 12 months.

Additional Information

As we care about the quality of our training, ITTA offers you an online skills assessment test before and after your course so that you can evaluate your progress
Explore all our Microsoft Office courses by clicking here