Microsoft Excel for Scientists and Engineers

Microsoft Excel for Scientists and Engineers

What you’ll 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.

How to Enroll Microsoft Excel for Scientists and Engineers course?

  • To Access "Microsoft Excel for Scientists and Engineers" Click on Enroll Now button at end of the post. It will redirect you to Udemy Course Page and then you can start the enrollment process.
  • If you're New to Udemy? Sign up with your email and create a password. for Existing users, log in with your credentials to access course.
  • How many members can access this course with a coupon?

    Microsoft Excel for Scientists and Engineers Course coupon is limited to the first 1,000 enrollments. Click 'Enroll Now' to secure your spot and dive into this course on Udemy before it reaches its enrollment limits!

    External links may contain affiliate links, meaning we get a commission if you decide to make a purchase
    Deal Score0

    Unlock the future with learning!

    Exclusive new customer deal: Top courses from $14.99 on your first visit.

    Compare items
    • Total (0)
    Compare
    0