From 10 a.m until 4 p.m
At Suite J231/250 Road 5, Opposite Stanbic Bank, Ikota Complex VGC Ajah
This training is designed to equip participants with the skills required to work with the advanced features of Microsoft Excel. Participants will be shown a practical way of learning with a hands-on and customizable approach.
After the training, participants will be able to use Excel to analyse numbers, keep track of data, and graphically represent information and do financial modelling. They will also acquire knowledge of employing an array of powerful tools useful in managing data through Skydrive.
OVERVIEW OF COURSE CONTENT
Absolute and Relative Reference
Conditional Formatting and Freezing Window Panes
Splitting Window Screen
Removing Duplicates
Transposing Data from Rows to Columns and Grouping and Outlining Data
Creating Charts, resizing and moving the Chart
Creating Pivot Tables and Pivot Charts
Choosing Fields and Grouping Data
Introduction to Macros
Displaying the Developer Tab
Changing the Security Level
Solving Formula Errors
Using the Trace Errors Commands
Evaluating Formulas
Using What If Analysis
Using Goal Seek
Using the Scenario Manager
Using a One and Two Input Data Table
Managing Your Data and Data Validation
Financial Functions
Deliberate Use of Circular Reference
Excel Shortcuts
Duration: 2 days
Fee: N75,000
Date: June 10 & 17
Fee Covers:
Pick up and drop off from and to designated locations
Lunch and certificate
Training manual
Make payment into the any of our Accounts
Account Number: 1014201920 Account Number: 0128488187
Account Name: LeadHire Limited Account Name: LeadHire Limited
Bank: Zenith Bank: Guaranty Trust Bank