Excel VBA -Learn Visual Basic macros (Beginner to Advanced)

Focused View

Rami Abou Jaoude

19:52:30

140 View

1. Introduction

1.1 01.SettingUp.pptx

1.2 MacShortcuts.pdf

1. Introduction.mp4

02:13

2. L02 Important How to choose the lessons for your level!.mp4

00:55

2. My First Macro ()

1.1 02.MyFirstMacro.pptx

1.2 2.firstmacro completed.zip

1.3 2.firstmacro todo.zip

1.4 Icons.xlsx

1. Material For the Section.html

2. L01 Basic Set up and Introduction to VBE ().mp4

07:59

3. L02 Copy Paste And Save your code ().mp4

03:56

4.1 Icons.xlsx

4. L03 Forget your fear and write your first macro ().mp4

05:42

5.1 Icons.xlsx

5. L04 Run your Macro 10 Ways ().mp4

09:24

6. L05 Use ChatGPT to write your code! ().mp4

04:40

7. L06 Code Color, Useful Shortcuts And Basic Debugging ().mp4

04:11

8. L07 Useful shortcuts And Debugging techniques ().mp4

05:44

3. Referencing and Copy Paste ()

1.1 03.CellRefCopyPaste.pptx

1.2 3.referencing and copy paste completed.zip

1.3 3.referencing and copy paste todo.zip

1. Material for the section.html

2. L01 Cell Referencing, Row Height And Column Width ().mp4

13:43

3. L02 Common Properties And Methods related to Cells ().mp4

05:44

4. L03 Finding Last RowLast Column in dataset ().mp4

10:32

5. L04 Select Data, Get the address And Delete Data ().mp4

09:41

6. L05 Part 1 Formatting with VBA ().mp4

10:04

7. L05 Part 2 Trick to extract RGB from a color ().mp4

05:46

8. L06 Sheet Referencing ().mp4

05:45

9. L07 Workbook Referencing ().mp4

05:14

10. L08 Copy Paste(Special) ().mp4

07:27

11. L09 Resize a Range ().mp4

07:36

12.1 Template.xlsx

12. L10 Mini Project Part 1- Sort Data and generate a report using a template ().mp4

09:50

13.1 Template.xlsx

13. L10 Mini Project Part 2- Sort Data and generate a report using a template ().mp4

11:01

14.1 Icons.xlsx

14. L11 Mini Project - Report Analyzer ().mp4

14:22

4. Data Object Model ()

1.1 04.DataObjectModel.pptx

1. Material for the section.html

2. L01 The Excel Object Model ().mp4

02:35

3. L02 Object Properties ().mp4

01:54

4. L03 Object Methods ().mp4

02:18

5. L04 Dont Memorize -Different ways to get find Objects, Properties And Methods().mp4

05:19

5. Menus And Toolbar Walkthrough ()

1.1 05.menutoolbarwalkthrough completed.zip

1.2 05.menutoolbarwalkthrough todo.zip

1. Material for the section.html

2. L01 File And Edit Menus ().mp4

08:48

3. L02 View Menu ().mp4

04:56

4. L03 Insert, Format, Debug And Run Menus ().mp4

05:15

5. L04 Tools Menu ().mp4

03:56

6. Variables And Formulas ()

1.1 06.VariablesFormulas.pptx

1.2 6.variables and_formulas_completed.zip

1.3 6.variables and_formulas_todo.zip

1. Material for section.html

2. L01 Intro to Variables And Types ().mp4

06:46

3. L02 Declaring Variables - best practices ().mp4

10:39

4. L03 Object Variables ().mp4

08:47

5. L04 Variable Scope - Rock Paper Cisor Game ().mp4

14:40

6. L05 Order of Preference in Calculations ().mp4

05:33

7. L06 Convert to a different Data Type ().mp4

05:49

8. L07 Formulas ().mp4

12:47

9. L08 Mini Project Expense Report ().mp4

16:12

7. Macro Recording ()

1.1 07.MacroRecording.pptx

1.2 7.macrorecording completed.zip

1.3 7.macrorecording todo.zip

1. Material for section.html

2. L01 Macro Recorder ().mp4

07:59

3. L02 R1C1 Notation ().mp4

13:49

4. L03 Practical use of Macro Recorder to automate Task ().mp4

