Booking options
£10.99
Course Images
Excel VBA/Macros Foundations
By Studyhub UK
(3)- 30 Day Money Back Guarantee
- Completion Certificate
- 24/7 Technical Support
Highlights
On-Demand course
8 hours 52 minutes
All levels
Description
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.
Learning Outcomes:
Understand the basics of LinkedIn Ads and their role in digital marketing.
Learn how to set up LinkedIn Ads to drive targeted website traffic.
Discover techniques for leveraging sponsored messages to engage with the audience.
Acquire the skills to create and optimize LinkedIn Ads for lead generation.
Gain proficiency in managing the billing center for efficient campaign budgeting and monitoring.
Why buy this Excel VBA/Macros Foundations?
Unlimited access to the course for forever
Digital Certificate, Transcript, student ID all included in the price
Absolutely no hidden fees
Directly receive CPD accredited qualifications after course completion
Receive one to one assistance on every weekday from professionals
Immediately receive the PDF certificate after passing
Receive the original copies of your certificate and transcript on the next working day
Easily learn the skills and knowledge from the comfort of your home
Certification
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.
Who is this course for?
This Excel VBA/Macros Foundations course is ideal for
Students
Recent graduates
Job Seekers
Anyone interested in this topic
People already working in the relevant fields and want to polish their knowledge and skill.
Prerequisites
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.
Career path
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.
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 | ||
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 |
About The Provider
Studyhub UK
London, England
(3)Studyhub is a premier online learning platform which aims to help individuals worldwide to realise their educational dreams. For 5 years, we have been dedicated...
Reviews
There are no reviews for Excel VBA/Macros Foundations yet.Why not be the first one to review this course?