ADVANCE EXCEL 2016 AND DATA ANALYSIS TRAINING!


OBJECTIVES OF THE TRAINING:
Perticipants should be able to:
1.Convert raw data into useful information
2.Analyse and present data for decision making
3.Enable you model business scenarios
4.Combine and update data from multiple worksheets and files
5.Import,tranform and analyse data from the web

DAY 1
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

DAY 2
WORKING WITH DATE
WORKING WITH NAME
WORKING WITH TIME
CONDITIONAL FORMATING
DATA VALIDATION
SMALL AND LARGE FUNCTION
THE POWER OF TEXT TO COLUMN DIALOG BOX
REPT FUNCTION
GO TO SPECIAL DIALOX BOX
DATABASE FUNCTION
FIXING PROBLEMS AND ERRORS IN SPREADSHEET
POWER MAP(NEW IN EXCEL 2016)
POWER VIEW(NEW IN EXCEL 2016)
FORECAST FUNCTIONS(NEW IN EXCEL 2016)
POWER QUERY(NEW IN EXCEL 2016)
PROFIT OPTIMIZATION
USING SOLVER FOR PRODUCT MIX
IF FUNCTION
INFO FUNCTION
LOOK UP FUNCTIONS(V LOOK UP, H LOOK UP , LOOK)
MATCH & INDEX FUNCTION
GETTING THE DESCRIPTIVE STATISTICS BEHIND YOUR DATA

DATE: Saturday 23rd and Sunday 24th September,2017.
COURSE FEE :₦50,000 (Fifty Thousand Naira only)
TIME: 9am daily.
Venue: CITRUS Training Centre. 3 Faramobi Ajike Street,Off Bush Street,
Anthony Village, Lagos.
PAYMENT
On or before Wednesday 20th September,2017.
PRE- REGISTRATION IS REQUIRED
FOR YOUR REGISTRATION LOG ON TO:

Register


FREE PACKAGES FOR ALL PERTICIPANTS
1)FREE OFFICE 2016 INSTALLATION
2) KEY FINANCIAL PERFORMANCE INDICATORS DASHBAORD
3) INSURANCE POLICY REGISTER TEMPLATE
4) PAYE TEMPLATE
5) BREAKEVEN ANALYSIS & CHART TEMPLATE
6)CUSTOMIZABLE SERVICE INVOICE

NB: LIMITED SPACES ARE AVAILABLE;
FULLY AIR CONDITIONED & PROJECTOR IN THE TRAINING .

POWERED BY:
IDEAL ACCOUNTING PROFESSIONALS

FOR ENQUIRY: 08056916276; 08022491792 ;08076583916

Leave a Reply