07:55

5. L04 Absolute vs Relative Reference in Recording ().mp4

06:10

8. Looping through Objects, Conditional And Logical Operators ()

1.1 08.ComparaisonThroughLoopingCondLogOps.pptx

1.2 8.comparaisonthroughloopincondlogops completed.zip

1.3 8.comparaisonthroughloopincondlogops todo.zip

1. Material for section.html

2. L01 With End With ().mp4

06:24

3. L02 For Each In...Next ().mp4

05:57

4. L03 If Statement with ProtectUnprotect Sheet ().mp4

06:40

5. L04 And Or Logical Operators ().mp4

05:03

6. L05 Like Operator ().mp4

08:20

7. L06 IsNumeric ().mp4

03:21

8. L07 Select Case ().mp4

08:17

9. Interacting with Users ()

1.1 09.InteractionWithUser.pptx

1.2 9.interactionwithuser completed.zip

1.3 9.interactionwithuser todo.zip

1. Material for section.html

2. L01 MsgBox Deep Dive ().mp4

11:04

3. L02 InputBox ().mp4

13:44

4. L03 Get a Range of Cells with InputBox ().mp4

04:12

5. L04 Mini Project - Identify the winners ().mp4

07:36

10. Looping ()

1.1 10.looping completed.zip

1.2 10.looping todo.zip

1.3 10.Looping.pptx

1. Material for section.html

2. L01 Use For Next Loop to filter Data ().mp4

12:45

3. L02 Reverse For Next Loop ().mp4

07:54

4. L03 Do Until Do While Do ().mp4

08:12

5. L04 Do Loop with InputBox ().mp4

08:10

6. L05 Find 1 Match ().mp4

10:24

7. L06 Find Multiple Matches ().mp4

07:32

8. L07 Timer to Measure Code RunTime ().mp4

04:15

9. L08 Stop an infinite Loop ().mp4

01:41

10. L09 While Loop with a new way to find last row in dataset ().mp4

07:02

11. L10 Mini Report with Loops ().mp4

11:51

11. Improving your code And Error Handling ()

1.1 11.improvingyourcode completed.zip

1.2 11.improvingyourcode todo.zip

1.3 11.ImprovingYourCode.pptx

1. Material for section.html

2. L01 Error Handling ().mp4

07:38

3. L02 Speed up your code ().mp4

03:26

4. L03 Modular Coding ().mp4

01:58

5. L04 Passing Arguments (Byval vs ByRef) to Procedures And Procedure Scope ().mp4

08:06

12. Text Manipulation ()

1.1 12.textmanipulation completed.zip

1.2 12.textmanipulation todo.zip

1.3 12.TextManipulation.pptx

1. Material for section.html

2. L01 Overview + Left, Right, Mid ().mp4

07:08

3. L02 Replace ().mp4

04:28

4. L03 Instr ().mp4

05:21

5. L04 Check if string is empty ().mp4

01:30

6. L05 Pitfall to avoid with Trim and Change Case of String ().mp4

04:34

7. L06 Mini Project - Extract Ratings ().mp4

16:19

13. Date Manipulation ()

1.1 13.DateManipulation.pptx

1.2 13.dates completed.zip

1.3 13.datesmanipulation todo.zip

1. Material for section.html

2. L01 Overview and basic date functions ().mp4

07:40

3. L02 Play with Date, Time and Use YearFrac ().mp4

08:28

4. L03 Number of days between dates (Simple subtraction And Networkdays) ().mp4

07:17

5. L04 Number of MonthsYears between dates - Datediff and DateDif ().mp4

12:16

6. L05 Mini Project - Fill the calendar ().mp4

11:56

14. Create your own Excel function ()

1.1 14.yourownfunction completed.zip

1.2 14.yourownfunction todo.zip

1.3 14.YourOwnFunction.pptx

1. Material for section.html

2. L01 Overview and your first custom function ().mp4

05:42

3. L02 Move your function under a category a provide definitions to the user().mp4

05:39

4. L03 Mini Project - Find the Expiry date ().mp4

08:58

5. L04 Function example - How to manipulate text ().mp4

04:36

6. L05 Run Functions from Subs Other functions ().mp4

04:17

7. L06 Optional Parameters in Functions ().mp4

