🔥 10 New Excel Formulas and Functions 2024 in Hindi | Excel Formula Tutorial

10 New Excel Formulas and Functions 2024 in Hindi | Excel Formula Tutorial
Discover 10 new and powerful Excel formulas and functions that will take your spreadsheet skills to the next level! Whether you're a beginner or an experienced user, these formulas and functions will help you analyze data, perform calculations, and automate tasks more efficiently. From dynamic arrays to text manipulation, this video covers a range of topics to enhance your Excel proficiency. Watch now to learn these exciting new formulas and functions and supercharge your Excel skills! you can practice all these new excel formulas in office 365 web version to enhance your skills. #excelformulas #office365 #excel #deepakeduworld
00:00 intro
00:27 Torow formula
04:19 Tocol formula
06:28 Textbefore formula
09:15 Textafter formula
11:59 Textsplit formula
13:07 Vstack formula
16:23 Hstack formula
17:38 Take formula
21:40 Drop Formula
22:54 Data From Picture
My Channels :
A to Z Excel : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : bit.ly/364SVGV
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP TUTORIALS ►
bit.ly/3kJyIBv
Thanks for Watching
Deepak EduWorld

[@DeepakEduWorld]

dosto ye new formulas apko kaise lage ? aapke liye sabse accha aur most useful formula konsa raha ? Comment Kare 😊😊

[@azharaliwarsi1227]

Sir, Stack Formula mujhe mast lga. Pls use my name in next practice sheet. Thanks

[@apocalypsematrix9252]

🙏🏻 KYA MASTI KYAH DHOOM MUGEMBO KUSH HOH GIYAHHH 🙏🏻

[@muttu99]

YE FORMULA 2016 ME CHALEGA KYA BHAI ME TRY KAR RHA HU NAHI HO RHA

[@UbaidAnsari499]

@@muttu99 Nahi chalega 😭

[@uniqe_classes_001]

​@@apocalypsematrix92520:40

[@darshitchavda8264]

Terrific sirjee.... good one

[@sadiqahmed814]

Deepak sir all farmulas are fantastic and very helpful. You are an excellent teacher of EXEL ever. Greatest appreciate and salute from Karachi Pakistan

[@KuldeepSingh-nq1vi]

All formulas are Useful, please keep uploading Videos regarding new formulas..

[@arunkumarsinghark3024]

Amazing interesting Sir शुक्रिया

[@sai-qj9ly]

Very very Useful Sir, Thank u so much

[@mohdnadeem5811]

excellent Amazing farmula

[@prince-68818]

All formulas are helpful, Excellent and awesome. Thank u soooooooo much

[@maheshsanghani6380]

All are very useful.

[@rtiwari6855]

DEEPAK JI ... U R DOING FANTASTIC JOB

[@VermaRajinder]

Excellent 👍👌

[@manojk2890]

I like it...all thans

[@mehedihasan-kf4uy]

Excellent

[@hemantkolhatkar4066]

Found very useful

[@shaifulislam6746]

Nice

[@neerajtiwari1119]

Fantastic work brother keep it up and thanks ❤❤

[@Jamalhappy]

Zabardast

[@koparkhairaneshop]

This video is very very so good and very nice. your teaching explanation is very good. because you give an example every time when you teach. thank you.

[@DeepakEduWorld]

You are most welcome 🥰

[@Rishi_khurana_hi-tech]

Thanks PRO

[@AdityaSharma-rg1zn]

Amazing as always

[@proficientclasses6757]

Good

[@baspulickal]

Sir, Konsa versioñ pe a function chaltahe

[@venkatraonamana6551]

Very nice information and thank you

[@pradeepnegi7523]

Nice sir

[@noorahmad2859]

Sir, excel ki trah word main kaisay link kia ja sakta hay taxt para k liay

[@AnkitSharma-jo5ow]

Sir yh formula Bhuat Accha hai power quary Ke liye alag data ko combine Karen Ke liye

[@arvindmaurya3149]

Sab bahut acche formula hai thankyou sir

[@RishabhPant-ik4nd]

Sir please provide full detailed course on VBA in Excel

[@rameshwernagar1599]

