Excel Macros VBA + Power Query (2 in 1 course)

Focused View

MyExcelAcademy .

16:40:17

198 View

1. Introduction - Getting the Fundamentals right

1. Excel Macros Magician.mp4

00:49

2. Option Explicit Statement.html

3. Introduction.mp4

04:57

4.1 understanding the fundamentals of macros.zip

4. The VB editor.mp4

04:35

5. Range object - Most Important.mp4

09:03

6. Start writing your first code.mp4

04:31

7. Absolute Mode Recording.mp4

06:10

8. Understanding the recorded code in Absolute Mode.mp4

07:49

9. Recording in Relative Mode.mp4

07:48

10. Recording in Absolute and Relative Mode.mp4

08:49

11. Understanding the recorded Macro codes.mp4

07:15

2. Variables and Using Loops

1. Declaring Variables.mp4

02:04

2. Scope of Variables.mp4

10:15

3. Data Types.mp4

10:17

4.1 Variables and Loops.pptx

4.2 variables and loops.zip

4. Loops in VBA.mp4

02:42

5. Using Instr.mp4

10:04

6. IF statements.mp4

04:32

7. Loops - Final Touches.mp4

08:20

3. Userform - Message

1.1 1. welcome screen on startup using userform.zip

1. Welcome Message.mp4

10:23

4. Employee Database Userform

1.1 2. employee database.zip

1. Employee Database Userform.mp4

47:34

5. How to merge text in a cell

1.1 3. merge text.zip

1. Merge text in a cell.mp4

13:08

6. How to split Numbers

1.1 4. split numbers.zip

1. Split Numbers.mp4

16:17

7. Loops

1.1 5. loop over files.zip

1.2 Apr.xlsx

1.3 Feb.xlsx

1.4 Jan.xlsx

1.5 Mar.xlsx

1.6 May.xlsx

1. Looping over Mutliple Files.mp4

15:00

8. Loop Multiple files and sum totals by date

1.1 6. loop over files and sum totals by date.zip

1.2 Apr.xlsx

1.3 Feb.xlsx

1.4 Jan.xlsx

1.5 Mar.xlsx

1.6 May.xlsx

1. Looping over files and summing by dates.mp4

23:05

9. Summarize Profits by Weekday

1.1 summarize profits by weekday.zip

1. Summarize Profits by Weekday using Loops.mp4

15:19

10. Understanding R1C1 referencing

1.1 8. monthly report - jan 2021.zip

1.2 Lookup Data.xlsx

1. R1C1 Referencing.mp4

07:36

11. Vlookup in VBA

1.1 9. using vlookup.zip

1.2 Lookup Data.xlsx

1. Vlookup - VBA version.mp4

16:39

12. Formatting Dates

1.1 10. formatting dates and save as table.zip

1. Formatting Dates and save as Table feature.mp4

13:12

13. Tables and ListObjects

1.1 11. understanding tables as list object.zip

1.2 Tables (ListObjects).pptx

1. Tables - List Objects.mp4

10:00

14. Calculating Margins and Revenue using Tables

1.1 12. calculating margins and revenue using tables in vba.zip

1.2 Lookup Data.xlsx

1. Using Formulas in VBA.mp4

09:21

15. Text function in VBA

1.1 13. using the text function in vba.zip

1. Text Function.mp4

05:33

16. Convert numbers stored as text to Numbers

1.1 14. convert text to numbers.zip

1. Convert numbers stored as text to Numbers.mp4

11:03

17. Sales Summary report

1.1 15. summary report.zip

1. Sales Summary report in VBA.mp4

18:22

18. Formatting your Report

1.1 16. format your report.zip

1. Formatting your report.mp4

12:36

19. Errors in VBA and how to deal with them

1.1 Backup.xlsx

1.2 error handling and debugging.zip

1.3 Errors and Debugging in VBA.pptx

1. Error handling.mp4

12:50

2. Error Handling Part 2.mp4

14:00

20. Create Multiple Reports with Unique function

1.1 18. unique function and create multiple reports.zip

1. Multiple reports.mp4

16:31

21. Multiple Report Generation with Criteria

1.1 19. multiple reports with criteria selection.zip

1. Multiple reports with crtieria.mp4

