Offset formula in excel in hindi | Excel OFFSET Function for Dynamic Calculations

Hello !!!!!!! In this video we will learn about OFFSET Funcion in excel. OFFSET tells Excel to “fetch” a cell location (address) from within a data range. The OFFSET function in Excel returns a reference to a range. It returns a range of cells that is specified number of rows and columns from the specified range. This function is very good for creating dynamic ranges and getting the range from the starting cell. It is an in-built function in Excel and categorized under the head Lookup/References functions. It is entered as a part of the formula as it is a worksheet function. This function applies to all Excel version from the Excel 2000. The Syntax for OFFSET function: OFFSET(range, rows, columns, [height], [width]) Where, Range: The starting point from where you will apply the OFFSET function. Rows: The number of rows to be applied as the offset range. It can be positive or negative number. Columns: The number of columns to be applied as the offset range. It can be positive or negative number. Height: This is an optional argument. If you omit this argument it will take the height of the range into consideration this argument specifies the height of the returned range. Width: This argument too is optional. If it is omitted it will assume the width of the range. This argument specifies the width of the returned range. Note: If the returned range is beyond the valid cells the OFFSET function will return an error. चैनल में, आप एक्सेल के अलावा PowerPoint, HTML, टैली, इंटरनेट, हार्डवेयर आदि से संबंधित वीडियो देख सकते हैं, so plz visit my channel And if you like my videos then subscribe to my channel. #abhayexcel #offsetexcel #offsetdynamicrange #exceloffset ------------------------------------------------------------------ ------------------------------------------------------------------ For CCC exam Preparation /playlist/PLPar9wB3f8YcHF23O4A1Wr3xZEwlxcS2p --------------------------------------------------------------------- --------------------------------------------------------------------- To Subscribe my channel:- /AbhayExcelCom ... --------------------------------------------------------------------- --------------------------------------------------------------------- For M.S.Word videos /playlist?list ... --------------------------------------------------------------------- --------------------------------------------------------------------- For Basic Excel videos :- /playlist?list ... For Excel Magical Trick /playlist/PLPar9wB3f8Ydy0bP7gF4Q6Q5_K9N27iOJ For Advance Excel /playlist/PLPar9wB3f8Yf-M412AAKbVSbkzv4YAd9Q --------------------------------------------------------------------- --------------------------------------------------------------------- For Powerpoint Videos /playlist/PLPar9wB3f8Ye8-uNCErhZYb42j9aDlQR6 --------------------------------------------------------------------- --------------------------------------------------------------------- Online Income Videos /playlist/PLPar9wB3f8YfxSkDtgHA6BVoggN35Xp37 --------------------------------------------------------------------- --------------------------------------------------------------------- For Computer Tricks Change login password without old password /watch/ob-UptT2Cct2U --------------------------------------------------------------------- --------------------------------------------------------------------- Our Top 6 videos /watch/Yi8D0gEOh1nOD /watch/8bfmUpAauAjam /watch/kJw3l09AKA_A3 /watch/oYpPnJhJxgBJP /watch/gnjcJnwlmCwlc /watch/sALuW4ofIZHfu Follow me on Facebook. https://www.facebook.com/Abhayexcelco ... --------------------------------------------------------------------- --------------------------------------------------------------------- FOLLOW ME ON GOOGLE+ https://plus.google.com/1107860104906 ... --------------------------------------------------------------------- --------------------------------------------------------------------- Visit our Blog https://successwaywithabhay.blogspot.com --------------------------------------------------------------------- --------------------------------------------------------------------- Visit Our Website https://newexcelcomputer.wordpress.com/ --------------------------------------------------------------------- --------------------------------------------------------------------- दोस्तों मै उम्मीद करता हु आपको मेरा ये विडियो पसंद आया होगा | दोस्तों अगर आपको कंप्यूटर या इस विडियो से सम्बंधित किसी प्रकार की कोई समस्या आ रही है तो आप हमे कमेट बॉक्स में जरुर बताइए या आपको किसी प्रकार का कोई प्रश्न पूछना है तो आप पूछ सकते हैं मै आपकी समस्या का समाधान जरुर करूँगा | Thanks for watching my video.

Category