Microsoft Excel for Scientists and Engineers

Unlock Excel's Potential: Data Analysis, Charting, and Advanced Techniques for Science & Engineering Professionals

Created by: Prof. Samer
Professor of Mechanical Engineering

What Will I Learn?

• Creating Charts: an XY scatter graph, XY chart with two Y-Axes, add error bars to your plot, create a combination chart
• Using Functions: Computing Sum, Average, Count, Max and Min, Computing Weighted Average, Trigonometric Functions, Exponential Functions, CONVERT Function...
• Conditional Functions: Logical Expressions, Boolean Functions, IF Function, Creating a Quadratic Equation Solver, Table VLOOKUP Function
• Regression Analysis: Trendline, Interpolation and Forecast, The LINEST Function, Multilinear Regression, Polynomial Fit Functions, Residuals Plot
• Iterative Solutions Using Excel: Using Goal Seek in Excel, Using The Solver To Find Roots, Finding Multiple Roots, Optimization Using The Solver, Minimization
• Matrix Operations Using Excel: Adding, Multiplying by a Scalar, Multiplying Two Matrices, Transposing, Inverting and Solving System of Linear Equations.
• VBA User-Defined Functions (UDF): The IF Structure, Select Case, For Next, Do Loop, Declaring Variables and Data Types, The Excel Object Model, For Each Next
• VBA Subroutines or Macros: Recording a Macro, Coding a Macro Finding Roots by Bisection, Using Arrays, Adding a Control and Creating User Forms.
• Numerical Integration Using Excel: The Rectangle Rule, The Trapezoid Rule, The Simpson's Rule, Creating a User-Defined Function Using the Simpson's Rule.
• Differential Equations: Euler's Method, Modified Euler's Method, The Runge Kutta Method, Solving a Second Order Differential Equation.

Requirements

• Basic understanding of the Excel Interface.
• Statistics, Calculus, Differential Equations and Numerical Methods.

Target audience

• People in the fields of science and engineering