- 131
- 82 426
TechMe
India
Registrace 2. 11. 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 32: UNIQUE FUNCTION | Excel Dynamic Array Function | Excel 365
Check out the Playlist here: czcams.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.
Unique function is a powerful formula introduced in Excel 2019 and 365. It helps you extract unique value out of a list or range.
zhlédnutí: 29
Video
Chapter 31: SORT & SORT BY FUNCTION: Sorting any data dynamic is Easy
zhlédnutí 24Před 7 hodinami
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
zhlédnutí 46Před 21 hodinou
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.
zhlédnutí 50Před dnem
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
zhlédnutí 55Před 14 dny
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
zhlédnutí 26Před 14 dny
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
zhlédnutí 49Před měsícem
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
zhlédnutí 36Před měsícem
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
zhlédnutí 40Před měsícem
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
zhlédnutí 40Před měsícem
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...
Module-2: Chapter-23: Switch Function
zhlédnutí 37Před měsícem
The SWITCH function in Excel is a powerful tool that allows you to evaluate one value (referred to as the expression) against a list of other values. It then returns the result corresponding to the first matching value. If no match is found, you can specify an optional default value to be returned. Here’s the basic syntax of the SWITCH function: =SWITCH(Value_to_switch, Value_to_match1, Result1...
How to Highlight Active Cell, Row and Column in Excel. Solved
zhlédnutí 49Před měsícem
Excel is very powerful application and we can do a lot to make our works interesting. Once such function is Conditional Formatting combined with VBA code. This video shows how we can highlight an active row, column, column and row together as well as Active cell only with very simple formula. 1) HIGHLIGT A ROW ON A CONDITION =SEARCH("YES",$H5)greater than sign 0 2) HIGHLIGHT ACTIVE ROW =ROW()=C...
Module-2 Chapter: 22 Text Functions
zhlédnutí 66Před měsícem
Text Functions can help you format text, combine numbers with text, and perform various other text-related tasks in your Excel spreadsheets. HOW TO FIX Access is denied in ZArchiver | How to Open/Access Android data & obb in Android 11 Free Computer Course With 100% Free Certificate | 2024 | in Hindi How to use Text Function in excel Concatenate Function in Excel Free computer course with 100% ...
Module-2 Chapter 21: Large Small & Rank
zhlédnutí 26Před měsícem
Module-2 Chapter 21: Large Small & Rank
Module-2 Chapter 20: Statistical Functions in Excel
zhlédnutí 26Před měsícem
Module-2 Chapter 20: Statistical Functions in Excel
Module-2 Chapter: 19 IF & IFS Functions
zhlédnutí 31Před měsícem
Module-2 Chapter: 19 IF & IFS Functions
Module-2 Chapter: 18 AND/OR/NOT FUNCTION IN EXCEL
zhlédnutí 75Před měsícem
Module-2 Chapter: 18 AND/OR/NOT FUNCTION IN EXCEL
Module-2 Chapter: 17 -Nested IF Function in Excel
zhlédnutí 191Před měsícem
Module-2 Chapter: 17 -Nested IF Function in Excel
Module 2 Chapter 14: Type of References
zhlédnutí 66Před měsícem
Module 2 Chapter 14: Type of References
Excel Calendar Templates Made Easy: How to Build Dynamic Calendars
zhlédnutí 49Před měsícem
Excel Calendar Templates Made Easy: How to Build Dynamic Calendars
Module-2 Chapter 13: Absolute & Relative Reference
zhlédnutí 146Před měsícem
Module-2 Chapter 13: Absolute & Relative Reference
Module-1 Chapter: 11- Date & Wildcard Filtering in Excel
zhlédnutí 86Před měsícem
Module-1 Chapter: 11- Date & Wildcard Filtering in Excel
Module -1 Chapter:10 Text & Number based Filter in Excel
zhlédnutí 45Před měsícem
Module -1 Chapter:10 Text & Number based Filter in Excel
Module -1 Chapter: 9- Sorting in Excel
zhlédnutí 79Před měsícem
Module -1 Chapter: 9- Sorting in Excel
Module 1 Chapeter:8- Autofill Function in Excel
zhlédnutí 69Před měsícem
Module 1 Chapeter:8- Autofill Function in Excel
Module-1 Chapter 7: Insert Delete Rows & Column
zhlédnutí 76Před měsícem
Module-1 Chapter 7: Insert Delete Rows & Column
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
Nice
Thanks
Thank you so much for this video! 😊
Thanks
papa
Plz provide the pdf