Shulou(Shulou.com)11/24 Report--

The original title: "more powerful than [Ctrl+E], this super easy to use shortcut key, I do not allow you not to know!" "

Hello, everyone. I'm Xiaolan who loves and kills each other with Excel.

When we analyze the data, there are generally many steps that need to be carried out, such as summarizing data, inserting charts and so on.

If every operation needs to be looked for in the taskbar, it is actually quite troublesome.

▲ non -, regular, tolerance, easy, eye, intimate Excel has already given the solution!

Press [Ctrl+Q] or select the table area to bring up the quick analysis tool

It is convenient for students to analyze and present the data.

How exactly should I use this tool? Let's take a look at one by one.

PS: it can only be used in Office 2013 or above.

1. Format ❶ with [data bars] to make data presentation more intuitive.

❷ uses [levels] to see the size of the data at a glance.

❸ uses [icon set] to make the data rise and fall more intuitively.

❹ uses [greater than] to display numbers greater than a certain number in 1 second.

❺ uses [Top 10] to directly display the numbers in the top 10%.

❻ uses [clear format] and clears the table format with one click.

2. Chart recommendation automatically recommend appropriate charts.

If the recommended chart does not meet the requirements, click "more Chart" to select the appropriate one:

3. Data summary can quickly sum, average, count, summary percentage and so on.

It is important to note that there is a blue one in the icon, which represents a summary of row data:

There is yellow in the icon, which represents the summary of column data:

4. the main function of inserting a table is to quickly insert a table or PivotTable report.

Insert table:

As for its function, it has been made very clear before, so I will not repeat it here. For those of you who want to see it, click on the link below to see it.

Do you know the super watch? "superhero" in Excel! (recommended collection)

Insert a PivotTable report:

To further learn the PivotTable report, click on this link to view:

Must learn! PivotTable 0 basic tutorial is here!

5. Mini charts can be quickly inserted into line charts, column charts, and profit and loss charts.

In this way, you can directly see the changing trend of each row of data, and you can clearly see the highest and lowest points of the data.

When there is a lot of data in the table, it can be messy to use ordinary charts, but not with mini-charts.

6. To sum up the content introduced in this article is relatively simple, mainly to let students learn the usage of [Ctrl+Q] this shortcut key to help you reduce the time wasted on some unnecessary operations.

But the tips in Excel go far beyond what I've introduced today.

For example, a powerful Excel master can process data more efficiently with only one shortcut key, making your work get twice the result with half the effort.

When you get an urgent task at work, what if you don't have time to process the data?

If you Get the Excel way of thinking, even if you use only one shortcut [Ctrl+E], you can quickly get the data 👇.

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Zhu Lan

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.