-
Cart
Registering for this site is easy. Just fill in the fields below, and we'll get a new account set up for you in no time.
Sign in to your One Education account
Excel 365 VBA Expert
Excel 365 VBA Expert
PRIVATE
PRIVATE COURSE OR
1 Year Access 
Intermediate
0 Students -
5 hours, 34 minutes
Learning Outcome
- Learn how to use the VBA editor and add macro buttons
- Discover how to work with integer variables and other variable types
- Know how to work with statements and understand conditional operators
- Gain ways to work with text strings and understand loops
- Explore ways to use various VBA functions and work with boxes
- Understand how to create a user form and debug coding
Overview
Learn how to automate Microsoft Office tasks and use one of the most outstanding abilities available in spreadsheets by taking the Excel 365 VBA Expert course. In conjunction with all the other functions, Visual Basic for Applications (VBA) enables users to take their analytical and coding abilities to new and innovative levels. This comprehensive training will offer you the edge in Excel usage, ensuring that your data is calculated spontaneously and accurately.
This advanced Excel tutorial will introduce you to the complex and valuable contribution that VBA can have to data and formulas. You’ll be shown how to work proficiently with VBA language, control variables, work with loops, call sub procedures, and much more. With these interactive teaching modules, you’ll be able to automatically transform data into powerful visuals and enhance your coding abilities.
Course design
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
- Video lessons
- Online study materials
Will I receive a certificate of completion?
Upon successful completion, you will qualify for the UK and internationally-recognised CPD accredited certification. You can choose to make your achievement formal by obtaining your PDF Certificate at the cost of £9 and Hard Copy Certificate for £15.
Why study this course
It doesn’t matter if you are an aspiring professional or absolute beginner; this course will enhance your expertise and boost your CV with critical skills and an accredited certification attesting to your knowledge.
The Excel 365 VBA Expert is fully available to anyone, and no previous qualifications are needed to enrol. All One Education needs to know is that you are eager to learn and are over 16.
Course Curriculum
| Course Introduction | |||
| Introduction | 00:03:00 | ||
| Unit 01 | |||
| Lesson 1-Adding the Developer Toolbar | 00:05:00 | ||
| Lesson 2-Understanding the VBA Editor | 00:11:00 | ||
| Lesson 3-Recording a Macro in Personal | 00:10:00 | ||
| Lesson 4-Understanding the Elements of the VBA Language | 00:07:00 | ||
| Lesson 5-Understanding Methods | 00:05:00 | ||
| Lesson 6-Understanding Comments | 00:06:00 | ||
| Lesson 7-Working with the Range Property and Worksheet Object | 00:07:00 | ||
| Lesson 8-Adding a Macro Button to a Spreadsheet | 00:03:00 | ||
| Lesson 9-Working with the ActiveCell Object | 00:02:00 | ||
| Lesson 10-Working with the Offset Property | 00:08:00 | ||
| Unit 02 | |||
| Lesson 1-Understanding Variables | 00:07:00 | ||
| Lesson 2-Working with Integer Variables | 00:03:00 | ||
| Lesson 3-Understanding Option Explicit | 00:05:00 | ||
| Lesson 4-Working with Other Variable Types | 00:07:00 | ||
| Unit 03 | |||
| Lesson 1-Working with IF Statements | 00:04:00 | ||
| Lesson 2-Working with ELSE | 00:03:00 | ||
| Lesson 3-Working with ELSEIF | 00:03:00 | ||
| Lesson 4-Understanding Conditional Operators | 00:06:00 | ||
| Lesson 5-Working with NOT, AND, and OR | 00:07:00 | ||
| Lesson 6-Working with Nested IF | 00:04:00 | ||
| Lesson 7-Working with Select Case | 00:06:00 | ||
| Lesson 8-Working with WITH and END WITH | 00:05:00 | ||
| Unit 04 | |||
| Lesson 1-Working with Text Strings | 00:05:00 | ||
| Lesson 2-Working with LCASE and UCASE Functions | 00:05:00 | ||
| Lesson 3-Working with LEN and TRIM Functions | 00:07:00 | ||
| Lesson 4-Working with LEFT, RIGHT, and MID Functions | 00:07:00 | ||
| Unit 05 | |||
| Lesson 1-Understanding Loops | 00:02:00 | ||
| Lesson 2-Working with For Next Loops | 00:07:00 | ||
| Lesson 3-Working with For Each Loops | 00:06:00 | ||
| Lesson 4-Working with Cells Property | 00:08:00 | ||
| Lesson 5-Working with Do Until Loops | 00:09:00 | ||
| Lesson 6-Working with Do While Loops | 00:05:00 | ||
| Unit 06 | |||
| Lesson 1-Calling Sub Procedures | 00:05:00 | ||
| Lesson 2-Working with Exit Sub | 00:04:00 | ||
| Lesson 3-Working with Message Boxes | 00:08:00 | ||
| Lesson 4-Working with Input Boxes | 00:08:00 | ||
| Lesson 5-Working with VBA Functions | 00:12:00 | ||
| Lesson 6-Working with Object Variable and Set | 00:06:00 | ||
| Unit 07 | |||
| Lesson 1-Understanding and Creating a User Form | 00:08:00 | ||
| Lesson 2-Adding Controls to a User Form | 00:16:00 | ||
| Lesson 3-Adding Code for a User Form | 00:10:00 | ||
| Lesson 4-Launching a User Form from Excel | 00:05:00 | ||
| Unit 08 | |||
| Lesson 1-Getting Started with Debugging | 00:10:00 | ||
| Lesson 2-Stepping Through Your Code | 00:06:00 | ||
| Lesson 3-Working with Breakpoints | 00:03:00 | ||
| Lesson 4-Working with the Immediate Window | 00:05:00 | ||
| Lesson 5-Working with the Locals Window | 00:05:00 | ||
| Lesson 6-Working with the Err Object | 00:06:00 | ||
| Lesson 7-Getting Help-v2 | 00:07:00 | ||
| Course Recap | |||
| Recap | 00:02:00 | ||
| Final Exam | |||
| Final Exam – Excel 365 VBA Expert | 00:20:00 | ||
Related Courses
Intermediate
Intermediate
With a team of industry professionals producing and delivering our course content, you can be sure the skills and knowledge you learn are applicable to your career aspirations, whether that’s in management, administration or beyond.
0
0
Your Cart
Your cart is emptyBrowse Courses
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.
Other Students Also Buy
-
Get Lifetime Access To Your Course£9.99 Add to basket+Add