Financial Modeling Using Advanced Features Of Excel

This programme is to guide the participants in understanding the complexity of business situations by using financial modeling as a strategic decision tool in order to arrive at a logical conclusion based on factors and variables associated with the business issues.
Course Objectives
  • Financial modeling as a planning tool for decision making
  • Use of automation functions features to enhance efficiency
  • Practical example and application of functions to business environments
  • Various what-if scenarios implications
  • Validation of data to increase accuracy of data quality
Course Duration
2 Days
Who should attend
  • Accountants
  • Finance Director
  • Financial Analyst
  • CFO
  • Financial planner
What you will learn
  • Easy way to format reports
  • Enhance presentation of financial results and analysis
  • Structural reference for lookup table
  • Decision making using simple modeling methodology
  • Various ways to resolve financial and managerial issues
  • Team participation
  • Various examples and exercises
  • Application of real life business situations
Course Leader
Course Modules
  • year, month, day, now, today
  • edate, eomonth
  • datedif, weekday, yearfrac
  • vlookup, index, match, column, columns,
  • row, rows, offset
  • sumifs, averageifs
  • if, or, and
  • subtotal, convert, round, roundup, rounddown
  • sumproduct, trunc
  • rand, randbetween
  • abs, concatenate
Number Formatting

  • currency symbols, reversed signs, country codes
  • showing days, calculations of months and years
Customised formatting
  • writing codes, putting conditions on number codes
  • colour codes
Copy & Paste
  • Absolute and relative
Model 1:
Income tax table

Conditional Formatting
  • controls
  • colours for highlights
Validation of data
  • list, whole number, decimal, formula controls
Naming of range
  • structural reference
Model 2:
Fixed asset and depreciation

Time Value of Money
  • annuity
  • compounded growth
  • discount factors
Setting up a financial statement as a model illustration
  • Profit & Loss
  • Balance Sheet
  • Cash Flows
Integrity of data
  • checking if balance sheet is balanced
  • are numbers tallied?
  • do the numbers make sense?
  • do the numbers meet the minimum or maximum requirements?
  • compounded growth
  • projections
  • regression
  • using random numbers for sales
  • using FV() for sales and expenses
Testing the model
  • variables
  • assumptions
  • using extremity
Data table
  • one-way and two-way
  • finding the optimal solutions
  • maximum profit and minimum profit
  • conditions
  • Using buttons to change alternative scenarios
Model 3
Tax equalisation scheme

Financial Modeling Exercise 1
Financial Modeling Exercise 2
Questions and answers
Course Fee (HRDF Claimable)
Early Bird: (before 6 May 2014)
1 person: RM1,299
2 persons: RM1,250

1 person: RM1,399
2 persons: RM1,299

Course fee is inclusive of Materials, Attendance Certificate, Lunch & Tea Breaks.

Laptop Rental Available: RM75 per day for those who don't have Microsoft Excel 2010.

Cheque Payment:
Payee: Logica Centre of Computer & Management Sdn Bhd
Bank: AmBank Berhad
Acc. No: 212-201-200360-6

For further enquiries, please call us at +6 (06) 8500888.

Register NOW!

Registration can be made by filling and submitting the online form below or email us at

Payment shall be made payable to LOGICA CENTRE OF COMPUTER & MANAGEMENT SDN BHD (AmBank Account Number: 212-201-200360-6)

Type of Course Registration

PART A: For ALL Types of Course Registration:

Your Choice of Program (required)

I / We would like to register for the above choice of program for:
Public CourseIn-house CourseOne-to-one Intensive Program

Your Name (required)

Your Company/Organization


Tel. No. (required)

Email (required)

PART B: For Corporate Registration ONLY:
Please fill in Approving Manager details for attendee(s) below.

Authorised By

No. of Delegates you want to register?

*Note: Payment can be made before or on the commencement date.

Terms & Conditions

Registration & Fees Policy:
Registration is confirmed once registration form is received via online form/email/mail. Letter of Approval (For Corporate Registration ONLY) must be made available and presented prior to the course.

Cancellation Policy:
Any cancellation must be received in writing within 5 working days prior to the event else full payment will be imposed. Any no-show by registered delegates will be liable for full payment of the program fees.