Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Engineering Calculations using Microsoft Excel to your Wishlist.

Add to Wishlist

Engineering Calculations using Microsoft Excel

Learn how to write your own customized calculations in minutes
2.6 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
113 students enrolled
Last updated 4/2014
English
$19 $50 62% off
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
By the end of the course you will be able to perform daily engineering calculations using Microsoft Excel with ease
View Curriculum
Requirements
  • Microsoft Excel 2010 or 2013 including VBA installed, Microsoft Visio. As the course starts from Scratch and hence does not require any pre-requirements.
Description

As every Engineer needs to do many daily calculations especially using modern standards like EUROCODES, the need to write custom software solutions is more and more real. Especially if standards includes many complex formulas which are hardly calculated using pocket computers as it was 30 years ago. Then it came programmable pocket computers, I clearly remember as I had SHARP programmable computer, where it was possible to write a complex software, but you couldn’t print the results as it is possible now. So today it is possible just by using Microsoft Excel and it’s programming abilities to write real software which can solve all daily engineering calculations with ease.

What does engineer need?

So what does engineer need when creating calculations? First there are input parameters, which should be entered on a very simple and a quick way, then a simple sketch as a graphical representation of the basis of calculation with annotations of input parameters. After that engineer needs to define the mathematical procedure which could be very simple, but it should also enable him, to write also more complex formulas or iterations. This is very easy to do with Excel.

Course Structure

In this course I will show you that you do not need to be a software developer to create your own customized engineering calculations in a minutes. What is maybe the most important, you can update formulas in your calculation any time you want. This is the solution that every engineer needs, because it offers open-source solution with powerfull programable tools, but on the other side simple enough to be done instantly.

We will learn the following topics:
- How to create cells where input parameters should be entered
- How to create a sketch with anotations of input parameters
- How to prepare cells where results of calculation will be written
- How to create a push button, where you will trigger start of the calculation
- How to write code to perform calculation
- How to write code to display the results of calculation
- How to perform calculation

This course will also show you how to write the software for practical engineering calculation for structural analysis. I will show you in detail, how to enter data, define formulas and actually perform calculation, including how to display results and format cells for results of calculation.

I will provide you with an easy-to-follow material explanation, all steps including source code will be explained in detail.

Who is the target audience?
  • Course is intended for students, engineers, laboratories, research institutes and professionals who want to learn how to perform custom calculations using Microsoft Excel in minutes
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 20 Lectures Collapse All 20 Lectures 01:24:19
+
Introduction
1 Lecture 03:36
+
Visual Elements on Excel Sheet
4 Lectures 34:43

In this lecture we will learn what are input parameters and how to prepare Excel cells for entering them.

Preview 06:48

In this lecture we will learn how to prepare Excel cells for displaying the results of calculation.

Cells for results of calcullation
05:12

In this lecture we will learn how to draw a sketch in Microsoft Visio. We will draw a sketch example and learn main tools for drawing a sketch. Finally we will insert a sketch into MS Excel.

Sketch with annotations of input parameters
16:31

In this lecture we will learn how to visually create a push buton in Excel worksheet.

How to create a push button
06:12
+
How to Write Software Code
5 Lectures 15:29

In this lecture we will learn what is code editor and how we use it to write the code.

Code Editor
03:12

In this lecture we will learn what is Sub procedure and how we can create it.

Creating a Sub Procedure
02:14

In this lecture we will learn what are variables and how we can create them. We will learn also the difference between simple variables and arrays.

Creating Variables
05:09

In this lecture we will learn how to store input parameters which we entered into cells of Excel worksheet into variables, so that we can later use them in our calculation.

Reading input parameters
02:00

In this lecture we will learn how we enter formulas in code editor, so that excel can later make calculation.

Entering formulas
02:54
+
Calculation & Results
1 Lecture 04:14

In this lecture we will learn how to display results of calculation and how to perform calculation.

Displaying Results & Perform Calculation
04:14
+
Software Example for practical Engineering Calculation
8 Lectures 25:19

In this lecture we will present you the formulas of typical engineering application. You will learn the calculation procedure which we will use in our Excel worksheet.

An Introduction to Engineering Calculation
03:00

In this lecture we will learn how to prepare cells for input and output parameters for our calculation on Excel worksheet.

Cells for input and output parameters
04:55

In this lecture we will learn how to enter the Code Editor.

Entering Code Editor
01:58

In this lecture we will learn how to create simple and array variables and read data from Excel worksheet to variables.

Creating variables & Reading Data
03:35

In this lecture we will learn how to enter formulas into Code Editor.

Entering formulas
02:02

In this lecture we will learn the structure of the For Next loop and how to calculate the array values for different values of the index.

Entering the For Next Loop
02:35

In this lecture we will learn how to write an If statement to use conditional formula calculation.

Entering the If Statement
04:09

In this lecture we will learn how to display results and perform calculation for our Excel worksheet data.

Displaying Results & Perform Calculation
03:05
+
In Closing
1 Lecture 00:58
Thanks for joining the course!
00:58
About the Instructor
3.2 Average rating
12 Reviews
143 Students
2 Courses
Structural Engineer & Technology Consultant

As a Structural Engineer with more than 15 years’ experience in building industry I am currently teaching how to use Eurocodes as the most advanced building design codes on a world scale. I am teaching also how to use technology for solving daily engineering calculations, including software development as a support to structural engineering.

I have been working on project documentation for all types of building structures, reinforcement plans for RC structures, fabrication plans of steel structures, fire resistance calculation of building structures including consultation on the most appropriate fire protection. Based on years of experience and participation in post-earthquake reconstruction, I specialize in Earthquake Reconstruction and rehabilitation of buildings too.

I have all possible licenses for the design and revision of project documentation for building structures at Slovenian Chamber of Engineers. Kindly check my licence at the address Slovenian Chamber of Engineers.

I run a company for structural engineering in Slovenia / EU and I have also additional license for the revision of the project documentation for building structures. All my skills and qualifications, including years of experience in building industry can be seen at the following address www.grsoft.eu.

Report Abuse