ADVANCED EXCEL 2016 AND DATA ANALYSIS TRAINING
OBJECTIVES OF THE TRAINING:
Participants should be able to:
1.Design CashFlow Statement Model from Income Statement and Balance sheet
2.Analyse and present data for decision making
3.Equip you with many Advance Excel Customized Template
4.Combine and update data from multiple worksheets and files
5.Import,tranform and analyse data from the web
6.Explore MS Excel in-depth analysis
COURSE OUTLINE
GETTING FAMILIAR WITH EXCEL 2016 INTERFACE
EXCEL BACK STAGE VIEW
EXCEL CELL REFERENCING
EXCEL COMPARTIBILITY CHECKER
ADVANCED DOCUMENT PROPERTIES
ADVANCED FILTER
ADVANCED SORTING AND FILTERING OF DATA
AUTO FORMATING OF CELLS
CUSTOM VIEW
DATA FORM
USE OF EXCEL CAMERA FOR MODELING
USE OF FORMAT PAINTER
USE OF SPEAK CELL
ADVANCED PIVOT TABLE
DATE GROUPING IN PIVOT TABLE(NEW IN EXCEL 2016)
EMBEDDING EXCEL IN MS WORD
NAVIGATING YOUR EXCEL WITHOUT MOUSE
SLICERS AND TIMELINE
SMART LOOKUP(NEW IN EXCEL 2016)
SUM FUNCTIONS
TELL ME WHAT YOU WANT TO DO(NEW IN EXCEL 2016)
TEXT FUNCTION
TRACING PRECEDENT/DEPENDENTS
WHAT IF ANALYSIS
WORKSHEET GROUPING
CASHFLOW STATEMENT MODEL
DATES: Weekday class 11th April,2018.
Weekend class 14th April,2018.
COURSE FEE :₦20,000 (Twenty Thousand Naira only)
TIME: 9am – 4pm.
Venue: Our office.109, Lagos-Abeokuta Expressway,Adealu Bus-stop, Iyana-Ipaja, Lagos State, Nigeria
CALL : 08022491792, 07037860933
EMAIL ADDRESS: GANIYU@IDEALPROFESSIONALS.COM
PRE- REGISTRATION IS REQUIRED
FOR YOUR REGISTRATION LOG ON TO:
PAYMENT
Payment on or before 3rd April,2018.
BANK DETAILS
THE IDEAL ACCOUNTING PROFESSIONALS
STERLING BANK PLC
0023311816
FREE PACKAGES FOR ALL PARTICIPANTS
1) AUTOMATIC IFRS CONVERSION TEMPLATE
2) KEY FINANCIAL PERFORMANCE INDICATORS DASHBAORD
3) PAYE TEMPLATE
4) BREAKEVEN ANALYSIS & CHART TEMPLATE
5) CUSTOMIZABLE SERVICE INVOICE
6) CASHFLOW STATEMENT
7) FINANCIAL STATEMENT FORECASTING
8) FINANCIAL PORTFOLIO
9) PROJECT BUDGET
10) ANNUITY INVESTMENT CALCULATOR
11) PROJECT EVALUATION LAYOUT
12)INSURANCE POLICY REGISTER TEMPLATE
NB: LIMITED SPACES ARE AVAILABLE;
Bring along your laptop.
