Reporting. So simple with VBA

reporting I have to prepare a daily, weekly, monthly, quarterly report… This is what managers do. Why? Why writing reports is more important than leading people or solving problems or proposing ideas?

Reports are important but in most cases reporting can be automated. We have to stop for a while and start working smart.

  • Can we talk about my idea?
  • Unfortunately I have to prepare a report. I have no time.
  • What report?
  • I have to prepare a financial statements. Download time logs from our experts, copy and paste them from hundreds of e-mails. Horrible…
  • Why don’t you use your brain and computer for doing all these things?

Let’s look at an example of an application that downloads attachments and move e-mails from Inbox to a separate folder. Here I will describe a procedure that may be used to download attachments from our e-mails.

Continue reading


Correcting data in Excel

Last time I have described a theory about finding typos in a set of data in an Excel file without using spell checker e.g finding typos in accounts numbers. Let’s assume that in most cases our data is correct (often true) and we collected number of transactions made by our clients. The data might look like below.


To compute probability we will use two simple Excel functions COUNTIFS and COUNT.
Continue reading

Learning – taking risk?

dilbert-105395-strip I have no time to learn at home, I have no time to learn at work, I have time for wasting so much time.

In my opinion learning always means taking risk. Nowadays, companies encourage people for taking trainings but in the same time they do not tolerate mistakes and as a result they do not tolerate creativity. We have to risk our position,  to do something in a different way, different than everyone before, change or improve something. What if we will fail? A disaster. We turned out to be irresponsible and stupid. What if we will succeeded? Nothing. Lucky guy, but nervous. In this case it is better to be like everyone. It is a trap …

How to be a good programmer? By programming. How to develop our skills by doing the same, well-known things? Impossible… We have to break such infinite loop to go further. Unfortunately, it will be uncomfortable for us, due to challenges on our way.

How to start? Let’s ask your colleagues about the worst task they performing. Ask about their ideas and design a small thing that will help them a lot. Small thing – small risk, but maybe a great improvement.