07:06

15. Arrays ()

1.1 15.arrays completed.zip

1.2 15.arrays todo.zip

1.3 15.Arrays.pptx

1. Material for section.html

2. L01 One-Dimension Array ().mp4

08:36

3. L02 Dynamic Sized Arrays ().mp4

03:24

4. L03 Keep your existing values when Rediming your array ().mp4

02:01

5.1 15 04.2DimArrays.mp4

05:19

5. L04 Multidimensional Arrays ().mp4

04:25

6. L05 Variant Array ().mp4

07:19

7. L06 Mini Project - Generate Sub Reports by City ().mp4

10:07

16. Files and Folders ()

1.1 16.filefolders todo.zip

1.2 16.filesfolders completed.zip

1.3 16.FilesFolders.pptx

1.4 SampleFolder.zip

1. Material for section.html

2. L01 Check if File Folder Exists and Create a new folder ().mp4

11:59

3. L02 Allow user to select the file to open via dialog box ().mp4

09:38

4. L03 Picking a Folder with FileDialog ().mp4

13:46

5. L04 Save your files in different formats ().mp4

06:03

6. L05 Open statement for more control over txt file ().mp4

06:58

7. L06 Copy paste data into CSV file with custom delimiter ().mp4

08:33

8. L07 Mini Project - Create a consolidated scorecard from selected files ().mp4

19:42

17. How to deal with Excel Tables And Pivot Tables ()

1.1 17.exceltablespivot completed.zip

1.2 17.exceltablespivot todo.zip

1.3 17.ExcelTablesPivot.pptx

1. Material for section.html

2. L01 Crash course on Excel Tables ().mp4

19:26

3. L02 Pivot Table VBA theory and Trick to get the right code-no memorizing ().mp4

13:22

4. L03 Pivot Table Main activities ().mp4

13:24

18. Interacting with Other Applications ()

1.1 18.2Template.docx

1.2 18.interactingwithotherapps completed.zip

1.3 18.interactingwithotherapps todo.zip

1.4 18.InteractingWithOtherApps.pptx

1. Material for section.html

2. L01 Create a PDF File from your excel sheets ().mp4

13:52

3. L02 Manipulate Word from VBA ().mp4

20:16

4. L03 Create a Presentation on PowerPoint from VBA ().mp4

20:02

5. L04 Create automatic Emails with attachments from VBA ().mp4

13:53

19. Sheet Controls ()

1.1 19.sheetcontrols completed.zip

1.2 19.sheetcontrols todo.zip

1.3 19.SheetControls.pptx

1.4 VariableValueForKeyMouseEvents.xlsx

1. Material for section.html

2. L01 Button Properties + Difference between ActiveX and Form controls ().mp4

12:26

3.1 VariableValueForKeyMouseEvents.xlsx

3. L02 Button Key Press Events Capture keys pressed - ActiveX ().mp4

06:49

4.1 VariableValueForKeyMouseEvents.xlsx

4. L03 Button Key Press Event Capture Control, Shift and Alt - ActiveX ().mp4

02:04

5.1 VariableValueForKeyMouseEvents.xlsx

5. L04 Button Mouse Over Event - ActiveX ().mp4

05:33

6.1 VariableValueForKeyMouseEvents.xlsx

6. L05 Button Simulate a Mouse Leave Event - ActiveX ().mp4

05:06

7.1 19 06.FormControlRecap.mp4

05:26

7.2 VariableValueForKeyMouseEvents.xlsx

7. L06 Button Write in Shape - Form Controls + Recap of what we learned ().mp4

06:24

8. L07 Textbox - ActiveX Additional Properties ().mp4

08:14

9. L08 Textbox - Form Controls Properties ().mp4

04:10

10.1 VariableValueForKeyMouseEvents.xlsx

10. L09 Textbox - ActiveX Tricks Part 1 (Tabbing, Change and Focus Events) ().mp4

08:41

11.1 VariableValueForKeyMouseEvents.xlsx

11. L10 Textbox - ActiveX Tricks Part 2 (Restrict user inputs) + recap ().mp4

04:54

12. L11 Checkbox - ActiveX Properties and Example ().mp4

10:31

13. L12 Checkbox - Form Control Properties and Example.mp4

06:37

