Nigerian Seminars and Trainings

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

business logo

Intermediate Excel for Financial and Business Analysis Course

By: Tom Associates Training  

Lagos State, Nigeria

02 - 05 Mar, 2021  4 days

Follow Event

  

NGN 155,000

Venue: 5/7 Alade Lawal Street, Off Ikorodu Road, Anthony Village, Lagos.

Other Dates

Venue Date Fee  
Online, Lagos State, Nigeria 01 - 04 Jun, 2021 NGN139750
5/7 Alade Lawal Street, Off Ikorodu Road, Anthony Village, Lagos., Lagos State, Nigeria 21 - 24 Sep, 2021 NGN155000

This intermediate course is to make participants understand some critical functions and their usages in MS Excel. It starts with Data Manipulations, and goes on to Formatting and Displaying Techniques, Creating organizations, Linking of Data and Worksheets, all through to Querying of your Databases.

Course Contents
Day One

Manipulating Data & Named Ranges

  • Paste Special
  • Transposing data
  • Importing text and delimiting by space, comma or tab
  • What does naming a cell range mean?
  • Rules for naming cells and ranges
  • Naming cell range(s) in a worksheet
  • Named ranges within formulas
  • Navigating through workbooks using named ranges
  • Creating named ranges automatically based on cell values
  • Deleting named cells/ranges
  • Creating organisations
  • Removing organisations.

Templates

  • Using templates
  • Creating templates
  • Opening and editing templates.

Formatting & Display Techniques

  • Formatting tables
  • Formatting tables using table styles
  • Formatting cell ranges using conditional formatting
  • Creating custom number formats
  • Freezing the top row
  • Freezing the first column
  • Freezing the top row and the first column at the same time
  • Hiding and un-hiding rows
  • Hiding and un-hiding columns
  • Hiding and un-hiding worksheets.

Day Two

Sorting & Querying Data

  • Sorting internal Excel databases
  • Custom sort options
  • Using AutoFilter to query data
  • Multiple queries
  • Removing filters
  • Top 10 AutoFilter
  • Filtering unique records
  • Advanced Filter.

Linking & Consolidating Data

  • Linking individual cells within a worksheet
  • Linking charts to data within a worksheet
  • Linking a cell range on one worksheet to another worksheet (within the same workbook)
  • Linking data on one worksheet to a chart in another worksheet (within the same workbook)
  • Linking data from one workbook to another
  • Linking a chart from one workbook to another
  • Copying data from Excel into a Word document
  • Linking data from Excel into a Word document
  • Copying a chart from Excel into a Word document
  • Linking a chart from Excel into a Word document
  • Consolidating data over several worksheets or worksheet pages.

Day Three

Charts Formatting Techniques

  • Changing the angle of pie chart slices
  • Formatting the chart axis fonts
  • Formatting the chart axis scales
  • Formatting the chart axis text orientation
  • Creating and positioning a chart title
  • Re-positioning a chart legend
  • Re-positioning chart data labels
  • Exploding the segments within a pie chart
  • Deleting a data series within a chart
  • Adding a data series to a chart
  • Modifying the chart type for a defined data series
  • Widening the gap between columns / bars within a 2-D chart
  • Inserting an image into a 2D chart (as a background)
  • Inserting an image into a 2D chart (to format a column or bar of data).

Day Four

Protection & Security

  • Specifying a password for opening a workbook
  • Using the “read-only recommended” option
  • Removing a password from an Excel workbook
  • Protecting a worksheet or worksheet elements
  • Removing workbook protection
  • Allowing selective editing of a protected worksheet.

Note: Candidates must be with their Computers

Note: Available as Classroom Training as Well as Online Training

5/7 Alade Lawal Street, Off Ikorodu Road, Anthony Village, Lagos. Mar 02 - 05 Mar, 2021
Online, Lagos State, Nigeria 01 - 04 Jun, 2021
5/7 Alade Lawal Street, Off Ikorodu Road, Anthony Village, Lagos., Lagos State, Nigeria 21 - 24 Sep, 2021

Registration: 09:00:am - 04:00:am

NGN 155,000.00(VAT Inclusive)
(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.
Related Courses
Managing the Learning and Development Function Training Managing the Learning and Development Function Training

5 days, 15 - 19 Feb, 2021 

2021-02-15 12:02:00 2021-02-15 12:02:00
State, Nigeria

Tom Associates Training

Because the current roles of Learning and Development (L and D) in all organizations will change in the future in line with the trends in best practices, efforts of the employees in all L and D ...

Virtual Training on Stores Keeping and Inventory Management Virtual Training on Stores Keeping and Inventory Management

3 days, 04 - 06 Aug, 2021 

2021-08-04 12:08:00 2021-08-04 12:08:00
Lagos State, Nigeria

Tom Associates Training

Efficient warehouse operations do the following: Understand the strategic importance of stores keeping and inventory management for company profitability. Provide timely customer service to ...

Virtual Training on Business Process Improvement Virtual Training on Business Process Improvement

5 days, 14 - 18 Jun, 2021 

2021-06-14 12:06:00 2021-06-14 12:06:00
Lagos State, Nigeria

Tom Associates Training

Simple choices managers can make in processes and practices that will certainly raise the performance bar in all areas of the organization’s activities and services. It is a course that will ...

Managerial Skills Appreciation - First Level Managers Programme Managerial Skills Appreciation - First Level Managers Programme

3 days, 10 - 12 Mar, 2021 

2021-03-10 12:03:00 2021-03-10 12:03:00
Lagos State, Nigeria

Tom Associates Training

This course is to introduce first level managers to office and business management by making them Understand their roles within the changes that do affect business Get clear the management styles ...