Ending In:
$138
78% off
Courses
2
Lessons
12
Enrolled
1,745
Courses
2
Lessons
12
Enrolled
1,745
What's Included
Advanced VBA
$69 Value
Microsoft VBA
$69 Value
Product Details
1 of 2
Access
1 year
Content
5 hours
Lessons
7
Advanced VBA
Start Automating Complicated Tasks in Excel
By Excel with Business | in Online Courses
This advanced course will expand on your beginner's foundations of working with Microsoft VBA. Delving into a more granular level, you'll gain a comprehensive understanding of how using VBA in Excel can transform the way you manage and communicate with data. This course is accredited by CPDUK, making it a valuable addition to your resume.
- Access 5 hours of content 24/7
- Understand how to write & implement Excel events
- Learn how to design & implement special classes of objects
- Find out how to use input boxes & message boxes to interact w/ end users
- Customize the right click menu w/ cell ranges
- Explore how to modify the Excel user interface, including the Ribbon & context menus to interact w/ your VBA code
- Create cross-functional flowcharts
Formed in 2009, Excel with Business was created by founders Marc, Vin and Chris to solve a problem close to their hearts – ineffective Microsoft Excel training. As three Strategy and Management Consultants they understood the importance of being able to apply MS Excel skills in a business context.
The main issue was that too many Excel courses were focussing on the software functionality rather than how that was applicable in business. They taught everything, creating long and laborious courses – rather than focusing on the most business-relevant parts of Excel… so an idea was born:
A business relevant Excel training course that was affordable and personalized to each person taking it.
The first Excel course quickly attracted over 100,000 users. Fast forward a few years and we have expanded our focus on improving personal productivity and helping people achieve their career ambitions through a comprehensive library of 50+ Microsoft and Business training courses. The principles of getting the right training to the right user remain and has become more sophisticated through the introduction of the filter on many courses.
For more details on this course and instructor, click here.
The main issue was that too many Excel courses were focussing on the software functionality rather than how that was applicable in business. They taught everything, creating long and laborious courses – rather than focusing on the most business-relevant parts of Excel… so an idea was born:
A business relevant Excel training course that was affordable and personalized to each person taking it.
The first Excel course quickly attracted over 100,000 users. Fast forward a few years and we have expanded our focus on improving personal productivity and helping people achieve their career ambitions through a comprehensive library of 50+ Microsoft and Business training courses. The principles of getting the right training to the right user remain and has become more sophisticated through the introduction of the filter on many courses.
For more details on this course and instructor, click here.
Details & Requirements
- Length of time users can access this course: 1 year
- Access options: web streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: advanced
Compatibility
- Internet required
- Microsoft Excel
Course Outline
- Section 1: Overview
- Section 2: Foundation
- Section 3: Events
- Section 4: Creating Objects
- Section 5: The Excel Interface
- Section 6: References & Libraries
- Section 7: Closure
Access
1 year
Content
4 hours
Lessons
5
Microsoft VBA
Get Started with Microsoft VBA to Revolutionize the Way You Work with Excel Data
By Excel with Business | in Online Courses
VBA, or Visual Basic for Applications, is like Excel on steroids. It may seem daunting, but with just a little VBA knowledge you'll be able to automate tasks in Excel and turbocharge your data handling capabilities. In this course, you'll get up to speed on all the basics, regardless of your prior experience. This course is accredited by CPDUK, making it a valuable addition to your resume.
- Access 4 hours of content 24/7
- Learn how to automate tasks & operations that you perform frequently
- Discover how to define & manage variables, set up subroutines, & create functions
- Understand practical methods for using macro errors to improve your VBA code
- Explore the PivotTable object & basic approaches to utilizing it
Formed in 2009, Excel with Business was created by founders Marc, Vin and Chris to solve a problem close to their hearts – ineffective Microsoft Excel training. As three Strategy and Management Consultants they understood the importance of being able to apply MS Excel skills in a business context.
The main issue was that too many Excel courses were focussing on the software functionality rather than how that was applicable in business. They taught everything, creating long and laborious courses – rather than focusing on the most business-relevant parts of Excel… so an idea was born:
A business relevant Excel training course that was affordable and personalized to each person taking it.
The first Excel course quickly attracted over 100,000 users. Fast forward a few years and we have expanded our focus on improving personal productivity and helping people achieve their career ambitions through a comprehensive library of 50+ Microsoft and Business training courses. The principles of getting the right training to the right user remain and has become more sophisticated through the introduction of the filter on many courses.
For more details on this course and instructor, click here.
The main issue was that too many Excel courses were focussing on the software functionality rather than how that was applicable in business. They taught everything, creating long and laborious courses – rather than focusing on the most business-relevant parts of Excel… so an idea was born:
A business relevant Excel training course that was affordable and personalized to each person taking it.
The first Excel course quickly attracted over 100,000 users. Fast forward a few years and we have expanded our focus on improving personal productivity and helping people achieve their career ambitions through a comprehensive library of 50+ Microsoft and Business training courses. The principles of getting the right training to the right user remain and has become more sophisticated through the introduction of the filter on many courses.
For more details on this course and instructor, click here.
Details & Requirements
- Length of time users can access this course: 1 year
- Access options: web streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: all levels
Compatibility
- Internet required
- Microsoft Excel
Course Outline
- Section 1: Introduction
- Section 2: VBA and Macros
- Section 3: Functions
- Section 4: Common Keys to VBA
- Section 5: Closure
Terms
- Unredeemed licenses can be returned for store credit within 15 days of purchase. Once your license is redeemed, all sales are final.
