Why should I learn excel? Inspiration and motivation from my first job in my life
YXP is calm 2021-02-23 02:53:56

The inspiration of my first job in my life and the sprouting of learning Excel Power


My first job in my life was as a product manager in a men's clothing company , My department has 4 personal ,1 A supervisor 3 A clerk , The organizational structure is shown in the figure below

 Why should I learn Excel? The inspiration and motivation from my first job in my life


The merchandiser is responsible for docking the store and daily ERP system operation , The work is very simple , It's basically a phone call to the store , Then carry out daily purchase, sale and inventory operation on the system , Two people divide all the customers of the company by geographical location , One man runs the north side , One man runs the south side , I'm one of them .

The data specialist will export the data of a week to make data report every Monday , There were

1、 Shop year on year and month on month report

2、TOP ranking

3、 Inventory structure

4、 Sell out rate of the season

So the busiest time for data specialists is the first two hours of Monday morning ,8:30 Busy to 10:30. And then from Monday morning 10:31 It starts on Friday 17:30 Start chasing the show ......

As for what the supervisor is doing, I can't remember , Maybe planning a strategic direction .

by the way ! I remember . The director was not very satisfied with the data specialist at that time , It's the data report of what the supervisor wants to see , This data specialist can't make it , It's depressing for the supervisor , I often go to the position of data specialist to communicate with her , When it comes to emotional communication, the data specialist will leave , Then the supervisor panicked , All kinds of stay , All kinds of coaxing ...... I don't know why , Maybe at that time, the recruitment in the talent market could not be operated Excel The guy who .

Don't lie to you , It was from that time that I sprouted learning Excel Ideas .

I wanted to. , We 4 Personal work can be done by two or even one person , If you control it yourself Excel, You can make the data report you want to see according to your own needs , And put all the repeatability 、“ Objectivity ”、 The work is given to Excel To complete , Reduce the time spent working in this area to a minimum , And then the rest of the time can do something “ Subjectivity ” The job of , Service output to customers , Whether it's business or emotional 、 Suggestions for the company's marketing activities 、 Inventory and sales warning of goods and so on .

VBA Learning the initial confusion and Enlightenment


So I started to learn Excel, All kinds of information , All kinds of requests , Learning progress is also very fast . Because of ignorance , During that time, every day I felt like I was bursting with confidence , I feel like I can handle it Excel 了 , Until I saw one VBA operation Excel In the video , The whole person is stupid , I didn't expect Excel I can still play like this , Driven by intense curiosity , I started to teach myself VBA, Without any code base , I graduated from accounting , At the beginning, I was totally confused , Looking at the code is like looking at the book of heaven , I gave up a few times intermittently , Think about not willing to continue to pick up learning , But it's still in the stage of no enlightenment , No direction .

During this period, I learned some scattered VBA Knowledge point , Declare variables , Variable type ,FOR loop ,IF sentence . If these knowledge points are only taken out individually , In specific cases, I can understand , But I can't make a comprehensive understanding , Also did not learn the knowledge to solve the actual problems encountered in the work , Because I know too little , I didn't come across the one that I just used now VBA Problems that knowledge can solve .

But I'm lucky , It was a weekend , I get up in the morning and turn on the computer , In a VBA I saw a person asking for help on the relevant forum , When I saw this problem, I suddenly felt like being struck by lightning , I feel like I can solve this problem , So I started writing , I wrote a simple piece of code for more than two hours , During repeated debugging , So the first time in my life to actually solve problems VBA There is , Although it's been several years, I can still remember that scene . In memory of , I keep this code on my computer all the time , Time is fixed on 2015-10-31 In the morning 10:39

 Why should I learn Excel? The inspiration and motivation from my first job in my life

chart 1


The first paragraph I wrote VBA Code


Let's take a look at this first , As shown in the figure below

 Why should I learn Excel? The inspiration and motivation from my first job in my life

chart 2


The table in the picture is the query page , The name of the worksheet is “ Inquire about ”, This book also has China 、 Japan 、 South Korea 、 Germany 、 North Korea 、 The US worksheets

 Why should I learn Excel? The inspiration and motivation from my first job in my life

chart 3


The worksheet for each country name has 5 Students and their scores in the corresponding subjects , As shown in the figure below , This is The contents of the China worksheet

 Why should I learn Excel? The inspiration and motivation from my first job in my life

chart 4


On the query page, select China from the drop-down menu , Then click the score query button

 Why should I learn Excel? The inspiration and motivation from my first job in my life

chart 5


Get query results , If the name of the query appears in the country worksheet of the query, the corresponding score will be displayed , On the contrary, it shows “/” It means that we can't find , Because there are only Zhang San In the Chinese worksheet , So you can find Zhang San .

 Why should I learn Excel? The inspiration and motivation from my first job in my life

chart 6


There is... In the Chinese worksheet “ greatly ” The name ( chart 4), If the query page “ Li Niu ” Switch to “ greatly ” Click query again, you can query it

 Why should I learn Excel? The inspiration and motivation from my first job in my life

chart 7


This is the code

 Why should I learn Excel? The inspiration and motivation from my first job in my life


Sub xx()

Dim rng As Worksheet, n%, i%

For Each rng In Worksheets

If rng.Name = Sheet1.Cells(1, 2) Then Exit For

Next rng

For n = 3 To 6

Dim h%

h = 0

For i = 2 To 5

If Sheet1.Cells(n, 1) = rng.Cells(i, 1) Then

rng.Range("b" & i & ":e" & i).Copy Sheet1.Range("b" & n)

Exit For

Else

h = h + 1

If h = 4 Then Sheet1.Range("b" & n & ":e" & n) = "/"

End If

Next i

Next n

End Sub

although , I don't know what the problem the caller raised can solve in his work , But I want to thank him , It's this question that has enlightened me , Let me learn VBA More confident .

And then I learned more Excel Functions and VBA knowledge , Now I've done what I thought , As long as it's repetitive work , I will use it. VBA solve , Keep the work done in this area to a minimum , It was a few hours ago , It can be compressed to tens of seconds . I spend more time on “ Subjectivity ” Things , Not only is it easy to work , It's efficient , There is more time to learn new knowledge to improve their work .

Sharpening a knife never misses a woodcutter , Learning takes time , But learning is once and for all . There used to be a saying that it's never too old to learn , But the current situation in the workplace is that only when you are old enough to learn can you live forever , Let's become a lifelong learner .
版权声明
本文为[YXP is calm]所创,转载请带上原文链接,感谢
https://fheadline.com/2021/02/20210223011242627o.html
相似文章

2021-08-09