fbpx

Advanced Microsoft Excel

20Apr2019
20Apr2019

Since June 2016 you need to have a valid API key enabled to display Google maps, see plugin settings

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
TRAINING REGISTRATION FORM
  1. (required)
  2. (required)
  3. (valid email required)
  4. (required)
  5. Will you be attending?
 

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.

 

Leave your thoughts