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

Excel has a very easy to use shortcut key "Ctrl + Q", it has many functions, can generate charts, color classification, summary and summation, etc., can effectively help us quickly analyze the data, if you do not know, then hurry to have a look!

Format 01, data bar select the data and use the shortcut key "Ctrl + Q", click on the "data bar" in the format, all the data can be turned into small data bar charts, and we can also view the data more intuitively when analyzing the data.

02, color levels use the "levels" in formatting, you can classify the data by color, green is large, red is small.

Icon set "icon set" generally indicates the rise and fall of prices, and is suitable for tables with positive and negative data.

04. Greater than if I want to quickly filter out data greater than 3000, I can highlight it by directly entering a numerical value in "greater than".

05. The top 10% "top 10%", as the name implies, highlights the top 10% of the data.

06. Clear format if you use some of the functions in "format" and want to clear it, you can select the data and then "clear format".

Chart 01, quickly generate Chart Select data and then use the shortcut key "Ctrl + Q", select "Chart", we can quickly generate the data into a chart.

Summary 01, row summary use "Ctrl + Q"-"summary", you can quickly sum the data, average, count, summary and so on.

02, column summary in the "summary" to continue to turn to the right, you can achieve column summary and other formula operations.

Form 01, Super Table "Ctrl + Q"-"Table" Select "Table", you can quickly convert the table into "Super Table".

02. Select "blank data" in the PivotTable report to convert it into a PivotTable report.

Mini chart 01, mini chart "Ctrl + Q"-"mini chart", you can quickly generate line chart, bar chart and mini chart of profit and loss.

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi

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.