I've been following your videos since I was still going through school for business analytics 3+ years ago. I still learn something new every time. I can see most of these having potential use with my current client (which does deal with financial records, but on an operations and audit level).
Hey, Alex. There's actually a little inconsistency in the first method (PMT): If you take the first monthly payment for ex ($471.78) over the period (5 x 12 months) , you'll get $28,306.8. But $25,000 capitalized annually at an interest rate of 5% per year will return a Future Value of $31,907.04. The reason for this is because the compound interest (used preferably in the economy). In order to achieve the same value, you should convert the annual interest rate in monthly interest rate too. Thank you for the video.
Hey Alex sir, I really like watching your videos, the way you explain is so easy to understand. I am a fresher and starting to explore the field of data analytics. With the help of your videos, I can understand all concepts much faster. Thank you so much
For big files with a lot of tricky formulas, I sometimes keep a kind of change tracker on a separate sheet. I make a list of all the formulas in the workbook, use FORMULATEXT to show them as a string, and copy paste as values in a helper column next to it. Conditional formatting to show if the FORMULATEXT differs from the pasted-as-values version, and I can tell at a glance where I made edits (or someone else broke something).
Hi Alex, your videos have been helping me a lot so I wanted to reach out and extend my thanks and appreciation! You should do a coding booting similar to the data analyst bootcamp where we get a certificate at the end. I'd definitely sign up for it! Keep up the good work :)
I've been following your videos since I was still going through school for business analytics 3+ years ago. I still learn something new every time. I can see most of these having potential use with my current client (which does deal with financial records, but on an operations and audit level).
Hey, Alex. There's actually a little inconsistency in the first method (PMT):
If you take the first monthly payment for ex ($471.78) over the period (5 x 12 months) , you'll get $28,306.8.
But $25,000 capitalized annually at an interest rate of 5% per year will return a Future Value of $31,907.04.
The reason for this is because the compound interest (used preferably in the economy). In order to achieve the same value, you should convert the annual interest rate in monthly interest rate too.
Thank you for the video.
Hey Alex sir,
I really like watching your videos, the way you explain is so easy to understand. I am a fresher and starting to explore the field of data analytics. With the help of your videos, I can understand all concepts much faster.
Thank you so much
Great functions. I have not seen them before. Thanks for sharing.
That's really amazing Alex. We want more sessions like this. It will be more helpful to reduce the complex works.
For big files with a lot of tricky formulas, I sometimes keep a kind of change tracker on a separate sheet. I make a list of all the formulas in the workbook, use FORMULATEXT to show them as a string, and copy paste as values in a helper column next to it. Conditional formatting to show if the FORMULATEXT differs from the pasted-as-values version, and I can tell at a glance where I made edits (or someone else broke something).
Thank you again Alex
Thank you Alex
Hi Alex, your videos have been helping me a lot so I wanted to reach out and extend my thanks and appreciation! You should do a coding booting similar to the data analyst bootcamp where we get a certificate at the end. I'd definitely sign up for it! Keep up the good work :)
mentor at again
love every info you give out
Appreciate it!
Hey you!
Hey!
@@AlexTheAnalyst feels like it’s been a minute. Great to see an excel video again!
@@humansizedaperture Haha I've been on an Excel kick - I have one more next week then I'll do some Shiny and then some AWS/Azure :)
🤯🤯🤯😊😊