Automation With Excel Macros / Vba - Beginner To Advanced

0nelove · Jul 29, 2024

Last updated 4/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.36 GB | Duration: 5h 51m

programming and automation using Microsoft Excel with its' macro and VBA coding functionality
What you'll learn
It will walk you through essential concepts and slowly demonstrate some powerful automation that this skill can bring to your clerical computer-based tasks.
It will automate processes at your business or job.
React dynamically to user events like entering a cell value or opening a workbook
Acquire critical Excel knowledge within the first 2 hours of tutorials.
Learn all about: tables, charts, formatting, formulas and functions, macros, pivot tables/charts, and much more!
Requirements
This class will introduce you to the concepts of programming and automation using Microsoft Excel with its' macro and VBA coding functionality. The beginning is suitable for beginners who have never done any programming before. It is an excellent introduction to Excel Macros and also programming in general with transferrable knowledge for other programming languages.
No experience needed. You'll learn everything you need to know right from the beginning.
This course is compatible with any version of Excel. Including Excel in Microsoft Office 365.
Anyone interested in becoming the coolest Excel ninja ever!
Description
The class project will take a list of numbers and then move only the numbers that are less than 10 to a new list with the click of a button.Lessons on more advanced topics will continue past the video for this introductory project.I appreciate your patience while I continue to build this course library!Class Description:This class will introduce you to the concepts of programming and automation using Microsoft Excel with its' macro and VBA coding functionality. The beginning is suitable for beginners who have never done any programming before. It is an excellent introduction to Excel Macros and also programming in general with transferrable knowledge for other programming languages.It will walk you through essential concepts and slowly demonstrate some powerful automation that this skill can bring to your clerical computer-based tasks.As the class continues, I will introduce increasingly advanced concepts. I will bring you along as I create example projects that combine and utilize the concepts discussed in earlier lessons.The approximate structure of the course is that the lessons at the beginning will teach you individual concepts shown by themselves. These are the building blocks. The later lessons will show example projects where I demonstrate and explain every step of building example tools that could automate processes at your business or job.Please feel free to contact me with any questions and leave a review. Thank you for any time you spend watching! If you leave a question in the discussion, I'd be happy to answer it and maybe even record a video lesson for the answer.
Overview
Section 1: 介绍
Lecture 1 1. Introduction
Section 2: Excel VBA Concepts
Lecture 3 1.2 Recording Macros
Lecture 4 1.3 Saving XLSM file type
Lecture 5 1.4 Viewing Your Code
Lecture 6 1.5 VBA Editor Message Box
Lecture 7 1.6 Cell Referencing
Lecture 8 1.7 Naming a Cell
Lecture 9 1.8 Create a Folder
Lecture 10 1.9 Error Debugging
Lecture 11 1.10 Writing Data to Cell
Section 3: Variant
Lecture 12 1.11 Variables
Lecture 13 1.12.1 Basic Math Integers
Lecture 14 1.12.2 Integer vs Long
Lecture 15 1.13 If Statements
Lecture 16 1.14 For Loop
Lecture 17 1.15 For Loops Continued Automation!
Lecture 18 1.A Class Project 01 Description and Tutorial
Lecture 19 1.16 Esc Key to Stop Macro
Lecture 20 1.17.1 Do While Loop Intro
Lecture 21 1.17.2 Do While Loop Use Case
Lecture 22 1.17.3 For Each Loop Intro
Lecture 23 1.17.4 Variant Variable Type
Lecture 24 1.17.5 For Each Loop using Variant
Lecture 25 1.18.1 Object Variables - Set - Intro
Lecture 26 1.18.2 Object Vars - Declare + Read All Files in Folder
Lecture 27 1.19.1 Workbook Object
Lecture 28 1.19.2 Worksheet Object
Lecture 29 1.20 Reference Libraries Word Object Intro
Lecture 30 1.21.1 Calling Sub From Another Sub
Lecture 31 1.21.2 Call Sub with a Parameter
Lecture 32 1.21.3 Call Sub with Multiple Parameters
Lecture 33 1.21.4 Sub with Optional Parameter
Lecture 34 1.22 Functions Intro
Lecture 35 1.23 With Statement
Lecture 36 1.24.1 Error Catching - Intro - On Error
Lecture 37 1.24.2 GoTo - Code Bookmark
Lecture 38 1.24.3 On Error Goto Bookmark
Lecture 39 1.24.4 On Error - Persistence and Reset
Lecture 40 1.C.1 Automate Creating Txt Files
Lecture 41 1.C.2 Automate Rename Files Fix
Section 4: Moving Data
Lecture 42 2.1 Moving Data - Create Form Record Macro
Lecture 43 2.2 Moving Data - Name the Ranges
Lecture 44 2.3 Moving Data - Simplify Recorded Code
Lecture 45 2.4 Moving Data - Paste Values Only
Lecture 46 2.5 Moving Data - Without Copy and Paste
Lecture 47 2.6 Moving Data - Writing to Next Row
Lecture 48 2.7 Moving Data - Add Timestamp
Lecture 49 2.8 Moving Data - Writing to Different Sheet
Lecture 50 2.9 Moving Data - Tidy up
Lecture 51 2.10 Moving Data - Validation Before Process
Lecture 52 2.11 Named Table Object (List Object)
Lecture 53 2.11.1 ListObjects (Table) - VBA Intro
Lecture 54 2.11.2 ListObjects - ListRows and Looping
Lecture 55 2.11.3 ListObjects - ListColumns and Row Values
Lecture 56 2.11.4 Excercise - Delete Certain Rows
Lecture 57 2.11.5 Excercise - Delete Certain Rows Lvl2
Lecture 58 2.12 Moving Data Add Row w ListObject
Anyone interested in becoming a proficient Excel user.,Anyone who would like to integrate the power of Excel into their personal or professional life.,Anyone who wants to add a truly valuable (and timeless) skill to their current skill set.
Screenshots

