OBJECTIVES OF THE TRAINING:
Participants should be able to:
1. Discover Excel back stage view with so many functions/formulas not visible ordinarily when you open Excel.
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
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
EMBEDDING EXCEL IN MS WORD
NAVIGATING YOUR EXCEL WITHOUT MOUSE
SLICERS AND TIMELINE
SUM FUNCTIONS
TEXT FUNCTION
TRACING PRECEDENT/DEPENDENTS
WHAT IF ANALYSIS
WORKSHEET GROUPING
DATE: Saturday, 19th October, 2019.
COURSE FEE :₦20,000 (Twenty Thousand Naira only)
TIME: 9am – 4pm.
Venue: 1st Floor, OAK Building, 39, Ogunnusi Road, Beside Polaris Bank, County Bus-stop, Ogba, Lagos.
CALL : 08022491792, 07037860933
EMAIL ADDRESS:GANIYU@IDEALPROFESSIONALS.COM
PRE- REGISTRATION IS REQUIRED
FOR YOUR REGISTRATION LOG ON TO:
PAYMENT
Payment on or before Friday 18th October, 2019.
BANK DETAILS
THE IDEAL ACCOUNTING PROFESSIONALS
STERLING BANK PLC
0023311816
FREE PACKAGES FOR ALL PARTICIPANTS
1) COMPREHENSIVE VIDEO TUTORIALS ON ALL TOPICS
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;
FULLY AIR CONDITIONED & PROJECTOR IN THE TRAINING ROOM.
Bring along your laptop.
A’Ganiyu Lawal B.SC ACA, ACTI
MB 27780 MB11846
Managing Consultant
THE IDEAL ACCOUNTING PROFESSIONALS
Advanced Excel Training