How to convert daily data into monthly, quarterly and yearly in excel I Explained by Dr Rakesh

Greetings Friends! In this video, I explained how to convert any daily data into monthly, quarterly, and yearly in excel file by using pivot table without writing any equations and codes. This details explanation can help you in your data processing during your research and project work. This all explanation based on experiences of institutes If you have any queries regarding this information, please write in the comment box and I will reply.
Please subscribe to my TH-cam channel and hit the bell icon for notification for the next video.
About this channel: This channel is made for educations, motivations, current issues, local and global issues, social issues, research and analysis, science and technology, innovations etc. on India and global level.
Please visit www.myinfohome.com for other details related to courses, Ph.D. assistance, and blogs.
For any query, please email us at [e-mail]
Be safe and Healthy!
All the Best!

[@namartakumari1390]

Thank you sir 🙏

[@niveditakumari3062]

Very useful information....keep it up

[@moesadr3342]

Great video, thank you. How about creating a dynamic report showing the totals in this format: This Month, Last Month and this quarter, last quarter and this year, last year at all times without any extra steps. something like a dashboard which always only automatically calculates and shows above mentioned values?

[@dheeraj-kumar]

Thanks for this informative video

[@DrRakesh]

Thank you Dhiraj ji!

[@pubalimukherjee4793]

hello sir , can the same be done in reverse manner like converting daily data to hourly format, a nc file which is a daily mean?

[@sunrays1234]

on 2:24 when you check the date How Quarters and Year Come?? When i click these options are not come..

[@ianwilliam9690]

same

[@TortlePods]

same here

[@dr.merzougsaida7102]

Thanks for this video

[@wilmarkjohnatty4924]

This isnt quarterly or monthly data - Its summarized. Quarterly data wont have a Yearly sum very 5th value. Quarterly data is 2015 Q1, 2015 Q2, 2015 Q3, 2015 Q4, 2016 Q1 etc. If you remove the Yearly data, it will summarize all the Q1 values (or average it). And not everyone wants the quarterly data starting in January. Doing this via Pivot tables is not the best way to do this.