Deepak bhaai aapke sare video 200% majedar hai

[@yogie4740]

Can you make video on daily and monthly production costing

[@sumankumar7215]

Wow amazine video with explanation..i wish do 365 excel i have but i work on windows 7😢

[@samirawati1975]

Bahut badhiya sir, aapke samzane ka tarika bohot hi simple hota hay. Please sir lamda formula k par bhi video baniye. Aur VBA micro siries kab chaloo ho rahi hay, 😢 kabhi se raha dekh raha hoo

[@Rk-bh7ru]

❤

[@SUMANDAS-js2kq]

Dear sir please make complete one video in MX Excel

[@mdasgaransari295]

Vstack helpful formula.!

[@kuldeepsingh-zf7fh]

can we download this excel practice sheet.

[@Himanshu_Panwar_Dhanpati.Uk11]

Datafrompic was awesome formula.

[@DharmendraNb22]

Sir aap Ms ka konsa version chala rahe ho

[@tinkukumarsaini8944]

Sir books m.s excel advance

[@burhanbhat6643]

Hlo sir jee aap se aaik request. Hai yeah formula kiss office mai 2019/2016 etc pls sir bolo na

[@makaniharesh1459]

Sahi hai sirji...thode din pehle mene aise data copy paste Kiya hai...😀😀😀🤣🤣🤣 Thank you ....

[@farman247]

Hello sir . Photo shop aor coraldraw par b video bna den . Fan from Pakistan

[@shivashankar486]

If incase we required values from bottom rows to top rows how to do take formula

[@shivashankar486]

Example In ten rows January to December data is there . If we require data from December to January how to use take formula or drop formula

[@noorahmad2859]

Sir, jis trah excel main 2 sheet ko apas main link kia ja sakta hay isi trah word main kaisay kia ja sakta hay

[@shivani-ur7pm]

sir all formulas are fantastic and very useful you are excellent teacher and you are explain very nice dear sir ji thank you so much sir ji🙏🔥👍

[@shivani-ur7pm]

sir ji mere paas excel test ki file hai jo interview me puche questions hai solve karna hai kaise

[@shivani-ur7pm]

sir ji please solve questions ❓🙏

[@zahoorwani495]

Sir could it be possible to insert rows or columns in huge excel data where we have add rows suppose in serial 1 we have add 5 and 2 we have add 8 and so on in big data kindly make a lesson

[@shankardeb4933]

Wonderful ! Excellent ! Amazing !

[@sachinkale4544]

updatefull vedio

[@versetilehub9178]

thank u sir..i have queries...i want 1000 rows so how i will add it.

[@sadsongstatus8526]

V stack or tocol

[@Rk-bh7ru]

Sir total column 11 me se column number 2,4,5 ,8 ko drop karana hai uske liye kya kare. Please tell us.

[@rajeevchikane8511]

Thnx sir 👍

[@mayank265memories]

Please provide the notebook for download

[@Ytgame11]

Sir want contact with you regarding excel learning

[@krishanyadav8145]

it's not working in my excel...Pls help me out..

[@PrasadRanjane-rl9zx]

Sir thx for teaching new formulas, my question is how to remove space, is there any way to do it because in small file u can check but in large file it's not possible, pl guide. I am facing this problem every time while I use vlookup function. Thx 🙏🏻 in advance.

[@DeepakEduWorld]

Plz wait for next excel tips and tricks video.. I noted your query…

[@Rk-bh7ru]

Sir ye new formula ke liye office 2021 ko update karna padega kya. Mere office 2021 me nahi hai.

[@muhammadkhan-zy5xw]

Sir if we want to keep mr before name than what formula will be use

[@DeepakEduWorld]

You can use instance_num parameter in textbefore formula…. For second space

[@muhammadaminrazagujjar8610]

Vstack is superbe

[@gvalfitness]

Vstack very helpful,,, remove Consolidate🤣🤣🤣👍👍

[@shitalsingh4995]

Vstack formula nahi ho Raha he error aata he

[@dineshchudasama5981]

Sir when I use textbefore formula resulting #NAME?

[@dineshchudasama5981]

Sir mai ek galti kar raha tha to ab ho gaya

