Computer Programming with Excel VBA by mor | Jul 28, 2021 Current Status Not Enrolled Price 157 Get Started Take this Course Course Content Introduction Course Structure and Contents Sample Lesson Why Learn Excel VBA and SQL? Sample Lesson Writing Your First VBA Program: Hello Sample Lesson Computer Programming Fundamentals Section Intro What Is a Computer Program Computer Language Structure and Elements Main Data Types Software Applications Architecture Quiz: Computer Programming Fundamentals Summary: Computer Programming Fundamentals VBA: The Building Blocks Section Intro Requirements and Setup Sample Lesson Getting Familiar with the VBA Editor Referencing Excel Cells, Ranges Referencing Rows Columns Worksheets The Immediate Window The Excel Object Model, Collections Properties, Methods, Events The Macro Recorder Applying Objects Formatting Range Selection, Copy, Paste Assignment: Employees Table by Region Assignment Solution: Employees Table by Region Data Storage Numeric Variables Non-Numeric Variables Working with Excel Objects Subroutines and Functions Working with Strings Working with Dates Variables Scope and Lifetime Constants User Defined Functions Application Events Debugging Tools Quiz: VBA Building Blocks Section Summary: VBA Building Blocks VBA: Programming Techniques Section Intro Conditional Program Flow Loops Assignment: A Dynamic Certificates Generator Assignment Solution: A Dynamic Certificates Generator 1-D Arrays 2-D Arrays ParamArray Application Behavior Control User Interaction User Collections Enumerations User Defined Types Data Structures Summary Error Handling Sample Lesson Assignment: Purchase Orders Enquiary Tool Assignment Solution: Purchase Orders Enquiary Tool – Part 1 Assignment Solution: Purchase Orders Enquiary Tool – Part 2 Quiz: VBA Programming Course Summary: Computer Programming with Excel VBA
