The Complete Zero To Master Excel Vba And Macros
Last updated 10/2020
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.65 GB | Duration: 5h 13m​
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



=================================
*
*

=================================