It's extremely high pressure for me during the month of May.
- I realized that the Dealer Statement (Accounts Receivable) was not only a hard bone but a rocky bone. It was not difficult to follow instructions to format the Excel data from various departments and upload this data to SAP. The most uncomfortable part was, most of the templates are very outdated and the responsible personnel actually do not have the full picture, they are very incapable of inputting billing data into this worksheet. That means I had to work a lot to fix the numbers from raw data.
- The result of the above is I spend valuable time fixing the broken data link and recovering the crashed formulas, plus I already have enough on my plate.
- To immediately improve my efficiency, I made the decision. I went to the responsible personnel and walked them through, spend at least 5 to 10 minutes to let them understand how the formula works. Also updated the hyperlink in the file.
- There was small progress in June and a bigger improvement for July. I even ahead of schedule nearly half-day, and completed other month-end tasks. All these make my day!
