Master Excel Vba And Excel Macros

Learn Microsoft Excel VBA Fundamentals. Automate Complex Tasks with Microsoft Excel VBA & Excel Macros.

What you'll learn

Master Excel VBA & Macros

Learn best practices when creating macros and streamline your VBA code

Utilize the objects in the Excel Object Model to emulate user actions in Excel

Make your team work fast and better with efficient VBA tools

Requirements

Microsoft Excel

Description

You will obtain practical fluency in Visual Basic for Applications (VBA) specifically as it applies to Microsoft Excel. You will learn to automate and extend Excel by adding VBA projects to your workbooks. You will learn how to respond to workbook, worksheet and application events to automate macro execution. You will learn how it is possible to reach outside of Excel by way of VBA, in order to perform cross-application tasks. 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. Microsoft Excel VBA (Visual Basic for Applications) provides Excel users with the ability to automate any Excel task. Excel Tasks that would normally take an extensive amount of work and time to complete can ultimately be automated and completed in a single click of a button. All that's needed to automate your experience is a little Excel VBA knowledge.Maybe you've heard of Excel Macros and VBA. Or, maybe you've even attempted to create your own. Jumping into VBA can be a bit daunting and overwhelming. 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.

Overview

Section 1: VBA And Macros Training

Lecture 1 Overview - Macro

Lecture 2 Recording First Macro

Lecture 3 Special Selection Macro

Lecture 4 Absolute and Relative Cell Reference

Lecture 5 Copy Data Recording a Macro

Lecture 6 Various Ways of Running Macro

Lecture 7 Understanding VBA Model

Lecture 8 Color Differences and Keyboard shortcuts

Lecture 9 How to Refer to Range and Write to Cell in VBA

Lecture 10 Writing to Cells in VBA

Lecture 11 Most used Range Properties

Lecture 12 Most useful Properties and Methods

Lecture 13 Most useful Properties and Methods Continued

Lecture 14 Copy and Pasting Various Methods

Lecture 15 Different Ways to Reference Worksheet

Lecture 16 Referencing Worksheets Project

Lecture 17 Referencing Worksheets Project Continued

Lecture 18 Understanding Variables

Lecture 19 Variables Declaration

Lecture 20 Array Declaration

Lecture 21 Set Statement

Lecture 22 Variable Scope

Lecture 23 Understanding Collections and with end with

Lecture 24 With - End With Example

Lecture 25 For Each Loop Collections

Lecture 26 Protecting Sheet with Password

Lecture 27 If Then Statement

Lecture 28 Select Case Statement

Lecture 29 Go to Statement

Lecture 30 Sample Activity

Lecture 31 Assignment 2

Lecture 32 Basic VBA Functions

Lecture 33 VBA Functions

Lecture 34 MsgBox Function

Lecture 35 Input Box Function

Lecture 36 Input Box Excel

This Excel Macro/VBA course is meant for those that use Microsoft Excel and are looking to become more efficient by automating their daily Excel tasks. No prior programming experience is required.,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.