22:11

22. Advanced Filter

1.1 20. Advanced Filter.mp4

18:08

1.2 20. using the advanced filter method.zip

1. Advanced Filter - VBA.mp4

18:08

23. VBA on Steroids - Arrays

1.1 21. using arrays (part 1).zip

1. Arrays.mp4

14:44

2.1 21. using arrays (part 2).zip

2. Using Arrays (Part 2).mp4

18:06

3.1 21. using arrays (part 3).zip

3. Using Arrays (Part 3).mp4

06:14

4.1 21. using arrays (part 4).zip

4. Using Arrays (Part 4).mp4

21:36

5.1 21. using arrays (part 5) complete.zip

5. Arrays (Part 5) - Complete.mp4

12:36

24. Pivot table in VBA

1.1 22. create pivot table using vba.zip

1. Pivot table automation.mp4

25:44

25. Shapes in VBA

1.1 shapes in vba.zip

1. Using Shapes in VBA.mp4

33:49

26. Pictures from Folder

1.1 24. inserting pictures from a folder.zip

1.2 Snooker Players.zip

1. Adding pictures from a folder.mp4

12:41

27. Embedding pictures from a folder

1.1 25. embedding pictures from a folder.zip

1.2 Snooker Players.zip

1. Embedding Pictures.mp4

05:37

28. Resizing pictures into a grid

1.1 26. resize pictures to grid.zip

1.2 Snooker Players.zip

1. Resizing pictures.mp4

25:30

29. File System Object

1.1 27. filesystemobject.zip

1. FileSystemObject - Access Files and Folders.mp4

30:46

30. Adding Hyperlinks to Folder Names

1.1 28. adding hyperlinks.zip

1. Add Hyperlinks.mp4

10:45

31. Copying Folder and Subfolders

1.1 29. copying folders and subfolders.zip

1. Copy files to folders.mp4

10:56

32. Embedding the images onto sheets

1.1 Copied Images.zip

1.2 Listing Images.zip

1. Embed images onto sheets.mp4

25:58

33. Creating Charts in VBA

1. Create a Chart with VBA (Part 1).mp4

18:18

2. Creating Multiple Charts (Part 2).mp4

17:37

3. Creating Multiple Charts (Part 3).mp4

18:54

4.1 31. creating multiple charts in vba.zip

4. Creating Multiple Charts (Part 4).mp4

04:57

34. Chart Animation 1

1.1 animate chart.zip

1. Chart Animation using VBA (Part 2).mp4

29:09

2. Chart animation using VBA (Part 1).mp4

01:21

35. Chart Animation 2

1. Arranging the Data first.mp4

08:12

2.1 33. chart animation 2.zip

2. Understanding how animation works.mp4

03:47

3. Using Named Ranges with Loop to create the Animation.mp4

11:55

4. Applying the Final Touches.mp4

05:56

36. Chart Animation 3

1. Adjusting the VBA code and Named Ranges.mp4

09:01

2. Adjusting the Chart series.mp4

07:55

3. Using a Toggle Switch.mp4

17:39

4. Final Touches.mp4

07:41

37. Interactive Sales Dashboard

1. Intro to the Interactive Sales Dashboard.mp4

01:33

2. Understanding the Data.mp4

02:30

3. Using Application.Caller method to call shapes.mp4

06:28

4. Pivot table and Slicer trick.mp4

06:46

5. Running the Advanced Filter.mp4

02:57

6. Calculate totals for the Category.mp4

07:26

7. Cell formatting and Conditional Formatting.mp4

08:07

8.1 interactive sales dashboard - incomplete.zip

8. Custom Format your Slicer.mp4

03:06

9.1 interactive sales dashboard.zip

9. Importing the pictures with VBA.mp4

22:18

10. Adding the Category and SKU cells.mp4

03:18

11. Using Named Formulas to capture a Dynamic range.mp4

04:10

12. Conditional Formatting for borders.mp4

02:14

13. Running the Advanced Filter at SKU level.mp4

11:03

14. Calculate values for Brand.mp4

05:01

15. Final Touches.mp4

06:49

38. Power Query Section

1. Intro to the Course.mp4

02:35

2.1 Split Column Dilemma.xlsx

