How to make Summary Report in Excel within 2 minutes, How to Summarize Data in Excel

How to make Summary Report in Excel within 2 minutes | How to Summarize Data in Excel | Make Summary in Excel | You will learn from this tutorial how to make summary report from detailed data within minutes. This is useful for Excel 2003, 2007, 2010, 2013, 2016
excel in hindi
excel formula
excel world
excel sheet
excel basics
excel shortcuts
excel
excel tricks
excel formulas
excel academy
excel android
excel all shortcut keys
excel balance sheet
Excel b
Excel Commands
Excel Calendar
Excel Data
Excel Date
Excel Exercise
Excel English
Excl Error
Excel Functions
Excel Filter
Excel Fun
Excel Gyan
Excel Group
Excel Hyperlink
Excel is Fun
Excel Online
Excel Office

[@MicrosoftOfficeTutorials]

If you want to learn Excel in Hindi or Urdu language please hit the below link to Subscribe and learn Excel in Hindi / Urdu 😊 youtube.com/@MegaMindTech?sub_confirmation=1

[@12dygee]

Thank God and thank you for posting this content. You may have just helped me secure a job. God bless you

[@Logomancer99]

This video is absolutely brilliant. Easy to understand. Terrific pedagogy. You are fantastic. Thank you.

[@godwinkuse1912]

WOW This your tutorial is really wonderful, I have learnt a lot. you have enabled me to solve the problem of summarizing my data in my Spreadsheet/Excel. I really want to say thank you. Though I am a beginner, but there are still a lot of things I will like to learn from you. thank you once more

[@moorkara]

Very Simple explanation...very useful

[@davesanderson4023]

Ok, this is a helpful video but anyone wanting to produce a table like this from a dataset, look at how to do a PIVOT TABLE, it automates this whole process and takes seconds

[@Brownmommy1000]

Many thanks for providing this tutorial. I tried many videos and your’s really helped me out. Thanks!

[@hanyirulz]

Thanks for this video, it was very useful. Saved hours to me.

[@francescafagnani-coor1087]

Thank you so much! This was really helpful for my research project.

[@nasirmuhammad3901]

Nice video. However, you assume everyone watching the video knows how to do all the tricks. Please it is always good to assume all those following you are laymen computerwise.

[@MicrosoftOfficeTutorials]

Sure, thanks for suggestion ❤️

[@rehanakhter1975]

Very nice explain and easy understand, Thanks

[@mahantisiva4690]

I think sir pivot table also can be used for this?

[@ConamaraCounty]

OK I watched it again and it is the number of Invoices that are counted in the summary rather than units sold, so I withdraw my previous comment. I applaud the speed in delivering the information, others could benefit from brevity.

[@HadiqaZainab-q2d]

This video is very helpful. Thank you so much

[@steni67]

Thank you so much I was looking this Video for a long time

[@ritamanasi5775]

great tutorial thanks

[@bikamdarai4682]

thanks for your tips

[@NazmulIslam-op9oh]

Thank you so much, man. You have saved my hours of workload.

[@neelampandey1718]

i like straightforward videos😀😄😄

[@hollyerincopeland]

Super helpful, thank you!

[@Sandman_OS]

This was great and very helpful. Thank you!

[@toxicchicken788]

thank you man you are the best i love u

[@kevindoohan8727]

That is really great stuff! Thanks for making the video and helping so many people.

[@anushayat6015]

wow.....amazing

[@SPORTSCIENCEps]

Thank you very much for the video!

[@fredo6799]

Life savior!!!!

[@talal401786]

thank you so much for this helpful video

[@shoaibm4s]

Thanks dear, since last few days i have been searching for an ans which i got it clearly by watching your valuable video. Although they are on simple step but clicked in correct moment and saved my valuable time... keep it up dear.. Best luck....

[@MicrosoftOfficeTutorials]

+Er. Shoaib A M thanks a lot. Very glad to know you find it helpful. :)

[@MicrosoftOfficeTutorials]

Please subscribe and share with others too.

[@aksharapoudel562]

@@MicrosoftOfficeTutorials s

[@prasantnayak1311]

While doing advance filter reference isnt valid show. What to do

[@sheezenkureshi8006]

This is very helpful

[@shuvendusaha9234]

thanks! this is fantastic!

[@meme32games95]

Super. It helped me a lot ❤

[@meriemadjez1003]

Life saver! Thank you

[@katiebarker8264]

Thank you!

[@jaydipsaradva9366]

Very usefull

[@rohitrawat5168]

👍nice but how to add two or three columns on a same time what to do

[@MicrosoftOfficeTutorials]

You need to add 2 or 3 blank columns at a time?

[@jeffreydeocampo3008]

May i know what formula for counting costumer name? Not duplicated

[@nehamehar6767]

Thank you so much, well explained 👍

[@ednace455]

Solved my problem, thank you!

[@karam259]

Thanks, Can you also help how to summarize the BOQ, with Brand, Model,qty and Amount.

[@utravelfriends]

Thank you very much,. 😍

[@AKHILKUMARUNSTOPABLE]

Why not use pivot tables instead of all the formulas and then copy paste the table to a different sheet

[@pianothatilove]

A massive thank you!!!

[@pamnunnOSA]

Took me a WHOLE LOT LONGER than 2 minutes.

[@runusarkar5157]

Amazing thsnks

[@ravikantlorekar4165]

Greate... Thanks...

[@t5698]

what buttons you press to highlight all fields and instantly go down to the bottom ?

[@MicrosoftOfficeTutorials]

Ctrl + Shift + arrow key For quick highlight

[@MicrosoftOfficeTutorials]

Ctrl + arrow key to quickly move

[@nurulaizatnordin2734]

great tutorial.. very straight forward.. thanks a lot..

[@suprabhamohanty3590]

What z difference between the using pivot and this method....

[@vishaldongare4127]

That's what i am thinking

[@yourepretty3453]

GOD LOVES YOU ALL, STAYSAFE

[@azmeerarajendar]

If we use if formula then how can we do sort high to low

[@magicassassin1947]

All I can say is holy shit this is so awesomeeeees😍😍😍💓 thank you thank you thank youuuuuuu😍😍😍

[@naveenfernando5126]

Thank You (

[@Senghanihardik]

If i want to add more columns in range then how to add ?

[@sandrapeart2300]

thank you

[@aneeshaph5007]

brilliant!

[@soulmortal1163]

Sir how to segregation condom brands Quality and quantity , expiry date.and values. In Excel.

[@MicrosoftOfficeTutorials]

Hi Soul, Please share screenshot of your data

[@soulmortal1163]

@@MicrosoftOfficeTutorials Dear sir, Please give your email id or teligram link.

[@MicrosoftOfficeTutorials]

[e-mail] Please let me know after you send email

[@soulmortal1163]

@@MicrosoftOfficeTutorials thank you sir. I will send you screen short.

[@christophersedlak1147]

great

[@meetsachu]

Better use pivot

[@lockdown5305]

Highest invoice amount per invoice per company

[@jb_2710]

why am I getting "Reference isn't valid"?

[@victoriawilliams7199]

This would be a great tutorial if you didn't talk so fast!

[@otekanonso7059]

100%

[@Janthony1977]

Skip, way too fast for me

[@hariyantoryan8538]

Are u Indian

[@solaimanshikder7003]

You should talk in hindi only 😑

[@jinanks]

life saver...

[@prasantnayak1311]

While doing advance filter reference isnt valid show. What to do

[@magicassassin1947]

Thank you so much 💓😍

[@thejster]

Thank you!