[@khabirulislam999]

Thanks a lot sir

[@Shoukat_Wadho]

Bhai me Pakistan se ho ……excel me data type tool me Stock or geography wala option nahi a rha he kese wo option aiga ????

[@Shoukat_Wadho]

Reply bro

[@anushajabegu808]

All formula is very useful and I am fully satisfied by this video. Well done sir.

[@MajidAlikhr]

Deepak Sir I am Facing difficulties during Farmulas Can You Help Me Plz i am Working On School Timetable

[@techbing2639]

सर जी आपका एक्सेल का कोर्स कन्हा है प्ले लिस्ट मिला ही नही सुरु से बेसिक से एडवांस होम टैब से लास्ट टेब तक

[@basantkumarchandola2897]

क्या ये सारे formulas Office, 10 में भी हैं?

[@amlanmukherjee7041]

VSTACK won the tournament easily defeated other formulas

[@uniquemobiletipstricks7714]

Konsa version है ये

[@DeepakEduWorld]

Ye sare new formulas hain… aap ye office 365 web version me practice kar saktey ho… i am using office 365

[@saurabhrastogi1115]

YE NORMAL EXCEL ME NHI AATA HAIN SIR

[@im_suraz]

2019 main support karega ya nahi

[@DeepakEduWorld]

Ye sare new formulas hain… office 365 web version me aap ye practice kar saktey hain ✅

[@im_suraz]

@@DeepakEduWorld lekin web version main free nahi hoga na ye bataiye office 2021 ke download link dijiye with crack

[@shashikantchaudhari1378]

Formula not available in my Excel 2021

[@DeepakEduWorld]

These all are new formulas available in office 365… you can practice all these formulas in office 365 web version ✅👍

[@arunkumarsinghark3024]

🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹❤🌹🌹 🌹 सीखते रहो, सिखाते रहो l❤ 🌺हमेशा हंसते मुस्कुराते रहे l कभी अपने लिए तो कभी अपनों के लिए l🌺🌹🌹❤

[@sanjubaba-xf6kj]

why it is not working on my office 365?

[@DeepakEduWorld]

Practice these all formulas in office 365 web

[@nabinkumardangol345]

how to get these formula in excel? When I tried, I didn't get these formula?

[@DeepakEduWorld]

These all for formulas are available in office 365 web version…. You can practice these formulas in 365 web version.

[@nabinkumardangol345]

@@DeepakEduWorld Thank you...

[@musondapeter3441]

Kindly help me use the formula (=Mod(row0,2)=0) because it's not working for me.

[@musondapeter3441]

Kindly help me use the formula (=Mod(row0, 2)=0). It is working for me on my PC with office 2016

[@gvalfitness]

Sir jaise company me koi peace rate pe work krta ho aur per piece ka itne rupye diye jate Hain,,maan lo ek din 120 peace bnaya,,phir 50 is trah se 1 months me total kitna peace Ready kiya,,uska total amount kitna hua? Ispe salary slip kaise banayenge batao sir?

[@DeepakEduWorld]

Row formula me cell reference missing hai….

[@musondapeter3441]

@@DeepakEduWorld thank you very much

[@gvalfitness]

Office 2021 paid me le to kitne lagenge?😊

[@arunkumarsinghark3024]

आप जो भी formula लगा रहे हैं तो उसके syntax के साथ पूरा formula details भी उसके नीचे show हो रहा है, यह कैसे हो रहा है please बताए l 🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹❤🌹🌹 🌹 सीखते रहो, सिखाते रहो l❤ 🌺हमेशा हंसते मुस्कुराते रहे l कभी अपने लिए तो कभी अपनों के लिए l🌺🌹🌹❤

[@DeepakEduWorld]

Because i am using office 365 web version… web version me show hota hai g …

[@DeepakEduWorld]

Radhe Radhe g

[@umeshchettri1985]

Not a proper steps

[@rajantech3572]

Sir mujhe apki video hi best lagti h aap ek ek chij detail se samjhate ho ❤ great teacher ho aap❤

[@03217227420]

you are wonderful man.👍

[@vishnubairwa5697]

Nice sir