14. L13 Option Button ActiveX - Grouping and example ().mp4

05:12

15. L14 Option Button - Form Control Grouping and example ().mp4

06:35

16. L15 Option Button and Checkbox Recap ().mp4

01:15

17. L16 Spin Buttons - ActiveX And Form Control Properties and example ().mp4

12:18

18. L17 Labels - ActiveX And Form Control Practical use cases ().mp4

07:41

19. L18 Combo box - ActiveX And Form Control Additional properties ().mp4

07:40

20. L19 Combo box - ActiveX Main activities ().mp4

12:30

21. L20 Combo box - Form Control Main activities ().mp4

09:29

22. L21 List box -Active And Form Control Additional properties ().mp4

03:12

23. L22 List box - ActiveX Main activities ().mp4

10:13

24. L23 List box - Form Control Main activities ().mp4

05:20

25. L24 Scroll bar Quick overview ().mp4

05:32

20. Userforms ()

1.1 20.userforms completed.zip

1.2 20.userforms todo.zip

1.3 20.Userforms.pptx

1.4 employee1.zip

1.5 noimage.zip

1. Material for section.html

2. L01 Intro to UserForms + a look at a new control! ().mp4

04:42

3. L02 UserForms Property ().mp4

06:54

4. L03 Button Aesthetic trick ().mp4

03:20

5. L04 Is TabStrip right for our mini project ().mp4

06:14

6. L05 Use Multipage to set up the form in a professional way ().mp4

06:29

7. L06 Using a Frame to Group Option buttons automatically ().mp4

01:42

8. L07 Dont forget to initialize your form ().mp4

04:54

9. L08 Initialize Combo Box ().mp4

02:12

10. L09 Initialize List Box ().mp4

03:24

11. L10 Tab it the right way! ().mp4

03:51

12.1 Website to resize your image.html

12. L11 Wow your stakeholders with an Image ().mp4

08:12

13. L12 Validate the Userform data entry or you might be in trouble ().mp4

11:38

14. L13 Save your data ().mp4

08:35

15. L14 Edit Form Set up ().mp4

08:41

16. L15 Dynamic Search Box ().mp4

04:47

17. L16 Get info form Database into the form ().mp4

17:01

18. L17 Saving edited data ().mp4

08:16

21. Charts ()

1.1 21.charts completed.zip

1.2 21.charts todo.zip

1.3 21.Charts.pptx

1. Material for section.html

2. L01 Chart Intro ().mp4

01:38

3. L02 Easiest way to create and modify a chart ().mp4

10:36

4. L03 Animate your chart to wow your audience ().mp4

14:32

5. L04 Load your chart into a UserForm ().mp4

05:52

22. Workbook and worksheet events ()

1.1 22.events completed.zip

1.2 22.Events.pptx

1.3 Section17Dashboardtocopy.xlsx

1. Material for section.html

2. L01 Workbook events ().mp4

04:40

3. L02 Worksheet events ().mp4

04:07

4. L03 Intersect to trigger an action only on certain cells ().mp4

07:19

5. L04 Reset a dependent dropdown menu ().mp4

05:18

6. L05 Use the BeforePrint event to fix your header issues ().mp4

03:16

23. Quizz

1. Final Question.html

Description

Become a Guru in Microsoft Excel macros (VBA) to automate your tasks, reports, dashboards and analysis with Visual Basic

What You'll Learn?

Automate your tasks in Excel and focus your time on more productive activities
Wow your stakeholders, e.g., Dynamic Charts and AI analyzing your report
Make your team work fast and better with efficient VBA tools
As you can't memorize everything, learn how to search, modify and use the right piece of code
Loose the fear of using VBA

Who is this for?

Beginners with no prior knowledge of VBA: You will learn step by step

Intermediate VBA users: You will be able to sharper your skill and take away a wealth of codes to use to in your projects

What You Need to Know?

Be comfortable using the normal Excel sheets. You don't need to be a formula Guru but you need to have the basic knowledge of Excel. How to use basic formulas, how to write in cells, copy paste formulas, etc...

More details

Description

Why learn Microsoft Excel Visual Basic (VBA):Â Today, Ms Excel is becoming the tool of choice in companies (in the USA alone, more than 500,000 companies actively use Excel) to be able to perform analysis and present data in a Quick way. A lot of the work won't require complicated models and can be set up in an automated way.

