- Видео 194
- Просмотров 1 667 699
Rath Point
Индия
Добавлен 16 сен 2017
Rath Point's Official RUclips Channel.
In Rath Point, watch MS Office Tutorial videos. SUBSCRIBE Rath Point, Like, Share and click on bell icon to get notifications for new videos to improve your MS Office skills.
We are updating the MS Office tutorial videos from time to time with more valuable contents, to improve your knowledge.
Please feel free to COMMENT on videos which will motivate us to add more videos for you.
MS Office is so much important now a days and you must learn it.
Thanks for watching in Rath Point RUclips channel.
Have a Great Day and Stay Safe.
#RathPoint
In Rath Point, watch MS Office Tutorial videos. SUBSCRIBE Rath Point, Like, Share and click on bell icon to get notifications for new videos to improve your MS Office skills.
We are updating the MS Office tutorial videos from time to time with more valuable contents, to improve your knowledge.
Please feel free to COMMENT on videos which will motivate us to add more videos for you.
MS Office is so much important now a days and you must learn it.
Thanks for watching in Rath Point RUclips channel.
Have a Great Day and Stay Safe.
#RathPoint
How to Paste Data in Reverse Order in Excel
In this video, I’ll show you how to paste data in reverse order in Excel.
Learn to copy and paste data in reverse order in Excel with easy steps. After watching this video, you can reverse the order of data such as text, value or numbers in Microsoft Excel. It will make the data upside down or flip vertically withing the column in the Excel spreadsheet.
Subscribe for more tutorial videos:
www.youtube.com/@rathpoint/?sub_confirmation=1
00:00 Introduction
00:22 How to Reverse Data in a Column
00:46 How to Flip Data within the Row
Below questions will be answered:
How to paste value in reverse order in Excel?
How to reverse the order of data in Excel?
How do I paste data upside down in Excel?
How do I ...
Learn to copy and paste data in reverse order in Excel with easy steps. After watching this video, you can reverse the order of data such as text, value or numbers in Microsoft Excel. It will make the data upside down or flip vertically withing the column in the Excel spreadsheet.
Subscribe for more tutorial videos:
www.youtube.com/@rathpoint/?sub_confirmation=1
00:00 Introduction
00:22 How to Reverse Data in a Column
00:46 How to Flip Data within the Row
Below questions will be answered:
How to paste value in reverse order in Excel?
How to reverse the order of data in Excel?
How do I paste data upside down in Excel?
How do I ...
Просмотров: 73
Видео
How to Remove Blank Rows in Excel Shortcut
Просмотров 81День назад
In this video, I'll show you how to remove blank rows in Excel shortcut keys. Learn how to remove blank rows in Excel shortcut keys with easy steps. If you have multiple blank rows in Excel, then its time consuming to select and delete then one by one. In this tutorial video, I’ll show you how to remove all blank rows in Excel at once with keyboard shortcut keys. After watching this video, you ...
How to Unhide Excel Workbook
Просмотров 10814 дней назад
In this video, I’ll show you how to unhide Excel workbook. Learn how to unhide Excel workbook accidentally hidden. You can easily unhide workbook in Excel after watching this tutorial video. Sometimes you can find that the entire Excel file is hidden when opened. In this video, I will explain how to unhide an entire Excel file step-by-step. Subscribe for more tutorial videos: www.youtube.com/@r...
How to SUM by Cell Colour in Excel without VBA
Просмотров 25521 день назад
In this video, I’ll show how to SUM by cell colour in Excel without VBA. rathpoint.com/how-to-sum-by-cell-colour-in-excel-without-vba You can also COUNT cells based on the background fill colour of the cell without using VBA in Office 365, Excel 2021, Excel 2019 and Excel 2016. Similarly, you can use IF, IFS, SUMIF, SUMIFS, COUNIFS, SUBTOTAL, AGGREGATE, AVERAGE and other Microsoft Excel functio...
How to Make an Excel File Read Only after Opening
Просмотров 237Месяц назад
In this video, I’ll show you how to make an Excel file read only after opening. Learn to make an Excel file read only after opening with step-by-step procedures: rathpoint.com/how-to-make-an-excel-file-read-only-after-opening/ You can also remove read only from an Excel file easily after watching this tutorial video. If you have made any changes after making the file read only then you will get...
How to Fix #VALUE! Error in SUMPRODUCT Function
Просмотров 4073 месяца назад
In this video, I’ll show you how to fix #VALUE! error in SUMPRODUCT function. Learn why SUMPRODUCT formula not working and what are the solutions to correct it. Visit website to learn how to use SUMPRODUCT Formula in Excel with Examples: rathpoint.com/sumproduct-formula-in-excel/ Subscribe for more tutorial videos: www.youtube.com/@rathpoint/?sub_confirmation=1 The syntax of Excel SUMPRODUCT fu...
How to create Pivot Table from Multiple Sheets in Excel
Просмотров 16 тыс.10 месяцев назад
In this video, I'll show how to create pivot table from multiple sheets in Excel. The pivot table from multiple sheets in Excel with same columns or different columns, can be done easily. After watching this tutorial video, you can easily create one pivot table from 2 sheets, 3 sheets, 4 sheets or more in Excel. Creating a PivotTable in Excel from multiple worksheets or workbooks is possible by...
How to Insert Checkbox in Excel
Просмотров 7 тыс.11 месяцев назад
In this video, learn how to insert checkbox in Excel. rathpoint.com/how-to-insert-checkbox-in-excel/ You can insert, edit and format multiple checkboxes in Microsoft Excel cell. Then you can click the Excel checkbox to tick and untick it. If you cannot insert a checkbox without the developer tab, then first you need to add the developer tab in Microsoft Excel. Subscribe Rath Point: www.youtube....
How to Remove Saved to this PC in Title Bar
Просмотров 72 тыс.Год назад
In this video, I’ll show you how to remove “Saved to this PC” in title bar of Microsoft Word, Excel and PowerPoint. You might have noticed “Saved to this PC” in title bar after saving a Word document, Excel spreadsheet or PowerPoint slide. To get rid of “Saved to this PC” in title bar after file name, follow the steps mentioned in this tutorial video. Subscribe Rath Point: www.youtube.com/@Rath...
How to Count Uppercase or Lowercase Letters in Excel
Просмотров 3,5 тыс.Год назад
How to Count Uppercase or Lowercase Letters in Excel
How to Automatically Add Serial Numbers in Excel
Просмотров 35 тыс.Год назад
How to Automatically Add Serial Numbers in Excel
How to fix Arrow Keys Not Moving Cells in Excel
Просмотров 91 тыс.2 года назад
How to fix Arrow Keys Not Moving Cells in Excel
How to Share Excel Workbook with Multiple Users
Просмотров 127 тыс.2 года назад
How to Share Excel Workbook with Multiple Users
How to Convert Month Number to Month Name in Excel
Просмотров 11 тыс.2 года назад
How to Convert Month Number to Month Name in Excel
How to keep column index number in VLOOKUP automatically
Просмотров 10 тыс.2 года назад
How to keep column index number in VLOOKUP automatically
How to Change Default Currency in Excel
Просмотров 2,5 тыс.2 года назад
How to Change Default Currency in Excel
Combine Multiple Excel Workbooks into One
Просмотров 2,1 тыс.2 года назад
Combine Multiple Excel Workbooks into One
How to convert PDF to Excel without losing formatting
Просмотров 3,2 тыс.2 года назад
How to convert PDF to Excel without losing formatting
How to Edit PDF File in Laptop for Free
Просмотров 9462 года назад
How to Edit PDF File in Laptop for Free
How to password protect PDF file Free
Просмотров 4482 года назад
How to password protect PDF file Free
How to use ACCRINT Function in Excel
Просмотров 1,9 тыс.2 года назад
How to use ACCRINT Function in Excel
very informative
Thanks 😊
Thank you
Welcome 😊
شكرا 👍
Welcome 😊
Thanks so much, good sir!
Welcome 😊
Great
Thanks 😊
Thank you ❤
Welcome 😊
Thank you so much
Welcome 😊
Nice
Thanks 😊
Thank you for the quick guidance. It's really helpful.
Welcome 😊
Very useful, why so few people watched this video? Well done.
Thanks 😊
Thanks a lot, it helped to resolve an issue
I am glad that it helped you. Thanks for your comment.
very helpful
Thanks 😊
thankyou Sr i subscribed
Welcome 😊
Hi brother, I am asking again this question , How to insret page number orders for multiple worksheets one execel file
I will make a video and will let you know the steps, so that it will be easy for you. Thanks
Please explain, my Documents are multiple work sheet how to do insert page numbers orde for those,
Keep your sheets in order. Then insert page number. The starting page number you can manually update if it's not reflecting correctly.
sir ap video editing app konsa use kar rahy ho
There are many free apps, imovie in macOS is also free.
@@rathpoint sum based on color and sign of interrogation, how it will in Capcut
I am not sure about Capcut.
Nice one
Thanks 😊
Music is damn low, please next time put more louder 👍🏽 useless
Sure, Thanks for your suggestion 😊
Thanks it worked for me
Welcome 😊
thanks
Welcome 😊
Thank you so much sir Subscribed ❤ I was looking for shortcuts which actually works . Thank you once again sir❤
You're welcome 😊
Hi, your video helped. When I did the search for 'keyboard' it didn't bring up the onscreen keyboard... I then typed in 'onscreen' and the search bar brought up onscreen keyboard and I was able to click off the scroll lock! Thanks
I am glad that it helped you. Thanks for your comment ☺️
If we share it in whatsapp group, than can the people in the group change it or edit it from mobile
Excel mobile version is always with limited features. Full features are available only in Windows or Mac version.
thanks boss, useful information.
Welcome 😊
To be honest, this is not really useful. I put formatting, formula and other for a purpose. Removing it will not help. You should speak about other options such as Power Query or alternatives.
Let me know the issue clearly, so that I can provide the solution.
MY MAN !! nice =CHOOSE(LEFT(TEXT(A1,"000000000.00"))+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine") &IF(--LEFT(TEXT(A1,"000000000.00"))=0,,IF(AND(--MID(TEXT(A1,"000000000.00"),2,1)=0,--MID(TEXT(A1,"000000000.00"),3,1)=0)," Hundred"," Hundred and ")) &CHOOSE(MID(TEXT(A1,"000000000.00"),2,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ") &IF(--MID(TEXT(A1,"000000000.00"),2,1)<>1,CHOOSE(MID(TEXT(A1,"000000000.00"),3,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine"), CHOOSE(MID(TEXT(A1,"000000000.00"),3,1)+1,"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen")) &IF((--LEFT(TEXT(A1,"000000000.00"))+MID(TEXT(A1,"000000000.00"),2,1)+MID(TEXT(A1,"000000000.00"),3,1))=0,,IF(AND((--MID(TEXT(A1,"000000000.00"),4,1)+MID(TEXT(A1,"000000000.00"),5,1)+MID(TEXT(A1,"000000000.00"),6,1)+MID(TEXT(A1,"000000000.00"),7,1))=0,(--MID(TEXT(A1,"000000000.00"),8,1)+RIGHT(TEXT(A1,"000000000.00")))>0)," Million and "," Million ")) &CHOOSE(MID(TEXT(A1,"000000000.00"),4,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine") &IF(--MID(TEXT(A1,"000000000.00"),4,1)=0,,IF(AND(--MID(TEXT(A1,"000000000.00"),5,1)=0,--MID(TEXT(A1,"000000000.00"),6,1)=0)," Hundred"," Hundred and")) &CHOOSE(MID(TEXT(A1,"000000000.00"),5,1)+1,,," Twenty"," Thirty"," Forty"," Fifty"," Sixty"," Seventy"," Eighty"," Ninety") &IF(--MID(TEXT(A1,"000000000.00"),5,1)<>1,CHOOSE(MID(TEXT(A1,"000000000.00"),6,1)+1,," One"," Two"," Three"," Four"," Five"," Six"," Seven"," Eight"," Nine"),CHOOSE(MID(TEXT(A1,"000000000.00"),6,1)+1," Ten"," Eleven"," Twelve"," Thirteen"," Fourteen"," Fifteen"," Sixteen"," Seventeen"," Eighteen"," Nineteen")) &IF((--MID(TEXT(A1,"000000000.00"),4,1)+MID(TEXT(A1,"000000000.00"),5,1)+MID(TEXT(A1,"000000000.00"),6,1))=0,,IF(OR((--MID(TEXT(A1,"000000000.00"),7,1)+MID(TEXT(A1,"000000000.00"),8,1)+MID(TEXT(A1,"000000000.00"),9,1))=0,--MID(TEXT(A1,"000000000.00"),7,1)<>0)," Thousand "," Thousand and ")) &CHOOSE(MID(TEXT(A1,"000000000.00"),7,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine") &IF(--MID(TEXT(A1,"000000000.00"),7,1)=0,,IF(AND(--MID(TEXT(A1,"000000000.00"),8,1)=0,--MID(TEXT(A1,"000000000.00"),9,1)=0)," Hundred "," Hundred and "))& CHOOSE(MID(TEXT(A1,"000000000.00"),8,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ") &IF(--MID(TEXT(A1,"000000000.00"),8,1)<>1,CHOOSE(MID(TEXT(A1,"000000000.00"),9,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine"),CHOOSE(MID(TEXT(A1,"000000000.00"),9,1)+1,"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"))
Thank u so much
Welcome 😊
Pls share formula to highlight cells having small alphabets/ letters
First, use the formula mentioned in this video to count lowercase. Then use conditional formatting with IF >0 and give color to highlight. Hope you got it.
@@rathpointsir, I want to highlight small letters in the whole sheet, not in a single column? Is this possible
Yes, include formula in conditional formatting.
Thnx bru
Welcome 😊
U solve my problem.i search 2.5 hour continuously RUclips videos
I am glad that it helped you. Thanks for your comment.
Good infm❤
Thanks 😊
Help
Hope it helped you.
I tried the formula but it still give an error.
Please help
Let me know your formula.
Did you get the video clip?
thanks bro
Welcome
Thank you so much ❤
Welcome 😊
Thank You so much bro❤
Welcome 🙏
Thank you 🙏
Welcome 🙏
Thank you....... Useful
Welcome 😊
Excellent, thank you.
Welcome.
You really help a lot, thank you so much👍
Welcome 😊
Can we use if function instead minus please show me how to do it ,and show how to compare number and text combination to get if function For example if coloumn C4 contione 500 and D4 contains true word I should get valid text in E5
Instead of multiple IF functions, use IFS function. Check the short video: ruclips.net/user/shortsHuweiCz97kg?feature=share
Very helpful! Thank you
Welcome 😊
😊 thanks
Welcome 😊
Thank you very much, this help me much, love u
Welcome 😊
Super
Thanks 😊
Thank you so much for this.
Welcome 😊
🙏
🙏
Thanks
Welcome 😊
Thank you so much meri problem solved ho gai bhai😊
I am glad that it solved your problem. Thanks for your comment ☺️
wow thank u so much
Welcome 😊
If I use number 852000 it shows as eight hundred fifty two thousand instead of eight laks fifty two thousand
You can replace the text lakhs with thousand.