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

# Powerful Data Analysis Tools: The Spreadsheet Models

## By: Tom Associates

Lagos State, Nigeria

14 - 17 Feb, 2017  4 days

### 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
• 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

• 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. Feb 14 - 17 Feb, 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.
 Accelerated Certification Training in Public Relations A 2 Day Certification Training that enables you to Acquire the licence to practice Public Relations
###### Related Courses
Protocol, Public Relations and Events Management

5 days, 07 - 11 May, 2018

Lagos State, Nigeria

Tom Associates

The objectives of this Protocol, Public Relations and Events Management training course include to: Arrange and provide protocol services including logistics requirements. Organize travel ...

Excellent English for Public Service Officers Course

5 days, 13 - 17 Aug, 2018

Lagos State, Nigeria

Tom Associates

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. ...

Internet Security Awarenes Training

5 days, 26 - 30 Nov, 2018

Lagos State, Nigeria

Tom Associates

Course Contents DAY ONE Having a security mindset What is Internet Security? What is at risk? Identity theft - people impersonating you Data theft of valuable personal and official data Accounts ...

Monitoring and Evaluation (M and E) of Government Projects Course

5 days, 10 - 14 Sep, 2018

Lagos State, Nigeria

Tom Associates

The country is as exposed as any country to the growing pressures on government for good governance, accountability, greater development effectiveness and delivery of tangible results. Accompanying ...