ABOUT US: Welcome to A.J. Silicon
CONTACT: Welcome to A.J. Silicon
INTRODUCTION
In today's modern business, it is very essential to make accurate financial & business decisions at the right time.
This training will help you overcome the complexity of preparing your forecasts in order to make more meaningful strategic business decisions.
COURSE OUTLINE
- Overview of MS Excel
- Logical Operations/functions
- Data Analysis & Formulas
- Consolidation
- Import & Export
- Sharing Workbook on a Network
- Database Functions
- Date Functions
- PivotTable & PivotChart
- Budgeting & Forecasting
- Targeting & Optimisation with Goal Seeker & Solver
- Evaluating alternatives using Scenario Manager
- Lookup functions: Hlookup & Vlookup
- Calculating Present & Future Values Using Financial Functions (NPV, FV, PMT)
- Introduction to Macros
- Case Study
TARGET AUDIENCE
Accountants, Bankers, Analysts, Auditors, Economists, Statisticians, Planners, IT Professionals, Undergraduates, Students, etc
TRAINING PERIOD
Weekday Option: 20th - 23th Sept. 2011 (4-day training) 9am - 4pm daily
Weekend Option: 1st - 2nd, 8th - 9th Oct 2011 (4-day training) 9am - 4pm daily
TUITION FEE
N25,000
This is a highly practical course and each participant is expected to come along with his/her back-up device to copy useful templates & models.
Prog Director: RAZAK JAIYEOLA, B.SC. FCA,CRISC
ENQUIRES
A.J. SILICON-TECH LTD
14B, Amara Olu Street,
Off Zenith Bank Branch,
Lateef Jakande Road,
Agidingbi-Ikeja.
Box 13292, Ikeja, Lagos.Tel: 07039273148, 08055272046
E-mail: [email protected]
![]()
******