|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-for-scientists-and-engineers/
课程评论：没有评论
课程名称：微软Excel用于科学家与工程师 课程概述： 本课程专为科学和工程专业人士设计，旨在提升数据分析技能和提高效率，使用的是微软Excel 2016。通过量身定制的练习，您将掌握必备的Excel功能，以在您的领域中脱颖而出。 主要内容包括： 1. **图表制作**：学习创建XY散点图、双Y轴图、误差条和组合图。 2. **函数使用**：掌握求和、平均值、计数、最大值、最小值、加权平均、三角函数、指数函数和单位转换等基础函数。 3. **条件函数**：理解逻辑表达式、布尔函数、IF函数、二次方程求解、VLOOKUP、AND、OR、XOR等条件函数的应用。 4. **回归分析**：学习趋势线、斜率、截距、插值、预测、LINEST、多元线性回归、多项式拟合、残差图及分析工具包的使用。 5. **迭代解法**：使用目标寻求、根求解器进行优化与最小化分析，掌握非线性回归技术。 6. **矩阵运算**：学习矩阵的加法、乘法、转置、逆以及线性方程求解。 7. **VBA用户自定义函数（UDF）**：掌握Visual Basic编辑器、IF结构、选择案例、循环、变量、数据类型和数组函数等。 8. **VBA子程序/宏**：学习宏记录、编码、通过二分法寻找根、数组、控件和用户表单的创建。 9. **数值积分**：掌握矩形法、梯形法、辛普森法以及使用辛普森法的用户自定义函数。 10. **微分方程**：学习欧拉法、改进的欧拉法、龙格-库塔法以及二阶微分方程的求解。 通过本课程的学习，您将提升数据分析能力，充分利用Excel在科学和工程应用中的强大功能。立即报名，开始一段充实的学习体验，掌握微软Excel在科学家与工程师中的应用！
Master Microsoft Excel for Scientists & Engineers: Efficient Data Analysis, Charting, Regression, VBA, and MoreThis 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:Charting: Create XY scatter graphs, dual Y-Axis charts, error bars, and combination charts.Functions: Compute Sum, Average, Count, Max, Min, Weighted Average, Trigonometric Functions, Exponential Functions, and Unit Conversion.Conditional Functions: Logical Expressions, Boolean Functions, IF Function, Quadratic Equation Solver, VLOOKUP, AND, OR, XOR.Regression Analysis: Trendline, Slope, Intercept, Interpolation, Forecast, LINEST, Multilinear Regression, Polynomial Fit, Residuals Plot, Analysis ToolPack.Iterative Solutions: Goal Seek, Solver for Roots, Multiple Roots, Optimization, Minimization Analysis, NonLinear Regression.Matrix Operations: Matrix Addition, Multiplication, Transpose, Inversion, and Solving Linear Equations.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.VBA Subroutines/Macros: Macro Recording, Coding, Finding Roots by Bisection, Arrays, Controls, User Forms.Numerical Integration: Rectangle Rule, Trapezoid Rule, Simpson's Rule, UDF using Simpson's Rule.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!
