Must-Know Excel Functions Part 3
On-Track is excited to offer LIVE virtual training classes to our beloved students. Enjoy all the benefits a live expert instructor from the comfort of your own home or office computer.
Please contact us at learn@on-track.com to receive additional information about our virtual classes and training platform.
Description: What makes this course so exciting is not just learning how to use popular functions but learning how to make them work for you in real-world scenarios along with all the cool tips and tricks that elevate their functionality. Our Master Trainers will show you how to put these functions to effective use so that you can get the most out of your data!
Duration: Half Day (3.5 hours)
COURSE OUTLINE
- The Essential Text Functions
- CONCATENATE, CONCAT
- TEXTJOIN
- FIND
- REPLACE
- LEFT
- RIGHT
- MID
- LEN
- VALUE
- Nesting text functions
- The Essential Database Functions
- DSUM
- DAVERAGE
- DCOUNT
- DMAX
- DMIN
- DGET
- Creating Your Own Function (User-Defined)
- What is VBA?
- Creating a simply custom function
- Using your custom function
- Making your custom functions available anywhere
- CONCATENATE, CONCAT
- TEXTJOIN
- FIND
- REPLACE
- LEFT
- RIGHT
- MID
- LEN
- VALUE
- Nesting text functions
- DSUM
- DAVERAGE
- DCOUNT
- DMAX
- DMIN
- DGET
- What is VBA?
- Creating a simply custom function
- Using your custom function
- Making your custom functions available anywhere