advanced excel applications for banking industries/oil & gas/banks

advanced excel applications for industries/oil & gas
(Technical and Industrial Method)

The training package aims at simplifying complex and advanced industrial tasks by implementing key mathematical tools/knowledge on Microsoft Excel platform. The following modules are covered using Microsoft Excel

Delivered entirely by capable facilitators with thorough, accurate and up-to-date knowledge .

Duration: Weekdays/weekends schedule (Call for time frame duration)
Venue: VOGW Concept, out station training is also available for client anywhere in the world
Cost: Confirm from the Management
Mode of Training: 99% practical
Prerequisite: Fundamental of computer knowledge with ability to reason logically

For more info Call :

Michael - 07034898577
Stan - 08133476558

Address: Suite 28, No 4 Irewole street,
Awosika B/S, Opebi Ikeja, Lagos State, Nigeria
Tel: 08133476558, 07085740887
Email: [email protected], [email protected]
website: www.Vogwconcept.Com

job for which this training is a pre-requisites
· Oil and Gas Industries
· Manufacturing Industries
· Banking and Business Industries
· Education Industries
· Data base Management
· Personal Consumption/Usage

pre-requisite for this training
· Personal Computer/Laptop – to be provided but preferably yours.
· Installed Microsoft Office package (at least 2007 version)
· basic knowledge in Excel usage
· Basic knowledge in Business Mathematics, Engineering/Scientific Mathematics

THE COURSE CONTENTS:

training module breakdown

MODULE 1

Fundamentals of Programming with VBA (Macros basics)
· Components of Visual Basic Statements
· Operators
· Variables
· Methods
· Objects,
· Properties
· Using Properties
· Functions
· Using Worksheet Functions with VBA
· Some Useful Methods
· Other Keywords
· Program Control
· Branching
· Logical Operators.
· Select Case
· Looping
· For Next Loop.
· Do While Loop etc

MODULE 2

Worksheet Functions for Working with Matrices
· Arrays, Matrices and Determinants
· Some Types of Matrices
· Excel's Built-in Matrix Functions
· Some Additional Matrix Functions

MODULE 3

Number Series
· Evaluating Series Formulas
· Using Array Constants to Create Series Formulas
· Using the ROW Worksheet Function to Create Series Formulas
· Examining the Values of Variables While in Break Mode
· An Introduction to Matrix Mathematics
· The INDIRECT Worksheet Function
· Using the INDIRECT Worksheet Function
· Using ROW Worksheet Function to Create Series Formulas
· The Taylor Series
· Numerical Method

MODULE 4

Interpolation
· Using the LOOKUP,VLOKUP and HLOOKUP Functions to Obtain Values from a Table
· Creating a Custom Lookup Formula to Obtain Values from a Table
· Linear Interpolation in a Table by Means of Worksheet Formulas
· Linear Interpolation in a Table by Means of a Custom Function
· Cubic Interpolation in a Table by Using the TREND Worksheet Function
· Linear Interpolation in a Two-way Table
· Cubic Interpolation in a Two-way Table
· Cubic Interpolation in a Two-way Table

MODULE 5

Differentiation
· Calculating First and Second Derivatives
· Using LINEST as a Fitting Function
· Derivatives of a Worksheet Formula
· The Finite-Difference Method
· The Newton Quotient
· Improving the VBA Function Procedure
· Second Derivative of a Worksheet Formula

MODULE 6

Integration
· Area under a Curve
· Calculating the Area under a Curve defined by table
· Calculating the Area under a Curve Defined by a Formula
· Area between Two Curves
· Integrating a Function
· Integrating a Function Defined by a Worksheet Formula
· Gaussian Quadrature
· Integration with an Upper or Lower Limit of Infinity
· Distance Traveled Along a Curved Path

MODULE 7

Roots of Equations
· A Graphical Method
· The Interval Method with Linear Interpolation
· The Interval-Halving or Bisection Method
· The Regula Fulsi Method with Correction for Slow Convergence
· The Newton-Raphson Method
· The Secant Method
· The Newton-Raphson Method Using Circular Reference and Iteration
· A Newton-Raphson Custom Function
· Using Goal Seek. to Find the Point of Intersection of Two Curves
· the Regula Fulsi Method)
· Bairstow's Method to Find All Roots of a Regular Polynomial
· Finding Values Other than Zeroes of a Function
· Using the Newton-Raphson Method to find the Point of Intersection of Two Lines
· Using the Newton-Raphson Method to Find Multiple Intersections of curves
· A Goal Seek Custom Function

