Language

Category

# Microsoft Excel for Scientists and Engineers

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

4.45 (148 reviews) Students

Content

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

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 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

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

Udemy ID

## 10/13/2020

Course created date

## 10/28/2020

Course Indexed date
Bot
Course Submitted by