This topic has been explained in great detail in the video shown below, to learn this topic just play the video and the notes are mentioned below the video.
In excel sometimes you would want that a file should not be opened by anyone right ? To do that you can add a password to open the file in excel and that can be done very very easily all you have to do it in an excel file
1.click on the file option on the top and then
2.click on the protect workbook option and from there
3.choose encrypt with password so when you click on encrypted password it will ask you to enter password of your choice if you ask you to re enter at press ok.
you are done this is so very easy this is how you can add a password in excel to open a workbook now
Once this password is in place nobody will be able to open the workbook without the password, once it is open then they can edit it change it ,whatever they can do but they cannot open it without the password you can also remove the password and is a bit complicated but yes can be done again now to remove password to open the excel file you have to click on file option and choose the Save as option and from the Saveas menu click the tools button at the bottom and from the tools button choose the General options and in General options you will get an option to remove the password simply remove whatever the password is given there and the password password gets removed so that is how to remove a password also
This Excel Crash Course contains the list of topics that cover the most important and used features and formula of Excel .
This Excel Crash Course lists 43 major topics in Excel so that you can start using Excel like a pro in the shortest possible time.
This Excel Shortcuts Complete list is to help you become save time and use Excel like a Master level user. Excel is best used when you know the Keyboard shortcuts because the use of keyboard shortcuts in Excel helps you in completing tasks faster.
I have created a Excel Shortcuts complete list for you to use Excel better, this list has 242 excel keyboard shortcuts which means that it covers almost everything that can be done using shortcuts in Excel.
Now easily convert numbers to Text in Excel with this inbuilt sheet from myelesson.org . Many times we need the amount in figures to be converted into words. This is a typical requirement for writing checks or any other financial reports. Microsoft Excel does not have standard function available for this requirement.
Just download this sheet and then you can convert any number to text in Excel.
Here is the list of most asked excel related questions in interviews. Prepare for this excel questions and you would be able to most of the excel interviews. This list of excel questions covers excel formula, excel analysis, excel reporting, excel charts and more.