- Видео 134
- Просмотров 82 735
TechMe
Индия
Добавлен 2 ноя 2013
I love sharing knowledge to increase knowledge. Educational, Awareness and learning are the main purpose of this channel. I make videos mostly on Educational and also share good content as LIVE sometime. I have plans to engage with influential as well as intellectuals to share more knowledge and information to the internet consumers.
CHAPTER 33: DYNAMIC ARRAY FUNCTIONS
Check the entire playlist to Learn Excel from scratch: ruclips.net/p/PLD0mRPtPp8ODEROuMQHRYTDqoLjvP7xs8&si=qgjI5oiGTKANCbh0
You can also check out the three functions I am using in this lecture at the link given below.
1) ruclips.net/video/7X4QBSDLMWo/видео.htmlsi=bmKEspt5J4iEQSot
2) ruclips.net/video/64tLXZYPWrw/видео.htmlsi=sUGcKisdiJalYBqi
3) ruclips.net/video/TqzeXuqsI00/видео.htmlsi=QO5MRAaae-Ejg-xg
Dynamic Array Functions are a powerful set of tools in Excel that allow you to automatically return multiple values into a range of cells based on a single formula. This feature represents a departure from traditional functions that could only return a single value to a single cell1. Let me ex...
You can also check out the three functions I am using in this lecture at the link given below.
1) ruclips.net/video/7X4QBSDLMWo/видео.htmlsi=bmKEspt5J4iEQSot
2) ruclips.net/video/64tLXZYPWrw/видео.htmlsi=sUGcKisdiJalYBqi
3) ruclips.net/video/TqzeXuqsI00/видео.htmlsi=QO5MRAaae-Ejg-xg
Dynamic Array Functions are a powerful set of tools in Excel that allow you to automatically return multiple values into a range of cells based on a single formula. This feature represents a departure from traditional functions that could only return a single value to a single cell1. Let me ex...
Просмотров: 17
Видео
Chapter 32: UNIQUE FUNCTION | Excel Dynamic Array Function | Excel 365
Просмотров 7312 часов назад
Check out the Playlist here: ruclips.net/p/PLD0mRPtPp8ODEROuMQHRYTDqoLjvP7xs8 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
Просмотров 2816 часов назад
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
Просмотров 46День назад
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Месяц назад
The VLOOKUP function in Excel is a powerful tool used for vertical lookup, which searches for a value in the first column of a table and returns a value in the same row from a specified column. =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) Wherease HLOOKUP function in Excel is a powerful tool used for horizontal lookup, which searches for a value in the first rowof a table ...
Module-2 Chapter: 25- vLOOKUP Function
Просмотров 41Месяц назад
he VLOOKUP function in Excel is a powerful tool used for vertical lookup, which searches for a value in the first column of a table and returns a value in the same row from a specified column. Here’s a breakdown of how it works: Imagine you have a table of employee IDs (column A) and names (column B), and you want to find the name of the employee with ID 12345. =VLOOKUP(12345, A:B, 2, FALSE)
Module-2 Chapter: 24 Date & Time Formula
Просмотров 40Месяц назад
Working with date and time in Excel involves a variety of functions that can help you manage and manipulate dates and times effectively. Here’s a brief overview of some key functions: NOW(): Returns the current date and time. TODAY(): Returns the current date. DATE(year, month, day): Combines individual year, month, and day values into a date. TIME(hour, minute, second): Combines individual hou...
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 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
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 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: 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
Просмотров 79Месяц назад
Module -1 Chapter: 9- Sorting in Excel
Module 1 Chapeter:8- Autofill Function in Excel
Просмотров 692 месяца назад
Module 1 Chapeter:8- Autofill Function in Excel
This short video also a kind of taste among the long video's,......... Please update regularly such short also.... Insha ALLAH.
Very useful
Keep practising
Very useful
Nice
Thanks
How do you find this lesson? Have you noticed something new? Leave your comment to get to know how good the lesson is. Thanks
thanks oja
Hope you are recommending my class to your friends
Promo-SM
Thanks
Watching Sir video makes me more improvement day after another
Hope you are watching all videos and also sharing to your friends.
oja na takpase yam laina tak a loina gyan tai
Yamna nungaijei Nahakki feedback fangjabada
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.
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.
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.
Thanks Mr. Ajimuddin for sharing feedback in detail.
This video really helps bring more clarity to my understanding of number formatting.
Thanks
The sound is much better from chapter one
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.
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.
Awesome to watch your channel Sir
Keep watching all chapters to become an advanced user and save time 10x times
thanks
What is that you learnt in this lecture.
Great formula, n if there is possibility to add multiple column index number, please explain that area also
A separate video on that will be made. We need to go chapter by chapter.
Yet another useful formula
Comment below if you find this lecture useful. Have you used vLOOKUP Function before.
Very easy but useful indeed
Very educational Sir..
Thanks Thomas
got some important clues from this video
sir ym nugyjare excel tmba fngbase . thank you very much for the educational videos
It my pleasure.
👍👍👍
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
Yaroi. Same cell da correction tounaba formula eebada cell da yaoriba text tu delete toukhrani
module 2 chapter 15 se private thmkhraba mnle ... video se udre
Fixed the issue. Check it out
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.
Kamaina eebano. 1 to 6725 Or Patient 1 Patient 2 Patient 3…. Patient 6725 Sumaina eebagiro
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
Very Informative
Thanks. Do not forget to share to your friends who may need this lesson.
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.
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 ........
Useful topic
Thank you Amir. Check out the other topics too.
Sound se yamna nungaite.. Clear oiba watle..
Chumme! Chapter 1 di sound du khara nungaiba watpani. Adubu chapter 2 onwards ti adum yarabra khalli. Check touraga haibirak o.
Excel loirga amuk tally twse
Awesome explanation!!
Thanks
Macros gi matang sisu........
Macro gi matang su yaorakkani. Adudi advanced stage ni aduna aroibada tagani.
Yai
Tq
Welcome.
Nice and really useful
Wow the new thing I learnt is putting absolute reference formula
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.
Excellent
Thanks
👍👍
Mashallah 💚💚💚💚
Let me know if you have seen other video
❤️ P R O M O S M
Ngacdage chahi 20 ge mamangda Lilong College da sakhiba naat malli ...oirabadi matamduge record touramlabadi mipum khudingna sonnani eidi ngacphao ningsingli.
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
ماشاءاللہ قاری صاحب اللہ تعالی آپ کی عمر میں برکت عطا فرمائے آمین
Aameen
Hemi tih hma hian deposit transaction pawh a theih lo hrim2 ami
Nice papa
Mashalla
Coming soon. Chsl 2019 batch