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

$44

Great news! You already have access to this course! 👇

25

Lectures

2:22H

Duration

ALL

Skill Level

ENGLISH

Language

COURSE OVERVIEW

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.

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
Show you multiple examples of real-life uses of user-defined functions.
Special built in functions that are only available in the Visual Basic editor
How you can use regular worksheet functions in your VBA code.
Troubleshooting tips for advanced functions like VLookup and HLookup,
Three distinct methods of sharing your functions and macros with coworkers, friends and family
How to create your very own Excel Add-In that will make your formulas available to others.
String manipulation & randomization techniques and much more!

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!

LEARNING PATH

Introduction

Introduction – Basic Excel Functions Vs. UDFs
Resources Download
Left, Right Functions
MID Function
Your First Custom Function!
Calling A Custom Function In VBA Instead Of In A Cell

Video: 18 minutes, 6 lectures

Digging Deeper

What Are Parameters?
If You Run Into A Links Error…
Find Nth Word Function – Fun!
Optional Parameters And How To Tell If They’re Present
Optional Parameters Pt. 2 – Using Specific Params In Any Order
Custom Last Row Function (Works Dynamically For Any Sheet)
Get The Last Row Dynamically Pt. 2 – Which Column Parameter
Getting The Row Where Employees End And Subtotals Begin Plus Extra Function!
Using Worksheet Functions In VBA
Evaluate Function
Sum Function In VBA
Count Function In VBA
VLOOKUP And HLOOKUP Tips In VBA

Video: 1 hour & 34 minutes, 13 lectures

Sharing Custom Macros

Sharing Functions With Yourself Or Other Computers
Using Your Personal.XLSB Workbook To Share With Yourself – Plus Reference Trick
Creating An Excel AddIn and Ways To Use It

Video: 24 minutes, 3 lectures

Logical Functions

Randomization with Rnd() Or Randbetween() Functions
Thank You And Final Thoughts
BONUS LECTURE

Video: 6 minutes, 3 lectures

WHO THIS COURSE IS FOR

Beginners with Excel VBA wanting to expand their skills
Anyone wanting to learn how to create their own Excel Functions/Formulas

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.

create your own Add-In today!

What Students Say About The Course

STUDENTS' TESTIMONIALS

"The pace of the course was good. The examples were very basic so that they were easy to understand."

Vernon Robinson

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

Steven Livingston

“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!”

Jack Lenngren

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

Jonathan M Undernehr

"Done a couple of Dan's VBA courses and always very easy to follow and understand. Thanks!"

Jordan Sykes

"Awesome course! Perfect compliment to the course I took earlier called "The Ultimate VBA Course"”

Hector Sanchez

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

Rashed Al Naamani

"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."

Florian Rudin

"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"

Chris Thomas

"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!"

Bob Hutchins

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

Donald McRoberts

30-DAY MONEY BACK GUARANTEE

This is backed by a 30-day money back guarantee. No questions asked!

Frequently Asked Questions

What Are The Requirements To Take The Course

You should already have Microsoft Excel for PC.
Very basic Excel skills needed for this course.

When Can I Start Taking The Course?

The course will start right away upon signing up, you get instant access.

What Is Excel Ninja Pro?

How would you like access to ALL our Excel courses?

Excel Ninja Pro is a subscription streaming service that offers a wide variety of Excel resources, including premium online courses, code vault, swipe files, downloadable workbooks, projects, events, and a results-driven community of Automators.
You can watch as much as you want, commercial free – all for one low monthly price. There’s always something new coming soon and Ninja Pro members get to help decide what comes next!

Learn more HERE.

How Do I Access The Course?

Visit the My Courses link at the top left of the site menu. You can also visit the Member’s Area and click on Courses tab.

NOTE: You should have an email with a username and link to reset password initially. If not, please check spam folder (if none, contact us immediately or see “How do I change/update my password?” above).

Can I Learn At My Own Pace?

Today’s World is full of busy people that want to better themselves, so self-paced programs are popular. Yes, you can learn at your own speed, so that you can focus on things that you find challenging and breeze past things that you already know. You will be the one to decide when to start accessing the course materials and when to finish.

Do You Provide Support Or Assistance When Taking The Course?

Yes, definitely! If you have questions about the lesson, we will answer all your questions as soon as possible.

How Long Do I Have Access To The Course?

Does lifetime access sounds good to you? You’ll have unlimited access to the course once you’ve enrolled. This means you can re-watch lessons whenever you need and complete the course at your own pace.

What Certifications Can I Get?

Every course in the member’s area comes with a ‘Certificate of Completion’ that you can add to your LinkedIn bio, to your resume or even brag to your friends.

You also get achievement badges the more you participate, comment, and share with the group. You can check out our achievement’s dashboard!

Got Other Questions?

Send us an email at help@excelvbaisfun.com and we will get back to you ASAP.

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

$44

25