Buy Premium From My Links To Get Resumable Support and Max Speed

Download file Automation_with_Excel_Macros_VBA_Beginner_to_Advanced.part1.rar

Download Automation_with_Excel_Macros_VBA_Beginner_to_Advanced.part1.rar fast and secure

rapidgator.net

Download file Automation_with_Excel_Macros_VBA_Beginner_to_Advanced.part2.rar

Download Automation_with_Excel_Macros_VBA_Beginner_to_Advanced.part2.rar fast and secure

rapidgator.net

Download file Automation_with_Excel_Macros_VBA_Beginner_to_Advanced.part3.rar

Download Automation_with_Excel_Macros_VBA_Beginner_to_Advanced.part3.rar fast and secure

rapidgator.net

Download Automation with Excel Macros VBA Beginner Advanced part1 rar

Download File Automation with Excel Macros VBA Beginner Advanced part1 rar

ddownload.com

Download Automation with Excel Macros VBA Beginner Advanced part2 rar

Download File Automation with Excel Macros VBA Beginner Advanced part2 rar

ddownload.com

Download Automation with Excel Macros VBA Beginner Advanced part3 rar

Download File Automation with Excel Macros VBA Beginner Advanced part3 rar

ddownload.com

Automation With Excel Macros / Vba - Beginner To Advanced

Currently reading: Automation With Excel Macros / Vba - Beginner To Advanced

0nelove

Download file Automation_with_Excel_Macros_VBA_Beginner_to_Advanced.part1.rar

Download file Automation_with_Excel_Macros_VBA_Beginner_to_Advanced.part2.rar

Download file Automation_with_Excel_Macros_VBA_Beginner_to_Advanced.part3.rar

Download Automation with Excel Macros VBA Beginner Advanced part1 rar

Download Automation with Excel Macros VBA Beginner Advanced part2 rar

Download Automation with Excel Macros VBA Beginner Advanced part3 rar

"S'all Good, Man."​

"Perfection Is The Enemy Of Perfectly Adequate."​

"Money Is The Point!"​

"I Travel In Worlds You Can't Even Imagine."​

"Say Nothing, You Understand? Get A Lawyer!"​

“Confidence is good. Facts on your side, better.” ​

“Facts are facts.”​

“Sometimes the good guys win.”​

“I’m not good at building shit, you know? I’m excellent at tearing it down.”​

“Money is not beside the point… Money is the point.”​

“Whoa, whoa. Hold up. What the hell happened to you? I get it, the first rule of Fight Club, right?”​

“A good magician never reveals his secrets.”​

“Got to look successful to be successful.”​

“The lesson is, if you’re gonna be a criminal, do your homework.” ​

“If I had to do it all over again, I would maybe do some things differently. I just thought you should know that.”​

“Some men aren't looking for anything logical. They can't be bought, bullied, reasoned or negotiated with. Some men just want to watch the world burn.”​

"Ernest Hemingway once wrote, "The world is a fine place and worth fighting for." I agree with the second part."​

