Get $1 credit for every $25 spent!

Microsoft VBA Bundle

Ending In:
Add to Cart - $29.99
Add to Cart ($29.99)
$138
78% off
wishlist
(80)
Courses
2
Lessons
12
Enrolled
797

What's Included

Product Details

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.

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

View Full Curriculum


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.

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

View Full Curriculum



Terms

  • Instant digital redemption

15-Day Satisfaction Guarantee

We want you to be happy with every course you purchase! If you're unsatisfied for any reason, we will issue a store credit refund within 15 days of purchase.