Title Engineering Analysis & Modeling with Excel-VBA v9.0.pdf ✅

© 2017 Matthew E. Moran Engineering Analysis & Modeling with Excel VBA: Course Notes 0 Engineering Analysis & Modeling with Excel VBA Version 9.0


© 2017 Matthew E. Moran Engineering Analysis & Modeling with Excel VBA: Course Notes 3 Table of Contents INTRODUCTION 1 Course Feedback 2 Table of Contents 3 Course Materials 7 Intended Audience & Use 8 How to Use These Notes 9 Instructor Bio 10 Course Summary 11 Learning Objectives 12 Topics: Getting Started 13 Topics: Design & Build 14 Topics: Refine & Optimize 15 Modeling Options 16 Advantages of Excel/VBA 17 Excel + VBA 18 Some Mac Tips 19 Basic Settings 20 Security Settings 21 EXCEL REVIEW 22 Appl: Simple Calc Sheet 23 Workbook Environment 24 Autofill & Absolute Refrs 25 Naming Cells & Ranges 26 Names Management 27 Add-Ins (Built-In) 28 Analysis ToolPak 29 Functions (Built-In) 30 Functions - Using 31 Sheet Structure & Linking 33 Cell Formatting 34 Equation Object 35 Graphics 38 Control Toolbox 40 Form vs ActiveX Controls 43 Ex 1: Convection Sheet 44 Ex 1: Hints 45 VBA INTRODUCTION 46 Appl: Another Calc Sheet 47 VBA – Accessing 48 Visual Basic Editor 49 Project & Properties 50 Modules 52 User Defined Functions 53 Sub Procedures 56 Functions vs Subs 59 Function & Sub Tips 60 Debugging Tools 61 Programming Aids 62 Variables – Declaring 63 Variables – Types 64 Variables – Tips 65 Object Structure 66 Object Oriented Prog 67 Recording Macros 68