If Excel is an enigmatic artifact in your head, you’re wrong; If you remember Excel as just another piece of office software, used only by clerical workers, you’re wrong, too. Whether you’re an office worker in a typical job with no tools, or a professional programmer with a wide range of skills, Excel is worth having. Because it can bring you more than you ever imagined. \
\
From dozens of commonly used functions, if multiple judgment, to the use of names, custom conditional formatting, validity, grouping and hierarchical display, to advanced filtering, custom sorting, merge, sorting, PivotTable, and the use of macros, Vba, small editor is all along the way, touch.
\
Although I am familiar with more advanced data analysis tools, Excel has never left my daily work. Always accompany xiaobian through the boring small data cleaning work.
\
Bit by bit of small skills too much, full of sharing, full of practice in the practice bar. \
\
Delete duplicates
\
What I want to emphasize here is that after you remove the duplicates, you have columns to choose from. This means that we can either de-weight all columns, or select only two or three of them.
\
\
Vlookup matching value
\
Excel beginners only need to learn this one formula, basically can cope with all the daily work. This is a highly used formula, which implements the function of finding the values of other fields on a record corresponding to a value in the selected area based on a value.
\
A row of data is a record, and a column is a field. Every formula parameter in Excel is not allowed to be memorized, you just need to provide the parameter according to the prompt, can use it. All the other formulas are the same.
\
\
Batch populate cell values
\
In some cases, it is necessary to complete the field values for each record in order to do PivotTable calculations. First, the region is selected for null value positioning. After positioning, without doing anything else, write the formula directly to the first cell with a null value equal to the value of the previous cell. Finally, hold CTRL + Shift + Enter on Window, Shift + Option + Enter on MAC, and you’re done.
\
\
I still can’t send a few more. Next time, please change the GIF. The maximum number of videos is three
\
Often see office colleagues that look of admiration, xiaobian secretly secretly pleased. But the glory belongs to Excel and To Microsoft. I’m just pretending to be a tiger. More tips to improve productivity will be shared later. \
\
Don’t forget to long click on the image below to identify the QR code and pay attention to the notes of data analysts
\