Ultimate Excel VBA
What you’ll learn
Course Goal: You will obtain practical fluency in Visual Basic for Applications (VBA) specifically as it applies to Microsoft Excel.
Course Objectives: 1) You will learn to automate and extend Excel by adding VBA projects to your workbooks. 2) You will learn to enhance, customize and extend the Excel user interface through modifications to the Excel environment, the creation of custom user forms, and the use of ActiveX controls. 3) You will learn how to respond to workbook, worksheet and application events to automate macro execution. 4) You will learn how it is possible to reach outside of Excel by way of VBA, in order to perform cross-application tasks.
Requirements
Microsoft Excel (2007-2013)
Description
This is an introductory course on how to program Excel using VBA macros. You will learn to automate and extend the Excel environment to supercharge your Excel models, automate routine tasks, customize your user interface, and manage large quantities of data. This course is based on the instructor’s semester-long college courses which have produced thousands of graduates in the fields of business, finance, health care and public policy. Designed for busy professionals who need to take their Excel abilities to the next level, you will not waste time on topics which you are unlikely to use, and you will receive extra attention to the often confusing or overlooked details that will make the most difference to your ultimate understanding. Over 8 hours of instruction!
Overview
Section 1: Introduction
Lecture 1 Course Overview
Lecture 2 Macro Recording Basics
Lecture 3 The VBA Editor
Section 2: The Excel Object Library
Lecture 4 VBA & The Object Library
Lecture 5 Objects and Properties
Lecture 6 Objects and Methods
Lecture 7 More about Objects and Properties
Lecture 8 Referencing a Range
Lecture 9 Important Range Properties
Lecture 10 The Worksheets Collection
Lecture 11 The Workbooks Collection
Lecture 12 Exploring the Object Library
Section 3: The VBA Language
Lecture 13 Simple Input & Output
Lecture 14 Variables & Data Types
Lecture 15 Object Type Variables
Lecture 16 VBA & Worksheet Functions
Lecture 17 User-Defined Functions
Lecture 18 Branching: IF…THEN
Lecture 19 Branching: SELECT…CASE
Lecture 20 Looping: DO…LOOP
Lecture 21 Looping: FOR…NEXT
Lecture 22 Looping: FOR…EACH
Lecture 23 Variable Scope
Lecture 24 Error Handling
Lecture 25 Project 1 – The VBA Language
Section 4: Launching Macros: Events & Shortcuts
Lecture 26 Macro Launching Shortcuts
Lecture 27 Modifying the Ribbon
Lecture 28 Workbook & Worksheet Events
Lecture 29 Application Events
Lecture 30 Project 2 – Event Handling
Section 5: Modifying the User Interface
Lecture 31 Enhanced Message Box
Lecture 32 ActiveX & The Worksheet (No Code)
Lecture 33 ActiveX & The Worksheet (With Code)
Lecture 34 Basic User Forms
Lecture 35 Project 3 – User Forms & ActiveX
Section 6: What’s Next?
Lecture 36 Reaching Beyond Excel
This is an introductory programming course, so no previous programming experience is assumed. The student should be at least moderately comfortable with Excel. The more prior exposure to Excel you have the more you will get out of the course, but you do not need to be an Excel expert to take the course.
Course Information:
Udemy | English | 8h 33m | 3.51 GB
Created by: Mark Talbert
You Can See More Courses in the Office Productivity >> Greetings from CourseDown.com