Course Content

Essential Excel for Finance Training Course This training workshop teaches you the essential Excel functions needed for finance professionals.

Essential Excel for Finance Training Course

This training workshop teaches you the essential Excel functions needed for finance professionals.

Learning Objectives
This course is very hands-on and practical. Each participant will be expected to create their own models utilising the tools and techniques covered during the course.

You will learn how to:

Apply the key functions in Excel to your own models
Select the most appropriate formula to achieve the desired outcome
Create in-built error checks and variance alerts
Prevent incorrect use of your model by protecting worksheets
Validate data entry by setting data entry parameters
Create a navigation page to help users find their way around your model
Develop drop-down boxes which enable a model to produce a series of results depending on scenario variable selected

Course Agenda

Must-know Tools and Techniques
Key points on upgrading from Excel 2003 to 2007
Absolute referencing
Named Ranges
Time saving shortcuts

Formulas you simply can't live without
LOOKUP, VLOOKUP, HLOOKUP
Logical functions eg. IF, AND
Aggregation functions eg. SUMIF, COUNTIF
Financial Functions eg. NPV, IRR, PMT
Formula Nesting

Bullet-proofing your Model
Protect data by locking cells
Password Protection
Restricting incorrect data entry with data validations
Using worksheet protection to prevent entry
Protecting your file using "Read Only" and password protection

Charting
Creating and modifying a chart
Making your charts look fabulous
Charting tips, tricks and shortcuts

Essential Advanced Tools
Autofilters
Goal Seek
Macros
Pivot Tables
Array formulas

Scenario Tools
Scenario Manager
Drop-down boxes
In cell drop-down boxes
Combo boxes
Data Tables

Other Useful Stuff
Spin buttons
Hiding
Working with dates
Hyperlinking
Conditional formatting

Selected Course Date

13th October 2010, 9:00AM - 13th October 2010, 5:00PM

Cost

USD $1,500

Location

Singapore (Singapore)
6 Raffles Boulevard Marina Square Singapore 039594.

Course Instructor

Danielle Stein Fairhurst