COURSE OUTLINE ADVANCED EXCEL 2016 AND FINANCIAL MODELING VIDEO TUTORIALS
EXCEL BACK STAGE VIEW
EXCEL CELL REFERENCING
EXCEL COMPARTIBILITY CHECK
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
EXCEL TEMPLATES
1)CLASS EXCERCISES
2) AUTOMATIC IFRS CONVERSION TEMPLATE
3) KEY FINANCIAL PERFORMANCE INDICATORS DASHBAORD
4) PAYE TEMPLATE
5) BREAKEVEN ANALYSIS & CHART TEMPLATE
6) CUSTOMIZABLE SERVICE INVOICE
7) CASHFLOW STATEMENT
8) FINANCIAL STATEMENT FORECASTING
9) FINANCIAL PORTFOLIO
10) PROJECT BUDGET
11) ANNUITY INVESTMENT CALCULATOR
12) PROJECT EVALUATION LAYOUT
13) INSURANCE POLICY REGISTER TEMPLATE
CALL : 08022491792, 07037860933
EMAIL ADDRESS: GANIYU@IDEALPROFESSIONALS.COM
DISTANT IS NOT A BARRIER!
Downloadable with N4,000 only. (450MB)
A’Ganiyu Lawal B.SC ACA, ACTI
MB 27780 MB11846
Managing Consultant
The Ideal Accounting Professionals
109, Lagos-Abeokuta Expressway,Adealu Bus-stop, Iyana-Ipaja, Lagos State, Nigeria.
_