3 Different Methods to Make Yearly Report in Excel | Beginner to Advance Level Tutorial

3 Different Methods to Make Yearly Report in Excel | Beginner to Advance Level Tutorial
Hello Friends, Hope so you are doing Well and Learning Everyday some informative.
In This Video Tutorial, I have shown three different methods to Create Month wise Report from the given data set for the full Year.
In the very first method,
I have Generate the monthwise report using the helper column and Sumif Formula in Excel.
In the second method, ( If You are having Excel 2021)
In this Method, I Have created a Monthly Report using Filter formula along with sum formula in excel.
In the last method,
I Have used Pivot table to generate the Monthly Report in Excel.
Hope So You Really Like and Share to this video.
Don't Forget to press the Subscribe button and Give Your feedback in the comment section.

[@santoshm2171]

Please do videos in English it will be useful to everyone

[@kidsparty5201]

Hi mery pass 1lakh student ka data hai Maine data ko 3 se 4 sheet main divide krna hai Yani 25k 25k ki 4 sheets ban Jain plz guide me

[@gaganwadhwafreelancer]

You can combine the data on one sheet make it master sheet. Do what ever you want to do there.
Go through these videos
ruclips.net/video/hsjH3JEQpLo/видео.htmlsi=E8MmfzXq_TIzKUS7
ruclips.net/video/7ZcLZBqYYYM/видео.htmlsi=e-7RsyI35MQR-gdB