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  

Lagos State, Nigeria

03 - 05 Jun, 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. Jun 03 - 05 Jun, 2015
NGN110,000.00
(Convert Currency)

08033019120

Related Courses
How to Set Key Performance Indicators (KPI): For Objective Performance Management How to Set Key Performance Indicators (KPI): For Objective Performance Management

2 day, 05 - 06 Jul, 2018 

2018-07-05 12:07:00
Lagos State, Nigeria

Tom Associates

The process of setting performance standards which can support appraising your employees’ performances against predefined sets of criteria that support the organization’s goals and ...

Growing as an Entrepreneur - What Set Successful Entrepreneurs Apart Growing as an Entrepreneur - What Set Successful Entrepreneurs Apart

5 days, 23 - 27 Jul, 2018 

2018-07-23 12:07:00
Lagos State, Nigeria

Tom Associates

To choose a path of entrepreneurship is a very major decision. To some the feeling is very great. To those forced into the choice, it is with trepidation. This course breaks down the Entrepreneurial ...

Big Data Analysis and Dashboards with Microsoft Excel for Buisness Analysis Course Big Data Analysis and Dashboards with Microsoft Excel for Buisness Analysis Course

3 days, 05 - 07 Dec, 2018 

2018-12-05 12:12:00
Lagos State, Nigeria

Tom Associates

This Big Data Analysis and Dashboards with Microsoft Excel for Buisness Analysis Course Contents DAY ONE Pivot Table Default Pivot Table Tabular Pivot Table Pivot Table Filtering Making a very ...

Pre-Retirement Course Pre-Retirement Course

4 days, 10 - 13 Jul, 2018 

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

Tom Associates

This is a programme on how all employees sure to approach retirement shortly or in a few years time must plan how they will confront real economic issues after their employment in the organisation. ...