Advanced Microsoft Excel for Finance Professionals, Managers and Supervisors
From 9am until 4pm
At LeadHire Limited
Suite J231, Road 5, Ikota Office Complex, VGC, Ajah, Lagos, Nigeria.
N30,750 (Deposit N30,750 per person)
LeadHire Limited / training@leadhire.com.ng ,08139498477
Advanced Microsoft Excel
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.
Course Content
- Absolute and Relative Reference
- Vlookup function
- 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
- 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
- Deliberate Use of Circular Reference
- Excel Shortcuts
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
Call 08139498477 or Email training@leadhire.com.ng for more details.