Shulou(Shulou.com)05/31 Report--

This article is to share with you what are the tips for using Excel. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

1. One click to set the drop-down menu

If the drop-down menu is used well, the efficiency will be improved in seconds! So how do you set the drop-down menu?

First select the cell, then click "data", select "data validation", select "sequence", then select the data source of the drop-down menu, and then click "OK".

Second, rapid calculation of data tables

Data tables are the most common operations in dealing with Excel data, so do you know how to calculate data tables?

In fact, the datasheet is calculated as follows:

First click "Analysis" in the menu bar, then click "calculate", click "Fields, items and sets", click "calculate Fields", and then enter the name in the pop-up "insert calculation Field" and add the formula.

Third, quickly insert the mini-image

Do not want your table data to be too monotonous, then you can use mini graphs to make your forms fuller and more interesting.

The setting of the mini image is also very simple, first select the corresponding data, then click "insert" in the menu bar, click "Mini", select the style of the mini image, such as the broken line mini image, and then set the [location range].

Fourth, quickly extract non-duplicated data

In the daily Excel office, one of the common operations is to check the data to see if there is any repetition in the tabular data. If you can only check and check one by one, you won't be able to finish it until tomorrow.

In fact, the simpler operation is as follows:

First select all the table data, then click "data", then click "Advanced" in "filter" to enter the "Advanced filter dialog box", then check "copy the filter results to other locations", then select the location of "copy to], and check" Select non-duplicated records ".

Change the date format quickly

In many cases, you need to change the wrong date format to the correct date format, or change one date format to another. You can actually do this:

Select all date areas, then right-click "format cells", then click "Custom", and enter [yyyy-mm-dd] in the border bar below "Type".

6. Apply Excel template flexibly

In addition, we can also apply some Excel templates to better improve efficiency and save time. After all, if we make our own Excel form, it sometimes takes a lot of time, and there is no guarantee that it is perfect.

Thank you for reading! This is the end of this article on "what are the tips for using Excel?". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.