Excel VBA Formulas, Functions, UDFs + Create Your Own AddIn
Build Custom Functions, Automate Tasks, and Share Your Excel Solutions with Add-Ins
- 100% Online
- All
- English
Stop Struggling With Complex Excel Formulas
Tired of spending hours on giant, error-prone formulas? Frustrated with nested IF statements that make your head spin? You’re not alone! Most Excel users face the same problem spending way too much time on tasks that could be automated or simplified.
Excel has amazing built-in formulas, but they don’t always do exactly what you need. That’s where Excel VBA comes in. With VBA, you can create custom formulas and functions that fit your workflow perfectly and even share them with others.
What You’ll Learn in This Course
From your first custom formula to building your own Excel Add-In, this course shows you how to make Excel work exactly the way you want.
- Start Simple Understand the difference between built-in functions and custom ones, then create your very first function in VBA.
- Make Functions Smarter Add flexible parameters and optional settings so your formulas adapt to different situations.
- Solve Real Problems Build functions to find the last row, clean up text, or improve lookups like VLOOKUP & HLOOKUP.
- Mix Excel + VBA Power Combine worksheet functions with VBA to unlock advanced automation not possible in Excel alone.
- Master Everyday Tools Use string manipulation, randomization, and logical functions to handle unique tasks with ease.
- Share Your Work Package your macros and custom functions so others can use them, even across different computers.
- Go Pro Build a polished Excel Add-In to distribute your own formulas like a professional tool.
Meet the Instructor:
Daniel Strong
Daniel Strong, founder of ExcelVBAIsFun, is a recognized Excel and VBA automation expert with 16+ years of experience in report generation, data analysis, and workflow automation. A passionate programmer since his teens, Daniel has built systems that save professionals hours of repetitive work and streamline high-volume processes across corporate reporting, finance, and Excel-based automation.
Recognized by Microsoft for his innovative systems and training strategies, Daniel has helped thousands of learners through his YouTube channel and online courses become confident Excel VBA developers who create real programs, solve real problems, and achieve measurable results.
In “Excel VBA Formulas, Functions & UDFs” course, Daniel teaches step-by-step how to write powerful custom functions, optimize formulas, and build UDFs (User-Defined Functions) that extend Excel’s capabilities. You’ll gain practical, real-world skills that allow you to automate repetitive calculations, simplify complex workflows, and unlock the full potential of Excel empowering you to work smarter, faster, and more efficiently from day one.
What You’ll Get
Everything you need to transform your Excel skills:
- 25 step-by-step video lessons (2+ hours) from formulas to Add-Ins
- Hands-on demonstrations for all key concepts
- Special code samples to automate your projects
- Customizable templates including Add-Ins, functions, and resources
- BONUS tips & tricks for string handling, randomization, and workflow shortcuts
- Lifetime access — all updates included
Who Should Take This Course?
This course is designed for Excel users who want to go beyond the basics and unlock advanced capabilities. If you’ve ever thought, “I wish Excel had a formula for this” — this training is for you. Freelancers, analysts, business professionals, and Excel power users will all gain the skills to create powerful, reusable solutions. By the end, you won’t just be using Excel — you’ll be extending it.
24/7 GPT-Powered Support Learning and Building Without Limits
Learning how to create your own formulas and functions in VBA can be both exciting and challenging.
That’s why the Excel VBA Formulas, Functions, UDFs + Create Your Own Add-In Course includes a built-in 24/7 Expert Assistant to guide you through every lesson.
If you need a quick summary, an explanation of how a UDF works, or help understanding how to turn your code into an add-in, the Assistant is there to help — anytime.
No waiting or searching, just instant, clear answers that help you learn faster and apply each concept with confidence.
Don’t Wait to Take Your Excel Skills to the Next Level
Start creating custom functions, UDFs, and Add-Ins today to work smarter, impress your team, and save hours of effort every week.
What Learners Are Saying
GET LIFETIME ACCESS TODAY
Invest once. Learn forever. With a single payment, you’ll unlock everything you need to master the material course without hidden fees or subscriptions.
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!
Sale Price:
$54.00
Regular Price:
$98.00
Lifetime Access For A One-Time Fee
$98.00
- 24/7 Expert Course Assistant
- Lifetime Access to 25 Course Lectures
- Step-by-Step 2:22 Hours of Video Lessons
- Downloadable Resources
- Certificate of Completion
Frequently Asked Questions
- You should already have Microsoft Excel for PC. Obviously the newer the better, but VBA works the same in all versions. It’s just that newer versions have more options, thus more VBA Commands to control those options.
- If you’re using Excel or Outlook for Mac, you will find that this course won’t cover all the various Mac nuances, as this course was filmed using a PC. Many students end up programming in windows and just using Mac to run the Excel wb or will virtualize Windows within Mac using programs like Parallels or Bootcamp.
- Very basic Excel skills needed for this course. If you know Basic to Intermediate Excel VBA, you can surely find more ways to utilize this information, but it is not required as I explain everything in detail.
- The course will start right away upon signing up, you get instant access.
- Visit My Courses at the top of the site menu.
- You should also receive an email with your username and a link to reset your password if needed check your spam folder just in case. If you have trouble, don’t hesitate to reach out to us.
- 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.
- 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.
Have Questions?
Do you have any concerns or questions? You can fill out the form below or directly email us.
Other Courses
Excel For Freelancers Mentorship Program
Unlock the potential to create and sell Excel-based applications, designed to guide you from concept to successful product launch. Gain lifetime access to lessons, and an extensive Excel Accounting Application. With structured phases in development, marketing, and licensing, plus exclusive tools like the License & Version Control Manager, this program is your comprehensive roadmap to a sustainable income stream.
Advanced Dashboard & Reports Masterclass
Master advanced Excel reporting with this masterclss! In 15+ hours of in-depth training, you'll gain the skills to create dynamic, single-click dashboards that automate reporting and generate stunning visuals. This course includes a full Excel Reports Application, comprehensive VBA code with comments, and powerful custom report features—all designed to streamline your workflow and impress your clients.
The Freelancer's Academy Masterclass
A comprehensive course packed with 100+ lessons and 30 hands-on exercises designed to elevate your freelance career. From finding your niche to landing high-paying clients, this course gives you the strategies and tools to build a flexible, profitable business. With lifetime access, you can learn at your own pace and gain insights into managing projects, creating a standout portfolio, and converting clients into repeat customers.
Complete Web Automation With Excel VBA
The Web Automation Course teaches you how to control any website using Excel VBA—automate logins, fill out forms, extract data, and more. No need for expensive tools or manual browser tasks—learn to build smart, time-saving solutions from scratch. Perfect for anyone who wants to boost productivity, streamline workflows, and take Excel skills to the next level.
The Ultimate Excel VBA Course
Master Excel automation! A complete certification program designed for all skill levels. Learn to write macros, automate repetitive tasks, build custom reports, and create advanced UserForms, all without prior coding experience. Gain lifetime access to 278 hands-on lectures, ready-to-use code samples, and exclusive bonuses, including a VBA keyboard shortcuts cheat sheet and icon pack.
