Registration
Home » Tutorials » Apply Excel Vba In Industry Series - Part I

Apply Excel Vba In Industry Series - Part I   

31-08-2022, 09:01 |   0nelove  Tutorials 83 0

Apply Excel Vba In Industry Series - Part I
Published 8/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.65 GB | Duration: 7h 18m





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
'Comment: You can use MS Excel 2010 and above for this course.Now the fun stuff!!!Why THIS course?- You have been wanting to tip your toes into learning VBA, but not sure where to start! - You are in the right place.I assume you know absolutely nothing, and willing to learn. I bring a very simplified lecture and a thorough explanation., and you bring your eagerness and willingness to learn. You leave with a thorough understanding of how VBA in Excel Works.What will I learn from course? (The non-technical stuff)1. A simplified business case, early in the course, to convince you that learning VBA in 2022 is still worth it!2. A simplified background of VBA, and how it functions on a basic level. It's not just code, but a lot more.3. How day-to-day operations you do in Excel can be done in the back-end with VBA. (Sum, count, average, etc.)4. Put the end user in mind first when designing a VBA tool. Whether it is yourself or for others. Many tips and tricks from industry experience that makes not only your work standout, but more importantly YOU.5. When to use and when to NOT use VBA - Yes! I'm going to steer you away from becoming a person that stretches their Excel muscles.6. And lastly, the WHOLE SELLING point of this course: REAL life examples that I personally applied in Industry! You're not just learning how to code, more importantly you are learning how to SOLVE PROBLEMS!What will I learn from course? (The technical stuff)1. Core VBA functions that include message box, input box, copying and pasting, arithmetic, and MANY more.2. Variables, how to use them in code, and make debugging your code a lot quicker. Quicker coding and debugging = Faster turnaround on your deliverables ?3. 'FOR' Loops, the basis of any VBA coder – the simplest and most applicable loop of all.4. 'IF' Statements in VBA, how to write them, when to use then.and when NOT to.5. 'Select Case' in VBA, the more flexible 'IF' Statement and multiple different examples of its application. Examples are REAL, and PRACTICAL.6. Adding and naming new worksheets and asking the user to provide a desired name.7. Looping through objects (worksheets in the entire workbook) and execute commands.8. Created an automated event log of operations, grab the username of the file opener, keep track of who did what and when.9. Code optimization, making your macros run as much as 300% faster!10. How to 'Record a Macro' and when to NOT rely on it.11. How to make your code dynamic, smarter and flexible if the size of your incoming data changes.12. All resources are downloadable for you take, practice and reference for your use.Multiple examples from INDUSTRY, in different departments, performing different functions and providing thought-provoking scenarios and questions. This course is a must – whether its for VBA or to get more experience in solving industry challenges.Strategically placed assignments and quizzes that will strengthen your understanding and enhance your thought process when approaching a new VBA project. Plus, you get the GRAND Assignment at the very end of the course – I called it the FINISHER – with a video recording of the solution.MOST Importantly, this is a beginning to a journey. The first step, a foundation to get you going, and an introduction to the upcoming PART II and PART III of the 'Apply Excel VBA in Industry' Series. Examples get tougher as you go along, and so do I. I CONSTANTLY CHALLENGE you throughout the course – you would think I'm your gym coach.Finally, my priority is to pass on VALUABLE Knowledge to YOU. To ensure you get your money's worth! I made sure throughout the course to provide you with material that will ADD to your knowledge, and nothing that you will hit the 'Next' button on!Happy Coding and Learning!
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"
Section 4: Excel VBA Basics - Part I
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 10 Declare Variables using "Dim"
Lecture 11 Excel VBA Basics Part I Summary Exercise Worksheet
Section 5: Excel VBA Basics - Part II
Lecture 12 "For" the love of VBA
Lecture 13 The "IF" Statement
Lecture 14 Select Case
Section 6: The Industrial Engineering Department, aka "Make more for Less"
Lecture 15 Calculate cycle times for each product on the assembly line
Lecture 16 Put Together Production Challenge Results
Section 7: The Financial Control Department. aka "Captain Crunch"
Lecture 17 Accounts Receivable: Develop an optimized collection strategy
Lecture 18 Accounts Payable: Optimized Procurement Strategy
Section 8: The Human Resources Department
Lecture 19 City Department Workforce Report
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
Lecture 24 What is coming in PART II and Part III of this series
No to little exposure or beginner level Excel VBA developers.
Screenshots


Donate For Servers
Comments
The minimum comment length is 20 characters. Respect yourself and others!
reload, if the code cannot be seen
There Are No Comments Yet. Do You Want To Be The First?
avaxdl Copyright Holders