Excel VBA Macros Hyperdisambiguated Excel VBA Programming

Learn Excel VBA macros, using clean, clear VBA programming techniques and code that you fully understand
Excel VBA Macros Hyperdisambiguated Excel VBA Programming
File Size :
7.36 GB
Total length :
11h 42m

Category

Instructor

Grant Gamble

Language

Last update

Last updated 11/2017

Ratings

4.3/5

Excel VBA Macros Hyperdisambiguated Excel VBA Programming

What you’ll learn

By the end of this course, you will be confidently writing VBA macros which automate procedures in Microsoft Excel.
You will fully understand the purpose and syntax of each line of code that you write.
You will not simply be entering lines of code because you have been told they will produce a certain result.
You will gain a solid understanding of both the VBA and Excel object models which underly VBA programming.

Excel VBA Macros Hyperdisambiguated Excel VBA Programming

Requirements

Experienced Excel users who are new to Excel VBA programming.

Description

This is a Udemy best-selleing course. Here is some of the feedback from other students:
“Best intro I’ve seen for a non programmer. Explains key concepts well.” Ron Willett
“Wonderful way of teaching. Shows the full hierarchy of both Excel and VBA objects. Now know the differences.” Bill Malemba
“Concise, thorough, yet repetitive enough to allow the concepts to stick. Love the real-world examples and the emphasis on concepts over code parroting. Best VBA tutorial I’ve found, hands down, bar none – covers top to bottom application/VBA structure which is immensely helpful. Well-organized, all code can be re-visited with provided worksheets…” Dy622
“this is my favourite excel vba course. Lot of exercises, lot of different area is covered, and really explains everything from step 1, not just the how, but the why as well. thanks to the course I understand vba and macros better than ever before.”

Excel VBA programming can seem baffling, especially when you don’t fully understand the code you are asked to write. Learn to write Excel VBA macros, from scratch, to automate Microsoft Excel tasks and operations.
This course is aimed particularly at Excel users without much programming experience, who struggle to remember the syntax and structure of the VBA (Visual Basic for Applications) programming language.
During the course, we will use a style of programming which emphasizes the significance of each line of code that you write. This means that when you revisit the code, the meaning of each line is apparent from the syntax, rather than becoming more and more unfamiliar. The course also demonstrates how to get the maximum benefit from IntelliSense, Microsoft’s code completion feature.
Whether you are looking to enhance your career prospects by adding Excel VBA to your C.V., save your company money or increase your productivity, this course will provide your with all the knowledge you need to get started.
You can download all of the materials used in the lectures, so that you can follow along. (Please, remember to unZIP the downloaded files.)

Overview

Section 1: 1. Getting Started

Lecture 1 1. Course introduction

Lecture 2 2. Excel VBA overview

Lecture 3 3. The Developer Tab

Lecture 4 4. Macro security

Lecture 5 5. The Visual Basic Editor and Project Explorer

Lecture 6 6. Excel objects and event code

Lecture 7 7. Writing a macro in the VBE

Lecture 8 8. Using the Immediate window

Lecture 9 9. Saving a macro-enabled workbook

Lecture 10 10. The correct way to use the macro recorder

Lecture 11 11. Analysing a recorded macro

Lecture 12 12. Improving a recorded macro

Lecture 13 13. Assigning a macro to a button

Lecture 14 14. Testing a macro on another worksheet

Section 2: 2. Key components of VBA code

Lecture 15 1. The Excel object model

Lecture 16 2. VBA classes and functions

Lecture 17 3. Properties and methods

Lecture 18 4. Data variables

Lecture 19 5. Object variables

Lecture 20 6. Option explicit

Lecture 21 7. Declaring and using constants

Lecture 22 8. Using MsgBox for output

Lecture 23 9. Using MsgBox for input

Lecture 24 10. Using VBA InputBox

Lecture 25 11. Using Application.InputBox

Section 3: 3. VBA Control statements

Lecture 26 1. If statements

Lecture 27 2. If … ElseIf statements

Lecture 28 3. Select Case

Lecture 29 4. For … Next loops

Lecture 30 5. For Each … Next loops

Lecture 31 6. Do … While loops

Lecture 32 7. Do … Until loops

Lecture 33 8. Creating arrays

Lecture 34 9. Dynamic arrays

Lecture 35 10. Utilising arrays

Section 4: 4. Procedures and Functions

Lecture 36 1. Sub Procedures and module level variables

Lecture 37 2. Static variables

Lecture 38 3. Passing parameters

Lecture 39 4. Creating and calling functions

Lecture 40 5. Creating user-defined functions

Section 5: 5. Application Object

Lecture 41 1. Changing and restoring user settings

Lecture 42 2. Application.GetOpenFilename Part 1

Lecture 43 3. Application.GetOpenFilename Part 2

Lecture 44 4. Application.GetSaveAsFilename

Lecture 45 5. Controlling screen updating

Lecture 46 6. Suppressing warning messages

Section 6: 6. Code recognition clinic

Lecture 47 1. Example 1

Lecture 48 2. Example 2

Lecture 49 3. Example 3

Lecture 50 4. Example 4

Lecture 51 5. Example 5

Lecture 52 6. Example 6

Lecture 53 07. Hyper-disambiguation practice

Section 7: 7. Files and Workbooks

Lecture 54 1. Targeting workbooks efficiently

Lecture 55 2. Checking whether a workbook is open

Lecture 56 3. Checking whether several workbooks are open

Lecture 57 4. Checking whether a file exists

Lecture 58 5. Checking whether a folder exists

Lecture 59 6. Deleting files and folders

Lecture 60 7. Processing all files in folder

Section 8: 8. Worksheets and charts

Lecture 61 1. Targeting worksheets efficiently

Lecture 62 2. Copying worksheets

Lecture 63 3. Moving worksheets between workbooks

Lecture 64 4. Saving worksheets as separate workbooks

Lecture 65 5. Working with the sheets collection

Lecture 66 7. Creating an embedded chart

Lecture 67 6. Creating a standalone chart

Section 9: 9. The Range object

Lecture 68 1. Copying a range of cells

Lecture 69 2. Using the Offset property

Lecture 70 3. The End property

Lecture 71 4. The Resize property

Lecture 72 5. Entering formulas with VBA

Lecture 73 6. Deleting ranges

Lecture 74 7. Inserting ranges

Lecture 75 8. Outlining ranges

Anyone wishing to learn professional Excel VBA programming techniques.

Course Information:

Udemy | English | 11h 42m | 7.36 GB
Created by: Grant Gamble

You Can See More Courses in the IT & Software >> Greetings from CourseDown.com

New Courses

Scroll to Top