Excel is a tool that is widely applied by the excel experts in preparing spreadsheets, as the excel features graphics, calculation, pivot tables and a programming language. All these features helps in making the spreadsheet look special; it also saves time of the experts preparing spreadsheet. Here are few special things that you as an expert can do within seconds to make your work extraordinary.
1. You can change the shape and the color of the cell by selecting the auto change option present in the draw menu on the left corner of your screen. You can also add on a smiley or other funny character using the option.
2. In a data if the excel experts have some unique items, and then in order to filter those unique items, you need to select the data and then from the filter tool select the advance filter option.
3. The sort option in the data sort menu enables you to maintain the normal top to bottom flow of your spreadsheet, instead of left to right.
4. You can also hide the grid lines from you spreadsheet, by opening the option dialog box in the tool menu. Once the dialog box is opened, uncheck the grid lines option so that the grid lines present in your worksheet is removed. In case excel experts want the color of the grid to be changed, then he needs to select the needful option from the same dialog box.
5. A border around the spreadsheet will make it look beautiful, this is the reason that the experts add border to their work. To add border you can just right click on the chart and select the format chart option from the dialog box. From the format chart options select the kind of border you require. You can also add effects if required to your spreadsheet from the same dialog box.
6. If the excel experts need to repeat rows or show header then they need to hit menu option and select file. Then from the page setup dialog box select the last tab and specify rows to repeat.
7. Formatting the spreadsheet in very easy in excel, this can be done by you in just one click. All you need to do is to go to the menu, select edit, clear and all. This will remove all the formatting from selected cell range.
8. Adding a long data is very easy, for doing this, select the bunch of numbers in different cells and then click on the sigma symbol on the standard tool bar. You can also use alt and = keys from the keyboard.
Excel experts also calculate the total number of working days easily with the help of excel. Moreover, you can also collect live stock quotes by typing the stock symbol in the cell and then press alt+ to open the research pane. Along with the live quotes of the stock you can also collect all the information about the company.
1. You can change the shape and the color of the cell by selecting the auto change option present in the draw menu on the left corner of your screen. You can also add on a smiley or other funny character using the option.
2. In a data if the excel experts have some unique items, and then in order to filter those unique items, you need to select the data and then from the filter tool select the advance filter option.
3. The sort option in the data sort menu enables you to maintain the normal top to bottom flow of your spreadsheet, instead of left to right.
4. You can also hide the grid lines from you spreadsheet, by opening the option dialog box in the tool menu. Once the dialog box is opened, uncheck the grid lines option so that the grid lines present in your worksheet is removed. In case excel experts want the color of the grid to be changed, then he needs to select the needful option from the same dialog box.
5. A border around the spreadsheet will make it look beautiful, this is the reason that the experts add border to their work. To add border you can just right click on the chart and select the format chart option from the dialog box. From the format chart options select the kind of border you require. You can also add effects if required to your spreadsheet from the same dialog box.
6. If the excel experts need to repeat rows or show header then they need to hit menu option and select file. Then from the page setup dialog box select the last tab and specify rows to repeat.
7. Formatting the spreadsheet in very easy in excel, this can be done by you in just one click. All you need to do is to go to the menu, select edit, clear and all. This will remove all the formatting from selected cell range.
8. Adding a long data is very easy, for doing this, select the bunch of numbers in different cells and then click on the sigma symbol on the standard tool bar. You can also use alt and = keys from the keyboard.
Excel experts also calculate the total number of working days easily with the help of excel. Moreover, you can also collect live stock quotes by typing the stock symbol in the cell and then press alt+ to open the research pane. Along with the live quotes of the stock you can also collect all the information about the company.
ليست هناك تعليقات:
إرسال تعليق