10 Tips to Work with Excel Like A Pro

Comment

Microsoft Excel is a spreadsheet program written by Microsoft for computers using the Windows and Apple Macintosh operating systems. Excel is the most popular personal computer data processing software because of its Intuitive interface, excellent calculation functions, and charting tools.

In our daily work, we need to master many job-matching skills, but even the most basic work requires some Microsoft Excel knowledge to make your work more efficient. Once you learn the basics of Microsoft Excel, it will be easy to make simple charts and to organize your data. With our tips and tricks, you can work with Excel like a pro easily.

1. Display Excel Spreadsheet Formulas

When you open a spreadsheet created by someone else and need to recheck the data, you need to check the spreadsheet formula. You can double-click the cells one by one to see the used formula. But this method is very inconvenient. Now, we will teach you a faster tip.

Open your Excel worksheet then click the "FORMULAS" button which can be found in the upper ribbon. Then click the "Show Formulas" button. To see all the spreadsheet formulas, or you can use "CTRL +" on your keyboard. This will give you a view of all formulas used in the workbook.

Microsoft Excel FORMULAS Show formulas

2. Use VLOOKUP

The "VLOOKUP" function is a vertical lookup function in Excel. It is widely used in work. For example, it can be used to check data and quickly import data between multiple tables. The VLOOKUP function is to search by column, and finally return the value corresponding to the query sequence required by the column.

When you need to find things in a table or a range by row you can use the VLOOKUP function. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID.

Step 1. Click the cell where you want the VLOOKUP formula to be calculated. Then click the "FORMULAS" > "Lookup & Reference" > "VLOOKUP" to use the VLOOKUP tool.

Microsoft Excel FORMULAS Lookup and Reference VLOOKUP

Step 2. Then it will pop up another VLOOKUP sheet where you will specify the cell. In this case, our lookup value is H2 which is where we want to put our product or the name of the tournament first. Once we've set up VLOOKUP properly, Excel will return the tournament's Total Rating Value in cell H3 when we type the tournament name in cell H2. Second, specify the data you want VLOOKUP to use for its search in the "Table_array" box. Third, in the "Col_index_num" box, we need to fill in the column number used to find the relevant data. Finally, we need to enter "FALSE" or "TRUE" in the "Range_lookup" box to specify whether an exact match is required. When you finished, click the "OK" button at the bottom of the popup window.

Microsoft Excel VLOOKUP Function Arguments

Step 3. Finally, enter the value of the data you want to search in the cell.

Microsoft Excel VLOOKUP Enter the Value

3. Freeze Rows and Columns

In Excel, when a table has a large number of records, such as a few hundred rows, it is often used to freeze the rows and columns to make it easier to move the spreadsheet. Next, we will tell you how to freeze rows and columns in Excel quickly.

Click the "VIEW" > "Freeze Panes" to freeze rows and columns. There are 3 kinds of ways to freeze. You can click the corresponding button as you need.

Microsoft Excel View Freeze Panes

4. Combine Data from Different Cells

Do you know how to put different data in different columns or rows and put them in one cell? Use this tip will make your time using the program a little easier. There are many methods for you to combine data from different cells, but here we will introduce the easiest way for you.

First, type "=" and select the first cell you want to combine. Then type "&" and use quotation marks with a space enclosed. At last, select the next cell you want to combine and press enter. Then you will see your data is successfully combined.

Microsoft Excel Combine Data

5. Copy Formulas or Data between Worksheets

When we edit data in Excel, we often use the same data or formula in more than one cell. To improve work efficiency, we often use the method of copying data or formula to obtain the calculation results. Next, we are going to show you a way to copy data or formulas in Excel.

First, you should hold down the "Ctrl" button and click the tab of the worksheet you want to copy to. Then click or navigate to the cell with the formula or data you want. Press "F2" to activate the cell. Finally, press the "Enter" button to copy the data or formulas successfully.

Microsoft Excel Copy Data or Formulas

6. Quickly Select the Contents of an Entire Spreadsheet

Many people will ask if there is any quick way to directly select thousands of records in Excel. Many people will use the mouse to drag and select the whole spreadsheet. But when we have a lot of table data, we will waste a lot of time, and we may start from scratch if we are not careful. So we need to master the skills of quick selection.

It is very easy to use this tip, First, click on the starting row of your spreadsheet. Then press F8 to activate extend. Then click on the final cell in your spreadsheet. Finally, hit F8 again to cancel. You will see your entire spreadsheet is selected quickly.

Microsoft Excel Select an Entire Spreadsheet

7. AutoFill Data

When some newbies use excel, they don't know the "AutoFill" function of Excel. Many novices will manually input one by one directly, but using this method can be very time-consuming. Then we teach you how to use the "AutoFill" function to automate repetitive entries in Excel.

First, enter a series of duplicates in the spreadsheet, such as dates. Move the cursor to the lower right part of the last cell above the square that pops up in each column then click and drag the column down. Then Excel will be smart at guessing what information you want to auto-fill.

Microsoft Excel AutoFill Data

8. Create a Beautiful Table in Seconds

Many people just know how to type the data into the cell, but how to create a beautiful table in seconds like a pro? Do not worry, you can follow these steps to create beautiful tables in seconds.

Select the data you want to make in the table. Click the "INSERT" > "Table" > "OK" to create a new table. You can also use the table icon in the upper right corner to change the color and use the checkboxes under the "Design" tab to change the layout.

Microsoft Excel Design the Table

9. Find the Specific Cell

In our daily work, our Excel worksheet usually contains a lot of data. It is difficult to track everything. This time we can use the "Go To" function in Excel to find the specific cell.

Select the range of data you want to find. On the "Home" tab, click the "Find & Select" > "Go To". Select the corresponding buttons and then click the "OK" button. 

Microsoft Excel Go To Special

10. Use the Format Painter

The "Format Painter" is a tool in Excel. We can use the format painter to quickly apply the formatting of the specified text to other text. This function greatly reduces the time of typesetting.

Select the text or graphic that has the formatting that you want to copy first. Click the "Home" > "Format Painter" to use the tool. Then use the brush to paint over a selection of text or graphics to apply the formatting. This only works once. To change the format of multiple selections in your document, you must first double-click the "Format Painter" tool.

Conclusion

With the above tips and tricks, we believe that you can learn how to use Excel skillfully. These tips won't turn you into an Excel pro overnight. But they can help you to take the first step to become a pro. If you have more Excel tips and tricks, please contact us!

Was this article helpful? Thank you for your feedback!

YES Or NO

Comment

Add File

Add File(s)

Select Tools
Install EasePDF - Free Online PDF Tools Chrome Extension?

No, thanks Install