归档: 2019 October 14
-
How to Calculate the Absolute Value with ABS Function in Excel
Calculating the absolute value is very common in Excel data processing. To fulfil the task quickly and accurately, you don’t need to do the operations by your own. Just make use of ABS function, you can get the absolute values of a batch of data in seconds. 1. Create a new column to output the […]
-
How to Batch Delete Blank Cells in Excel
What would you do if you find some unwanted blanks in Excel sheet? Deleting them one by one is obviously a waste of time. Is there any quick way to remove all the blank cells at once? Well, the Go To feature of Excel may help you. 1. First of all, select the whole sheet. […]
-
How to Insert Hyperlinks in PowerPoint Presentation
When editing presentation with PowerPoint, sometimes you might need to link specified contents with others, such as pictures, videos or even web pages. It could be done very conveniently with the hyperlinks feature of MS PPT. Here I’ll share the method to insert hyperlinks in PowerPoint presentation. 1. Enter the text in the slide which […]
-
How to Create a Lined Paper Template in Microsoft Word
If you want to create a lined paper in Microsoft Word and print it out for some special requirements, you actually don’t need to download the template from Internet or draw the line by yourself. Just imagine the lined paper is a one-column table without vertical borders, the method is quite self-explanatory now. 1. First, […]
-
How to Add a Watermark to All Slides in PowerPoint
You can protect the PPT content from unauthorized copying by adding a watermark to all slides. The smartest way to achieve it is to use Slide Master, and in this post, I will share the detailed steps. Just have a look and make your PowerPoint presentation more professional. 1. Go to View tab, find Master […]
-
How to Add a Bookmark to Mark the Specific Place in Word Document
If you are viewing a long Word document which can’t be read completely at once, adding a bookmark can be as helpful as a real bookmark in life. Let’s see how to use the feature in Word 2016. 1. Open a document in Word, put your cursor at the place you want to make a […]