![]() ![]() Using this function, we can enter values between 1 and 0. But what to do if we want to enter random fraction values? Then, we can use the RAND function. We can enter random values with the RANDBETWEEN function. But remember that the index should be unique like passport number or roll number. But Index-Match future will find and get you the desired information instantly. It will seem, like searching for a drop of blood in an ocean. If you want to find a particular data, you may feel hard. Index-Match future comes in handy when you have to handle a massive database with vast data. Now you can customize your pasting too! 9. It is also a time-saving feature because you don’t have to erase all the unwanted texts. In such situations, you can use Paste Special feature. Sometimes you may not want to copy all of them. But sometimes, you may copy formulae, values, and comments. When we started to use the copy and paste option, we didn’t have to type everything. Next, click, hold, extend, and drag to fill the values automatically till your desired cell. Now select those two cells from top to bottom. Fill your data in the first two cells (let us consider A1 and A2, for example). You don’t have to enter them in each cell. You can fill the weekdays from Sunday to Saturday in a fraction of a second. You can save a lot of time with this feature. With this feature, you can fill the data in series. Auto-FillĪuto-fill is a simple but useful feature in Excel. After enabling the feature, you can see a new spreadsheet with different fields. Now click on tables and then pivot tables. To enable this feature, select the table and click on insert. And also, ensure that there are no blank rows. With this feature, you can make the first row includes a heading and remaining rows to contain values. If you want to create a table that is clear to understand, you can use the pivot table feature. Pivot TablesĪnalyzing the data in Excel is quite interesting. Now select the protection tactics with which you are comfortable. To enable this feature, click on the file and then click ‘protect workbook’. After enabling this feature, no one can open your document without the password. #Top 10 microsoft excel functions passwordIf you are worried about unauthorized access, you can use password protection to ensure your safety. You may have some private data that you want to keep secured. You can perform certain operations without touching the mouse in a fraction of a second. Now it is easier to access the data when you know the shortcut keys. Shortcut KeysĮxcel has made it easy to analyze data. You can finish this within a fraction of a second. With this feature, you don’t have to waste time guessing the numbers. The first one is the least number you are going to insert into your sheet, and the second one is the largest number. One of them is “RANDBETWEEN.” You can use this function to insert random numbers into the sheet. ![]() You can find plenty of unique features and functions in Excel. Tadaa! The sum is displayed automatically. Select the cell of which you want to find the sum, and press the shortcut Alt+=. ![]() MS Excel has a cool feature to find the sum easily. Be relaxed! Don’t search for a Calculator or pen and paper to perform addition. You may have to enter a list of numbers in a column and find the sum. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |