![acredations](https://studyhub.org.uk/wp-content/themes/wplmsblankchildhtheme/assets/img/accredations.png)
A Complete Guide for Effective LinkedIn Ads” is a comprehensive course that covers the fundamentals of setting up and managing successful LinkedIn Ads campaigns. Participants will learn to drive website traffic, utilize sponsored messages, generate leads, and effectively manage billing centers on the platform.
After studying the course materials of the Excel VBA/Macros Foundations there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60.
This Excel VBA/Macros Foundations course is ideal for
This Excel VBA/Macros Foundations does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Excel VBA/Macros Foundations was made by professionals and it is compatible with all PC’s, Mac’s, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.
As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Excel VBA/Macros Foundations is a great way for you to gain multiple skills from the comfort of your home.
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 | ||
Workbook Events – Follow Hyperlink event | 00:02: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 | ||
Resources | |||
Resources – Excel VBA/Macros Foundations | 00:00:00 | ||
Assignment | |||
Assignment – Excel VBA/Macros Foundations | 00:00:00 |
Overview The Ultimate Microsoft Office Bundle course will allow you to get the very best results from every one of …
65
Overview Uplift Your Career & Skill Up to Your Dream Job – Learning Simplified From Home! Kickstart your career & …
1
Dive deep into the intricate world of Microsoft Office with a tailored course specifically designed for Arabic speakers. The “Microsoft …
1