Nigerian Seminars and Trainings

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

business logo

Intermediate Excel for Financial and Business Analysis

By: Tom Associates Training  

Lagos State, Nigeria

18 - 20 Oct, 2017  3 days

Follow Event

  

NGN 115,500

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 and 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 organizations
  • Removing organizations.
  • Templates
  • Using templates
  • Creating templates
  • Opening and editing templates.
  • Formatting and 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 and 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 and 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).
  • Protection and 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
5/7 Alade Lawal Street, Opposite Divisional Police Station, Off Ikorodu Road, Anthony, Lagos. Oct 18 - 20 Oct, 2017

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

Class Session: 09:00:am - 04:00:am

NGN 115,500.00(Including VAT)
(Convert Currency)

08033019120

Discount of 5% to 3-4 participants from same organization. Discount of 10% to 5 or more participants from same organization.
Related Courses
Value Added Marketing: Advanced Marketing Strategies Value Added Marketing: Advanced Marketing Strategies

4 days, 14 - 17 Nov, 2017 

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

Tom Associates Training

At the end of this Value Added Marketing - Advanced Marketing Strategies course, participants will: Develop enhanced skills in formulating strategic marketing plans Have higher creativity in brand ...

Delivering Results through Teams Delivering Results through Teams

4 days, 26 - 29 Dec, 2017 

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

Tom Associates Training

This training course Delivering Results through Teams will discuss the following: How to develop a team that delivers results through: Harnessing quality staff and aligning the employees efficiently ...

Fluent English for Public Service Officers Fluent English for Public Service Officers

5 days, 20 - 24 Nov, 2017 

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

Tom Associates Training

Effective writing in English, the official language, is a powerful tool in the hands of public service officers. Brilliant officials articulate their thoughts in a clear and concise manner. They ...

Job Hazard Analysis Training: Health and Safety Hazards at SME’s Worksites Job Hazard Analysis Training: Health and Safety Hazards at SME’s Worksites

2 day, 08 - 09 Feb, 2018 

2018-02-08 12:02:00
Norway

Tom Associates Training

This job hazard analysis training: health and safety hazards at SME’s worksites training course will discuss: Day One What is Job Hazard Analysis? Why Conduct a Job Hazard Analysis? Hazard ...