Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Online Business Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-03-16 13:53:57
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel

Microsoft Excel for Scientists and Engineers

If you are in the field of science or engineering, you can Excel with this Microsoft Excel course!!
Rating: 4.5 out of 54.5 (254 ratings)
41,495 students
Created by Prof. Samer
Last updated 3/2021
English
English [Auto]
30-Day Money-Back Guarantee

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.

Requirements

  • Basic understanding of the Excel Interface.
  • Statistics, Calculus, Differential Equations and Numerical Methods.

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

Who this course is for:

  • People in the fields of science and engineering

Course content

12 sections • 64 lectures • 7h 8m total length

  • Preview12:05
  • Copying and Pasting
    05:55
  • Using Auto Fill to Automatically Enter Data
    08:00
  • Selection Techniques for Large Data Range
    06:55
  • Inserting Cells
    04:07

  • Preview05:13
  • Formatting an XY Scatter Graph
    06:25
  • Preview06:22
  • How to Add Error Bars to Your Plot
    03:51
  • How to Create a Combination Chart
    06:20

  • Computing Sum, Average, Count, Max and Min
    06:04
  • Preview10:17
  • Trigonometric Functions
    08:21
  • Exponential Functions
    02:46
  • Using The CONVERT Function to Convert Units
    02:48

  • Logical Expressions
    03:46
  • Boolean Functions
    07:07
  • Practical Example
    05:26
  • IF Function
    03:54
  • Preview10:49
  • Table VLOOKUP Function
    05:35

  • Trendline, Slope and Intercept
    09:10
  • Preview04:18
  • The LINEST Function
    08:21
  • Multilinear Regression
    10:03
  • A Polynomial Fit
    08:13
  • Residuals Plot
    05:12
  • Slope and Tangent
    15:55
  • The Analysis ToolPack
    02:55

  • Using Goal Seek In Excel
    05:32
  • Using The Solver To Find a Root
    05:37
  • Finding Multiple Roots
    06:07
  • Optimization Using The Solver
    02:59
  • A Minimization Problem
    10:05
  • NonLinear Regression
    07:32

  • Adding Two Matrices
    03:04
  • Multiplying a Matrix by a Scalar
    02:23
  • Multiplying Two Matrices
    02:36
  • Transposing a Matrix
    01:56
  • Inverting a Matrix
    05:22
  • Solving System of Linear Equations
    03:33

  • The Visual Basic Editor (VBE)
    13:08
  • The IF Structure
    10:21
  • The Select Case Structure
    05:16
  • The For Next Structure
    09:24
  • The Excel Object Model
    12:22
  • The For Each Next Structure
    08:42
  • The Do Loop Structure
    07:52
  • Declaring Variables and Data Types
    05:28
  • An Array Function
    09:31

  • Recording a Macro
    06:45
  • Coding a Macro: Finding Roots by Bisection Method
    15:22
  • Using Arrays
    06:37
  • Adding a Control
    01:59
  • User Forms
    10:40

  • The Rectangle Rule
    06:30
  • The Trapezoid Rule
    02:47
  • The Simpson's Rule
    04:59
  • Creating a UDF for the Simpson's Rule
    08:28

Instructor

Prof. Samer
Professor of Mechanical Engineering
Prof. Samer
  • 4.5 Instructor Rating
  • 894 Reviews
  • 86,513 Students
  • 8 Courses

Samer is currently a Professor of Mechanical Engineering. He has ten years of teaching experience in thermo-fluid courses which include:

1-Engineering Thermodynamics

2-Heat Transfer

3-Internal Combustion Engines

4-Fluid Mechanics

5-HVAC

6-Power Plant Engineering

7-Solar Engineering

8-Computational Fluid Dynamics CFD

Moreover, Prof. Samer is involved in a wide research projects in Computational Fluid Dynamics (CFD), Fluid-Structure Interaction and numerical simulations applied to multi-functional heat exchangers/reactors. Prof. Samer has authored and co-authored several highly cited journal publications, conferences in the aforementioned topics.


  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.