Udemy

Platform

English

Language

Microsoft

Category

Microsoft Excel for Scientists and Engineers

Charting, Functions, Regression, Iterative Solutions, Matrix Operations, VBA, Numerical Integration, Differential Eq.

4.45 (148 reviews)

Microsoft Excel for Scientists and Engineers

21707

Students

7 hours

Content

Nov 2020

Last Update
$129.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, Using The CONVERT Function to Convert Units

Conditional Functions: Logical Expressions, Boolean Functions, IF Function, Creating a Quadratic Equation Solver, Table VLOOKUP Function

Regression Analysis: Trendline, Slope and Intercept, Interpolation and Forecast, The LINEST Function, Multilinear Regression, Polynomial Fit Functions, Residuals Plot, Slope and Tangent, Analysis ToolPack.

Iterative Solutions Using Excel: Using Goal Seek in Excel, Using The Solver To Find Roots, Finding Multiple Roots, Optimization Using The Solver, Minimization Analysis, NonLinear Regression Analysis

Matrix Operations Using Excel: Adding Two Matrices, Multiplying a Matrix by a Scalar, Multiplying Two Matrices, Transposing a Matrix, Inverting a Matrix and Solving System of Linear Equations.

VBA User-Defined Functions (UDF): The Visual Basic Editor (VBE), The IF Structure, The Select Case Structure, The For Next Structure, The Do Loop Structure, Declaring Variables and Data Types, An Array Function The Excel Object Model, For Each Next Structure.

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.



Description

This course uses Microsoft Excel 2016. It is intended for people in the fields of science and engineering.

It is designed to show you how to get your results in the best efficient way possible. Each exercise aim is to get you up and running with an excel feature.

Lots of topics including:

1- Charting: Create an XY scatter graph, XY chart with two Y-Axes, add error bars to your plot, create a combination chart

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

3- Conditional Functions: Logical Expressions, Boolean Functions, IF Function, Creating a Quadratic Equation Solver, Table VLOOKUP Function, AND, OR and XOR functions.

4- Regression Analysis: Trendline, Slope and Intercept, Interpolation and Forecast, The LINEST Function, Multilinear Regression, Polynomial Fit Functions, Residuals Plot, Slope and Tangent, Analysis ToolPack.

5- Iterative Solutions Using Excel: Using Goal Seek in Excel, Using The Solver To Find Roots, Finding Multiple Roots, Optimization Using The Solver, Minimization Analysis, NonLinear Regression Analysis.

6- Matrix Operations Using Excel: Adding Two Matrices, Multiplying a Matrix by a Scalar, Multiplying Two Matrices, Transposing a Matrix, Inverting a Matrix and Solving System of Linear Equations.

7- VBA User-Defined Functions (UDF): The Visual Basic Editor (VBE), The IF Structure, The Select Case Structure, The For Next Structure, The Do Loop Structure, Declaring Variables and Data Types, An Array Function The Excel Object Model, For Each Next Structure.

8- VBA Subroutines or Macros: Recording a Macro, Coding a Macro Finding Roots by Bisection, Using Arrays, Adding a Control and Creating User Forms.

9- Numerical Integration Using Excel: The Rectangle Rule, The Trapezoid Rule, The Simpson's Rule, Creating a User-Defined Function Using the Simpson's Rule.

10- Differential Equations: Euler's Method, Modified Euler's Method, The Runge Kutta Method, Solving a Second Order Differential Equation.

Enjoy and happy learning



Content

Introduction

Creating Your First Worksheet

Copying and Pasting

Using Auto Fill to Automatically Enter Data

Selection Techniques for Large Data Range

Inserting Cells

Charts

Creating an XY Scatter Graph

Formatting an XY Scatter Graph

XY Chart with Two Y-Axes

How to Add Error Bars to Your Plot

How to Create a Combination Chart

Using 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

Trendline, Slope and Intercept

Interpolation and Forecast

The LINEST Function

Multilinear Regression

A Polynomial Fit

Residuals Plot

Slope and Tangent

The Analysis ToolPack

Iterative Solutions Using Excel

Using Goal Seek In Excel

Using The Solver To Find a Root

Exercise Files

Exercise Files



Reviews

R
Ruen27 December 2020

It can be easily used by beginners although if you are already familiar with Excel, you would probably skip the first parts. If you are a college student with courses under engineering or other science-related ones, this might be the only class you need to master Excel for your needs.

A
Anil20 December 2020

Very smooth. I knew everything that was discussed here but the professor showed multiple ways of making that happen, which is appreciable


Coupons

StatusDateDiscount
Expired10/30/202080% OFF
Expired11/14/2020100% OFF
Expired12/16/202090% OFF
Expired12/20/2020100% OFF
Valid1/17/202192% OFF


3565253

Udemy ID

10/13/2020

Course created date

10/28/2020

Course Indexed date
Bot
Course Submitted by

Twitter
Telegram
Android PlayStore
Apple Appstore