LEARNING PATH
- Introduction – Basic Excel Functions Vs. UDFs
- Resources Download
- Left, Right Functions
- MID Function
- Your First Custom Function!
- Calling A Custom Function In VBA Instead Of In A Cell
Video: 18 minutes, 6 lectures
- What Are Parameters?
- If You Run Into A Links Error…
- Find Nth Word Function – Fun!
- Optional Parameters And How To Tell If They’re Present
- Optional Parameters Pt. 2 – Using Specific Params In Any Order
- Custom Last Row Function (Works Dynamically For Any Sheet)
- Get The Last Row Dynamically Pt. 2 – Which Column Parameter
- Getting The Row Where Employees End And Subtotals Begin Plus Extra Function!
- Using Worksheet Functions In VBA
- Evaluate Function
- Sum Function In VBA
- Count Function In VBA
- VLOOKUP And HLOOKUP Tips In VBA
Video: 1 hour & 34 minutes, 13 lectures
- Sharing Functions With Yourself Or Other Computers
- Using Your Personal.XLSB Workbook To Share With Yourself – Plus Reference Trick
- Creating An Excel AddIn and Ways To Use It
Video: 24 minutes, 3 lectures
- Randomization with Rnd() Or Randbetween() Functions
- Thank You And Final Thoughts
- BONUS LECTURE
Video: 6 minutes, 3 lectures