Categories：Excel Tips
-
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 […]
-
How to Convert Arabic Numerals to Roman Numerals in Microsoft Excel
Luckily we don’t use the Roman numerals much today, a kind of counting way which is really complicated to remember, and some of them look similar but have completely different meanings. Due to the requirement of work, in some cases, Arabic numerals might need to be displayed as Roman numerals, and is there any easy […]
-
How to Count the Non Repeating Data in MS Excel
Sometimes you want to count a long list of data in Excel, but there are many duplicates interfering with your statistics, and you can’t just delete them. At this point, is there a way to get rid of the influence of repeated data and count only the non-repeating data in a column? As the answer […]
-
How to Add the Developer Tab to MS Excel Ribbon
In Microsoft Excel, using some advanced features requires you to enable Develop tab, which is not always shown in the Excel ribbon from the beginning. If you can’t find it, don’t worry, you can still add the Developer tab to the ribbon manually. Please follow the steps below: 1. Open an Excel file and go […]
-
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 […]
-
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, […]
-
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 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 […]
