How to use Offset function in Excel (हिंदी में)

[@learnwithlokeshlalwani]

Please check out my video on Offset Function in Excel. I will upload daily content during #lockdown. ✌️😊😊

[@juliuscolton9419]

i dont mean to be offtopic but does anybody know a trick to log back into an Instagram account..? I stupidly forgot my account password. I love any tricks you can offer me.

[@andersonbaylor8684]

@Julius Colton instablaster ;)

[@juliuscolton9419]

@Anderson Baylor i really appreciate your reply. I got to the site thru google and I'm trying it out atm. I see it takes quite some time so I will reply here later when my account password hopefully is recovered.

[@juliuscolton9419]

@Anderson Baylor It did the trick and I finally got access to my account again. Im so happy:D Thank you so much, you saved my ass!

[@andersonbaylor8684]

@Julius Colton You are welcome :)

[@ankitakothari3138]

Sir highly impressed by your explaination skills....randomly open ki thi kuch sikhne ko mai toh stick ho gayi aapki videos par hats off sir......🤗

[@siripurapusamyuktha4340]

I practiced many times offset but never get satisfied... But your video made me clear about this formula. Thanks alot 🙏

[@ABHIBSD]

Good Instructor

[@jatanmehta3612]

thanks sir ..👍👍👍👍👍👍

[@laxmanbhardwaj2554]

SUPPER BRILLIANT EXCELLENT AWESOME GREAT QUALITY OF TEACHING SIR!!!!!!!!!!!

[@varunkexperiences]

offset function is very useful

[@rajwali8405]

Sir i havee sceen many video on offset but u done superb Job 👍🏆

[@arifjagmag9300]

Explains well with logic

[@adityavarma461]

Thanks bhaiya , your teaching way is very nice

[@learnwithlokeshlalwani]

It's my pleasure

[@darshandave9145]

sir column ke liye bhi bata dete ?????

[@pawanverma7220]

Sir Data ko table mai bhi toh convert kar sakte hai dynamic ke liye?

[@umarchitapure]

Nice video sir, which screen recorder did you use for such awesome video

[@onlyexcel493]

You explain very well sir

[@rajpatel4596]

good 👍👍👍

[@vijaysahal4556]

nice 👍🏻👍🏻👍🏻👍🏻👍🏻

[@sachingupta2700]

Thanks a lot sir

[@iftikharali481]

Very nice & informative video Keep it up.

[@mahabiraggarwal8426]

Very useful sir. How we can dynamically set print area with offset function

[@shradhagarg4893]

Hi Lokesh. Do you give training on MACROS. Please share the link if YES. Thanks!

[@learnwithlokeshlalwani]

Hello, Here is a link to enroll for the course. learn-with-lokesh-lalwani.thinkific.com/courses/Excel-Masterclass

[@ajrocks1231000]

Very well explained. Your videos are quite helpful.

[@learnwithlokeshlalwani]

Glad you liked my videos :) By any chance, if you missed out, you can join this FREE course learn-with-lokesh-lalwani.thinkific.com/courses/Freemium-Excel-Course to become the part of my mission to grow our learning community to 20,000 people by the end of 2020 and help then in earning online to become financially independent. So hold my hand and helps other too to become the part of this mission by sharing this FREE course to all. Let's learn and grow together. Happy Learning 😊 #20000by2020 #learnwithlokeshlalwani

[@RohitKumar-uy7cx]

Nice vedio sir

[@amitrana8147]

Sir mera 13/3/2020 se 28/3/2020 se jab main date fill krta hun toh voh text format main aa raha hain ab sir value kaise banau inki

[@rccollection146]

Great😁

[@mehboobmaniyar1890]

Nice explanation sir

[@jasdeepsingh5538]

Very informative

[@kishorpanara4191]

Sir formula ke age minus or plus ka sing ata hai uske bare me samjaye pls sir again pls

[@learnwithlokeshlalwani]

Hi Kishore, Aapko iske uper detailed video mere FREE course main mil jayega. Aap yej course iss link se join kar sakte ho. learn-with-lokesh-lalwani.thinkific.com/courses/Freemium-Excel-Course Happy Learning :)

[@BlitzBandit09]

Offset function से page selection केसे कर सकते हैं

[@learnwithlokeshlalwani]

Hi Amit, here is an example - =OFFSET(Sheet_Name!$A$1, 0, 0, COUNTA(Sheet_Name!$C:$C), 1)

[@BlitzBandit09]

@@learnwithlokeshlalwani ye formula kaam nahi kar raha hai

[@shalurani3164]

Sir no. Of cols 0 q liya gya hai.

[@IK-619]

Because that would have moved the reference to the other column.

[@preshrajoria9401]

maine offset lgya in pivot table but jb maine excel file ka name change krti hu to wo offset use nhi hota ..plz help anyone

[@learnwithlokeshlalwani]

Hi Presh, can you please share your file at [e-mail] (if its not confidential or you can send me with dummy data). Let me look over and get back to you.

[@shantisawaroopsharma6589]

Very informative

[@learnwithlokeshlalwani]

Glad you liked it