Online Courses

Objective

• Learn the efficient use of different MS EXCEL features to carry out engineering tasks.

Who Will Benefit

• Engineers / Technologists
• Students
• Researchers

Course Detail

Introduction

• Creating A Worksheet
• Copy and Paste Option
• Using Auto Fill to Automatically Enter The Data
• Selection Techniques for Wide Data Range
• Inserting Cells

Charts

• Creating an XY Scatter Graph
• Formatting an XY Scatter Graph
• XY Chart with dual Y-Axes
• Add Error Bars In Plot
• Create a Combination Chart

Functions

• Computing Sum, Average, Count, Max and Min
• Computing Weighted Average
• Trigonometric Functions
• Exponential Functions
• Using The CONVERT Function to Convert Units

Conditional Functions

• Logical Expressions
• Boolean Functions
• Practical Example
• IF Function
• Creating a Quadratic Equation Solver
• Table VLOOKUP Function

Regression Analysis

• Trend-line, Slope and Intercept
• Interpolation and Forecast
• The LINEST Function
• Multilinear Regression
• A Polynomial Fit
• Residuals Plot
• Slope and Tangent
• Analysis Tool

Iterative Solutions

• Goal Seek In Excel
• Solver To Find a Root
• Finding Multiple Roots
• Optimization Using The Solver
• A Minimization Problem
• Non-Linear Regression

Matrix Operation

• Adding Two Matrices
• Multiplying a Matrix by a Scalar
• Multiplying Two Matrices
• Transposing a Matrix
• Inverting a Matrix
• Solving System of Linear Equations

VBA User-Defined Functions

• Visual Basic Editor (VBE)
• IF Structure
• Select Case Structure
• For Next Structure
• Excel Object Model
• For Each Next Structure
• Do Loop Structure
• Declaring Variables and Data Types
• An Array Function

VBA Subroutines (Macros)

• Recording a Macro
• Coding a Macro: Finding Roots by Bisection Method
• Adding a Control
• User Forms

Numerical Integration

• Rectangle Rule
• Trapezoid Rule
• Simpson’s Rule
• Creating a UDF for the Simpson’s Rule

Differential Equations

• Euler’s Method
• Modified Euler’s Method
• Runge-Kutta Method
• Solving a Second Order Differential Equation