Microsoft Excel for Scientists and Engineers
Unlock Excel's Potential: Data Analysis, Charting, and Advanced Techniques for Science & Engineering Professionals
4.45 (520 reviews)
47,198
students
7 hours
content
Mar 2021
last update
$59.99
regular price
What you will 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.
3565253
udemy ID
10/13/2020
course created date
10/28/2020
course indexed date
Bot
course submited by