TechMe
TechMe
  • 137
  • 82 828

Відео

CHAPTER 33: DYNAMIC ARRAY FUNCTIONS
Переглядів 19День тому
Check the entire playlist to Learn Excel from scratch: ua-cam.com/play/PLD0mRPtPp8ODEROuMQHRYTDqoLjvP7xs8.html&si=qgjI5oiGTKANCbh0 You can also check out the three functions I am using in this lecture at the link given below. 1) ua-cam.com/video/7X4QBSDLMWo/v-deo.htmlsi=bmKEspt5J4iEQSot 2) ua-cam.com/video/64tLXZYPWrw/v-deo.htmlsi=sUGcKisdiJalYBqi 3) ua-cam.com/video/TqzeXuqsI00/v-deo.htmlsi=QO...
Chapter 32: UNIQUE FUNCTION | Excel Dynamic Array Function | Excel 365
Переглядів 72День тому
Check out the Playlist here: ua-cam.com/play/PLD0mRPtPp8ODEROuMQHRYTDqoLjvP7xs8.html Unique function is a powerful formula introduced in Excel 2019 and 365. It helps you extract unique value out of a list or range.
Chapter 31: SORT & SORT BY FUNCTION: Sorting any data dynamic is Easy
Переглядів 28День тому
This function is available in Excel 2019 and Excel 365 versions only. This function will help you to sort any data dynamically. This is new Dynamic Array Function.
Chapter:30-FILTER FUNCTION | How to use Filter Function in Excel | Dynamic Array
Переглядів 4614 днів тому
Enhance your Excel skills with my in-depth tutorial on using the FILTER Function with multiple criteria. This video will guide you through complex data analysis techniques. Learn how to make your Excel workbooks more dynamic and responsive. In This Class: ▪️ FILTER Function Basics: Understand how to apply the FILTER function with multiple criteria. ▪️ AND & OR Conditions: Learn to filter data u...
Chapter 29: XLOOKUP in Excel | How can you apply in your daily task.
Переглядів 6014 днів тому
Discover the powerful capabilities of Excel's XLOOKUP function in this detailed class. Ideal for Excel users looking to enhance their data lookup skills. XLOOKUP offers a more versatile and efficient approach compared to traditional functions like VLOOKUP and INDEX MATCH.
Chapter 28: Spilled Array Concept | How Spilled Array can solve multiple problems in Data Analysis
Переглядів 5514 днів тому
In Excel, a spilled array refers to a set of values returned by a dynamic array formula that automatically populates neighboring cells. Let’s break it down: Dynamic Array Formulas: These are formulas that return a set of values (an array) and spill those values into adjacent cells. Unlike older array formulas (legacy array formulas), dynamic array formulas can vary in size and adapt to the data...
Leap Year Test: Easy and short way to find out
Переглядів 2614 днів тому
Leap year comes once every four years which means the year should be devisable by 4. Excel has easy formula to test the same.
Module-2: Chapter-27: INDEX MATCH Function
Переглядів 49Місяць тому
The INDEX MATCH function is a powerful tool in Excel that allows you to perform more advanced lookups. Let’s break it down step by step: MS WORD ME ENGLISH SE HINDI TYPING KEISE KAREN| MA WORD ME HINDI TYPING KI SETTING kaise Kare 7 amazing Excel tricks and tips| Learn Ms Excel IUPAC Nomenclature of organic compounds explained in Telegu part 1 NEET/JEE INDEX Function: The INDEX function retriev...
Module-2: Chapter 26- VLOOKUP & HLOOKUP
Переглядів 37Місяць тому
Module-2: Chapter 26- VLOOKUP & HLOOKUP
Module-2 Chapter: 25- vLOOKUP Function
Переглядів 41Місяць тому
Module-2 Chapter: 25- vLOOKUP Function
Module-2 Chapter: 24 Date & Time Formula
Переглядів 41Місяць тому
Module-2 Chapter: 24 Date & Time Formula
Module-2: Chapter-23: Switch Function
Переглядів 37Місяць тому
Module-2: Chapter-23: Switch Function
How to Highlight Active Cell, Row and Column in Excel. Solved
Переглядів 49Місяць тому
How to Highlight Active Cell, Row and Column in Excel. Solved
Module-2 Chapter: 22 Text Functions
Переглядів 66Місяць тому
Module-2 Chapter: 22 Text Functions
Module-2 Chapter 21: Large Small & Rank
Переглядів 26Місяць тому
Module-2 Chapter 21: Large Small & Rank
Module-2 Chapter 20: Statistical Functions in Excel
Переглядів 26Місяць тому
Module-2 Chapter 20: Statistical Functions in Excel
Module-2 Chapter: 19 IF & IFS Functions
Переглядів 31Місяць тому
Module-2 Chapter: 19 IF & IFS Functions
Memory of Village-Ningthounai
Переглядів 70Місяць тому
Memory of Village-Ningthounai
Module-2 Chapter: 18 AND/OR/NOT FUNCTION IN EXCEL
Переглядів 75Місяць тому
Module-2 Chapter: 18 AND/OR/NOT FUNCTION IN EXCEL
Module-2 Chapter: 17 -Nested IF Function in Excel
Переглядів 191Місяць тому
Module-2 Chapter: 17 -Nested IF Function in Excel
Module-2 Chapter:16 - IF Function
Переглядів 281Місяць тому
Module-2 Chapter:16 - IF Function
Module-2 Chapter 15: Sum Function
Переглядів 48Місяць тому
Module-2 Chapter 15: Sum Function
Module 2 Chapter 14: Type of References
Переглядів 66Місяць тому
Module 2 Chapter 14: Type of References
Excel Calendar Templates Made Easy: How to Build Dynamic Calendars
Переглядів 50Місяць тому
Excel Calendar Templates Made Easy: How to Build Dynamic Calendars
Module-2 Chapter 13: Absolute & Relative Reference
Переглядів 146Місяць тому
Module-2 Chapter 13: Absolute & Relative Reference
Module -1: Chapter-12: Custom List
Переглядів 60Місяць тому
Module -1: Chapter-12: Custom List
Module-1 Chapter: 11- Date & Wildcard Filtering in Excel
Переглядів 86Місяць тому
Module-1 Chapter: 11- Date & Wildcard Filtering in Excel
Module -1 Chapter:10 Text & Number based Filter in Excel
Переглядів 45Місяць тому
Module -1 Chapter:10 Text & Number based Filter in Excel
Module -1 Chapter: 9- Sorting in Excel
Переглядів 792 місяці тому
Module -1 Chapter: 9- Sorting in Excel

