Microsoft Office is the perfect productivity suite for Official work. It includes apps like MS Word for creating text document, MS Excel for calculations, MS PowerPoint for making presentation, and MS Outlook for sending and receiving emails etc. This software is useful in both homes as well as for business purpose. It is very easy to use and you can install this software through www.office.com/setup in your device. In this blog, you will learn Microsoft Office tricks which will help you to make your work easier and faster. These tricks will increase the productivity of your organizations to a great extent.
What are the tricks of MS Office to increase Productivity?
- Recovering Lost Text:
When you create a text document, you must have faced the problem of data loss and corrupted files. But you can recover these lost text documents by just going to the File menu and then go to Open option. Now you have to select the corrupted or damaged file and then just select the Recover Text from Any File. This command is there in the drop down menu File type list. All text will be recovered but you cannot be able to recover image files. source
- Learn About Spike:
If you wanted to copy or move the information from multiple locations to one location in the document, then you should use Spike. In this you just have to copy or select the text from different location and paste it to a new location. For this, you have to select the text and then press Ctrl+F3. This will move the data to Spike. Now, just place the cursor at the desired location and then press Ctrl+Shift+F3. This will move the text completely. You can press CTRL+Z for Undo immediately, if you do not want to move the text.
- Pivot Tables:
This helps to analyze a large datasets without using a formula. For this, you have to go to Insert option and then go to Pivot-table. Now, just select the datasets which you want to analyze and then just click on OK button. By this way, you can generate the report easily.
- Conditional Formatting:
This tool is very useful in presentation; you can highlight certain the data set. If you want to draw their attention to values then highlight it. You can do this by clicking on the Home and conditional Formatting. this link
- Insert Slides from Other Slides:
You can insert slides from other files from prepared presentations by just using clicking on Insert option and then select Slides from Files.
For more details, you can visit to the official site of MS Office via office.com/setup. For customer help, you can call the customer care executive any time on their toll free number.