Microsoft Excel for Mac 4: VBA macros for Excel - an intro

Focused View

Phillip Burton,I Do Data Limited

3:12:02

166 View

1 - Introduction

1 - Introduction.mp4

01:34

2 - Welcome to Udemy.html

3 - Introduction to Udemy.mp4

02:00

4 - Do you want autotranslated subtitles in more languages.html

2 - Recording your first macro

5 - The Developer Tab and creating My First Macro.mp4

04:50

6 - The editing environment.mp4

07:39

7 - Hello World.mp4

09:35

8 - Saving our spreadsheet.mp4

04:30

9 - Opening our spreadsheet and Security.mp4

07:25

3 - Variables

10 - Introducing variables.mp4

08:17

11 - Scope.mp4

06:52

12 - Breakpoints the Immediate Window and Watches.mp4

08:20

13 - String operators.mp4

03:19

14 - Declaring types of variables.mp4

07:10

15 - Avoiding typos.mp4

06:52

4 - The Excel Object Model

16 - Interacting with the Excel spreadsheet.mp4

03:28

17 - Introducing Objects.mp4

04:53

18 - Introducing the Object Model.mp4

04:17

19 - Default Objects and Default Properties.mp4

07:02

5 - Loops and If statements

20 - ForNext Loops.mp4

07:54

21 - ForNext Loops part 2 and debugging.mp4

07:01

22 - InputBox.mp4

04:54

23 - About the next video.html

24 - IsNumeric and IfThen.mp4

06:55

25 - IfElseEnd If.mp4

04:53

26 - Val.mp4

04:44

27 - Do WhileLoop.mp4

09:29

28 - Using our Do WhileLoop.mp4

04:21

29 - Other types of loops.mp4

07:39

30 - Selection.mp4

05:10

31 - Coding Exercise Using ForNext Loop with Selection.mp4

10:38

32 - Set.mp4

08:35

33 - For EachNext Loop.mp4

03:55

6 - Well done

34 - Congratulations.mp4

00:43

35 - Bonus Lecture.mp4

07:08

35 - idodatabonuslecture230113.zip

Description

Go from Beginner Level of Excel VBA to Intermediate. Create your own Excel Macros in Visual Basic for Applications.

What You'll Learn?

Add the Developer tab and record macros.
Adapt macros using the Excel Object Model, so that you can use them in your spreadsheets.
Know about variables, and how to use loops and If statements.
Interact with Excel - find out how to access the Selection object, and output results using a MessageBox (MsgBox).

Who is this for?

This Excel VBA course is for you if you want to learn how to automate Excel and provide a better user interaction.

No prior programming language is required - although, it would always help!

This course is not for you if you are confident using VBA, and are looking for more advanced techniques.

More details

Description
ReviewÂ of the Windows version:

"This is a very good starting point in VBA. But doing this course one realize how extensive and huge VBA is. As always the teacher is great and one feels his in depth knowledge" -- Daniel Sandberg

Welcome to Excel VBA - An Introduction for the Mac. This course delves into the Visual Basic which allows you to automate Microsoft Excel (and other MSÂ Office products).

Microsoft Excel is an extremely powerful tool â€“ and yet most people only scratch the surface of what it can do. In addition to PivotTables, VLookup formulas and the like, you can also automate it. You can add buttons and forms to add interactive features â€“ yet most people donâ€™t even know itâ€™s there. Maybe you have someone in your organization who is an absolute wizard, getting the computer to do things and walking away while it does it. Do you want to be able to do that? Welcome to wizard school â€“ or in other words, Visual Basic for Applications (VBA).

In this course, Iâ€™ll assume that you have some fair knowledge of Excel â€“ able to do basic formulas and colour cells and the like â€“ but you donâ€™t need any prior knowledge of VBA or any programming language for that matter. Of course, the more you already have, the better. Iâ€™ll take things nice and slowly. Each video will center around one new aspect, or weâ€™ll consolidate what you already know with coding exercises.Â

Once you have finished the course, then you will be well on your way to developing your own macros to solve your own problems.Â And youâ€™ll be able to take your new-found knowledge for use in Word and PowerPoint as well
Who this course is for:
This Excel VBA course is for you if you want to learn how to automate Excel and provide a better user interaction.
No prior programming language is required - although, it would always help!
This course is not for you if you are confident using VBA, and are looking for more advanced techniques.

User Reviews

Rating

average 0

Total votes0

Focused display

Hi. I'm Phillip, and I'm proud to Teach with Udemy as a Udemy Instructor Partner. I have been teaching on Udemy since 2015, and I have over 500,000 students and more than 40 video courses, including over a dozen Bestseller courses.My courses include Power BI, Tableau, SQL Server, Power Platform (Power Apps, Power Automate, etc.), Azure, Microsoft Office, and more. Many of my courses follow requirements for official Microsoft certifications - so with a bit of practice, you could enter the exam and put it on your CV or resume.I have been a Computing Consultant providing expert services in the development of computer systems and data analysis. I am one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards. My interests are working with data, including Microsoft Power BI, Excel, Access, SQL Server, and the Power Platform.

I Do Data Limited

Instructor's Courses

I Do Data is dedicated to creating video courses on Udemy in a variety of computer-related topics, such as SQL in its different dialects and Microsoft Office.Are you wanting to learn a new skill from the beginning? Or are you wanting to build on an existing skill? In either case, welcome.Our courses are available on Udemy at any time, so you can watch them whenever you like, as often as you like.For many of our courses, if you master the skills taught, you are able (if you wish) to take (and hopefully pass) the official certification offered by Microsoft, Tableau or other companies. That would look good on your CV or resume? It could make the difference between getting a promotion, or a more rewarding job. I Do Data courses are dedicated to enabling you to succeed.

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.