A.J. SILICON Presents Advanced Excel

http://www.ajsilicon.com/images/logo.gif
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.http://www.ajsilicon.com/images/wdot.gifTel: 07039273148, 08055272046

E-mail: [email protected]
http://www.ajsilicon.com/images/wdot.gif