标签:Excel
-
How to Start Microsoft Word/Excel/PPT in Safe Mode
Safe mode is a kind of protection mechanism of Microsoft Office. When you open or close these documents in a wrong way or just install some plug-ins to them, Office applications may fail to work. At this point, you can still start Word, Excel, PowerPoint, etc. normally in safe mode. To make use of safe […]
-
How to Use AutoFill in Excel to Quick Enter a Series of Data
Microsoft Excel is a particular powerful tool. When you make use of it, there are lots of tips can help you process the data automatically. For example, if you want to enter a series of data or a line of increasing numbers into a spreadsheet, you don’t need to type them one by one manually. […]
-
How to Unify the Date Format in Microsoft Excel
To record a set of data in Microsoft Excel, you probably don’t think much about the format at the beginning. The data like dates can be entered in Excel with different formats by yourself or several different people. But things change, now you want to rearrange the dates in the spreadsheet. At this point, how […]
-
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 […]
-
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 […]