Microsoft Excel For Mac 4: Vba Macros For Excel - An Intro

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).

Requirements

You need to have Microsoft Excel installed on your Mac.

You also need to have a little knowledge of Excel itself - how to enter values, do basic formulas and color cells.

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

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Welcome to Udemy

Lecture 3 Introduction to Udemy

Lecture 4 Do you want auto-translated subtitles in more languages?

Section 2: Recording your first macro

Lecture 5 The Developer Tab and creating My First Macro

Lecture 6 The editing environment

Lecture 7 Hello World!

Lecture 8 Saving our spreadsheet

Lecture 9 Opening our spreadsheet and Security

Section 3: Variables

Lecture 10 Introducing variables

Lecture 11 Scope

Lecture 12 Breakpoints, the Immediate Window and Watches

Lecture 13 String operators

Lecture 14 Declaring types of variables

Lecture 15 Avoiding typos

Section 4: The Excel Object Model

Lecture 16 Interacting with the Excel spreadsheet

Lecture 17 Introducing Objects

Lecture 18 Introducing the Object Model

Lecture 19 Default Objects, and Default Properties

Section 5: Loops and If statements

Lecture 20 For…Next Loops

Lecture 21 For…Next Loops part 2 - and debugging

Lecture 22 InputBox

Lecture 23 About the next video

Lecture 24 IsNumeric and If…Then

Lecture 25 If…Else…End If

Lecture 26 Val()

Lecture 27 Do While…Loop

Lecture 28 Using our Do While…Loop

Lecture 29 Other types of loops

Lecture 30 Selection

Lecture 31 Coding Exercise - Using For…Next Loop with Selection

Lecture 32 Set

Lecture 33 For Each…Next Loop

Section 6: Well done

Lecture 34 Congratulations

Lecture 35 Bonus Lecture

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.