4 Super Cool Tricks for MS Excel | Excel Magic Trick Part 13

[@MyLiveSupport]

🔥Get our Complete MS Excel & Word Course in just Rs 299 visit👉 www.mylivesupport.in/

[@sarfarajkhan8996]

Very nice.

[@sandeepsingh-jf5qb]

Sir Your Teaching Skill Is Unbelievable 💯💯💯💯💯💯

[@MyLiveSupport]

Thank You So Much 😀

[@panchamkumar2219]

Nice trikes sir 👍

[@sushilchandrakar8692]

Nice bhaiya

[@tiwarinavneet515]

Phantastic video sir ji I like it.

[@MyLiveSupport]

Thank you sir

[@sureshkharage6425]

Bhahot badiya sir

[@shyamusingh5611]

Siper tracks

[@kanhaiyalalnewaskar5225]

Sir, 14th April,2019. Awsome and Very useful idea to combine name. Hoping to receive more ideas. Thank you very much Kanhaiyalal Newaskar.

[@BeenaMenon1968]

All ur tricks are Super cool. And u explain well too.

[@REHANKHAN626]

Very nice information sir

[@udaydas8818]

thanks chander very nice day of explaining the excel tricks

[@prakashgupta7924]

Nice work sir

[@sunilbhosale7172]

Nice 👍

[@2bypuri686]

Gud one

[@narayanupadhyaya5335]

Nice video... Good explanation

[@sureshnagwan7805]

Good information

[@ribulraj2662]

Super video sir

[@prabhakarpawar573]

Nice and very usefull video sir

[@paravej]

Trick no 3 is awesome, It's just a great logic.

[@pckanade]

Thanks Sir

[@thelegalmirror2196]

Nice one

[@user-tw9if4rt2x]

Nice!

[@rahulmahajan9904]

Thank you sr thank you very much

[@rankanidhiswain6086]

Nice 🙂

[@chakrabahadurbhandari2670]

Thank you so much sir. Actuall very useful and unknown tricks i learn about excel use. I watched your 2 vedeos on tally and excel which is excellent really really new and magical. I hope there will so many other tricks on diffent features.

[@kiirans9009]

Great video. I loved it😍👍👍👍👍. Can you plz explain how can we split the full name in one cell into first name and last name in different cells?

[@sandeepsingh-jf5qb]

Sir Pivot Table Upar V Aise Video Laye

[@pnj4661]

Nice tricks

[@skbk7139]

Very nice

[@krishnapechiwala8417]

Nice Sir

[@vijay26001]

Sir I like your video, please make a video on text to column also .

[@MyLiveSupport]

Already make it. Check on channel

[@ramveerjatav4796]

Good video

[@rahulekhe3514]

Great

[@manoranjandas7509]

Yes bro 3 Rd wala tricks is osm...baki bhi hai....

[@deepakzeeb4u]

3rd one is very osm ! 👍 Nice

[@MyLiveSupport]

thanks bro

[@subratabanerjee1233]

excellent

[@sureshkhandelwal3497]

Wow. Very mast and cool tricks

[@MyLiveSupport]

thanks bro

[@lokeshgupta2063]

Aapka Video mast hai bhaijaan

[@MyLiveSupport]

thanks bro

[@annasaabchitta]

Very useful tricks. Thanks

[@raosahab323]

Pereto chart p video bnao bhai

[@deepakpanchal5521]

Very nice ,,it will help. Lot..thank

[@MyLiveSupport]

thanks deepak ji

[@dr.shreyas123]

3rd one was killer one. Before your explanation on 3rd trick I was thinking how to do it, but could not get answer. It was amazing... Thanks. Even I liked 1st trick.

[@birendraji.3106]

Nice..sir.😃

[@MyLiveSupport]

thanks bro

[@YashRaj-cb7no]

Super

[@atul.holker9052]

Sir ek video asi bana do jo ki kisi bhi campany me work kr sku ma jake🙏🏻🙏🏻🙏🏻

[@Skumarcomputeredu]

Thanku

[@abdullahnajafi]

great

[@arv8231]

Nice teaching thank you

[@pawanpawar6128]

Please video on ek sheet m jise for example jitne products k entry h . Wo automatically alag alag sheet pe product wise maintain Hoti jae . Is par video lae

[@rubiprajapati6443]

Kya Multiple unit use kr sakte hai Sir

[@gopalsingh1413]

Cool

[@pallavigupta3392]

Sir agar mujhe 3 line insert karni hai tu kuch trick bataye

[@sumitpatait9464]

Thanks Bhai

[@Luckybhai..420]

Thanks you

[@BrijeshKumar-nh3ex]

Nice

[@Akshay.Mathpal]

Nice bro

[@avinashvarnwal9463]

Great... Keep it up

[@arupsasmal4591]

apki last trick ka reverse formula ka hoga?

[@srikrishna8752]

4th I know; 1st super

[@jagdishnmeena9644]

Your channel is very educational I want find number 35 in excel cell 1-100

[@sheetalpatil2571]

3re very nice trick.

[@devendramohite4435]

Thanks

[@ManojKumar-ii7zh]

jai ho.

[@MyLiveSupport]

jai ho

[@abhishakya5263]

Excel main page watermarks ke liye please koi video bataye sir