“There’s no better way to destroy someone’s life than to uncover their secrets.”​

“Hackers are breaking the systems for profit. Before, it was about intellectual curiosity and pursuit of knowledge and thrill, and now hacking is big business.”​

“Hackers often describe what they do as playfully creative problem-solving.”​

“Computer hackers do not need to know each other’s real names, or even live on the same continent, to steal millions in mere hours."​

“While many hackers have the knowledge, skills, and tools to attack computer systems, they generally lack the motivation to cause violence or severe economic or social harm.”​

“Very smart people are often tricked by hackers, by phishing. I don’t exclude myself from that. It’s about being smarter than a hacker. Not about being smart.”​

“At the end of the day, my goal was to be the best hacker.”​

“Humiliation is the favorite currency of the hacker.”​

“The hacker didn’t succeed through sophistication. Rather he poked at obvious places, trying to enter through unlocked doors. Persistence, not wizardry, let him through.”​

"Rules. Without Them We Live With The Animals.”​

“Consider This A Professional Courtesy.”​

"I've Lived My Life My Way, And I'll Die My Way."​

"You stabbed the devil in the back, and forced him back into the life that he had just left."​

"You Want A War, Or Do You Want To Just Give Me A Gun?"​

"Leave one wolf alive and the sheep are never safe."​

"When you play the game of thrones, you win or you die. There is no middle ground."​

"It's not easy to see something that’s never been before: A good world."​

"I believe in second chances. I don't believe in third chances."​

"If you only trust the people you grew up with, you won't make many allies."​

"A man with no motive is a man no one suspects. Always keep your foes confused: If they don't know who you are, what you want—they can't know what you plan to do next."​

"Never forget what you are, the rest of the world will not. Wear it like armor and it can never be used to hurt you."​

"I try to know as many people as I can. You never know which one you'll need."​

"It's hard to put a leash on a dog once you've put a crown on its head."​

“Everything before the word ‘but’ is horseshit.”​

“A lion doesn’t concern himself with the opinions of a sheep.”​

“Nothing FUCKS you harder than time.”​

“You pray for rain, you gotta deal with the mud too. That’s a part of it.”​

“I’d be more frightened by not using whatever abilities I’d been given.”​

“Luck is where opportunity meets preparation.”​

“If you have an enemy, then learn and know your enemy, don’t just be mad at him or her.”​

“Every failed experiment is one step closer to success.”​

When you work on a computer your hands travel 20 kilometres a day!​

Fugaku supercomputer is the world’s fastest computer. The $1-billion supercomputer has 7,630,848 cores, requires 29,899 kilowatts of electricity, and can execute 442,010 teraFLOPs.​

“Every day, about 317 million new viruses are discovered.​

“Microsoft’s founder, the infamous Bill Gates, was actually a college dropout."​

Did you know?​

“On average, a human blinks 20 times per minute, but using a computer reduces it to 7."​

Did you know?​

“The most common password for a computer and social media platforms is 123456."​

Did you know?​

“There are eight varieties of computers: mainframe, supercomputer, workstation, personal computer, Apple Macintosh, laptop, tablet, and smartphone."​

Did you know?​

“Linux leads the industry as it is used by Google, Facebook, Twitter, and Amazon."​

Did you know?​

“NASA computers were hijacked by a 15-year-old, resulting in a 21-day halt."​

Did you know?​

“You may heat a room with Gaming PCs more effectively than a heater."​

Did you know?​

“Physical money accounts for just around 10% of global cash, while the rest is stored on computers."​

Did you know?​

“YouTube actually started as a dating website." (Oh crap xD)​

Did you know?​

“Before they could progress as stable brands, Microsoft, HP, and Apple began manufacturing computers in their Garages."​

Did you know?​

Currently reading:
Automation With Excel Macros / Vba - Beginner To Advanced

"S'all Good, Man."

"Perfection Is The Enemy Of Perfectly Adequate."

"Money Is The Point!"

"I Travel In Worlds You Can't Even Imagine."

"Say Nothing, You Understand? Get A Lawyer!"

“Confidence is good. Facts on your side, better.”

“Facts are facts.”

“Sometimes the good guys win.”

“I’m not good at building shit, you know? I’m excellent at tearing it down.”

“Money is not beside the point… Money is the point.”

“Whoa, whoa. Hold up. What the hell happened to you? I get it, the first rule of Fight Club, right?”

“A good magician never reveals his secrets.”

