Udemy

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

立即報名
  • 1,027 名學生
  • 更新於 4/2019
4.3
(122 個評分)
CTgoodjobs 嚴選優質課程,為職場人士提升競爭力。透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。

課程資料

報名日期
全年招生
課程級別
學習模式
修業期
2 小時 22 分鐘
教學語言
英語
授課導師
Daniel Strong
評分
4.3
(122 個評分)
4次瀏覽

課程簡介

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!

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.

[Enter custom functions and formulas.]

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

  • Show you multiple examples of real-life uses of user-defined functions. We'll also show you

  • Special built in functions that are only available in the Visual Basic editor as well as

  • How you can use regular worksheet functions in your VBA code. We'll also review

  • Troubleshooting tips for advanced functions like VLookup and HLookup,

  • String manipulation & Randomization techniques and much more! We'll also show you

  • Three distinct methods of sharing your functions and macros with coworkers, friends and family Including

  • How to create your very own Excel Add-In that will make your formulas available to others.

    Take the next step in your Excel mastery and grab your lifetime access for Excel VBA formulas functions and UDF's-and create your own ad in today!

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!

課程章節

  • 4 個章節
  • 25 堂課
  • 第 1 章 Introduction
  • 第 2 章 Digging Deeper...
  • 第 3 章 Sharing Custom Macros
  • 第 4 章 Logical Functions

課程內容

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


評價

  • V
    Vernon Robinson
    5.0

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

  • S
    Steven Livingston
    5.0

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

  • J
    Jack Lenngren
    5.0

    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!

  • J
    Jonathan M Undernehr
    5.0

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

立即關注瀏覽更多

本網站使用Cookies來改善您的瀏覽體驗,請確定您同意及接受我們的私隱政策使用條款才繼續瀏覽。

我已閱讀及同意