2. Split Column Dilemma.mp4

11:49

3.1 Sales Data.zip

3. Format Multiple Files from a Folder.mp4

10:19

4.1 ConfirmedUnconfirmedSalesAnalysisReport - 2022-11-01T155838.360.xlsx

4. Category Sales.mp4

07:28

Description

Learn Excel Macros Automation and Power Query (2 in 1 course)

What You'll Learn?

Students will learn how to debug recorded macros and write their own coding using VBA. A little basic understanding of Macros is what you need.
Most students struggle to understand VBA codes, this course has what you need to expand your knowledge into the VBA world.
All you need is a will to master the basic concepts, some practise and your on your way to become an expert. Watch, repeat and Practise is key here.
VBA code written in front of your eyes, not written and then narrated. Relate words with action. Follow along as we write code, debug and correct errors.
At the end of the course, you will be able to master key concepts, write your own loops and even make summary reports.

Who is this for?

All students seeking coding knowledge basics, working professionals wanting to learn Excel Macros and how to automate processes.

Managers , Sales professionals, Data Analysts, anyone basically wanting to learn new skills.

More details

Description
Fear not if you don't know how to record a Macro and use it. In this course, I will show you how to record macros, edit them , understand the code, debug them and start writing your own applications.
VBA for Excel is still King in terms of Automation. There is so much magic that you can achieve by learning how to code. All you need is the will power to learn and practise.
Start from the Basics of recording and understanding macros. Learn to write VBA code from scratch. You don't need to be a Programmer.
Once you're done with VBA, learn Power Query.....the best tool to Master without learning how to code

"It is in detail ie., step by step for the non coding background learners"
Rajesh L N - India

"I needed a course that takes me from basic vba to intermediate vba and so far with the course content i see myself headed towards becoming an expert vba which is awesome"
Emmanuel - Uganda

"Excellent course contents and thanks for uploading this savior course. It really helped and perfectly fits for the day to day work automations. I highly recommend this course for macros learners...!!"
Rizwan Safdar - Switzerland

"Practical examples and well explained formulas. Excellent course explained with formulas and debugging. Can't wait to learn the Excel animation and move to Power BI. Would recommend the course to Excel enthusiasts to explore."
Shagufta M - Pakistan

"Itâ€™s a very nice course, I recommend to everyone who wants to learn VBA. Instructor has got excellent knowledge about the teachings."
Sarfraz - India

Variety of codes for different situations, written right before your eyes. Debug, compile and recover from mistakes.
Over 50 completed files, videos and examples.
Userforms
Animation in Charts using Named ranges and VBA
Looping over multiple files
Using the speed of Arrays
Scripting with Files and Folders
Creating Summary Reports
Formatting your reports
Embedding images onto sheets
Resizing multiple charts in a grid
Creating Charts in VBA
Embedding Pictures from a Folder
Error handling and debugging
Using Advanced Filter
Using Shapes in VBA
Understanding Tables and List Objects
Interactive Sales Dashboard
Record macros in Absolute and Relative mode, understand the differences. Start building Userforms, create loops to loop over multiple files.
Understand Pivot table automation and to access Tables as List Objects.
Create multiple charts and resize them in a customized grid.
Create animation using Advanced techniques with Named ranges and VBA to animate Excel charts.
This course covers all the basics as well as advanced concepts of VBA for beginners.
Each project contains exercise files that you can download and use.
This course will help students, accountants, data analysts, working professionals, any Excel enthusiast.
Course will be updated with new videos...

Who this course is for:
All students seeking coding knowledge basics, working professionals wanting to learn Excel Macros and how to automate processes.
Managers , Sales professionals, Data Analysts, anyone basically wanting to learn new skills.

User Reviews

Rating

average 0

Total votes0

Focused display

I have been an Excel user for the last 13 years and enjoy working with Excel on a daily basis. It never seems to amaze me what you can learn everyday using your Excel skills. I work as a Brand Manager for an FMCG Sales distribution company and have successfully taught many working professionals and corporate companies basics to advanced techniques using Excel and VBA. I now plan to bring my own course to Udemy followers and share my methodology and techniques. I will be updating my course with new materials for my students with Power Query + Power BI and other interesting Excel videos.

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.