Udemy

Microsoft Excel for Scientists and Engineers

立即報名
  • 47,301 名學生
  • 更新於 3/2021
  • 可獲發證書
4.4
(546 個評分)
  • 提示:
  • 透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。

課程資料

報名日期*
全年招生
課程級別
學習模式
修業期
7 小時 8 分鐘
教學語言
英語
授課導師
Prof. Samer
證書
  • 可獲發
  • (證書的發放與分配,依課程提供者的政策及安排而定。)
評分
4.4
(546 個評分)
課程連結
*提示: 以上時間表僅供參考,以機構網站為準。

課程簡介

Microsoft Excel for Scientists and Engineers

Unlock Excel's Potential: Data Analysis, Charting, and Advanced Techniques for Science & Engineering Professionals

Master Microsoft Excel for Scientists & Engineers: Efficient Data Analysis, Charting, Regression, VBA, and More

This course in Microsoft Excel 2016 is designed specifically for professionals in science and engineering, aimed at optimizing your data analysis skills and improving efficiency. With exercises tailored to essential Excel features, you'll gain the knowledge you need to excel in your field.

Key topics include:

  1. Charting: Create XY scatter graphs, dual Y-Axis charts, error bars, and combination charts.

  2. Functions: Compute Sum, Average, Count, Max, Min, Weighted Average, Trigonometric Functions, Exponential Functions, and Unit Conversion.

  3. Conditional Functions: Logical Expressions, Boolean Functions, IF Function, Quadratic Equation Solver, VLOOKUP, AND, OR, XOR.

  4. Regression Analysis: Trendline, Slope, Intercept, Interpolation, Forecast, LINEST, Multilinear Regression, Polynomial Fit, Residuals Plot, Analysis ToolPack.

  5. Iterative Solutions: Goal Seek, Solver for Roots, Multiple Roots, Optimization, Minimization Analysis, NonLinear Regression.

  6. Matrix Operations: Matrix Addition, Multiplication, Transpose, Inversion, and Solving Linear Equations.

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

  8. VBA Subroutines/Macros: Macro Recording, Coding, Finding Roots by Bisection, Arrays, Controls, User Forms.

  9. Numerical Integration: Rectangle Rule, Trapezoid Rule, Simpson's Rule, UDF using Simpson's Rule.

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

By the end of this course, you will have enhanced your data analysis capabilities and harnessed the power of Excel for scientific and engineering applications.

Enroll now for a rewarding learning experience and master Microsoft Excel for scientists and engineers!

課程章節

  • 12 個章節
  • 64 堂課
  • 第 1 章 Introduction
  • 第 2 章 Charts
  • 第 3 章 Using Functions
  • 第 4 章 Conditional Functions
  • 第 5 章 Regression Analysis
  • 第 6 章 Iterative Solutions Using Excel
  • 第 7 章 Matrix Operations In Excel
  • 第 8 章 VBA User-Defined Functions (UDFs)
  • 第 9 章 VBA Subroutines (Macros)
  • 第 10 章 Numerical Integration
  • 第 11 章 Differential Equations
  • 第 12 章 Exercise Files

課程內容

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


評價

  • s
    salim yagoub
    3.5

    i have to rate this course as good because i learned many staff but topics didn't match my expectations, so check the topics and see if they match your interests first, the instructor is great and his english is very understandable.

  • S
    Shane Malai
    4.0

    The course is a great foundation for Aspiring Engineers who specialize in Analysis and Design. I appreciate the course composer. Great Course! Thanks

  • S
    Sebastian Binder
    3.0

    Better micro pls

  • s
    siddhi chheda
    5.0

    its superb

立即關注瀏覽更多

本網站使用Cookies來改善您的瀏覽體驗,請確定您同意及接受我們的私隱政策與使用條款才繼續瀏覽。

我已閱讀及同意