归档： 2019 August 14
-
How to Use VLOOKUP Function in Microsoft Excel to Find the Specified Data
VLOOKUP is a very useful Excel function which can easily search through a column and find the corresponding data. For example, you can search for the score of a student in class quickly according to his or her name. The basic formula for VLOOKUP is: =VLOOKUP (lookup_value,table_array,col_index_num,range_lookup) “lookup_value” refers to the keyword for searching; “table_array” […]
-
Tip to Quickly Insert Different Types of Lines in Microsoft Word
Some of you are probably only familiar with how to insert straight line, here I’d like to give a simple guide of inserting other lines, such as double straight line, wavy line, imaginary line and three straight line. 1. Straight Line Enter “-” for three times and press Enter 2. Double Straight Line Enter “=” […]
-
How to Merge the Content in Different Cells Using Excel Function
Usually we insert different kinds of data (like number and text) into different Excel columns for better recording the information and doing calculations. But sometimes we may also need to merge the content from different cells in an existing table. If there isn’t a large amount of data for us to process in the table, […]
-
How to Change the Default Font of Excel 2019
Every time you open an Excel file, the font will turn back to the default setting even if you’ve changed it for tons of times in previous file. To fit your taste more, you can change the default font of Excel actually. Click File tab on the top-left corner. Click Options in the left sidebar. […]
-
How to Change the Theme Color of Microsoft Office
For many office workers, processing data and editing documents with Microsoft Office tools is not a temporary task but daily routine. No matter what are we working with, Word, Excel, PPT or Outlook, the interface layout and color schemes are all similar to some degree. Looking at them for a long time can be very […]
-
Top 10 Microsoft Office Shortcuts in Apps for Editing Text
We often use Microsoft Office tools to edit text, such as Excel, Word and PPT. You can naturally associate these tools with the use of shortcuts. But even working for ten years, some of you may still use Ctrl+C & Ctrl+V only in daily work. Here I’ d like to share 10 useful shortcuts for […]
-
Top 10 Windows Keyboard Shortcuts to Start High Efficient Work
Nowadays, it is hard to work without computers, and we all know that using shortcuts will improve the efficiency and accuracy of our work. There are a lot of useful windows keyboard shortcuts to explore and here are some basic ones to share. 1. Win + D: Show desktop 2. Win + L: Lock desktop […]
