- 71
- 56 503
Sandeep Mr Gypsy
India
Приєднався 17 чер 2008
"Sandeep Mr Gypsy" is a UA-cam channel dedicated to Microsoft Excel tutorials. This channel provides comprehensive Excel guidance with practical examples. What sets it apart is the use of Malayalam voiceovers, making it accessible and user-friendly for Malayalam-speaking viewers. Whether you're a beginner looking to learn the basics of Excel or an advanced user seeking to master advanced features, "Sandeep Mr Gypsy" offers valuable insights and demonstrations to enhance your Excel skills. Join this channel to excel in Excel with the guidance of Sandeep Mr Gypsy.
Learn XLOOKUP in Just 3 minutes
Hey everyone! In this quick video, we’ll show you how to use XLOOKUP in Excel in just 3 minutes. Whether you’re looking up values in rows or columns, XLOOKUP is a powerful function that makes it simple. Let’s dive in!
What is XLOOKUP?
XLOOKUP is a versatile lookup function in Excel that allows you to search for a value in one column and return a corresponding value from another column. It replaces older functions like VLOOKUP and HLOOKUP, offering more flexibility.
XLOOKUP Syntax
Here’s the basic syntax of XLOOKUP:
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])
• lookup_value: What you’re searching for.
• lookup_array: Where you want to search for that value.
• return_array: Where you want Excel to find and return a corresponding value.
What is XLOOKUP?
XLOOKUP is a versatile lookup function in Excel that allows you to search for a value in one column and return a corresponding value from another column. It replaces older functions like VLOOKUP and HLOOKUP, offering more flexibility.
XLOOKUP Syntax
Here’s the basic syntax of XLOOKUP:
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])
• lookup_value: What you’re searching for.
• lookup_array: Where you want to search for that value.
• return_array: Where you want Excel to find and return a corresponding value.
Переглядів: 119
Відео
Splitting Data to Multiple Columns
Переглядів 873 місяці тому
The video shows how to split data from a singe column to multiple columns. This is done by using the Text to Column function via fixed width or delimited. explained with the help of examples in Malayalam
Print Excel Sheets with Headings in every Page
Переглядів 524 місяці тому
This video depicts on how to keep the headings in each of the sheets while printing a large document in MS Excel which is to be printed in multiple pages. This vide also shows how to keep all the rows & columns in a single sheet while printing
Usage of SUMIF/SUMIFS Formula in MS Excel
Переглядів 1168 місяців тому
This video will help to learn on how and where to use the SUMIF & SUMIFS formulas in MS Excel. This video is done by using live example to make the learners understand it clearly This is done with Malayalam voice over
Learn the Count Formula in MS Excel with Ease
Переглядів 1599 місяців тому
This video is all about various COUNT formulas which are used for different instances. this is explained in Malayalam with live example with a comparison to the pivot table
How & When to Use IF & IFS for Data Analysis
Переглядів 6910 місяців тому
This video teaches you when to use the If & Ifs formula in MS Excel. These functions are used when there are multiple iterations. This can be easily understood from this Malayalam class
Gantt Chart - Graphical Representation of Timelines
Переглядів 11011 місяців тому
A Gantt chart is a bar chart that illustrates a project schedule. A Gantt chart is a commonly used graphical depiction of a project schedule. It's a type of bar chart showing the start and finish dates of a project's elements such as resources, planning, and dependencies. In this video the same is explained well in Malayalam with an example of project timelines
Shortcut to find Day, Month & year from Date in MS Excel
Переглядів 120Рік тому
This video depicts on how to find the Day, Month & year from the Date in MS Excel. This is the best shortcut in MS Excel to quickly find the segregation of these three using a simple formula. TEXT is used to segregate the same. The video is made with examples in the Malayalam Voice over
Making of DROP DOWN option in MS Excel
Переглядів 241Рік тому
This video depicts how to make Drop Down Option in a MS Excel file. Drop Down helps to decrease the errors of typing. it is used when finite data has to be made in that cell. Its very simple but very useful one
Pie Charts - How & When to Use for Data Presentation
Переглядів 127Рік тому
The video depicts How to use & when to use the Pie Charts for the Data Presentation. How the data to be formated for the same What kind of analysis we can get it from such charts How to design it You will get all the answers for the above from this video. The video is done by making a using an example in Malayalam
Data Presentation Using Charts - Part 2
Переглядів 117Рік тому
The Video Depicts how to present the Data in MS Excel using the charts. In the series of charts, in this episode you can learn how to use the Column Chart for a data in multiple columns. It also shows that how to change the design, text colour etc. Very useful when you need to graphically shows the data of same kind for multiple years or days
Data Presentation Using Column Chart 1
Переглядів 136Рік тому
The Video Depicts how to present the Data in MS Excel using the charts. In the series of charts, in this episode you can learn how to use the Column Chart for a simple data. It also shows that how to change the design, text colour etc
Finding Duplicates using Shortcut
Переглядів 2342 роки тому
This video depicts on fining the duplicate values or text using a shortcut. the shortcut used is Conditional formatting by using the new rule. The same is explained in Malayalam with examples in MS Excel
Highlight Cells (Colour/Arrows/Dots) using Shortcut
Переглядів 3392 роки тому
Highlight Cells (Colour/Arrows/Dots) using Shortcut
Shortcut to find the Days to Expiry in MS Excel
Переглядів 1792 роки тому
Shortcut to find the Days to Expiry in MS Excel
How to Find Expiry Date using MS Excel Shortcut
Переглядів 2372 роки тому
How to Find Expiry Date using MS Excel Shortcut
Excel Shortcut for Aligning & Cleanup of Data in a Cell
Переглядів 2782 роки тому
Excel Shortcut for Aligning & Cleanup of Data in a Cell
Combining Data from multiple cells - Concatenate - Excel Shortcuts for Data Analytics
Переглядів 3212 роки тому
Combining Data from multiple cells - Concatenate - Excel Shortcuts for Data Analytics
Find Largest Number - Excel Shortcuts for Data Analytics
Переглядів 3472 роки тому
Find Largest Number - Excel Shortcuts for Data Analytics
Find Length - Excel Shortcuts for Data Analytics
Переглядів 3222 роки тому
Find Length - Excel Shortcuts for Data Analytics
Roundingoff Numbers in Multiples - Excel Shortcuts for Data Analytics
Переглядів 3022 роки тому
Roundingoff Numbers in Multiples - Excel Shortcuts for Data Analytics
ROUNDing OFF DECIMALS - Excel Shortcuts for Data Analytics
Переглядів 2222 роки тому
ROUNDing OFF DECIMALS - Excel Shortcuts for Data Analytics
Find Age using MS Excel (Y/M/D)- Shortcuts for Data Analysis
Переглядів 2333 роки тому
Find Age using MS Excel (Y/M/D)- Shortcuts for Data Analysis
REFORMAT Data - MS Excel Shortcuts for Data Analytics
Переглядів 3163 роки тому
REFORMAT Data - MS Excel Shortcuts for Data Analytics
Rank Formula in Malayalam - Excel Shortcuts for Data Analytics
Переглядів 9933 роки тому
Rank Formula in Malayalam - Excel Shortcuts for Data Analytics
Pay Property Tax Online & Download Ownership Certificate - പ്രോപ്പർട്ടി ടാക്സ് ഓൺലൈനിൽ
Переглядів 4143 роки тому
Pay Property Tax Online & Download Ownership Certificate - പ്രോപ്പർട്ടി ടാക്സ് ഓൺലൈനിൽ
Remove Duplicates - Shortcuts for Data Analytics
Переглядів 1813 роки тому
Remove Duplicates - Shortcuts for Data Analytics
FREEZE the Headings in MS Excel (Malayalam)
Переглядів 5233 роки тому
FREEZE the Headings in MS Excel (Malayalam)
Insert Shapes in MS Excel - Explained in Malayalam
Переглядів 3973 роки тому
Insert Shapes in MS Excel - Explained in Malayalam
Kollam sir
Applicant forml kuttiyude sign /thumb avashyam undo?
👍👍
Explanation very nice🎉
Informative...
Vediyovil sarintte nmbr kooi undaayirunnel nannayirunnu
Can contact me in telegram @sandy615
Sarintte nmbr thrumo
7907099445
👍
Good concepts
👍👍
Super
Thanks
🎉
👍👍
Very useful. Explained very clearly and in a simple way. Thank you so much for making these videos.
Glad it was helpful! Thanks
Thanks this video is very usefull
Glad it was helpful!
Helpful 👍
Very useful🙏
Thanks a lot
Very helpful 👍👍👍👍👍👍
Glad to hear that
informative
Thank You
Helpful👍
Glad to hear that
Good video 👍🏻
Thanks 👍
Very useful vide thank you so much
Glad it was helpful!
Informative 👍
Thanks 🙂
👍👍
Very informative😊
Thanks. Table nte ullil merge cheyth type cheyyunna video undo?
Yes You can watch this link ua-cam.com/video/WYZPz8fBqmg/v-deo.html
@@sandhuexcel Thanks
Sir
Yes dude
Informative...
Great explanation 👍
👍
എന്റെ 3വയസായ മോൾക്ക് പാസ്പോട്ട് എടുക്കണം എന്റെ പാസ്പോട്ട് 20വർഷം സ്പയർ ആണ് പുതുക്കീട്ടില്ല എന്റെ പാസ്പോട്ട് പുതുക്കാതെ മോൾക് പാസ്പോട്ട് കിട്ടുമോ
Yes. Parentsinte address proof mathi. Passport venam ennilla
Super one
Super class
Super
👍🏻
Good knowledge sharing video
Good
Select cheytha table print edukunath engane anu
Ctrl + P
Father te address and baby birth certificate different ayyal problem undo
No
കുറെയേറെ നാളുകൾ ആയി അന്വേഷിച്ച് നടന്ന ഒരു സംഭവം ശ്രദ്ധയിൽ പെട്ടു. നന്ദി.
Good one
Informative
👍
👍
Sir Minor passport puthukan adhar card avashyamundo
Old Passport and other documents of current address either minors (if he has it then better)
Thank you
👍🏻👍🏻
വളരെ മികച്ച അവതരണം..... Thk u so much👍👍
No sound
Very nice video and useful