| 0 | 1.2 KB | ||
| 1 - Introduction Basic Excel Functions versus UDFs English.vtt | 6.7 KB | ||
| 1 - Introduction Basic Excel Functions versus UDFs.mp4 | 32.8 MB | ||
| 1 | 204.8 B | ||
| 2 | 213.2 KB | ||
| 3 | 101.2 KB | ||
| 10 - Optional Parameters and How to Tell If Theyre Present English.vtt | 8.3 KB | ||
| 10 - Optional Parameters and How to Tell If Theyre Present.mp4 | 34.2 MB | ||
| 11 - Optional Parameters Pt 2 Using Specific Params In Any Order English.vtt | 10.1 KB | ||
| 11 - Optional Parameters Pt 2 Using Specific Params In Any Order.mp4 | 48.4 MB | ||
| 12 - Custom LastRow Function Works Dynamically for Any Sheet English.vtt | 10.7 KB | ||
| 12 - Custom LastRow Function Works Dynamically for Any Sheet.mp4 | 43.7 MB | ||
| 13 - Get The Last Row Dynamically Pt 2 Which Column Parameter English.vtt | 7 KB | ||
| 13 - Get The Last Row Dynamically Pt 2 Which Column Parameter.mp4 | 32 MB | ||
| 14 - Getting The Row Where Employees End and Subtotals Begin Plus Extra Function English.vtt | 18.2 KB | ||
| 14 - Getting The Row Where Employees End and Subtotals Begin Plus Extra Function.mp4 | 197.3 MB | ||
| 15 - Using Worksheet Functions in VBA English.vtt | 8 KB | ||
| 15 - Using Worksheet Functions in VBA.mp4 | 34.9 MB | ||
| 16 - Evaluate Function English.vtt | 7 KB | ||
| 16 - Evaluate Function.mp4 | 42.2 MB | ||
| 17 - Sum Function in VBA English.vtt | 3.9 KB | ||
| 17 - Sum Function in VBA.mp4 | 23.7 MB | ||
| 18 - Count Function in VBA English.vtt | 3 KB | ||
| 18 - Count Function in VBA.mp4 | 14 MB | ||
| 19 - VLookup and HLookup Tips in VBA English.vtt | 16.4 KB | ||
| 19 - VLookup and HLookup Tips in VBA.mp4 | 125.4 MB | ||
| 2 - Course-Downloads.zip | 120.8 KB | ||
| 2 - Resources Download.html | 102.4 B | ||
| 20 - Sharing Functions With Yourself or Other Computers English.vtt | 6 KB | ||
| 20 - Sharing Functions With Yourself or Other Computers.mp4 | 38.8 MB | ||
| 21 - Using Your PersonalXLSB Workbook To Share With Yourself Plus Reference Trick English.vtt | 12.4 KB | ||
| 21 - Using Your PersonalXLSB Workbook To Share With Yourself Plus Reference Trick.mp4 | 90.3 MB | ||
| 22 - Creating An Excel AddIn and Ways To Use It English.vtt | 13.4 KB | ||
| 22 - Creating An Excel AddIn and Ways To Use It.mp4 | 88.9 MB | ||
| 23 - Randomization with Rnd or Randbetween functions English.vtt | 5.6 KB | ||
| 23 - Randomization with Rnd or Randbetween functions.mp4 | 20.7 MB | ||
| 24 - Thank You and Final Thoughts English.vtt | 2.2 KB | ||
| 24 - Thank You and Final Thoughts.mp4 | 5.9 MB | ||
| 25 - BONUS LECTURE.html | 102.4 B | ||
| 25 - bonus-lecture.pdf | 828.5 KB | ||
| 3 - LEFT RIGHT Functions English.vtt | 3.7 KB | ||
| 3 - LEFT RIGHT Functions.mp4 | 13.1 MB | ||
| 4 - MID Function English.vtt | 3.8 KB | ||
| 4 - MID Function.mp4 | 13.7 MB | ||
| 4 | 316.1 KB | ||
| 5 - Your First Custom Function English.vtt | 6.3 KB | ||
| 5 - Your First Custom Function.mp4 | 22.6 MB | ||
| 6 - Calling a Custom Function in VBA Instead of In A Cell.mp4 | 15.4 MB | ||
| TutsNode.net.txt | 102.4 B | ||
| [TGx]Downloaded from torrentgalaxy.to .txt | 614.4 B | ||
| 5 | 104.5 KB | ||
| 6 | 282.6 KB | ||
| 6 - Calling a Custom Function in VBA Instead of In A Cell English.vtt | 3.6 KB | ||
| 7 - What are Parameters English.vtt | 5.8 KB | ||
| 7 - What are Parameters.mp4 | 23.8 MB | ||
| 7 | 298.3 KB | ||
| 8 - If you run into a Links Error English.vtt | 2.4 KB | ||
| 8 - If you run into a Links Error.mp4 | 20.1 MB | ||
| 8 | 183 KB | ||
| 9 - Find Nth Word Function Fun English.vtt | 16.1 KB | ||
| 9 - Find Nth Word Function Fun.mp4 | 63.7 MB | ||
| 9 | 118 KB | ||
| 10 | 317.4 KB | ||
| 11 | 219.1 KB | ||
| 12 | 465.5 KB | ||
| 13 | 187.4 KB | ||
| 14 | 268.3 KB | ||
| 15 | 369.8 KB | ||
| 16 | 347.1 KB | ||
| 17 | 439.9 KB | ||
| 18 | 113.7 KB | ||
| 19 | 8.3 KB | ||
| 20 | 291.4 KB | ||
| 21 | 372.6 KB | ||
| 22 | 103.9 KB | ||
| ▲ 75 total files | |||
Description
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!
Who this course is for:
Beginners with Excel VBA wanting to expand their skills
Anyone wanting to learn how to create your own Excel Functions/Formulas
Do not take this course if you hate learning awesome stuff
Requirements
Need to Have Excel
Last Updated 4/2019
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 3.7 GB | freecoursewb | 5 months | 0 | 0 | |
| 1.7 GB | freecoursewb | 7 months | 11 | 6 | |
| 1.3 GB | freecoursewb | 7 months | 4 | 0 | |
| 1.3 GB | freecoursewb | 1 year | 9 | 0 | |
| 481 MB | freecoursewb | 1 year | 11 | 0 |
All Comments