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!

4.25 (120 reviews)

Udemy

platform

English

language

Programming Languages

What you will 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.

Why take this course?

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!

Reviews

Steven

December 28, 2021

This was a very basic simple course on how to create functions and apply them to a worksheet. Great job!

Jack

September 3, 2021

If you're new to the concept of how the VBAs Function-statement functions, then this course is a perfect first step into its definition! Love this course! You will too!

Jonathan

March 12, 2021

Daniel Strong's courses are adequate, to-the-point, and have increased my abilities far beyond what they ever were in corporate accounting.

Jim

September 22, 2020

In comparison to Garret Grant videos, very disjoint, non polished material review and end summary for each section. More "general" review material in place of actual creation of user defined functions.

Eric

August 17, 2020

I hate to do this, but this course is tough to follow. I'm through section 1.10 and found it very difficult to follow the instructor. He seems to be all over the place. Perhaps I need additional courses before trying this one. I will come back later after taking other Excel courses to see if I can better follow the instructor and update the rating.

Elizabeth

July 30, 2020

This instructor is making all sorts of assumptions about our knowledge of Excel. Pressing ALT+F11 opened the macro editor but not with anything on the top half where I could type. Looks like he opened something that already had macros or functions in there. I didn't know how to get the white window that allowed me to type what he was typing. Then I know about the left, mid and right functions to use in a worksheet but once the functions were created I could not get them to run as he showed. It just gave me #NAME?. Under Modules, I only show RibbonX_Code and not Module1 as he had. Very frustrating experience. If I can't get the beginning stuff to work there's probably no reason to go any farther with this course.

Hector

May 3, 2020

Awesome course! perfect complement to the course I took earlier called "The Ultimate Excel Programmer Course"

Rashed

May 2, 2020

The flow and examples provided are very good. The instructor pace and knowledge is Fantastic. I am enjoying the material of this course

Florian

March 24, 2019

The course was overall really interesting. I learned a lot of new things within excel and I'm really excited to try it with my own functions in my office.

Scott

March 18, 2019

Even though I've taken one of his other VBA classes it was valuable to review functions specifically.

Chris

January 4, 2019

Great description and good pace, brilliant thank you. I am keen to see if you can use a function within table calculations especially if you are moving across columns

Amihud

January 1, 2019

in the first lesson the text is very blurred and you cannot read whats in there beside that everything is good

Bob

December 19, 2018

This is the second or third course I've taken from Daniel. I have enjoyed every one and learned a tremendous amount in the process. I learned some really neat tricks in this course for functions. And I thought I already knew about all there was to know about functions...boy was I wrong! Keep up the good work, Daniel!

Kevin

November 26, 2018

Great course Daniel. I picked up quite a few tips to add to my arsenal of macros and learned a couple of things along the way. Recommend this course to anyone with a little VBA experience that wants to add to their knowledge.

Donald

November 22, 2018

Thanks Dan! I now see the value of creating custom functions in VBA routines. This new knowledge will certainly help to reduce code complexity!

Charts

Price

Rating

Enrollment distribution

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