Mastering MS Excel Financial Functions For Non-Accountants

Autusbridge Consulting Limited

Price: N60,000 N47,250

Course Specifications

Mode of study : Offline

Location : No 10, Wilmer Street Off Town Planning Way, Ilupeju, Lagos.

Duration : 2 Day(s)

Date : Apr 21 - Apr 22   2018

Course Description

This course is not for starters, rather, it has been packaged to enable casual and intermediate users with financial related deliverables to take their MS Excel skills to another level of proficiency.
This is a hands-on course that will showcase efficiencies with the use of advanced financial functions, while introducing super user shortcuts.


Training Date

Lagos: April Sat 21st & Sun 22nd

Time

9:00 am - 5:00 pm


₦ 47,250 covers Tuition,Course Manuals,Tea/Snacks,Lunch & Certificate





N.B: NO REFUND (Terms and Conditions Apply)

Career Outcomes

At the end of this course participants will be able to;
* Project financial statements including key schedules
* Perform financial statement analysis
* Perform sensitivity and scenario analysis for Budget
* Understand visual basic: macro and user defined functions
* Manipulate and create pivot charts

Course Outline

  • PMT Calculating a loan payment
  • PPMT & IPMT Calculating principal and interest per loan payment
  •  CUMPRINC & CUMIPMT Calculating cumulative principal and interest btw periods
  • ISPMT Calculating interest paid during a specific period
  • EFFECT and NOMINAL Finding nominal and effective interest rates
  • ACCRINT and ACCRINTM Calculating accrued interest for investments
  • RATE Discovering the interest rate of an annuity
  • NPER Calculating the number of periods in an investment

How To Enroll

Fill in your details on the enquiry form, proceed to pay online by clicking on the orange button "Pay with your ATM card" If you wish to make an online transfer or cash deposit to the bank, please send a mail to [email protected] requesting for account details.

Price: N60,000 N47,250

Receive a free course outline

For enquiries call 08139859990, 08086660967, 08129123104 or send an email to [email protected]


You can also request a call and a consultant would reach out to you

Request a Call

Similar Courses

Finance for Non-finance Executives

Autusbridge Consulting Limited

Ilupeju

Offline

Finance