Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Foundation Excel for Financial and Business Analysis

By: Tom Associates  

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
Internet Security Awarenes Training Internet Security Awarenes Training

5 days, 26 - 30 Nov, 2018 

2018-11-26 12:11:00
Lagos State, Nigeria

Tom Associates

Course Contents DAY ONE Having a security mindset What is Internet Security? What is at risk? Identity theft - people impersonating you Data theft of valuable personal and official data Accounts ...

Business Acumen Master Class: Transformative Learning of How the Business Makes Money Business Acumen Master Class: Transformative Learning of How the Business Makes Money

3 days, 25 - 27 Jul, 2018 

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

Tom Associates

Business Acumen is all about seeing the big picture and recognizing that all decisions no matter how small can have an effect on the bottom line. Therefore the focus of this course is to prepare ...

Competency Training For Business Development Executives Competency Training For Business Development Executives

3 days, 08 - 10 Aug, 2018 

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

Tom Associates

A Business Development skill is an enterprise management capability, and all participants in this course will acquire Seven Major Competencies: Ability to develop business trendsetter ideas Ability ...

Making Your Business Blossom in a Suppressive Market: Groundbreaking Action Plans for Cutting-Edge Companies Making Your Business Blossom in a Suppressive Market: Groundbreaking Action Plans for Cutting-Edge Companies

4 days, 07 - 10 Aug, 2018 

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

Tom Associates

This courses teaches pungent lessons to any business that will successfully wade through a period when its counterparts are experiencing comatose: How much time managers spend on problem definition, ...