Excel Macros And Vba: Automate Your Excel Workload

Learn how to use the power of Excel Macros and VBA to automate and reduce you Excel workload to almost nothing!

What you'll learn

Automate your Excel workload

Impress your boss with your Excel wizardry!

Build your Resume by adding Excel Programming to your Skills

Requirements

Microsoft Excel

Basic Excel Skills (you know what rows and columns are)

Description

If you already use Excel, you know how repetitive and time consuming some tasks can be. This course is designed to teach you how to take those repetitive and time consuming Excel tasks, and make them happen in a click of a button! If you use Excel a lot in your work, this course is essential; it will reduce your workload significantly.
In this course you will learn:
What macros are and why you should use them.How to read and edit Visual Basic for Application code, and quickly edit macros.How to make conditional macros that work in a variety of situations.How to create macros that apply effects dynamically to large sets of Excel data.How to save enormous amounts of time by automating your Excel work.

Overview

Section 1: Welcome to Excel 2013: Macros!

Lecture 1 Introduction

Section 2: What is a Macro and when to Use Them?

Lecture 2 Identifying Applicable Situations for Using Macros

Lecture 3 More Macro Situations

Lecture 4 The Macro Recorder Example

Section 3: Let's Explore Visual Basic for Applications (VBA)!

Lecture 5 Overview of Other Techniques: Using VBA

Lecture 6 The Many Ways to Run a Macro

Lecture 7 The VBA Environment and Componets

Lecture 8 Creating a Simple Macro

Section 4: Unlock the True Power of Macros, Starting Here

Lecture 9 Expanding a Macro with the IF Statement

Lecture 10 Understanding when to Use Absolute and Relative References

Lecture 11 Using For Next Statements

Lecture 12 Using Do While and Do Until Statements

Section 5: Supplemental Lectures

Lecture 13 Relative vs. Absolute References

Lecture 14 Macro Code: Covert Clients to Database Format

Section 6: Was this Course Worth Your Money?

Lecture 15 How to Leave a Review

Lecture 16 How to Request a Refund

This course is meant for people who know how to use the basic features of Excel and want to unlock it's true power.