标签:Excel
-
5 Practical Excel Functions to Improve Your Working Efficiency
Microsoft Excel is a widely used office software which you must have tried or at least heard in life. It’s convenient, powerful and also complicated for some newbies since there seems to be too much to learn. They may end up doing repetitive work manually without knowing how to use Excel formulas to complete their […]
-
How to Turn Off Auto Save in Microsoft Excel
Auto save is a convenient feature in Microsoft Office programs to avoid unexpected data loss. With it, you can find the edited file back even if you didn’t save it before accidents like power outages and computer breakdowns occurring. But there’re also downsides – it may cause lags sometimes especially when the configuration of your […]
-
How to Change the Default Saving Format of Microsoft Excel
When you create a new Excel file and want to save it for the first time, it can’t be saved directly but requires you to choose the location and format for saving. If you don’t have any special need to meet, you can let the format stay as default, which is Excel Workbook (*.xlsx), of […]
-
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” […]
-
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 […]
-
How to Capitalize the First Letter in Microsoft Excel
When working with Excel, sometimes the data may not be very consistent when it comes to upper and lower case letters. But do you know how to capitalize the first letter? The method is also simple. Enter all data and select the first row of which you want to capitalize. Next, find Formulas tab, click […]
-
How to Copy Excel Tables of Charts as Pictures
People who often works with Excel may have the requirement to display tables or charts to others on different devices. Using screenshots seems like a good idea but the captured pictures are usually not that clear. I can’t stop wondering, is there any way to copy tables or charts in Excel as pictures directly. In […]