КОМЕНТАРІ

  • @user-wb9kw7jd1r
    @user-wb9kw7jd1r День тому

    Very informative

  • @user-wb9kw7jd1r
    @user-wb9kw7jd1r День тому

    Very useful...Well explain

  • @muhammadriyajuddin7073
    @muhammadriyajuddin7073 День тому

    Very very useful in the area of some random calculations etc....

  • @muhammadriyajuddin7073
    @muhammadriyajuddin7073 3 дні тому

    This short video also a kind of taste among the long video's,......... Please update regularly such short also.... Insha ALLAH.

  • @muhammadriyajuddin7073
    @muhammadriyajuddin7073 5 днів тому

    Very useful

  • @muhammadriyajuddin7073
    @muhammadriyajuddin7073 5 днів тому

    Very useful

  • @safurabegum-lg9fj
    @safurabegum-lg9fj 5 днів тому

    Nice

  • @TechMe.79
    @TechMe.79 20 днів тому

    How do you find this lesson? Have you noticed something new? Leave your comment to get to know how good the lesson is. Thanks

  • @botontong3936
    @botontong3936 22 дні тому

    thanks oja

    • @TechMe.79
      @TechMe.79 22 дні тому

      Hope you are recommending my class to your friends

  • @danetodd5311
    @danetodd5311 23 дні тому

    Promo-SM

  • @Fsenpuhaokip1234
    @Fsenpuhaokip1234 25 днів тому

    Watching Sir video makes me more improvement day after another

    • @TechMe.79
      @TechMe.79 22 дні тому

      Hope you are watching all videos and also sharing to your friends.

  • @botontong3936
    @botontong3936 29 днів тому

    oja na takpase yam laina tak a loina gyan tai

    • @TechMe.79
      @TechMe.79 28 днів тому

      Yamna nungaijei Nahakki feedback fangjabada

  • @mdajimuddinsheikh8892
    @mdajimuddinsheikh8892 Місяць тому

    The Wildcard Filtering was new to me. This Module is very important for those who never went for a formal Excel course. I learnt Excel by practicing by myself so I missed out on a lot of basics which could make my work much easier and this channel fills the gap for me.

    • @TechMe.79
      @TechMe.79 Місяць тому

      Thanks. Check out the VLOOKUP and Index Match chapter. That is another powerful lookup function if you are new to these two powerful functions. Will be waiting your feedback.

  • @mdajimuddinsheikh8892
    @mdajimuddinsheikh8892 Місяць тому

    Thanks so much! Every video is a new learning for me. Actually, I was using the format painter but the double-click option used to apply the same format in some desired cells only is new to me. Love it! I would recommend every Excel beginner to check out this channel and you will never get disappointed.

    • @TechMe.79
      @TechMe.79 Місяць тому

      Thanks Mr. Ajimuddin for sharing feedback in detail.

  • @mdajimuddinsheikh8892
    @mdajimuddinsheikh8892 Місяць тому

    This video really helps bring more clarity to my understanding of number formatting.

  • @mdajimuddinsheikh8892
    @mdajimuddinsheikh8892 Місяць тому

    The sound is much better from chapter one

  • @mdajimuddinsheikh8892
    @mdajimuddinsheikh8892 Місяць тому

    I think I am good at Excel. I am starting the Basic to Advanced playlist today to further polish my skills in Excel. Thanks so much for initiating such a channel which will contribute to the skill growth of many learners like myself. Currently, the sound in the video is not up to the mark but I hope this will improve with time and with each upcoming video.

    • @TechMe.79
      @TechMe.79 Місяць тому

      Thank you for the feedback. Yes the sound of the first video was too bad but it has been improved from second video onwards. It will be even better from chapter 28 which will be uploaded by the end April 2024.

  • @Fsenpuhaokip1234
    @Fsenpuhaokip1234 Місяць тому

    Awesome to watch your channel Sir

    • @TechMe.79
      @TechMe.79 Місяць тому

      Keep watching all chapters to become an advanced user and save time 10x times

  • @botontong3936
    @botontong3936 Місяць тому

    thanks

  • @TechMe.79
    @TechMe.79 Місяць тому

    What is that you learnt in this lecture.

  • @muhammadriyajuddin7073
    @muhammadriyajuddin7073 Місяць тому

    Great formula, n if there is possibility to add multiple column index number, please explain that area also

    • @TechMe.79
      @TechMe.79 Місяць тому

      A separate video on that will be made. We need to go chapter by chapter.

  • @riyaznadwi0607
    @riyaznadwi0607 Місяць тому

    Yet another useful formula

  • @TechMe.79
    @TechMe.79 Місяць тому

    Comment below if you find this lecture useful. Have you used vLOOKUP Function before.

  • @riyaznadwi0607
    @riyaznadwi0607 Місяць тому

    Very easy but useful indeed

  • @thomasvsailo7471
    @thomasvsailo7471 Місяць тому

    Very educational Sir..

  • @muhammadriyajuddin7073
    @muhammadriyajuddin7073 Місяць тому

    got some important clues from this video

  • @Padam561
    @Padam561 Місяць тому

    sir ym nugyjare excel tmba fngbase . thank you very much for the educational videos

  • @sarinakhulakpam5810
    @sarinakhulakpam5810 Місяць тому

    👍👍👍

  • @muhammadriyajuddin7073
    @muhammadriyajuddin7073 Місяць тому

    Within cell da correction tawba yaroidara i.e A2 cell da leriba asi adumak A2 cell da oina atoppa cell nattabada. Hoi amadi yai after correction just delete column A

    • @TechMe.79
      @TechMe.79 Місяць тому

      Yaroi. Same cell da correction tounaba formula eebada cell da yaoriba text tu delete toukhrani

  • @Padam561
    @Padam561 Місяць тому

    module 2 chapter 15 se private thmkhraba mnle ... video se udre

    • @TechMe.79
      @TechMe.79 Місяць тому

      Fixed the issue. Check it out

  • @jaweedmedia
    @jaweedmedia Місяць тому

    Sir Auto fill twnaba eina double click nambada karimta thokte karigino? Eigisi windows 7 oibagira? Curser na black color oiba matmda double click toubadani. Patient no. 1 du double click twbada 6725 faoba chtpadu eigisida yade.karm twgani.

    • @TechMe.79
      @TechMe.79 Місяць тому

      Kamaina eebano. 1 to 6725 Or Patient 1 Patient 2 Patient 3…. Patient 6725 Sumaina eebagiro

    • @TechMe.79
      @TechMe.79 Місяць тому

      Nahakki excel sheet tu screenshot louraga tharak o. Thengnaba cell du data yaobro. Yaodradi yaroi. Column A da Autofill touge hairadi column B da data 6725 row faoba yaogadabani. Aduga cell A1 da 1 enter touro aduga A2 da 2 eeoro. Adugi matungda 1&2 punna select touro aduga drag upto 6725 row or double click tou. Yagani

  • @user-ew5yj6ck3w
    @user-ew5yj6ck3w Місяць тому

    Very Informative

    • @TechMe.79
      @TechMe.79 Місяць тому

      Thanks. Do not forget to share to your friends who may need this lesson.

  • @riyaznadwi0607
    @riyaznadwi0607 Місяць тому

    Try to zoom in when you put the formula so that everyone could see clearly that input because many are probably watching on their mobile screen.

  • @muhammadriyajuddin7073
    @muhammadriyajuddin7073 Місяць тому

    Very informative n very easily understandable page format to understand some given formula at once on their respective results n difference.... ALLAH na makha henna chathaba ngamhanbisanu ........

  • @amirumar1987
    @amirumar1987 Місяць тому

    Useful topic

    • @TechMe.79
      @TechMe.79 Місяць тому

      Thank you Amir. Check out the other topics too.

  • @inaotombanaorem9035
    @inaotombanaorem9035 Місяць тому

    Sound se yamna nungaite.. Clear oiba watle..

    • @TechMe.79
      @TechMe.79 Місяць тому

      Chumme! Chapter 1 di sound du khara nungaiba watpani. Adubu chapter 2 onwards ti adum yarabra khalli. Check touraga haibirak o.

  • @MdAnish-ll4kh
    @MdAnish-ll4kh Місяць тому

    Excel loirga amuk tally twse

  • @buyamayumliyaquatali5576
    @buyamayumliyaquatali5576 Місяць тому

    Awesome explanation!!

  • @muhammadriyajuddin7073
    @muhammadriyajuddin7073 Місяць тому

    Macros gi matang sisu........

    • @TechMe.79
      @TechMe.79 Місяць тому

      Macro gi matang su yaorakkani. Adudi advanced stage ni aduna aroibada tagani.

  • @muhammadriyajuddin7073
    @muhammadriyajuddin7073 Місяць тому

    Yai

  • @user-mj7wv9et7v
    @user-mj7wv9et7v Місяць тому

    Tq

  • @riyaznadwi0607
    @riyaznadwi0607 Місяць тому

    Nice and really useful

  • @riyaznadwi0607
    @riyaznadwi0607 Місяць тому

    Wow the new thing I learnt is putting absolute reference formula

    • @TechMe.79
      @TechMe.79 Місяць тому

      Check out the custom list in chapter 12. That is also a very handy thing. If you make custom list of your own, you will save lot of time in future.

  • @hafijtamij3826
    @hafijtamij3826 2 місяці тому

    Excellent

  • @arsadboicha6348
    @arsadboicha6348 2 місяці тому

    👍👍

  • @user-jn7kt3gy5g
    @user-jn7kt3gy5g 2 місяці тому

    Mashallah 💚💚💚💚

    • @TechMe.79
      @TechMe.79 2 місяці тому

      Let me know if you have seen other video

  • @gregorypadilla1182
    @gregorypadilla1182 3 місяці тому

    ❤️ P R O M O S M

  • @syedershad6228
    @syedershad6228 5 місяців тому

    Ngacdage chahi 20 ge mamangda Lilong College da sakhiba naat malli ...oirabadi matamduge record touramlabadi mipum khudingna sonnani eidi ngacphao ningsingli.

    • @TechMe.79
      @TechMe.79 2 місяці тому

      Masidi 2021 da Y Academy da Qari Saab na lakpada toujahouba recording ni. Allah na mahakpu matam chuppa da ana ayek yaodana khidmat touba ngamhabisanu

  • @hafizsalehahmed5670
    @hafizsalehahmed5670 5 місяців тому

    ماشاءاللہ قاری صاحب اللہ تعالی آپ کی عمر میں برکت عطا فرمائے آمین

  • @user-un2yz2sl1h
    @user-un2yz2sl1h 6 місяців тому

    Hemi tih hma hian deposit transaction pawh a theih lo hrim2 ami