Uploaded January 2026 | Updated September 2026, 2 weeks ago
Unlock the power of Excel with this Text and Financial Functions course. This is perfect for anyone looking to enhance data accuracy and perform key financial calculations. Learn how to clean, transform, and analyze data using essential text functions like TRIM, SUBSTITUTE, and PROPER, then dive into financial tools like PMT, IPMT, and SLN to calculate payments, interest, and depreciation. You’ll also explore advanced statistical functions such as NORM.DIST, NORM.INV, and STDEV to measure probability and data dispersion confidently.
✅Download the free course files and follow along here:
➡️ simonsezit.com/excel-text-and-financial-functions-course-files
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - LOWER, UPPER, and PROPER Functions
00:03:06 - MID, LEN, LEFT, and RIGHT Functions
00:12:07 - VALUE Function
00:13:29 - TRIM Function
00:14:17 - SUBSTITUTE Function
00:15:59 - Personal Financial Functions
00:21:23 - PMT, PPMT & IPMT Functions
00:25:42 - SLN Function
00:28:36 - NORM.DIST and NORM.INV Functions
00:33:36 - STDEV.S, STDEV.P and QUARTILE.INC
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ simonsezit.com/courses
🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 11,000+ ad-free videos and begin your transformation today! ➡️ simonsezit.lpages.co/ssit-14-day-free
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 400+ hour training course playlist here ➡️
youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🔥 For a full training experience, check out our FREE YouTube course: 👉 youtube.com/@SimonSezIT/courses
✅ Microsoft Excel Tips and Tricks 👉youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
✅ Microsoft Office 2021 and Office 365 Training here 👉youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
💬Stay in touch!
SimonSezIT.com: SimonSezIT.com
LinkedIn: linkedin.com/company/simon-sez-it
FaceBook: facebook.com/SimonSezIT
🔔 Subscribe to our channel:
youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
Unlock the power of Excel with this Text and Financial Functions course. This is perfect for anyone looking to enhance data accuracy and perform key financial calculations. Learn how to clean, transform, and analyze data using essential text functions like TRIM, SUBSTITUTE, and PROPER, then dive into financial tools like PMT, IPMT, and SLN to calculate payments, interest, and depreciation. You’ll also explore advanced statistical functions such as NORM.DIST, NORM.INV, and STDEV to measure probability and data dispersion confidently.
✅Download the free course files and follow along here:
➡️ simonsezit.com/excel-text-and-financial-functions-course-files
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - LOWER, UPPER, and PROPER Functions
00:03:06 - MID, LEN, LEFT, and RIGHT Functions
00:12:07 - VALUE Function
00:13:29 - TRIM Function
00:14:17 - SUBSTITUTE Function
00:15:59 - Personal Financial Functions
00:21:23 - PMT, PPMT & IPMT Functions
00:25:42 - SLN Function
00:28:36 - NORM.DIST and NORM.INV Functions
00:33:36 - STDEV.S, STDEV.P and QUARTILE.INC
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ simonsezit.com/courses
🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 11,000+ ad-free videos and begin your transformation today! ➡️ simonsezit.lpages.co/ssit-14-day-free
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 400+ hour training course playlist here ➡️
youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🔥 For a full training experience, check out our FREE YouTube course: 👉 youtube.com/@SimonSezIT/courses
✅ Microsoft Excel Tips and Tricks 👉youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
✅ Microsoft Office 2021 and Office 365 Training here 👉youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
💬Stay in touch!
SimonSezIT.com: SimonSezIT.com
LinkedIn: linkedin.com/company/simon-sez-it
FaceBook: facebook.com/SimonSezIT
🔔 Subscribe to our channel:
youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
