Warning: getimagesize(https://www.nigerianseminarsandtrainings.com/images/category_images/information-and-communications-technology_1491822723.png): failed to open stream: HTTP request failed! HTTP/1.1 403 Forbidden in /home/nst1/public_html/event-detail.php on line 120
Advanced Excel Simplified for Financial Analysis :27800 -

Nigerian Seminars and Trainings

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

business logo

Advanced Excel Simplified for Financial Analysis

By: Tom Associates Training  

Lagos State, Nigeria

16 - 18 Nov, 2016  3 days

Follow Event

  

NGN 115,500

Advanced Excel is for people who already can create moderately complex spreadsheets and still want to add more sophistication and automation.

This training will equip participants with relevant tools and functions in MS Excel for the development of automated systems to replace certain manual and repetitive processes.

Learning Objectives

By the end of this course participants will be able to:

  • Use outlines, range names, databases and the data form
  • Use AutoFilter and advanced filters
  • Work with Data Series
  • Use advanced functions
  • Modify charts
  • Use Scenarios and Goal Seek
  • Use templates, data tables and solve problems
  • Use automatic formatting and styles
  • Work with views, consolidate worksheets
  • Create and revise PivotTables
  • Use, record and edit macros

Prerequisite

Participants should already be using Excel on a regular basis. Alternatively, they must have a good knowledge of Excel introduction topics

Course Content

Day One

  • Work with Outlines
  • Use Multiple Workbooks
  • Use Range Names
  • Work with Tables
  • Work with Advanced Filters
  • Work with Views
  • Share Workbooks
  • Views
  • Consolidate Worksheets
  • Use Advanced Functions.

Day Two

  • Create/Revise PivotTables
  • Advanced Charting
  • Use Templates
  • Use Auditing Tools.

Day Three

  • Use Scenarios and Seeking Goal
  • Solve Problems
  • Use Automatic Formatting and Styles
  • Use Conditional and Custom Formats
  • Share Workbooks
  • Create/Revise PivotTables
  • Using, Recording
  • Use, Record, Edit Macros
  • Create a Macro Button.
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. Nov 16 - 18 Nov, 2016
NGN 115,500.00(VAT Inclusive)
(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
Prosperous Retail Business Course : The Essential Salesmanship and Customer Service Prosperous Retail Business Course : The Essential Salesmanship and Customer Service

3 days, 26 - 28 Mar, 2018 

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

Tom Associates Training

This course is structured to take retail sales outlet team through: How to increase their mental agility so as to perform always at the very best How to bring high energy to bear for top performance ...

Management of Non-Current Assets: Fixed Assets Management Management of Non-Current Assets: Fixed Assets Management

3 days, 08 - 10 Aug, 2018 

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

Tom Associates Training

This Management of Non-Current Assets: Fixed Assets Management training course will discuss the following: To expose the participants to the Techniques of Assets Maintenance Management. To enable ...

Value Added Marketing Strategies Course Value Added Marketing Strategies Course

4 days, 13 - 16 Nov, 2018 

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

Tom Associates Training

At the end of this Value Added Marketting Strategies Course, participants will:       Develop enhanced skills in formulating strategic marketing plans ...

How to Find and Win New Business: Opening Doors and Converting Opportunities How to Find and Win New Business: Opening Doors and Converting Opportunities

3 days, 02 - 04 May, 2018 

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

Tom Associates Training

The Focus of the How to Find and Win New Business: Opening Doors and Converting Opportunities training course are: How to plan prospecting for new customers How to position the organization and ...