MODULE 8

Systems of Simultaneous Equations
· Cramer's Rule
· Solving Simultaneous Equations by Matrix Inversion
· Solving Simultaneous Equations by Gaussian Elimination
· The Gauss-Jordan Method
· Solving Linear Systems by Iteration
· The Jacobi Method Implemented on a Worksheet
· The Gauss-Seidel Method Implemented on a Worksheet
· The Gauss-Seidel Method Implemented on a Worksheet
· Using Circular References
· A Custom Function Procedure for the Gauss-Seidel Method
· Solving Nonlinear Systems by Iteration
· Newton's Iteration Method
MODULE 9
Numerical Integration of Ordinary Differential Equations
Part I: Initial Conditions
· Solving a Single First-Order Differential Equation
· Euler's Method
· The Fourth-Order Runge-Kutta Method
· Runge-Kutta Method Applied to a Differential Equation
· Fourth-Order Runge-Kutta Custom Function
· Systems of First-Order Differential Equations
· For Systems of Differential Equations
· Predictor-Corrector Methods
· A Simple Predictor-Corrector Method
· Higher-Order Differential Equations
· Fourth-Order Runge-Kutta Custom Function
· Utilizing an Intentional Circular Reference

Part II: Boundary Conditions
Numerical Integration of Ordinary Differential Equations
· The Shooting Method.
o Deflection of a Simply Supported Beam
· Solving a Second-Order Ordinary Differential Equation
· By the Shooting Method and Euler's Method
· By the Shooting Method and the RK Method
· Finite-Difference Methods.
· A Limitation on the Finite-Difference Method
· Elliptic. Parabolic and Hyperbolic Partial Differential Equations
· Elliptic Partial Differential Equations
· Replacing Derivatives with Finite Differences
o Temperature Distribution in a Heated Metal Plate
· Parabolic Partial Differential Equations.
· Solving Parabolic Partial Differential Equations: The Explicit Method
o Heat Conduction in a Brass Rod
· The Crank-Nicholson or Implicit Method
o Vapor Diffusion in a Tube
· Vapor Diffusion in a Tube
· A Crank-Nicholson Custom Function
· Hyperbolic Partial Differential Equations
· Replacing Derivatives with Finite Differences
o Vibration of a String

MODULE 10

Linear Regression and Curve Fitting
· Linear Regression
· Least-Squares Fit to a Straight Line
· SLOPE, INTERCEPT and RSQ
· Least-Squares Fit to a Straight Line Using LINEST
· Multiple Linear Regression Using LINEST
· Handling Noncontiguous Ranges of known-x's in LINEST
· A LINEST Shortcut
· LINEST's Regression Statistics
· Linear Regression Using Trend line
· Limitations of Trend line
· Importing Trend line Coefficients into a Spreadsheet
· Using the Regression Tool in Analysis Tools
· Limitations of the Regression Tool

MODULE 11

Partial Differential Equations
· Solving Elliptic Partial Differential Equations
· Solving Parabolic Partial Differential Equations
· Solving Hyperbolic Partial Differential Equations
· Multiple Linear Regression
· Importing the Trend line Equation from a Chart into a Worksheet

MODULE 12

Nonlinear Regression Using the Solver
· Nonlinear Least-Squares Curve Fitting
· Introducing the Solver
· How the Solver Works
· Loading the Solver Add-In
· Why Use the Solver for Nonlinear Regression?
· Nonlinear Regression Using the Solver: An Example
· Some Notes on Using the Solver
· Some Notes on the Solver Options Dialog Box
· When to Use Manual Scaling
· Statistics of Nonlinear Regression
· The Solver Statistics Macro

MODULE 13

Random Numbers and the Monte Carlo Method
· Random Numbers in Excel
· How Excel Generates Random Numbers
· Adding "Noise" to a Signal Generated by a Formula
· Some Notes on the Solver Parameters Dialog Box
· Using Random Numbers in Excel
· Selecting Items Randomly from a List
· Random Sampling by Using Analysis Tools
· Simulating a Normal Random Distribution of a Variable
· Monte Carlo Simulation
· Monte Carlo Integration
· The Area of an Irregular Polygon

Presentation of Result and Project reporting / Project work

For more info Call :

Michael - 07034898577
Stan - 08133476558

Address: Suite 28, No 4 Irewole street,
Awosika B/S, Opebi Ikeja, Lagos State, Nigeria
Tel: 08133476558, 07085740887
Email: [email protected], [email protected]
website: www.Vogwconcept.Com