标签：filter
-
How to Screen Out the Specific Data in Excel
In a large, complex Excel sheet, you can find the data meets your criteria quickly through the powerful function called Filter, while other data that doesn’t meet your need is automatically hidden by Excel. How to screen out the data that equals/larger than/smaller a specified value Using the Filter function, you can screen out all […]
-
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. […]
-
25 Microsoft Excel Tips for Beginners Who Work at Office
For an office worker, it’s very important to grasp some commonly used Excel skills to process the data in a spreadsheet. Only in this way they can save the time to do more constructive work and improve themselves. So, how to use Microsoft Excel smartly to boost the working efficiency? In this post I collected […]