Work Smarter not Harder:Â With the advance of technology and information, jobs are becoming more and more challenging. In addition, data and analysis are becoming more and more accessible with time. The difference in productivity between a NOOBÂ in Excel and an advanced User is more than 10X. Imagine automating your task and using your time for more productive activities!

Why this course:
Excel has the power to access anything you can do on the computer. You will be surprised how much you can automated &Â save time!
Learn how to automate reports. While you are home asleep, you computer can download data, analyze it, create a report and send it out!
Coding could be daunting at first. With this course, you will see that it's easy if you go step by step
This course teaches you how to understand coding and memorize the minimum - This will enable you to find code, modify it and use it
Unlike many courses, this course teaches you how to use code in real life - You will see examples you can relate to such as copy pasting, dashboards, creating customized letter, etc...
Course is designed for all levels: Whether you want to learn from scratch or deepen your understanding in VBA, you are at the right place!
Â 4. Curriculum - Practical Hands on Excel Visual Basic (VBA):
Dealing with Files &Â Folders
Interacting with Applications such as PDF, PPT and Word
Creating your own formulas &Â Functions (Like what you have in Excel)
Manipulating Excel Tables and Pivot Tables
ActiveX and Form controls
Userforms
Triggering macros based on events
Comparison though looping in Collections
Conditional &Â Logical operators (Even partial match)
Loops (For, do, while etc...)
Referencing cells &Â copy pasting
Variables &Â how to use excel formulas in VBA
How to use the macro recorder
Msgbox with inputs from user
Error Handling &Â Debugging
Manipulating text and dates
Arrays
Â 5. What you will learn:
What you need to know to complete most assignments
Best practices in coding such as identing, commenting, using variables, reusing code
Building automated Reports, Analysis &Â Dashboards (including how to get the raw data automatically
How to search for a code you don't know - Using the macro recorder, internet and more...
How to build faster codes
Useful Shortcuts
How to deal with Errors
Functionalities of The Visual Basic Editor
How to create applications with cool userforms and graphs/pics in the form
How to simulate typing on the keyboard
How to run your macro while you are not there
And many more!
Â 6. About me:
Harvard MBA
Extensive consulting experience with McKinsey &Â Co, having learned the ability to dissect problems and perform complex analysis in no time
11+ years as a Vice President in a bank heading analytical and strategy teams
Built the whole analytics department of a 3500+Â employee share services subsidiary
Degree in Computational Sciences among others
Well versed in Data and Artificial intelligence, having built chatbots
Passion for teaching Excel as a backbone to increasing productivity
Who this course is for:
Beginners with no prior knowledge of VBA: You will learn step by step
Intermediate VBA users: You will be able to sharper your skill and take away a wealth of codes to use to in your projects

User Reviews

Rating

average 0

Total votes0

Focused display

Excel VBA

Excel

Rami Abou Jaoude

Instructor's Courses

Who is Rami Abou Jaoude?1) First of all Rami brings with him a wealth of experience with 4 years spent in McKinsey & Co, a top tier consultant company resolving the biggest issues faced by top clients in multiple industries. This always requires an analytical mindset and an ability to be able to dissect problems like a doctor, bring data and find the best course of action2) In addition, Rami served 11 years as a Vice President in one of the most prestigious banks in the Middle East taking up roles in strategy and analytics. Rami has built the whole Analytics infrastructure for the shared service subsidiary of the bank and started the journey towards having decisions based on analytics rather than anecdotes. Rami has also touched the artificial intelligence space having built chatbots to address queries related to HR and defaulted customers3) In terms of Education, Rami has an MBA from Harvard business school and multiple degrees in Economics, Computational Sciences and Finance. This enables him to understand business and IT at the same time and to bring all parties together under a common language4) Well before the buzz in data, Rami had a drive to use data. His Moto in Life is work SMARTER not HARDER. The idea was to combine knowledge in Computer Science with the ability to understand businesses. For this, he has built hundreds of models, tools and dashboards way before the Agile term come into play!5) Rami is all about passion. A passion for adrenaline sports, normal sports and art (like playing piano). For this purpose, he wants to share his knowledge with others in all the fields that he has mastered!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.