Ultimate Excel VBA

Programming for the Business Professional
Ultimate Excel VBA
File Size :
3.51 GB
Total length :
8h 33m

Instructor

Mark Talbert

Language

Last update

Last updated 8/2013

Ratings

4.5/5

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.

Ultimate Excel VBA

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

New Courses

Scroll to Top