How To Create Your First Custom Function In Excel

Elevate your VBA skills with my Saturday Training, where I dive deep into the world of Custom Functions, also known as user-defined functions. These powerful tools are designed to automate repetitive tasks, streamline your workflow, and enhance your overall productivity in Excel.

During this session, I will guide you through the creation of these custom functions live, exploring each step in detail and discussing all the options, results, and practical use-cases. By the end of this training, you’ll have a solid understanding of how to craft your own functions to tackle common tasks more efficiently and tailor your Excel environment to better suit your needs. Whether you’re just starting with VBA or looking to expand your toolkit, this tutorial promises to transform the way you approach automation in your projects.

Join me for an engaging and informative session that will take your VBA capabilities to the next level.

Picture of Randy Austin

Randy Austin


Unlock endless Excel possibilities with our 300 Workbook Pack! Customize, innovate, & profit with ease from the world's largest template library.

Picture of Randy Austin

Randy Austin

Randy Austin, an expert with 28 years of experience, is dedicated to empowering users with practical Excel solutions. Renowned as a top Excel developer and three-time Excel MVP, Randy's YouTube videos on Excel Application Development have garnered over 35 million views.

300 Workbooks Package

Dive into the world of Excel with this remarkable collection of 300 Excel Workbooks. Each workbook is thoughtfully curated to help you get started and includes neatly organized VBA code compiled in a PDF guide for easy reference.


Boost your productivity instantly with 500 pre-built macros designed to streamline your Excel development process. Turbocharge your app development, & effortlessly locate, add, and edit macros, each with detailed descriptions for quick understanding.

Excel AI Toolpack Add-In

Combines 6 incredible AI tools into one seamless package. Revolutionize your productivity by effortlessly fixing formula errors, extracting data, & receiving instant AI responses. No API required – just the untapped potential of AI enhancing Excel.


Unlock your path to financial freedom with our Mentorship Program. Gain the skills and confidence to create your own Excel-based applications, paving the way for a sustainable passive income stream. Join us and transform your aspirations into reality.


This masterclass provides you with a blueprint for creating dynamic, single-click dashboards. Explore filtering, single-click sorting, drill-down reports, and more in this 16-hour course. Master the art of crafting professional Dashboards ready for any project.


Master the art of negotiation for higher rates, elevate your portfolio, and achieve financial independence through monetizing your expertise. Acquire the essential strategies and tools to launch and grow your freelance business successfully.


Take control of Excel & automate your tasks. Delve into the powerful VBA programming language, learning to create custom forms, analyze data, and generate reports effortlessly. Progress at your pace through concise, and information-packed lectures.

The Ultimate Excel
Resource Guide

Consist of 1000 resources, ensuring it's the only Excel reference you'll ever need. The guide is organized into 10 tabs, each containing 100 resources that are easily sortable and filterable, making it effortless to find the tools you're looking for.


Packed with essential tools and templates, this comprehensive guide is your one-stop-shop for all things freelancing. With 1,000 live links and a single click-to-update feature, you'll always have access to the latest freelancing resources.



It's Great to see you!

Login or Create an Account if you still don't have one...