Nigerian Seminars and Trainings

Search conferences, training, seminars, courses and workshops in Nigeria and around the world

business logo

Foundation Excel for Financial and Business Analysis

By: Tom Associates Training  

Lagos State, Nigeria

28 - 30 Oct, 2015  3 days

Follow Event

  

This course presents the first level of understanding of the working of MS Excel for its use to deliver basic financial and accounting assignments. It is for Analysts in accounts and finance functions who must possess a simple competence to use excel to generate management reports.

Course Contents

  • A First Look at Excel 
  • Starting the Excel programme
  • What is the Active Cell?
  • The Excel cell referencing system
  • Entering numbers and text
  • Default text and number alignment
  • Adding a column of numbers
  • Worksheets and Workbooks
  • Saving a workbook
  • Closing a workbook
  • Creating a new workbook
  • Opening a workbook
  • Switching between workbooks
  • Saving a workbook using another name
  • Saving a workbook using a different file type
  • Help 
  • Getting help
  • Searching for Help
  • The Help ‘Table of Contents’
  • Printing a Help topic
  • Alt key help
  • Using Excel 
  • Selection Techniques 
  • Why are selection techniques important?
  • Selecting a cell
  • Selecting a range of connecting cells
  • Selecting a range of non-connecting cells
  • Selecting the entire worksheet
  • Selecting a row
  • Selecting a range of connecting rows
  • Selecting a range of non-connected rows
  • Selecting a column
  • Selecting a range of connecting columns
  • Selecting a range of non-connecting columns
  • Manipulating Rows and Columns 
  • Inserting rows into a worksheet
  • Inserting columns into a worksheet
  • Deleting rows within a worksheet
  • Deleting columns within a worksheet
  • Modifying column widths
  • Modifying column widths using ‘drag and drop’
  • Automatically resizing the column width to fit contents
5/7 Alade Lawal Street, Opposite Divisional Police Station, Off Ikorodu Road, Anthony, Lagos. Registration: 8.30 - 9.00 a.m. Class Session: 9.00 - 4.00 p.m. Oct 28 - 30 Oct, 2015
NGN110,000.00
(Convert Currency)

08033019120

Related Courses
Competencies in Human Resources Management: Basic Human Resources Management Competencies in Human Resources Management: Basic Human Resources Management

5 days, 09 - 13 Oct, 2017 

2017-10-09 12:10:00
Lagos State, Nigeria

Tom Associates Training

These Competencies in Human Resources Management: Basic Human Resources Management training courses will address the following Competencies Addressed Ability to adopt a strategic approach in human ...

Complete Salesperson: The Seven Traits Complete Salesperson: The Seven Traits

5 days, 10 - 14 Jul, 2017 

2017-07-10 12:07:00
Lagos State, Nigeria

Tom Associates Training

This Complete Salesperson: The Seven Traits will discuss the following Sales Competence Commercial Knowledge Business Development Capabilities Bidding and Tendering Application of Excel in Sales Use ...

Root Cause Analysis Training: Diagnosing Underlying Causes of Problems and Undesired Events Root Cause Analysis Training: Diagnosing Underlying Causes of Problems and Undesired Events

2 day, 26 - 27 Oct, 2017 

2017-10-26 12:10:00
Lagos State, Nigeria

Tom Associates Training

Delegates will become very competent in Seven major things: Understand and implement the “Root Cause Analysis methodology" Practically employ the basic techniques associated with Root ...

Mastering Negotiations: The Principles and Practice Mastering Negotiations: The Principles and Practice

3 days, 11 - 13 Oct, 2017 

2017-10-11 12:10:00
Lagos State, Nigeria

Tom Associates Training

A training programme whose contents have been developed around six “Key Negotiation Lessons,” namely: Avoiding unreasonable or arbitrary positions Avoiding letting prejudices show ...