Apply Excel Vba In Industry Series Part I

Last updated 8/2022
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz

Learn & retain Excel VBA by solving REAL LIFE challenges in Professional Industry. Boost productivity through automation

What you’ll learn

Apply Excel VBA in Industry, I’ll use REAL LIFE examples for Industry. Every example I present is an actual case that is used in industry.

Save time by Automation! Your daily tasks will take very little time as opposed to what they do today.

Stand out and be the go-to person about VBA. Develop ideas by the end of the course of how Excel VBA can be applied in your work/school.

Don’t waste time organizing data, instead focus and reflect more on what the data is telling you. Invest your time in tasks that will benefit YOU.

Learn, Apply and Teach is the best method in order to truly master any skill – and this is the method i will use

By the end of the course you’ll be able to pass on basic Excel VBA knowledge to your peers.

Requirements

Frequent Exposure to Microsoft Excel. You have to have some preliminary knowledge of how Excel works

Description

Overview

Section 1: Personal & Course Introduction

Lecture 1 Introduction & Course Structure

Section 2: Excel VBA Background

Lecture 2 Why use Excel VBA ?

Lecture 3 What is Excel VBA? And how does it Work?

Section 3: VBA Intro

Lecture 4 Add Developer to Excel

Lecture 5 "I’m Going to Master This"

Lecture 6 The most common: Copy & Paste – how it’s done in code

Lecture 7 Arithmetic [Add, Divide, Multiply, Substract] in Excel VBA

Lecture 8 MsgBox – a convenient way to display information to the user

Lecture 9 Input Box – Ask for user input

Lecture 12 "For" the love of VBA

Lecture 13 The "IF" Statement

Lecture 14 Select Case

Lecture 15 Calculate cycle times for each product on the assembly line

Lecture 16 Put Together Production Challenge Results

Lecture 17 Accounts Receivable: Develop an optimized collection strategy
Lecture 18 Accounts Payable: Optimized Procurement Strategy
Lecture 20 Payroll Earnings Processing

Lecture 21 Lec21/Assignment 6

Section 9: Course Takeaways

Lecture 22 Rule of thumb on Excel VBA, and when is it not worth it?

Lecture 23 When you’re stuck – Record a Macro

No to little exposure or beginner level Excel VBA developers.