The How’s and Why’s of Creating User-Defined Functions in Excel - Part 1
With approximately 500 functions already present, Excel seemingly has a function for every need. But sometimes the function YOU need just simply isn’t available. For example, Excel does not have functions to calculate income tax expense or, in many cases, depreciation expense. To solve these shortcomings, you can create User Defined Functions (UDFs). UDFs provide you with the opportunity to create functions for use in any of your formulas and automate your most complex calculations. Join us to learn how to put the power of UDFs to work to simplify and automate even your most complex calculations.
Are you a CPA?? Are you a Financial Professional?? Earn CPE Credits for Today's Podcast. Check out https://cpe.cx/udf1/. Take a quick 5 question quiz and get your certificate today. Super Easy!
Presented by Stephen M. Yoss, CPA, MS (https://yoss.io)
Produced by Alicia Nichols
Graphics By Flaticon.com and Upsplash.com
Music by Bensound.com
Education and Compliance By K2 Enterprises (https://k2e.com)
Copyright. All product names, logos, and brands are the property of their respective owners. All company, product, and service names used in this website are for identification purposes only. The use of these names, logos, and brands does not imply endorsement.
Educational Use Only. The information presented in this presentation is for educational use only. The presenter will make specific recommendations, but the participant is highly recommended to do their own due diligence before making any investment decision.
- Contents of this video --------
00:00 - Intro
00:30 - What is a Function?
04:11 - What is a User Defined Function (UDF) in Excel?
04:54 - What are some advantages associated with UDFs?
08:03 - What are some potential UDF issues?
15:40 - What does the DAYNAME of the week function do?
16:37 - What are the steps to create a UDF?
17:06 - What is a Module?
18:00 - What does the Visual Basic for Application (VBA) screen look like?
18:53 - What does the Name of the Day of the week UDF code look like?
19:18 - What are some key terms and what do they mean?
22:32 - What does #NAME? error mean?
23:45 - How to get to the Add-ins, Trust Center, and Customize Ribbon?
24:44 - What is the Trust Center?
27:41 - Why can't I get my Macros to run?
28:07 - What are Add-ins and what do they do?
29:38 - What does the Customize Ribbon do?
30:14 - What can the Developer Tool Bar do?
31:29 - How do I write the DAYNAME UDF?
32:26 - What does VBA or IDE contain?
35:11 - Why should I write comments in the code and how?
35:59 - How to get started writing a function?
36:48 - What do Arguments mean in an Excel Function?
39:20 - What does the Week Day Function do?
41:03 - What is a Select Statement in Excel?
44:51 - What does Income Tax Calculation do and look like?
46:37 - How to make UDFS easier to access and use?
48:31 - What steps do I do to convert UDFs to Add-ins?
50:27 - How to convert xlsm workbook to an xlam Add-ins?
53:15 - How do I enable UDFs?