All Courses for £49
Overview
By enroling in Excel VBA/Macros Foundations, you can kickstart your vibrant career and strengthen your profound knowledge. You can learn everything you need to know about the topic.
The Excel VBA/Macros Foundations course includes all of the most recent information to keep you abreast of the employment market and prepare you for your future. The curriculum for this excellent Excel VBA/Macros Foundations course includes modules at all skill levels, from beginner to expert. You will have the productivity necessary to succeed in your organisation once you have completed our Excel VBA/Macros Foundations Program.
So enrol in our Excel VBA/Macros Foundations course right away if you’re keen to envision yourself in a rewarding career.
Description
Enroling in this Excel VBA/Macros Foundations course can improve your Excel VBA/Macros Foundations perspective, regardless of your skill levels in the Excel VBA/Macros Foundations topics you want to master. If you’re already a Excel VBA/Macros Foundations expert, this peek under the hood will provide you with suggestions for accelerating your learning, including advanced Excel VBA/Macros Foundations insights that will help you make the most of your time. This Excel VBA/Macros Foundations course will act as a guide for you if you’ve ever wished to excel at Excel VBA/Macros Foundations.
Why Choose Us?
- After successfully completing the Excel VBA/Macros Foundations Course, you will receive a FREE PDF Certificate as evidence of your newly acquired abilities.
- Lifetime access to the whole collection of Excel VBA/Macros Foundations learning materials.
- Online test with immediate results
- Enroling in the course has no additional cost.
- You can study and complete the Excel VBA/Macros Foundations course at your own pace.
- Study for the Excel VBA/Macros Foundations course using any internet-connected device, such as a computer, tablet, or mobile device.
Who Is This Course For?
This Excel VBA/Macros Foundations course is a great place to start if you’re looking to start a new career in Excel VBA/Macros Foundations field. This training is for anyone interested in gaining in-demand Excel VBA/Macros Foundations proficiency to help launch a career or their business aptitude.
Requirements
The Excel VBA/Macros Foundations course requires no prior degree or experience. All you require is English proficiency, numeracy literacy and a gadget with stable internet connection. Learn and train for a prosperous career in the thriving and fast-growing industry of Excel VBA/Macros Foundations, without any fuss.
Career Path
This Excel VBA/Macros Foundations training will assist you develop your Excel VBA/Macros Foundations ability, establish a personal brand, and present a portfolio of relevant talents. It will help you articulate a Excel VBA/Macros Foundations professional story and personalise your path to a new career. Furthermore, developing this Excel VBA/Macros Foundations skillset can lead to numerous opportunities for high-paying jobs in a variety of fields.
Course Curriculum
| Section 01: Introduction | |||
| Recording Macros vs Writing VBA | 00:04:00 | ||
| Understanding Objects in Excel VBA | 00:07:00 | ||
| Understanding VBA Syntax and Parts of Speech | 00:10:00 | ||
| Activating the Developer tab | 00:01:00 | ||
| Recording a basic Macro | 00:05:00 | ||
| Absolute vs Relative Macro recording | 00:04:00 | ||
| Section 02: Exploring the Visual Basic Environment | |||
| Introduction to the Visual Basic Environment | 00:02:00 | ||
| The Project Explorer | 00:02:00 | ||
| The Properties Window | 00:02:00 | ||
| The Code Window | 00:04:00 | ||
| Immediate, Locals and Watch Window | 00:03:00 | ||
| Dealing with Modules | 00:03:00 | ||
| Comments in Excel VBA | 00:01:00 | ||
| Section 03: The Range Object | |||
| Introduction and Changing Cell Values | 00:10:00 | ||
| Adding a text to a cell | 00:01:00 | ||
| Dealing with Named Ranges | 00:03:00 | ||
| Value vs Text Property | 00:04:00 | ||
| Row and Column properties | 00:02:00 | ||
| The Select Method | 00:02:00 | ||
| The Count Property | 00:04:00 | ||
| The Address Property | 00:09:00 | ||
| The Formula Property | 00:03:00 | ||
| The Number Format Property | 00:07:00 | ||
| The Font Property | 00:08:00 | ||
| Section 04: Understanding the Cells Collection Object | |||
| What is the cells object? | 00:06:00 | ||
| Using the Cells collection to affect cells positionally within a range | 00:05:00 | ||
| Affecting all cells within a sheet | 00:02:00 | ||
| Combining Range and cells objects | 00:03:00 | ||
| Section 05: Working with Sheets/Worksheets | |||
| Selecting Sheets | 00:06:00 | ||
| Adding Sheets | 00:11:00 | ||
| Sheets vs Worksheets | 00:04:00 | ||
| Copying Sheets | 00:05:00 | ||
| Moving Sheets | 00:01:00 | ||
| Deleting Sheets | 00:04:00 | ||
| Section 06: Understanding Variables in Excel VBA | |||
| Introduction to Variables | 00:06:00 | ||
| Variable Data Types | 00:09:00 | ||
| Declaring Variables | 00:14:00 | ||
| Object Variables | 00:08:00 | ||
| Calling a procedure from Another Procedure & Variable Scope | 00:03:00 | ||
| Public and Private Variables | 00:07:00 | ||
| Declaring Constants | 00:04:00 | ||
| Exercises-Variables | 00:06:00 | ||
| Section 07: Dealing with Workbooks | |||
| Referring to Workbooks-Different ways | 00:04:00 | ||
| Closing Workbooks | 00:03:00 | ||
| Adding and Saving Workbooks Part 1 – Save method | 00:04:00 | ||
| Adding and Saving Workbooks Part 2 – Save as method | 00:10:00 | ||
| Opening Workbooks | 00:06:00 | ||
| Section 08: Must Know Excel VBA Logic | |||
| Finding the Last row | 00:09:00 | ||
| Finding the Last Column | 00:04:00 | ||
| Finding the next row | 00:04:00 | ||
| The WITH Statement | 00:04:00 | ||
| Comparison operators in Excel VBA | 00:01:00 | ||
| IF Statements- Simple IF Statements | 00:07:00 | ||
| IF THEN ELSE Structure | 00:03:00 | ||
| IF THEN ELSEIF Structure | 00:07:00 | ||
| Nested IFs | 00:04:00 | ||
| OR – AND logical operators | 00:07:00 | ||
| NOT Logical operator | 00:03:00 | ||
| CASE Statements Part 1 – Single Case Statements | 00:09:00 | ||
| CASE Statements Part 2 – Nested Case Statements | 00:06:00 | ||
| Case Statements-Exercise | 00:01:00 | ||
| GOTO and Labels | 00:03:00 | ||
| Section 09: Looping in Excel VBA | |||
| Loops-Introduction | 00:01:00 | ||
| FOR NEXT Loop | 00:11:00 | ||
| Exit For | 00:09:00 | ||
| Exercise – For Next loop | 00:01:00 | ||
| FOR EACH Loop – Intro | 00:07:00 | ||
| FOR EACH Loops – More examples | 00:05:00 | ||
| Do Loop – Introduction | 00:04:00 | ||
| Do Loop Example | 00:01:00 | ||
| Do Until | 00:02:00 | ||
| Do While | 00:02:00 | ||
| Do while vs Do until – Movies Example | 00:04:00 | ||
| Exit Do Statement | 00:05:00 | ||
| Exercise – Do Loop | 00:01:00 | ||
| Section 10: Interacting with Your Users | |||
| The Messagebox – Introduction | 00:03:00 | ||
| Messagebox -Inputs | 00:07:00 | ||
| Messagebox – Capturing the User’s input | 00:05:00 | ||
| Adding a new line to your VBA Strings | 00:02:00 | ||
| The Inputbox – introduction | 00:04:00 | ||
| Inputbox – Example1 – Capturing a user’s name | 00:05:00 | ||
| Inputbox -Employee Database Example Part 1 | 00:05:00 | ||
| Inputbox -Employee Database Example Part 2 | 00:04:00 | ||
| Exercise – InputBox | 00:02:00 | ||
| Section 11: Error Handling in Excel VBA | |||
| Error Handling – Introduction | 00:09:00 | ||
| Different Error types in action | 00:04:00 | ||
| On Error Goto statement | 00:04:00 | ||
| Resetting the error handling Status with On Error Goto | 00:02:00 | ||
| The Err Object | 00:07:00 | ||
| Setting a Breakpoint | 00:02:00 | ||
| Section 12: Triggering Code with Events! | |||
| Worksheet Events -Selection change | 00:08:00 | ||
| Worksheet Events – Worksheet Activate event | 00:03:00 | ||
| Worksheet Events – Deactivate event | 00:02:00 | ||
| Worksheet Events – Before Delete Event | 00:02:00 | ||
| Worksheet Events – Before Double click event | 00:08:00 | ||
| Worksheet Events – Before Right Click event | 00:03:00 | ||
| Worksheet Events – Calculate event | 00:03:00 | ||
| Enabling and Disabling Events | 00:03:00 | ||
| Worksheet events – Worksheet change event | 00:11:00 | ||
| Worksheet events – Follow Hyperlink event | 00:03:00 | ||
| Worksheet events -Exercise | 00:01:00 | ||
| Workbook Events – Workbook open event | 00:05:00 | ||
| Workbook Events – Workbook Activate event | 00:02:00 | ||
| Workbook Events – Workbook Before save event | 00:06:00 | ||
| Workbook Events – Workbook Aftersave event | 00:04:00 | ||
| Workbook Events – Workbook Beforeclose event | 00:09:00 | ||
| Workbook Events – Workbook BeforePrint event | 00:03:00 | ||
| Workbook Events -Workbook De-activate events | 00:02:00 | ||
| Workbook Events – New Chart event | 00:08:00 | ||
| Workbook Events -New sheet event | 00:03:00 | ||
| Workbook Events – Sheet calculate event | 00:03:00 | ||
| Workbook Events – Sheet De-activate event | 00:06:00 | ||
| Workbook Events – Follow Hyperlink event | 00:02:00 | ||
| Workbook Events – Workbook Window Activate event | 00:06:00 | ||
| Workbook Events – Workbook Window De-Activate event | 00:02:00 | ||
| Workbook Events – Window Resize event | 00:02:00 | ||
| Exercise- Workbook Events | 00:01:00 | ||
Related Courses
