ME Online

Computer-Aided Computations (ME 1101/L)

In this course, students learn the fundamentals of Excel spreadsheets and computer programming using the Visual Basic for Applications (VBA) language. Students also learn the fundamentals of MATLAB and some numerical methods tools. There is a video for every Excel VBA topic.

1.1 - Getting started in Excel (8:33)
1.2 - Order of operations (3:38)
1.3 - Defining cell names (5:33)
1.4 - Built-in functions in Excel (5:57)
1.5 - Relative vs absolute references in Excel (17:07)
1.6 - Plotting in Excel (5:00)

Same videos in a playlist: Videos 1.1 - 1.6

2.1 - Accessing the VBA environment (4:48)
2.2 - Creating your first macro (6:38)
2.3 - Variables (10:59)
2.4 - Message boxes & input boxes (8:09)
2.5 - Absolute vs relative references in VBA (6:49)
2.6 - Recording macros (5:20)
2.7 - Making better use of space in VBA (1:54)

Same videos in a playlist: Videos 2.1 - 2.7

3.1 - Data types (8:53)
3.2 - Constant variables (3:03)
3.3 - Built-in functions in VBA (1:33)

Same videos in a playlist: Videos 3.1 - 3.3


4.1 - Introduction to Sub procedures (5:25)
      4.1.1 - Example: Calling a Sub procedure (10:19)
      4.1.2 - Example: Reusing Sub procedures (10:17)

Same videos in a playlist:  Videos 4.1 - 4.3

5.1 - Introduction to Function procedures (9:20)
5.2 - Customized worksheet functions (5:27)
5.3 - Procedures within procedures (10:21)

Same videos in a playlist: Videos 5.1 - 5.3

6.1 - Relational and logical operators (10:31)
6.2 - If-Then structures (3:46)
6.3 - If-Then-Else structures (3:46)
6.4 - If-Then-ElseIf structures (6:50)
6.5 - Select Case structures (4:44)
6.6 - Flowcharts (3:23)
6.7 - Nested decision structures (6:10)

Same videos in a playlist: Videos 6.1 - 6.7

7.1 - Introduction to repetitive execution (1:50)
7.2 - For loops (12:50)
7.3 - Do While & Do Until loops (7:45)
7.4 - Nested loops (5:08)
7.5 - Loops and the Excel workbook environment (7:46)

Same videos in a playlist: Videos 7.1 - 7.5

8.1 - Introduction to UserForms (16.28)
8.2 - Example using OptionButtons and a ComboBox (12:13)

Same videos in a playlist: Videos 8.1 - 8.2

9.1 - 1D arrays (11:26)
9.2 - Multidimensional arrays (9:09)
9.3 - Passing arrays to procedures (5:05)
9.4 - Dynamic memory allocation (3:04)

Same videos in a playlist: Videos 9.1 - 9.4