Accounting Equation Demystified
35:46
Relative and Absolute Referencing
22:35
Excel Referencing Cell Range
16:29
3 жыл бұрын
Creating Fixed Assets Registers
23:58
Payback Period - Financial Modeling
12:30
Пікірлер
@dhruvjoshi524
@dhruvjoshi524 26 күн бұрын
Sir why don't you solve those business questions btw video is very helpful for learning basics and one more thing i genuinely request you to improve your video quality i need one more help like can you please provide me this excel sheet
@Mark-sf4kh
@Mark-sf4kh Ай бұрын
Nice job bossss
@high5tutorials135
@high5tutorials135 Ай бұрын
Thank you
@zach4hoff
@zach4hoff Ай бұрын
Thanks!
@high5tutorials135
@high5tutorials135 Ай бұрын
Welcome!
@wisdom_uboh
@wisdom_uboh Ай бұрын
Thanks for recording and sharing your knowledge. Bringing in the combo box is a top-notch idea 🔥🔥🔥🔥🔥🔥🔥🔥
@high5tutorials135
@high5tutorials135 Ай бұрын
Thank you very much. I very well appreciate you compliments.
@ngoziokafor3891
@ngoziokafor3891 Ай бұрын
You are the real MVP🙌. Thanks Charles
@Moremi-tv
@Moremi-tv Ай бұрын
This is the best tutorial ever! I had never done a process chart before and did a picture perfect one with your tutorial! You also saved me a lot of stress. Thanks again!
@olivere9772
@olivere9772 16 күн бұрын
Hes a good guy
@vincentchidiebere1652
@vincentchidiebere1652 2 ай бұрын
Great explanations. Perhaps you can provide the workbook for practice.
@zararahmed1103
@zararahmed1103 3 ай бұрын
thank you for this video. 🙂🤝
@high5tutorials135
@high5tutorials135 3 ай бұрын
Thank very much for your kind appreciation.
@high5tutorials135
@high5tutorials135 3 ай бұрын
Thank you for your kind appreciation
@iyaboishola7165
@iyaboishola7165 3 ай бұрын
To get the end date I can't get the answer,is showing #Value
@high5tutorials135
@high5tutorials135 3 ай бұрын
Check your cell that have the start and end date. Make sure the date reads month number/day number/year number. Or dd-mmm-yyyy format. Hopefully, this will help
@dennisappiah-kubi5269
@dennisappiah-kubi5269 3 ай бұрын
Thank you for this video. It was very helpful!
@high5tutorials135
@high5tutorials135 3 ай бұрын
So happy you enjoyed it.Thank you
@brandsouqriyadh
@brandsouqriyadh 3 ай бұрын
please text sumif formula apply in gross block
@high5tutorials135
@high5tutorials135 3 ай бұрын
Check the condition within your sumif function. If you have multiple conditions, use sumifs.
@high5tutorials135
@high5tutorials135 3 ай бұрын
Check the condition in your sumif formula. Make sure it matches. Also make sure that the sum and criteria range is completely referenced. If you are using multiple conditions, use sumifs function.
@oluseyeoyeyemisunday4890
@oluseyeoyeyemisunday4890 4 ай бұрын
Thank you for helping me understand index match. Your explanation were simple and clear
@MuhammadIrfan-ml5gb
@MuhammadIrfan-ml5gb 4 ай бұрын
Lovely
@ngapuikuemberirua3670
@ngapuikuemberirua3670 4 ай бұрын
Very good content
@ngapuikuemberirua3670
@ngapuikuemberirua3670 4 ай бұрын
Great stuff
@high5tutorials135
@high5tutorials135 4 ай бұрын
Thank you very much
@rajeshparsekar2994
@rajeshparsekar2994 5 ай бұрын
VERY HELPFUL AND easy to apply
@high5tutorials135
@high5tutorials135 5 ай бұрын
Thank you Sir
@raphaelokoye4310
@raphaelokoye4310 6 ай бұрын
This is the best explanation of index and match I have seen in a long time time🎉
@high5tutorials135
@high5tutorials135 6 ай бұрын
So happy you found it understandable
@ravmon1000
@ravmon1000 6 ай бұрын
great content sir!!
@high5tutorials135
@high5tutorials135 6 ай бұрын
Thank you for watching. Glad you found it a great content
@oluseyeoyeyemisunday4890
@oluseyeoyeyemisunday4890 6 ай бұрын
At the end of video you mentioned something about being unable to reduce the width of the line in the drawing mode. I found out that this could be possible by holding down the shift key and scrolling down with your mouse wheel.
@high5tutorials135
@high5tutorials135 6 ай бұрын
Thank you for watching and for adding value to this video. Happy to learn from you.
@karlagranados9921
@karlagranados9921 7 ай бұрын
Hi Charles! This is a great video. I would love to connect and discuss this template with you. I sent you a LinkedIn invite to connect. Thank you.
@high5tutorials135
@high5tutorials135 7 ай бұрын
I am happy you live it. Connected. Thank you.
@peteriruogu8928
@peteriruogu8928 9 ай бұрын
I appreciate the informative video. Currently, I'm experiencing problems with the index formula as it doesn't capture the total amount for a specific asset class, eg for furniture and fittings. The index formulae seems to be missing some asset values when calculating the gross black for the same asset asset class on different rows
@high5tutorials135
@high5tutorials135 8 ай бұрын
I am very sorry for late response. I may need to look the spreadsheet with you using not sensitive data. [email protected]. However, the index function returns a value and not the sum of values. The sumifs function should do the job if I understood what you have stated. Thank you for the compliments
@peteriruogu8928
@peteriruogu8928 8 ай бұрын
@@high5tutorials135 Thank you for reaching out. It has been sorted already
@mohitmishra9322
@mohitmishra9322 10 ай бұрын
OMG this was so helpful. Thankyou Sir !
@high5tutorials135
@high5tutorials135 8 ай бұрын
Welcome. Happy to know it helped
@Grandmajoe123
@Grandmajoe123 11 ай бұрын
What a fantastic video and tutorial, thanks for all your help.
@high5tutorials135
@high5tutorials135 6 ай бұрын
Welcome and thank you for watching.
@sindhujamilkuri-k2c
@sindhujamilkuri-k2c Жыл бұрын
What is the Report Date and how do I know about the Report Date
@high5tutorials135
@high5tutorials135 8 ай бұрын
Just like in monthly reports, the report date is the last day of a report month. However, the report date can be any date from which the report need to be evaluated
@ravindharmadas6729
@ravindharmadas6729 Жыл бұрын
What is the Report Date and how do I know about the Report Date
@christyo.9125
@christyo.9125 Жыл бұрын
This video is very helpful, thank you for your time.
@christyo.9125
@christyo.9125 Жыл бұрын
Very impactful. highly simplified
@micalghebreab1
@micalghebreab1 Жыл бұрын
Thank you a lot!
@high5tutorials135
@high5tutorials135 3 ай бұрын
Thanks for the appreciation. You inspire me.
@kingjoseph927
@kingjoseph927 Жыл бұрын
Thanks i enjoyed the lecture.
@annietran8200
@annietran8200 Жыл бұрын
Thank you so much
@H-do8tr
@H-do8tr Жыл бұрын
Great tutorial! Speaking about the disposal, what about if I want to dispose a part of an asset amount not an entire asset?
@komninoskamamis1098
@komninoskamamis1098 Жыл бұрын
Thank you very much. Very helpful
@khaledhasan6998
@khaledhasan6998 Жыл бұрын
Thanx
@michaelrouse5286
@michaelrouse5286 Жыл бұрын
Great presentation
@sday2551
@sday2551 Жыл бұрын
Hi - Trying to do the Gross Block - the formula only calculates the first row of figures and not the 10 ( I have 11 rows of assets) any ideas ??
@high5tutorials135
@high5tutorials135 8 ай бұрын
Use Sumifs to calculate the gross block
@nyambesimangolwa5755
@nyambesimangolwa5755 Жыл бұрын
Golden, thanks!
@tehxii7706
@tehxii7706 Жыл бұрын
I should probably learn to use Visio but with limited time I am attempting to use Excel.
@hushtoroar1677
@hushtoroar1677 2 жыл бұрын
You are a genius! Thanks so much xx😍
@high5tutorials135
@high5tutorials135 2 жыл бұрын
So happy to know you like it
@dabbahprosperprince862
@dabbahprosperprince862 2 жыл бұрын
Is a good practical PPE register. I tried it but released that the depreciation per day is not zero when the asset reached its useful life. Therefore push the lapse days more than the uesful life days abd the net effect is in negative
@high5tutorials135
@high5tutorials135 8 ай бұрын
Could it be because of the salvage value?
@mawaemmanuelalex4179
@mawaemmanuelalex4179 2 жыл бұрын
Was helpful. Thanks.
@kevinassang3158
@kevinassang3158 2 жыл бұрын
Very good, thanks
@diamondglow7947
@diamondglow7947 2 жыл бұрын
Great explanation! Thank you for sharing
@high5tutorials135
@high5tutorials135 2 жыл бұрын
Thank you very much
@theatmp97
@theatmp97 2 жыл бұрын
Shouldnt you include the effect of the tax shield?
@fredricklangat1677
@fredricklangat1677 2 жыл бұрын
This indeed is very helpful
@high5tutorials135
@high5tutorials135 2 жыл бұрын
Happy to know. Thank you
@bhawanihada9986
@bhawanihada9986 2 жыл бұрын
Superb illustration boss
@high5tutorials135
@high5tutorials135 2 жыл бұрын
🙏
@Sp18111
@Sp18111 2 жыл бұрын
Do you have the link to download this excel template which u created ?
@kaluanyim1453
@kaluanyim1453 2 жыл бұрын
Thanks for the insightful tutorial, Sir. Can the formula be adjusted to depreciate for a full year irrespective of the purchase date of the asset?
@high5tutorials135
@high5tutorials135 2 жыл бұрын
Thanks for watching. Let me get you clear. If I buy the assets at the Middle of the year, do you want it to assume a full year depreciation at the end of the purchase year?
@tongvang724
@tongvang724 2 жыл бұрын
Why not just use visio?
@high5tutorials135
@high5tutorials135 2 жыл бұрын
Because Microsoft made the possibilities in Excel. Anyway Visio was made for flow charts thank you for commenting
@surfmarko
@surfmarko 2 жыл бұрын
fantastic! Thank you!
@high5tutorials135
@high5tutorials135 2 жыл бұрын
Welcome. Thanks for watching
@wavesofhealingssj6303
@wavesofhealingssj6303 2 жыл бұрын
This is very helpful, thank you. How do I create a Legend as shown in the video?
@WavesofHealing-jz2ef
@WavesofHealing-jz2ef 2 жыл бұрын
Well done, thank you!