” ONE “

As we all know, many industries are inseparable from Excel:

Do financial, to use Excel to do statements;

Logistics, will use Excel to track the order situation;

HR people can use Excel to calculate salaries.

Do analysis, can use Excel to calculate data to make statements.

I don’t know if you’ve ever used Excel to do data analysis, but you tend to generate multiple workbooks to do intermediate calculations, and mouse all the way to the last page before the final result table appears.

This phenomenon is common among consultants and analysts.

If something goes wrong with the source data at this point, you might want to start with the first report and then, page by page, go through it to determine what went wrong. Also, it’s easy to make mistakes by switching from one workbook to another.

To avoid this situation and to achieve report automation, many people start to learn Excel’s advanced skill – VBA.

But actually, number one, VBA is not easy to learn. Second, VBA takes a lot of time to run when there is a large amount of data.

Here are a few things that make Excel a pain in the neck:

  1. The set of errors

If a piece of data changes and is used multiple times in the workbook. If the formula is not quoted elsewhere, then this error will probably require a lot of manual and discerning work to correct, and may not be correct.

  1. Do not extend

Excel has at most 1,048,576 rows and 16,384 columns. If you have a lot of data and you don’t have a lot of memory on your computer, it’s very likely that you’re processing it all the time or jumping out of it without saving it.

I guess this happens to a lot of people.

  1. Performance is not good

Once the volume of Excel data becomes too large, it can greatly affect the efficiency of your workbook. Sometimes, even if you add a number, it takes a long time to type it in. Not to mention opening and saving workbooks.

  1. Complex formula

Because Excel’s cell formula must be written in one sentence. So if the logic of computation is complicated, whether it’s when you write it down, or when the formula is wrong, or when someone reads your formula, it’s very difficult. It takes a lot of time to make sense of the logic.

  1. Catastrophic forgetting to save

If encounter crash, automatic jump out; Or the hand slides off. Congratulations, you may have wasted a whole morning of work.

  1. To work together

Although there are currently cloud platforms sharing Excel for everyone to use.

However, in today’s big data statistics, especially in China, Excel is still run and edited on local machines, which causes great inconvenience for collaborative work.

  1. Version control

Excel reports are usually V1, V2, VF versions. If it’s multiple hands, you can see John_V1, Lily_V2, etc. If two people are working on the V3 version and it is released at the same time, it would be a complete tragedy.

  1. The company operates

Excel was originally designed to do small, quick calculations that didn’t count as permanent solutions at the company level.

But now, there are more and more demands that Excel report forms connect with financial system and operation system, while Excel itself was not designed for these purposes at all.

So not only is maintenance troublesome, but it is not an easy thing to get through this kind of report in the company.

With all the headaches, what should we do about it?

The answer is: Learn Python!

So why learn Python?

  1. Python is simple

First, Python is easy to learn and very versatile.

  1. Good for job hunting

Take a tour of the job search web and you’ll see more and more job listings that require Python in addition to Excel.

3) You can be lazy

With Python, you can do in an hour what someone else did in Two days with Excel. Others 996, you take a mobile phone secretly play king of Glory, no more cool than this bar!

Why learn Python and not C++ or JAVA?

Although many people say C++, JAVA can also do Python’s functions, why not learn from them? There are two reasons:

  1. Not easy to learn

  2. The code is too complex

C++ may need 10 lines for the same data processing, whereas Python can do it in one.

Python can do a lot of things for you

Python also provides a lot of pre-written code that you can reference without writing.

Such as:

  1. Read and write clean data

  2. Statistical calculations

  3. External databases are directly connected

  4. Machine learning modeling

  5. Draw beautiful, interactive graphics

  6. Write SQL

  7. Automatic Email sending

  8. Web crawler

  9. automation

  10. Interacting with Excel (if you really like using Excel)

After reading these 10 points, Python seems like a panacea.

Learn one thing and you’ll feel 100 things.

Xiaoziyan teaches you how to get rid of the inefficient way of learning and working, no longer respond to wechat messages late at night, no longer pile up emails, efficient implementation of batch statistics, modification and other processing work.

Let you no longer forced 996, no longer suffering from no new way to dare not job-hopping!

So if you want to increase your salary, increase your productivity, and automate your work faster, you must keep learning Python!

Now ENGAGED in financial work, procurement work, administrative work, operation work; Or if you’re a student, you know a little Excel, and after reading the introduction above, you should rediscover your passion for Python and start your career in a new way.

Go ahead, like, comment and follow!