ProductivityTrending Courses

[100% OFF] Microsoft Excel for Scientists and Engineers

What you Will be taught ?

  • Creating Charts: an XY scatter graph, XY chart with two Y-Axes, add error bars to your plot, create a mix chart
  • Utilizing Features: Computing Sum, Common, Rely, Max and Min, Computing Weighted Common, Trigonometric Features, Exponential Features, Utilizing The CONVERT Perform to Convert Models
  • Conditional Features: Logical Expressions, Boolean Features, IF Perform, Making a Quadratic Equation Solver, Desk VLOOKUP Perform
  • Regression Evaluation: Trendline, Slope and Intercept, Interpolation and Forecast, The LINEST Perform, Multilinear Regression, Polynomial Match Features, Residuals Plot, Slope and Tangent, Evaluation ToolPack.
  • Iterative Options Utilizing Excel: Utilizing Objective Search in Excel, Utilizing The Solver To Discover Roots, Discovering A number of Roots, Optimization Utilizing The Solver, Minimization Evaluation, NonLinear Regression Evaluation
  • Matrix Operations Utilizing Excel: Including Two Matrices, Multiplying a Matrix by a Scalar, Multiplying Two Matrices, Transposing a Matrix, Inverting a Matrix and Fixing System of Linear Equations.
  • VBA Consumer-Outlined Features (UDF): The Visible Primary Editor (VBE), The IF Construction, The Choose Case Construction, The For Subsequent Construction, The Do Loop Construction, Declaring Variables and Knowledge Sorts, An Array Perform The Excel Object Mannequin, For Every Subsequent Construction.
  • VBA Subroutines or Macros: Recording a Macro, Coding a Macro Discovering Roots by Bisection, Utilizing Arrays, Including a Management and Creating Consumer Varieties.
  • Numerical Integration Utilizing Excel: The Rectangle Rule, The Trapezoid Rule, The Simpson’s Rule, Making a Consumer-Outlined Perform Utilizing the Simpson’s Rule.
  • Differential Equations: Euler’s Methodology, Modified Euler’s Methodology, The Runge Kutta Methodology, Fixing a Second Order Differential Equation.

Course Description

This course makes use of Microsoft Excel 2016. It’s supposed for individuals within the fields of science and engineering.

It’s designed to point out you get your ends in the most effective environment friendly manner attainable. Every train intention is to get you up and operating with an excel characteristic.

Plenty of matters together with:

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

2- Features: Computing Sum, Common, Rely, Max and Min, Computing Weighted Common, Trigonometric Features, Exponential Features, Utilizing The CONVERT Perform to Convert Models

3- Conditional Features: Logical Expressions, Boolean Features, IF Perform, Making a Quadratic Equation Solver, Desk VLOOKUP Perform, AND, OR and XOR capabilities.

4- Regression Evaluation: Trendline, Slope and Intercept, Interpolation and Forecast, The LINEST Perform, Multilinear Regression, Polynomial Match Features, Residuals Plot, Slope and Tangent, Evaluation ToolPack.

5- Iterative Options Utilizing Excel: Utilizing Objective Search in Excel, Utilizing The Solver To Discover Roots, Discovering A number of Roots, Optimization Utilizing The Solver, Minimization Evaluation, NonLinear Regression Evaluation.

6- Matrix Operations Utilizing Excel: Including Two Matrices, Multiplying a Matrix by a Scalar, Multiplying Two Matrices, Transposing a Matrix, Inverting a Matrix and Fixing System of Linear Equations.

7- VBA Consumer-Outlined Features (UDF): The Visible Primary Editor (VBE), The IF Construction, The Choose Case Construction, The For Subsequent Construction, The Do Loop Construction, Declaring Variables and Knowledge Sorts, An Array Perform The Excel Object Mannequin, For Every Subsequent Construction.

8- VBA Subroutines or Macros: Recording a Macro, Coding a Macro Discovering Roots by Bisection, Utilizing Arrays, Including a Management and Creating Consumer Varieties.

9- Numerical Integration Utilizing Excel: The Rectangle Rule, The Trapezoid Rule, The Simpson’s Rule, Making a Consumer-Outlined Perform Utilizing the Simpson’s Rule.

10- Differential Equations: Euler’s Methodology, Modified Euler’s Methodology, The Runge Kutta Methodology, Fixing a Second Order Differential Equation.

Take pleasure in and pleased studying

Coupon Code : FREEAPRIL2

Course Requirements

  • Primary understanding of the Excel Interface.
  • Statistics, Calculus, Differential Equations and Numerical Strategies.



Join us on telegram for Course Updates


Join Whatsapp Group for Daily Free Courses

Leave a Reply

Your email address will not be published. Required fields are marked *