归档： Cordelia
-
How to Create a Barcode in MS Excel and Word
When you buy something in a supermarket, you must notice that there’s a barcode on the back of each product. By identifying the barcode, you can get a lot of information such as the manufacturer, name, date, price and so on. Barcodes are now widely used to identify all kinds of information of a wide […]
-
How to Set the Header or Footer as the Chapter Title in Word
When you are editing a document with many chapters, a header or footer with the title of each chapter can indicate your location in the document and also the content of the current page. It’s very common in practice, but can also be troublesome if you intend to do it manually. So, is there a […]
-
5 Cases to Use Microsoft Excel IF Function in Practice
IF function, also known as conditional function, enables you to get corresponding results in Microsoft Excel spreadsheets when meeting the specific conditions. How Does IF Function Work The function syntax of IF function is: IF(logical_test,[value_if_true],[value_if_false]). If the specified conditions evaluate to true, this function will return a value; If the specified conditions evaluate to false, […]
-
5 Tips to Help You Wake Up and Sober Up in the Morning
It’s no secret that waking up early is good for your health, but today’s office workers are often plagued with the problem of getting up in the morning. Do you have the experience of lying in bed after the alarm goes off and being late for work, or finally getting up in time with a […]
-
How to Print a Worksheet in Excel With Gridlines
When you print a worksheet in Excel, the gridlines will not be printed out together by default. Even if you manually add borders to the spreadsheet, the area outside of it will still be pure blank. So if you want to print a worksheet with gridlines in the selected area, you need to make some […]
-
How to Print an Excel Worksheet on Center of a Page
In general, if the worksheet you want to print doesn’t take up a full page, it will be automatically placed on the upper-left corner of the page (like the picture below), which won’t look good apparently. The better way is to center the worksheet you want to print on the page. Switch to Page Layout […]
-
How to Add Text on Top of A picture in Excel
You may insert pictures to Excel spreadsheets a lot and have been already familiar with the steps. But out of the need for designing or processing data, it has a chance to require you to add text on top a picture. Here’s a simple guide to achieve this goal. Click Insert – Pictures and select […]
-
How to Remove the Odor and Fresh the Air in Your Office
For office workers who stay at least 8 hours in the office every day, the freshness of the office air is directly related to their productivity and even health. Some people feel dizzy and hardly cheer up once get to company, the dirty air might be part of the reason. Think about it, most of […]
-
How to Make a Table Header with 2 Slashes in Excel
In addition to a cell with a diagonal line, sometimes you may also need to make a table header with 2 slashes in Excel if there are multiple kinds of data to be organized. It requires you to insert 2 lines in a cell as well as text on each side of the lines. So […]
-
The Quickest Way to Sum columns or rows in Excel Spreadsheet
Among all these ways to calculate the summation in Excel, the fastest way as I think is to use shortcuts. With it, you can even sum multiple columns or rows in seconds. The only thing you need do is selecting the values to sum, and press Ctrl+= on the keyboard. For example, if you want […]