“Got to look successful to be successful.”

“The lesson is, if you’re gonna be a criminal, do your homework.”

“If I had to do it all over again, I would maybe do some things differently. I just thought you should know that.”

“Some men aren't looking for anything logical. They can't be bought, bullied, reasoned or negotiated with. Some men just want to watch the world burn.”

"Ernest Hemingway once wrote, "The world is a fine place and worth fighting for." I agree with the second part."

“There’s no better way to destroy someone’s life than to uncover their secrets.”

“Hackers are breaking the systems for profit. Before, it was about intellectual curiosity and pursuit of knowledge and thrill, and now hacking is big business.”

“Hackers often describe what they do as playfully creative problem-solving.”

“Computer hackers do not need to know each other’s real names, or even live on the same continent, to steal millions in mere hours."

“While many hackers have the knowledge, skills, and tools to attack computer systems, they generally lack the motivation to cause violence or severe economic or social harm.”

“Very smart people are often tricked by hackers, by phishing. I don’t exclude myself from that. It’s about being smarter than a hacker. Not about being smart.”

“At the end of the day, my goal was to be the best hacker.”

“Humiliation is the favorite currency of the hacker.”

“The hacker didn’t succeed through sophistication. Rather he poked at obvious places, trying to enter through unlocked doors. Persistence, not wizardry, let him through.”

"Rules. Without Them We Live With The Animals.”

“Consider This A Professional Courtesy.”

"I've Lived My Life My Way, And I'll Die My Way."

"You stabbed the devil in the back, and forced him back into the life that he had just left."

"You Want A War, Or Do You Want To Just Give Me A Gun?"

"Leave one wolf alive and the sheep are never safe."

"When you play the game of thrones, you win or you die. There is no middle ground."

"It's not easy to see something that’s never been before: A good world."

"I believe in second chances. I don't believe in third chances."

"If you only trust the people you grew up with, you won't make many allies."

"A man with no motive is a man no one suspects. Always keep your foes confused: If they don't know who you are, what you want—they can't know what you plan to do next."

"Never forget what you are, the rest of the world will not. Wear it like armor and it can never be used to hurt you."

"I try to know as many people as I can. You never know which one you'll need."

"It's hard to put a leash on a dog once you've put a crown on its head."

“Everything before the word ‘but’ is horseshit.”

“A lion doesn’t concern himself with the opinions of a sheep.”

“Nothing FUCKS you harder than time.”

“You pray for rain, you gotta deal with the mud too. That’s a part of it.”

“I’d be more frightened by not using whatever abilities I’d been given.”

“Luck is where opportunity meets preparation.”

“If you have an enemy, then learn and know your enemy, don’t just be mad at him or her.”

“Every failed experiment is one step closer to success.”

When you work on a computer your hands travel 20 kilometres a day!

Fugaku supercomputer is the world’s fastest computer. The $1-billion supercomputer has 7,630,848 cores, requires 29,899 kilowatts of electricity, and can execute 442,010 teraFLOPs.

“Every day, about 317 million new viruses are discovered.

“Microsoft’s founder, the infamous Bill Gates, was actually a college dropout."

Did you know?

“On average, a human blinks 20 times per minute, but using a computer reduces it to 7."

Did you know?

“The most common password for a computer and social media platforms is 123456."

Did you know?

“There are eight varieties of computers: mainframe, supercomputer, workstation, personal computer, Apple Macintosh, laptop, tablet, and smartphone."

Did you know?

“Linux leads the industry as it is used by Google, Facebook, Twitter, and Amazon."

Did you know?

“NASA computers were hijacked by a 15-year-old, resulting in a 21-day halt."

Did you know?

“You may heat a room with Gaming PCs more effectively than a heater."

Did you know?

“Physical money accounts for just around 10% of global cash, while the rest is stored on computers."

Did you know?

“YouTube actually started as a dating website." (Oh crap xD)

Did you know?

“Before they could progress as stable brands, Microsoft, HP, and Apple began manufacturing computers in their Garages."

Did you know?

“For every 12 million email spams, only one gets a reply."

Did you know?

“Banks and other corporate giants hire white hats or “good hackers” to help fix security issues and prevent system infiltration."

Did you know?

“If Earth stopped rotating for 1 second, everyone would die."

Did you know?

“If someone made a sound of 1100db or larger a black hole would form sucking in our whole solar system."

“People shouldn't be afraid of their government. Governments should be afraid of their people.”