[@sanjaykumaragrawal1286]

Kindly upload the video on pivot table

[@MyLiveSupport]

Already make. Search on channel

[@nasucontrolsandengineersbe2698]

Sir ,Thank you

[@MyLiveSupport]

welcome sir ji

[@spnokijeet]

जो लोग स्टूडेंट हैं या किसी जॉब की तैयारी कर रहे हैं वॉइस लोंग वे इस लिंक को फॉलो जरूर करें kzbin.info/door/cNFYIt3UQiVjYIEZHB0KSw

[@rajkumarsherkhane]

Camera work as copy paste

[@sameerpandey6190]

Use =Concatenate( for last trick

[@manoranjandas7509]

Bro open excel k baare me koi tricks

[@ZindagiTechnical]

very nice video which software used to edit your videos and you how do you display that popping name on your screen please guide

[@ZindagiTechnical]

Answer to my question sir...Which software you use for video edit...

[@kishorisawant3037]

Sir Can you pls make a video regarding percentage or ratio...

[@rajatverma1578]

Thank u

[@dharmendrayadav-bw2gp]

Nice video . If different units in data like nos,piece,kg then how to calculate it.

[@MyLiveSupport]

already make video on this comment. see video

[@alibijapur313]

Tikh hai I like ir

[@RaviKumar-mz3jg]

Entire.addfit kar formula hai uska

[@shabbirmandasourwala5186]

Concatenate is an easier option for the fourth trick..

[@surendrakumar-fu1wx]

M S word me Hindi English ek saath Liliane Ka short trick bataye

[@bijayakumarsahoo6300]

Please inform camera option available in MS Excel 2007

[@viveksingh-un5dh]

In trick no. 1, what if I want pcs for some items and sets for other items as my goods should be measured in pcs for some items and sets for other items.

[@comedyshots9929]

sir excel me bina esqual lagaye two value ko add kaise karege please tell me.

[@zahidbadshahrzi3930]

Salam sir. Sir kia ye camera wala pic whatsapp ya email ho sakta hai ya nahi agar han to kaise?

[@MyLiveSupport]

Pehle ise computer mein save karna hoga

[@AnkitSingh-ng5un]

Index match ka formula kaise lagate hai?

[@MyLiveSupport]

Video already banaya hai jake dekhlo channel pe

[@pramodkumarmishra3779]

Good

[@MyLiveSupport]

thanks bro

[@chintamankadam3077]

Big Thanks for teaching us all excel formulas

[@RaviKumar-mz3jg]

Mujhse ek bar wo video chahiya Jo like ka bad khud hi arrgest ho gata hai

[@ManojKori-kn7oq]

Magic trick 4, can be done by using flash fill easily.

[@pankaj9988024865]

Brother all tricks were good, but please tell camera trick kaise useful hai because it is similar to copy and paste

[@deepakzeeb4u]

It's not copy paste, it's just like screen shot. It's result as a picture not as a data sheet

[@arupsasmal4591]

i have an excel data sheet of 500 name and its unique number such as 5462 ram, 4786 shyam 8546 rahim. In an another sheet in a cell i just put the unique number and beside the cell it will take the name automatically. Like i put the number 5462 in a cell it will take the name ram in its right cell.How its possible? Please help me

[@anilchavanvipra]

In your first example.. where u put pcs along with amount .. what if various units .. ie . Box..set..nos

[@dr.shreyas123]

Yes even other texts will work in similar way

[@BeenaMenon1968]

When you click a cell d line border looks green. Can u pls tell me how to change the selection line colour.

[@SONIKUMARI-mx5sf]

Onile class karate hai sir

[@vipinsingh2372]

Bhai ap ek video bnaye jisme scanned documents ya mail par pdi report ki images Ko excel sheet pr kaise convert kre .. Mai government employee hu or mujhe hindi me matter ka sath data milta h. To kya same hindi format me ap convert kr skte h kya??

[@vipinsingh2372]

Ocr net se alg koi website ya solutions h to btana

[@bsmcool5611]

last formulae mein agar middle name nehi ho toh double space hojayega

[@MyLiveSupport]

No

[@dr.shreyas123]

Then we can use if and modify formula for both scenarios

[@GaganDeep-zt2qx]

Bro how to find duplicates in multiple sheets?

[@pankajchandra7106]

Don't long opration as 3rd one Simple put formula or double click on plug before creating series.

[@afrozattar7671]

View code ko kaise break kar sakaten hain sir

[@ayodhyafestival1870]

Sir ji excel se special characters hatana hai to kya kare

[@sudeepjainshastri7197]

How to split worksheets from Drop down list like show report filter pagaes in pivot table but I want to do show report filter pager from dorpdown list not from pivet table.. I search a lot of but unfortunately can't find please guide me.

[@malharcreations3438]

SIRJI AAPNE CAMERA KE BARE ME BATAYA WHO Ok PER AAP EK BAT KEHNA BHUL=GAI= KI JAB HUM KHUCHA CHANGE KARTE HAI= TO WO PHOTO BHI CHANGE HOTI HAI

[@paravej]

Camera ki jagah paste special me 2 options hain A. Paste Special - As a Picture B. Paste Special - As a Link Picture Second वाले option me source data change karne par picture me भी change hoga