in the future - u will be able to do some more stuff here,,,!! like pat catgirl- i mean um yeah... for now u can only see others's posts :c
Abbreviation Function In Excel (VBA UDF for Short form | Abbreviation | Acronym)
https://youtu.be/HBXO76Vx14A
1 - 0
How to lock or protect cells after data entry in Excel? | Auto protect cell after edition in Excel
https://youtu.be/zPsUSQ77MsI
In this Excel in Hindi video, you will see how to automatically lock cells after data entry in an Excel sheet.
The range will get automatically protected after doing data entry.
Two examples are shown
- Auto-lock or protect a record range after doing a complete entry
- Auto-protect a cell after doing data entry
1 - 0
Various ways to concatenate text in Excel.
learnyouandme.com/concatenate-and-join-cells-in-ex…
Here this post shares various Excel functions you can use to concatenate cells or text in Excel.
This post also shares how to do concatenation in VBA.
2 - 0
Compare two columns in Excel to find matches and differences – 4 examples
learnyouandme.com/compare-two-columns-in-excel-to-…
Sometimes you may need to compare two or more Excel columns to find the matches and differences.
Here I have discussed various scenarios and respective methods to compare values in Excel columns.
0 - 0
Easy Excel grade formula without IF function | Give grades to marks in Excel
learnyouandme.com/excel-grade-formula-without-if-f…
Say bye to manually giving grades to marks in Excel based on mark range.
Even if you have used nested and complicated IF function for giving a grade, here I will share a very simple and easy way to give grading to marks in Excel without using the IF function.
Using this technique you can expand your grades without complicating the formula.
0 - 0
2 easy ways to extract all comments in Excel to a sheet
learnyouandme.com/2-easy-ways-to-extract-all-comme…
0 - 0
Automatic uppercase in Excel
Here I will show you a solution where entered value will auto-get converted to Uppercase (or in any specified text case) even if your entry is in lowercase or any other text case.
learnyouandme.com/excel-uppercase-to-lowercase-cha…
4 - 0
Top 70 keyboard shortcuts of Excel with illustration
learnyouandme.com/top-keyboard-shortcuts-of-excel-…
Learning Excel is not enough, one should also know keyboard shortcuts for Excel.
Learning Excel shortcut keys not only helps you to become more productive but also will help you acing Excel interview questions.
Here I am sharing the top 70 Microsoft Excel shortcut keys with the illustrative images.
6 - 0
How to filter by bold in Excel?
learnyouandme.com/how-to-filter-by-bold-in-excel/
Sometimes you need to filter cells with bold text in Excel.
But, in Excel, there is no direct way to do this. In this article, you will learn how to filter cells with bold font formatting.
2 - 0
Thanks for Subscribing. Not yet subscribed then Subscribe now and don't forget to click the bell icon.
Knowledge then Application then Empowerment. This channel is to give lessons about IT and Android mobile and Computer of things like Ms Excel, Excel VBA, SQL, Ms Access etc. I hope my channel will help you in gaining skills related to the Computer world.
Websites
🌎learnyouandme.com
🔵Facebook www.facebook.com/LearnYouAndMe
🔴Quora link www.quora.com/profile/Abhishek-Pandey-328