f

Nigerian Seminars and Trainings

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

business logo

Powerful Data Analysis Tools: The Spreadsheet Models

By: Tom Associates Training  

Lagos State, Nigeria

04 - 07 Sep, 2017  4 days

Follow Event

  

NGN 136,500

The simple spreadsheet is one of the most powerful data analysis tools that exists, and it’s available to almost anyone. 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, you have to know how to use it.

This course is designed to present an introduction to basic spreadsheet tools and formulas with which to begin to harness the power of spreadsheets to map the data you have now and to predict the data you may have in the future.

The course also teaches the building of decision trees in excel.  Basic familiarity with, and access to, Excel or Sheets is required.

Course Contents

Day One

  • Spreadsheets: A Tool for Thinking with Numbers
  • A Little Spreadsheet History
  • Navigating a Spreadsheet and Crafting Formulas
  • Using Functions
  • Using Conditional Expressions in Formulas
  • Common Errors in the Use of Spreadsheets
  • Differences between Sheets and Excel.

Day Two

  • From Spreadsheet to Model
  • Using Assumptions and Decision Variables in Spreadsheet Models
  • Structuring a Spreadsheet to Model Variables, Objectives, and Objective Functions
  • Constructing Simple Cash Flow Model
  • What-If Analysis and Sensitivity Analysis
  • Limits to Simple Deterministic Models.

Day Three

  • Addressing Uncertainty and Probability in Models
  • Random variables and probability distributions
  • Changes in discrete and continuous time
  • Power, exponential, and log functions
  • Probability trees and decision trees.

Day Four

  • Simulation and Optimization
  • Monte Carlo Simulations
  • Linear Programming
  • Differences between Excel and Sheets.

NOTE: Participants Must Be With Their Computers

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. Sep 04 - 07 Sep, 2017
NGN 136,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
Comprehensive Basic Accounting Training Comprehensive Basic Accounting Training

5 days, 07 - 11 Aug, 2017 

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

Tom Associates Training

This programme takes the employees responsible for running the Accounts and Finance functions of the organization through their core duties. They will be taken through the step-by-step process of ...

Mastering Competitive Positioning, Blue Ocean Strategy and Value Chain Management Mastering Competitive Positioning, Blue Ocean Strategy and Value Chain Management

3 days, 02 - 04 Aug, 2017 

2017-08-02 12:08:00
Lagos State, Nigeria

Tom Associates Training

How does the management find a unique positioning, the “place” the organization should be in the industry? That is discovering a good strategy. In your arena of tough business rivalry, ...

Strategic Procurement and Vendor Management Course Strategic Procurement and Vendor Management Course

5 days, 13 - 17 Nov, 2017 

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

Tom Associates Training

This course provides participants with the necessary knowledge and skills to effectively and efficiently manage company and project procurement functions. The topics covered will include: The ...

Facility Maintenance and Management Training Facility Maintenance and Management Training

3 days, 20 - 22 Sep, 2017 

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

Tom Associates Training

This is a programme for Facility Managers and Office Managers who support the Facility Managers. It is to give them the know-how to effectively manage the physical assets. The programme will make all ...