Excellent video by an excellent teacher indeed! The simpler the better... this teacher has put a lot of education in a few steps which can not get any simpler !
@sternwheeler
6 ай бұрын
Thank you very much!
@asgharjavadi4763
4 жыл бұрын
THANK YOU Z ... you are the best teacher
@sadashivdaruwale3614
3 жыл бұрын
Very nice video and excellent explanation. Thanks
@arifulhoque4547
4 жыл бұрын
Wauuu.... you gave the simplest method. Thanks
@kovolff
4 жыл бұрын
Glad it helped
@pratham899
2 жыл бұрын
Thanks you so much ...
@vinto1583
3 жыл бұрын
How to make this into a moving last 5 reference .... for example if someone has new data coming in and they add rows so will the last 5 move accordingly down to represent the last 5 ....
@sajanjain6402
4 жыл бұрын
Thank you so much, sir, for teaching this such a nice concept. but I want to know one more thing that how to do the same thing if data are in different workbook or worksheet and data are given in horizontally.
@kovolff
4 жыл бұрын
Thanks for your feedback. I will check it out and see if I will make a video around this. Check Excelator.tv (same as kzitem.info/door/PL7mNAQHLbrTvKyYPyVJe2bQ3y3uglegNE) for any future Excel related content. As of this year, this channel will just output German content.
@MarekKoppel
4 жыл бұрын
Thanks!
@gmo709
3 жыл бұрын
Does this work horizontally? i have a pivot table that continues to grow to the right. i have been asked to create to date totals and the pivot results actually go beyond that so i have grand totals, but i need the running total to date. Plus, i have to sum every 4th cell. This is a more advanced ask. Hmm. i think i will use a SUMIFs formula for this, at the source import. i can use your vid for another spreadsheet I have though. i have a downward results sheet for my blood pressure and want a running 5 day or 10 day avg. this works for that. thnks.
@claudiorosa419
2 жыл бұрын
Excelente!!! Obrigado.
@catalinamoncadagiraldo9211
3 жыл бұрын
Hi, if instead of having the turnovers in a column but in a row, how can I calculate the last cell and the first cell?
@kovolff
3 жыл бұрын
Not that I know of
@dakugabbersingh1688
4 жыл бұрын
if you are using new excel sheet do not use [;true] in average column
Пікірлер: 18