fbpx

Excel Modelling for Accounting and Finance

10Jun2017

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

 

Leave your thoughts