The Complete Zero To Master Excel Vba And Macros

Learn how to snag the most in demand role in the tech field today!

What you'll learn
Basic Machine Learning Concepts
Requirements
No experience necessary
Description
This course is project-based so you will not be learning a bunch of useless coding practices. At the end of this course you will have real world apps to use in your portfolio. We feel that project based training content is the best way to get from A to B. Taking this course means that you learn practical, employable skills immediately.You can use the projects you build in this course to add to your LinkedIn profile. Give your portfolio fuel to take your career to the next level.Learn intermediate VBA skills in this hands on course. Only beginners VBA skills required.Hands On Lectures Including:Build projects with loops, a fundamental programming concept.Learn to manipulate strings to automate your Excel workflow.Build custom functions, including a calculator, to maximize your Excel potential.Build arrays, a key programming data structure, in VBA.Learn to work with dates to schedule procedures and much more.Work with the Application object to show progress, read and write data, and more.Learn to build a table of contents project to organize your worksheets.Build charts programatically.And much more!Learning how to code is a great way to jump in a new career or enhance your current career. Coding is the new math and learning how to code will propel you forward for any situation. Learn it today and get a head start for tomorrow. People who can master technology will rule the future.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Introduction to Loops

Lecture 2 Topics Overview

Lecture 3 Single Loop

Lecture 4 Double Loop

Lecture 5 Triple Loop

Lecture 6 Do While Loop

Lecture 7 Build A Commission Table

Lecture 8 Source Files

Section 3: Loop Projects

Lecture 9 Topics Overview

Lecture 10 Loop Through Defined Range

Lecture 11 Loop Through Entire Column

Lecture 12 Do Until Loop

Lecture 13 Use Step To Increment

Lecture 14 Build A Pattern Project

Lecture 15 How To Sort

Lecture 16 Sort By Related Data

Lecture 17 Delete Duplicate Values

Lecture 18 Source Files

Section 4: String Manipulation

Lecture 19 Topics Overview

Lecture 20 Join Strings

Lecture 21 Extract Substrings From Left Or Right

Lecture 22 Extract Substring At Middle

Lecture 23 Get Length Of A String

Lecture 24 Get Substring Position

Lecture 25 How To Split Strings

Lecture 26 Reverse Characters

Lecture 27 Change String Casing

Lecture 28 Count Words In A Range

Lecture 29 Source Files

Section 5: Build Custom Functions

Lecture 30 Topics Overview

Lecture 31 Make And Use Your Own Function

Lecture 32 Pass Arguments To A Function

Lecture 33 Custom Calculator Function

Lecture 34 Source Files

Section 6: Build Arrays

Lecture 35 Topics Overview

Lecture 36 One Dimensional Array

Lecture 37 Two Dimensional Array

Lecture 38 Change Array Size

Lecture 39 Build An Array

Lecture 40 Populate Row With Array

Lecture 41 Array Length

Lecture 42 Split String Into An Array

Lecture 43 Join Array Into A String

Lecture 44 Source Files

Section 7: Work with Dates

Lecture 45 Topics Overview

Lecture 46 Delay A Procedure

Lecture 47 Schedule A Procedure

Lecture 48 Count Years

Lecture 49 Count Days Between Dates

Lecture 50 Count Weekdays Between Dates

Lecture 51 Sort Dates

Lecture 52 Source Files

Section 8: Application Object

Lecture 53 Topics Overview

Lecture 54 How To Access Excel Functions

Lecture 55 Disable Screen Updating

Lecture 56 Disable Alerts

Lecture 57 Show Progress Of Macro

Lecture 58 Show Progress Of Macro

Lecture 59 Read Data From A File

Lecture 60 Write Data To A File

Lecture 61 Source Files

Section 9: VBA Projects

Lecture 62 Topics Overview

Lecture 63 Build A Table

Lecture 64 Build A Table Of Contents

Lecture 65 Build A Table Of Contents 2

Lecture 66 Combine Worksheets

Lecture 67 Combine Worksheets By Column

Lecture 68 Source Files

Section 10: Programming Charts

Lecture 69 Topics Overview

Lecture 70 Program A Chart

Lecture 71 Program An Embedded Chart

Lecture 72 Delete Charts Programmatically

Lecture 73 Source Files

Absolute beginners to programming,Developers transferring from other languages