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

 

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

 

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

Video: 6 minutes, 3 lectures

WHO THIS COURSE IS FOR

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

WHAT YOU'LL LEARN

create your own Add-In today!

What Students Say About The Course

STUDENTS' TESTIMONIALS

30-DAY MONEY BACK GUARANTEE

We are confident that our course will provide you with immense value and help you achieve your goals. To demonstrate our commitment to your satisfaction, we offer a 30-day money back guarantee. If for any reason you are not completely satisfied with the course within 30 days of your purchase, simply contact our customer support team, and we will refund your full payment. No questions asked! 

Frequently Asked Questions

  • You should already have Microsoft Excel for PC.
  • Very basic Excel skills needed for this course. 
  • The course will start right away upon signing up, you get instant access.

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.

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

  • 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.
  • Yes, definitely! If you have questions about the lesson, we will answer all your questions as soon as possible.
  • 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.

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!

© 2024 – Strong Software Solutions LLC | ExcelVbaIsFun – Privacy PolicyTerms and Conditions
This site is not a part of the Facebook website or Facebook Inc. Additionally, This site is NOT endorsed by Facebook in any way.

FACEBOOK is a trademark of FACEBOOK, Inc.
X

Forgot Password?

Join Us

1
    1
    Your Cart