How can you learn excel if you can't input data well?
Old face of empty city 2021-02-22 22:48:01

Today we're going to talk about excel Relevant knowledge . Whenever we talk about data entry and data processing , Most people will think of this software that every computer will have ——Microsoft Office Excel.

But it can really put excel Very few people make good use of it .


I remember when I used to work part-time in the school office , I often need to help the teacher make forms and so on , And I just went to know almost nothing ,excel It's just for typing , Every time I do something, I have to teach by hand ... Teachers are not good at all , But it can't be like this after work , Even if the task arranged by the leader has never been contacted, he should learn relevant skills to complete at the first time , It's also a mature experience .

Many students even connect before graduation excel I don't know the basic operation of , And just started excel When , There's a lot of confusion , Many functions 、 A PivotTable on a big computer 、power View and power Map wait , So powerful excel, How on earth should we learn ?

Excel The most basic content should be : Data entry , In fact, there are many skills to input data , Or one by one ?

and Excel It's not just a data entry tool , It's also a data processing tool , So a good start to learning , Starting from standardizing data entry .

For example, these skills of standardizing data entry .

【1】 Text numbers to numbers

Sometimes when we're dealing with numbers , You'll find a small green triangle in the upper left corner of some cells , If we sum this number , We will find that , We sum to zero .

 Even data entry is not good , How else can you learn Excel?


But a list of data , We want to sum up this column , How to solve ?

 Even data entry is not good , How else can you learn Excel?


1. Select all cells with small green triangles in the upper left corner

2. Move the mouse to the yellow exclamation mark on the left to check for errors

3. Click the drop-down triangle to find the convert to number

4. Click Convert to number , We'll see that the previous value that our summation option showed as zero now gives the correct result

【2】 Cancel merging cells

The technique of merging cells is believed to be 90% Everyone knows , Although merging cells does look visually more intuitive , But for data processing , It will cause a lot of trouble and even make mistakes .

 Even data entry is not good , How else can you learn Excel?


For example, we can't select multiple cells in a row , So how should we solve ?

1. Select all merged cells

2. Click Cancel merging cells

3. Click Find and select to find the location condition

4. Select null value , Click ok

5. Enter... On the keyboard 【=】 Then click on the next cell

6. Use the... On the keyboard 【ctrl】+【enter】 To fill in blank cell data

【3】 Extra space should be removed from the text

Sometimes we import from other platforms to excel The data of , Will contain extra invisible spaces , Or sometimes we do it for beauty , Some spaces will be added in the middle of the text , however , When we do statistics and screening, we excel These spaces are not recognized

 Even data entry is not good , How else can you learn Excel?


How to solve ?

 Even data entry is not good , How else can you learn Excel?


1. Select all cells

2. Click Find and replace under the start tab

3. Select the replacement option to open the dialog window

4. Enter a space in the search

5. Delete everything in replace with , You don't have to type anything

6. Click Replace All , Now excel Will remove all the spaces in the cells

【4】 Regulate access dates

There are many ways to write dates , Some people like to use 2017/6/27 Some people like to use 2017.6.27, However excel You can't recognize the date separated by dots , Therefore, when doing data filtering, we can't filter by date

 Even data entry is not good , How else can you learn Excel?


How to solve ?

 Even data entry is not good , How else can you learn Excel?


1. Select irregular date cells

2. Click the split option under the data tab

3. Select the separator and click next

4. Do not deal with specific separation symbols , In the data preview area below, there is no split

5. Click next , Select the date in the column data format , The following drop-down menu defaults to YMD

6. Finally, click the finish button , Complete the conversion of irregular dates

【5】 The contents of cells should be unified and clear

Some people like to enter values and units in one cell at the same time , It is not advisable to do so , A cell records an attribute , If you put values and units in the same cell , Will cause the data to be unable to sum and filter .

 Even data entry is not good , How else can you learn Excel?


How to solve ?

 Even data entry is not good , How else can you learn Excel?


If you really want to display the unit as well as the value in a cell , We can format cells

1. Select the cell you want to set

2. Right click , Open format cell

3. Under the numbers tab, find custom

4. Enter... In the type on the right G/ General format " element "

5. Click ok , In this case, the cell value is a number , But when it is displayed, it will add a “ element ”

【6】 Delete extra total lines

A standardized data sheet , We should not add summation statistics to the data , Although it is convenient for intuitive Statistics , But this may make the data table unable to generate the PivotTable report normally , If you really want to see classification statistics , You can consider using subtotals

 Even data entry is not good , How else can you learn Excel?


1. Select the data area and sort the classified fields

2. Click the subtotal under the data tab , Open the dialogue window

3. According to personal needs , Select the corresponding category field 、 Summary method and selected summary items

4. Click OK to generate classified summary statistics

 Even data entry is not good , How else can you learn Excel?


If you don't need a breakdown , You can select Delete subtotal all in the subtotal dialog window

In addition to the above points , We should also pay attention to the continuity of data , There can be no empty row or empty column to partition the data

At the same time, pay attention to the repetition or missing of the header , I've done all of the above , It's the perfect data table .

版权声明
本文为[Old face of empty city]所创,转载请带上原文链接,感谢
https://fheadline.com/2021/02/20210222113716565y.html
相似文章

2021-08-09