Excel VBA Formulas, Functions, UDFs + Create Your Own AddIn!
4.5 (77 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
651 students enrolled

Excel VBA Formulas, Functions, UDFs + Create Your Own AddIn!

Learn Built-In VBA Functions, Build Your Own Custom UDF (User-Defined Functions) and Learn To Share Them!
Bestseller
4.5 (77 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
651 students enrolled
Created by Daniel Strong
Last updated 4/2019
English
English [Auto-generated]
Current price: $67.99 Original price: $104.99 Discount: 35% off
15 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 2 articles
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Create custom Excel Functions
  • How To use parameters to allow users to specify how they want to use your functions
  • Understand real-life uses of user-defined functions (UDFs)
  • Learn Special built-in Functions that are only available in the Visual Basic editor
  • Utilize Regular Worksheet Functions in your VBA code
  • Breeze through Advanced Functions like VLookup and HLookup in VBA with our Troubleshooting tips
  • Master String manipulation & Randomization techniques in VBA
  • Discover the 3 Distinct Methods of sharing your functions and macros with coworkers, friends and family
  • Create your very own Excel Add-In that will make your formulas available to others.
Course content
Expand all 25 lectures 02:22:10
+ Introduction
6 lectures 18:06
Resources Download
00:03
LEFT, RIGHT Functions
02:53
MID Function
02:47
Your First Custom Function!
04:46
+ Digging Deeper...
13 lectures 01:33:32
What are Parameters?
04:58
If you run into a Links Error...
02:03
Find Nth Word Function - Fun!
12:39
Optional Parameters and How to Tell If They're Present
06:41
Optional Parameters Pt. 2 - Using Specific Params In Any Order
07:58
Custom LastRow Function (Works Dynamically for Any Sheet)
08:14
Getting The Row Where Employees End and Subtotals Begin Plus Extra Function!
14:54
Using Worksheet Functions in VBA
06:21
Evaluate Function
05:59
Sum Function in VBA
03:14
VLookup and HLookup Tips in VBA
13:02
+ Sharing Custom Macros
3 lectures 24:27
Sharing Functions With Yourself or Other Computers!
04:29
Using Your Personal.XLSB Workbook To Share With Yourself - Plus Reference Trick
09:24
Creating An Excel AddIn and Ways To Use It!
10:34
+ Logical Functions
3 lectures 06:04
Randomization with Rnd() or Randbetween() functions
04:16
Thank You and Final Thoughts
01:45
BONUS LECTURE
00:03
Requirements
  • Need to Have Excel
Description

The last thing you want to do is waste your own time! Unfortunately, most Excel users find themselves creating humongous formulas that are prone to errors, nested if statements that will drive you nuts and generally looking for more efficient ways to perform routine tasks or look up data.

Microsoft Excel has some amazing built-in formulas, but they don't always have the special customizations that you need.

[Enter custom functions and formulas.]

With this course, you're going to master creating your own customized formulas using Excel VBA, the hidden programming language behind Microsoft Excel. You'll learn the ins and outs of using VBA to supercharge your productivity in Excel. Regardless of programming experience, if you're ready to step up your game and increase productivity and efficiency in your Excel usage, this course is for you.

We'll show you:

  • How To use parameters to allow users to specify how they want to use your functions as well as

  • Show you multiple examples of real-life uses of user-defined functions. We'll also show you

  • Special built in functions that are only available in the Visual Basic editor as well as

  • How you can use regular worksheet functions in your VBA code. We'll also review

  • Troubleshooting tips for advanced functions like VLookup and HLookup,

  • String manipulation & Randomization techniques and much more! We'll also show you

  • Three distinct methods of sharing your functions and macros with coworkers, friends and family Including

  • How to create your very own Excel Add-In that will make your formulas available to others.

    Take the next step in your Excel mastery and grab your lifetime access for Excel VBA formulas functions and UDF's-and create your own ad in today!

Take the next step in your Excel mastery and grab your lifetime access pass for "Excel VBA Formulas, Functions & UDFs - and create your own Add-In today!

Who this course is for:
  • Beginners with Excel VBA wanting to expand their skills
  • Anyone wanting to learn how to create your own Excel Functions/Formulas
  • Do not take this course if you hate learning awesome stuff