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 Course

By: Tom Associates Training  

Lagos State, Nigeria

28 - 31 Jan, 2020  4 days

Follow Event

  

NGN 155,000

Venue: 5/7 Alade Lawal Street, Opposite Divisional Police Station, Off Ikorodu Road, Anthony, Lagos.

Other Dates

Venue Date Fee  
5/7 Alade Lawal Street, Opposite Divisional Police Station, Off Ikorodu Road, Anthony, Lagos., Lagos State, Nigeria 05 - 08 May, 2020 NGN155000
5/7 Alade Lawal Street, Opposite Divisional Police Station, Off Ikorodu Road, Anthony, Lagos., Lagos State, Nigeria 06 - 09 Oct, 2020 NGN155000

This course is designed as an introduction to basic spreadsheet tools and formulas. Candidates will be able to map data to predict the future.

Major corporations and small businesses alike use spreadsheet models to determine where key measures of their success are now, and where they are likely to be in the future. But in order to get the most out of a spreadsheet, an analyst must know how to use it well.

No prior familiarity with, and access to, Excel or Sheets is required.

On successful completion of this workshop, participants will be able to:

  • Understand and apply excel commands to enhance productivity.
  • Use spreadsheet models to predict organizational growth
  • Generate accurate management reports and improve the bottom line of the organization.

Course Contents

Day One

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
  • Modifying row heights
  • Copying, Moving and Deleting 
  • Copying the cell or range contents
  • Deleting cell contents
  • Moving the contents of a cell or range
  • Editing cell content
  • Undo and Redo
  • AutoFill
  • Sorting a cell range
  • Searching and replacing data
  • Worksheets 
  • Manipulating Worksheets 
  • Switching between worksheets
  • Renaming a worksheet
  • Inserting a new worksheet
  • Deleting a worksheet
  • A worksheet within a workbook
  • Moving a worksheet within a workbook
  • Copying or moving worksheets between workbooks
  • Formatting 

Font Formatting

  • Font type
  • Font size
  • Bold, italic, underline formatting
  • Cell border formatting
  • Formatting the background colour
  • Formatting the font colour

Alignment Formatting

  • Aligning contents in a cell range
  • centring a title over a cell range
  • Cell orientation
  • Text wrapping
  • Format painter

Number Formatting 

  • Number formatting
  • Decimal point display
  • Comma formatting
  • Currency symbol
  • Date styles
  • Percentages
  • Freezing Row and Column Titles 
  • Freezing row and column titles 

Day Two

Formulas and Functions

Creating formulas

  • Easy way to create formulas
  • formulas
  • Operators
  • Formula error messages
  • Cell Referencing:
  • Relative cell referencing within formulas
  • Absolute cell referencing within formulas
  • Three-Dimensional referencing formulas

Functions

  • What is a function?
  • Common functions
  • Sum function
  • Average function
  • Max function
  • Min function
  • Count Function
  • What are ‘IF functions’
  • Using the IF function

Day Three

Using Charts

  • Inserting a column chart
  • Inserting a line chart
  • Inserting a bar chart
  • Inserting a pie chart
  • Resizing a chart
  • Deleting a chart
  • Chart title or labels
  • Chart background colour
  • Changing a column, bar, line or pie slice colours
  • Changing the chart type
  • Modifying Charts using the Layout tab
  • Copying and moving charts within a worksheet
  • Copying and moving charts between worksheets
  • Copying and moving charts between workbooks

Day Four

Customizing Excel

  • Modifying basic options
  • Minimizing the Ribbon
  • AutoCorrect options
  • Printing

Worksheet Setup

  • Worksheet margins
  • Worksheet orientation
  • Worksheet page size
  • Headers and Footers
  • Header and footer fields
  • Scaling your worksheet to fit a page(s)

Preparing to Print a Worksheet

  • Visually check your calculations
  • Gridline display when printing
  • Printing titles on every page when printing
  • Printing the Excel row and column headings
  • Spell checking
  • Previewing a worksheet
  • Comparing Workbooks side by side
  • Zooming the view
  • Printing options  
  • Good’ Goals.

 

5/7 Alade Lawal Street, Opposite Divisional Police Station, Off Ikorodu Road, Anthony, Lagos. Jan 28 - 31 Jan, 2020
5/7 Alade Lawal Street, Opposite Divisional Police Station, Off Ikorodu Road, Anthony, Lagos., Lagos State, Nigeria 05 - 08 May, 2020
5/7 Alade Lawal Street, Opposite Divisional Police Station, Off Ikorodu Road, Anthony, Lagos., Lagos State, Nigeria 06 - 09 Oct, 2020

Registration: 08:30:am - 09:00:am

Class Session: 09:00:am - 16:00:pm

NGN 155,000.00(VAT Inclusiveko)
(Convert Currency)

Mr Abiodun Toki 08033019120

Discount of 5% to 3-4 Participants from Same Organization. Discount of 10% to 5 or More Participants from Same Organization.
NST PPC Advert
Related Courses
Financial Statement Analysis Course Financial Statement Analysis Course

3 days, 03 - 05 Jun, 2020 

2020-06-03 12:06:00
Lagos State, Nigeria

Tom Associates Training

This financial statement analysis course is oriented around interpreting financial results of live companies and financial institutions so candidates can gain a solid understanding of financial ...

Putting Data to Work - Analyses of Past, Present and Forecast of Business Putting Data to Work - Analyses of Past, Present and Forecast of Business

5 days, 09 - 13 Mar, 2020 

2020-03-09 12:03:00
Lagos State, Nigeria

Tom Associates Training

How can you put data to work for you? How can numbers be used to tell you about present and future of business activities? This course answers these questions with quantitative models. Candidates ...

Competencies in Service Strategy Course Competencies in Service Strategy Course

4 days, 11 - 14 Feb, 2020 

2020-02-11 12:02:00
Lagos State, Nigeria

Tom Associates Training

A customer service thought process that enables everyone participating in it to contribute to development of strategies regarding: Understanding Customer Equity: Customer value proposition Customer ...

Key Account Managers Training Key Account Managers Training

4 days, 27 - 30 Apr, 2020 

2020-04-27 12:04:00
Lagos State, Nigeria

Tom Associates Training

Key-Account Managers Training teaches participants the relevant marketing, selling and relational skills needed today to grow and keep an Account for life. Managers of Key Accounts should be ever so ...