归档： 2019 September 23
-
How to Highlight All the Nonworking Days in Excel Spreadsheet
If you entered a series of dates into Excel spreadsheet, and want to highlight all the nonworking days. Do you have to pick out the weekends manually? In my previous post, I’ve introduced some uses of the powerful Conditional Formatting. It enables you to apply a format to multiple cells that meet the specific criteria. […]
-
How to Use Smart Guides to Align Images in MS PowerPoint
Inserting several images in one single slide of PowerPoint requires you to aligne them well, otherwise the layout will look messy. But it is difficult to estimate the distance between images with naked eyes, and if there are lot of pictures to be aligned, arranging them could be very time-consuming. In this case, using Smart […]
-
How to Insert or Delete a Sound in PowerPoint Presentation
Perhaps you have learned a lot tricks about how to create an attractive PowerPoints slide show, but besides all functions in the Ribbon, inserting a sound in the document will results in a better presentation. A double sensory experience of sight and hearing will definitely leave a stronger impression. So how can we achieve it? […]
-
How to Customize and Unify the Date Format in Excel Quickly
It’s quite troublesome to enter dates into Excel Spreadsheet with a canonical format manually. But if you don’t unify the format, it will affect the operation with formulas in the sheet. Therefore, I’d like to introduce 2 ways to unify the entered data and display them as the customized format. Method 1: Using Format Cells to […]
