MS Excel - Consolidation Extended

MS Excel - Consolidation Extended
Watch More Videos at:
www.tutorialsp...
Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited

[@TutorialsPoint_]

To Get Certification, Click Here: bit.ly/38Jyu3p Use coupon "KZbin12" to get ‘’FLAT 12%’’ OFF at Checkout.

[@jeevanbakshi-sn6fh]

sir i have no words for u....tommorow is my practical and i have not studied anything....but just because of u now i am onfident

[@TheBhattacharya]

BEST IN THE WORLD 🌍

[@sivaramtt4728]

very helpful, Thanks bro🤩

[@mayankgaming5128]

Do you know that our school it teache suggest your's video 😮 good keep it up 😂😂

[@rahulgoel5010]

Awesome video and explanation. I have a doubt in this video Location of John is changing, understandable. But the other values are different in different sheets like Mike7, Mike3 and Mike1 missing in respective sheets. So how did it consolidate the values for them?

[@rajputshubhamkumar4159]

their values is considered 0 . see in sum sheet ,there are 8 rows , where as in reference data there were 7 rows

[@Lotus0305]

Hi. Why if the rows are not the same in all the sheets? Meaning, one sheet might have 90 rows, another 100, and so on. Would Consolidation still work in that case?

[@swapanbhattacharya4155]

Thank you. May I request you to share one vdo on sum of odd and even column/row.

[@himanshujhamtani1711]

sir your way of explanation is awesome

[@HuongNguyen-oy6mc]

thank you very much

[@mohamedhusain1773]

Excellent explanation, Thank you

[@mahipalmallela5428]

Hi Sir, I've been following your excel videos, your explanation is good and easy to understand. Can you please explain how to consolidate only the data from multiple workbooks into one workbook? I mean not calculating formulas.

[@amanbhargava2702]

See just above video

[@mrshabeermp]

Very helpful and owe some presentation

[@shashnarayansunkari3276]

hello sir your videos are very useful to most of the real people . i am unable to get conslidate function not working how can i resolve it

[@27vijays]

www.coursera.org/learn/excel-intermediate-1/lecture/rCZ3p/practice-video-consolidating-by-position Hope this link helps (you don't have to buy the course, this video is available even if you just 'audit' it)

[@amanbhargava2702]

Thank you😊😊😊😊😊

[@abhimankhade7628]

It's like magic I just want to know, is it possible with name means one column with name and row with number, if anyone just mention formula name....

[@Elearner6162]

26/12/23

[@nairsantosh17]

How will this formula work if there is no uniform column or row heading? Eg I have 5 students marks in sheet 1, in sheet 6 students . How such cases can be consolidated ?

[@kiranmaidhulipala4248]

hi please show us productivity dash board on excel

[@diptisrivastava6370]

Please sir GST ka class lijiye aap🙏🙏🙏🙏🙏🙏