In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-02-12 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > IT Information >
Share
Shulou(Shulou.com)12/24 Report--
In the process of using Excel, there is no doubt about the power of functions and PivotTable, but they are powerful, but they are not omnipotent.
For example, there is nothing you can do about cell entry or selection.
If you can use some quick settings and operating skills to complete the task, it will be the only magic weapon to improve work efficiency.
Today, I would like to introduce you to some very practical tips, let's take a look!
1. The custom status bar is displayed in the following figure, which is a salary table summarized by month:
The data section has been set to a special accounting format with currency symbols.
The question now is, how to quickly view the Total count of a month and specify the Cell display format?
For example: let's look at [column B] (January salary) the total salary.
After [column B] is selected, you can quickly view the total count for that month in the status bar at the bottom.
But how can it be displayed in the same accounting format in the status bar at the bottom?
After [column B] is selected, the actual situation is as follows:
It only shows the general format and does not bring out the currency symbol.
Similar to the custom status bar display, there is no function button for the setting in Excel.
It doesn't matter. Let's be flexible.
Set the first selected cell (that is, the header) to the desired format, and that's fine.
Select the [B1] cell, and then select the Accounting specific format in the start tab.
Then select [column B] and look at the status bar display.
The problem is solved perfectly!
Here, you can also set the first cell of the selected area to the other format you want according to your actual needs.
2. Quickly check out different formats of data derived from the system or copied from the Internet, as well as data derived from other colleagues in the company, sometimes text numbers and numerical numbers are mixed together, resulting in subsequent statistical analysis errors.
For example, the following picture is a payroll, some of which are self-entered and some copied from other places.
At a cursory glance, the total number of [2-month salary] is obviously wrong.
However, the summation formula was checked and no problem was found.
The most likely reason is that there are text-based figures that are not included.
On the face of it, they all look the same as ordinary real numbers, so how to find out these false numbers quickly?
We can use [filter] to see. As shown below:
In the filter box, the numbers are supposed to be sorted from smallest to largest
But two of the numbers 496and 800are behind 2036. There must be something wrong!
Then check the cell format, it is really "text format"!
So how to convert this kind of pseudo-numbers into real numbers in bulk?
One [fast] [ruthless] [accurate] way is to use [separate] functions.
Select the [C] column, click [data] > [separate], bring up the [separate] dialog box, and then directly click "finish".
As shown in the following figure: text-based numbers are converted to real numbers.
Check again with the filter function to see that all the numbers are arranged in ascending order.
Whether the data is recorded manually or downloaded from the Internet or the system, it often needs to be processed before analysis, to change the data that Excel does not know into what it is familiar with, and to make the irregular data regular.
Then using the PivotTable, you can quickly and efficiently analyze the data in multiple dimensions and make high-end Excel reports!
3. The selection of cards that do not follow the routine in the daily processing of table data, in most cases, we need to select the target cell before we proceed to the next step.
So how to quickly select the desired area?
Usually we can press [Ctrl+A] to select all.
For example, this area below. Click on any cell in the data area, and then press [Ctrl+A] to select the data region.
However, sometimes there may be blank rows or empty columns in the middle of the area, so how do you choose?
You can click the first cell, such as [A1] cell.
Then press [Ctrl+Shift+End] to select the entire area.
But there is also a situation where when you press [Ctrl+Shift+End]
The selected area is like Brother Sun, turning over a somersault cloud, which goes straight to 100000 thousand li, which is terrible.
What should I do?
In fact, in view of the fact that there is a lot of data and blank rows, we can first select the multiple columns of data we need.
For example, in the image above, we need to select the data area of [Ctrl+Shift G], and then press [BRV + up Arrow]:
At this point, the entire range of cells with blank lines is selected, which is quite convenient.
PS. If there are empty columns in the data, the operation method is the same as above, except that after selecting the entire column first, press [Ctrl+Shift + right Arrow].
4. at the end of today, we share a few practical tips in our daily work:
❶ customizes the status bar display format.
❷ quickly examines and processes data in different formats.
❸ does not follow the routine selection of cards.
There is more than one loss for the boys to improve their work efficiency.
This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Der Spiegel in Heart
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.