Excel 365 VBA Expert

For You
For Business

Excel 365 VBA Expert

PRIVATE

PRIVATE COURSE

*Certification Fee Applicable

1 Year Access
Intermediate
0 Students
5 hours, 34 minutes

Gift this course

£19.99 /Unit Price

£199.9

Quantity:

Add to Cart

Buying more than one of the same courses?

50% discount for orders of 10+ courses
65% discount for orders of 25+ courses
75% discount for orders of 50+ courses

Looking for a more personalised package?

get Access To All 3500+ One Education Courses For Just £49/Year!
Claim Offer

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