Running some ads and showing some numbers from the ad results does not help to make a data-driven marketer. Anyone can simply pick the numbers from the marketing campaign report and present the same numbers. To become a Data-Driven marketer, you need to Set up the marketing campaign the right way so that you can collect as much data as possible. If you do it wrongly, the data is gone forever.   Collating the data into Excel is the easiest and the cheapest option. If you can’t even handle the data in Excel, you can’t handle the data in any other tools. Analyze the results of your campaign. Every ad…

A letter to those who have sent their staff for my training or who have attended my courses. Do you know these 2 developments?1.We have just launched a new advanced Excel course2.There is a skillsfuture credit for corporate 1. We have launched a new advanced Excel course How advanced is this Excel course? This course is even more advanced than “Hidden Secrets in Data Analysis in Excel”. In this course, we do not use worksheet functions. We use Power Query, a function that is designed to prepare your data for analysis. This function works exactly the same way as any data analytics tools (including Power BI and Tableau) out there…

This sounds like a lame question but it’s really not. When I asked this question in the workshop, most people gave different answers other than the right one. Every answer sounded logical and they all seemed correct. But until you really know how to define it, you are not really into data analytics. Knowing the right answer increases your sensitivity to data and helps build your foundation in data analytics. Want to know what is that question? . . . . The question is: What is Data? Want to know the answer? Come to our data analytics course to find out. http://www.everydayexcel.com/data-analytics/

Learning Excel is a dead end He took aim at the body. It was easier to hit the body than the head. As he readied himself, he held his breath for a second and pulled the trigger. It was a perfect shot. 4 more rounds to go and each one of them was hit around the same area. “I am going to get my marksmanship this time round” He told himself. After all the practice that he had done, he believed his effort had paid off. When the result was announced, he was shocked. He failed his shooting test. He couldn’t believe it because he saw his last 5 shots…

The #1 rule of data analytics is not to touch the original data. By that, I DO NOT mean create a copy and work on it. You should still be using the original data but you should not make any change to the source file. All the changes should be done within the data analytics area. This area is available in Excel as well as Power BI. If you are able to fulfil this first rule, you will find that your analysis and/or your report is maintenance free. If you do not understand this first rule, you are not in data analytics yet. Sign up for our data analytics course…

For the last 20 years, you have invested your prime into becoming a domain expert. Those experience are valuable and cannot be easily replaced with just some text book knowledge or technology. But with the explosion of the internet, the learning curve to reach where you are now is going to be shorten. In order to stay relevant or reinvent yourself, you need to equip yourself with new skills.  Data Analytics is one of the up and coming skills that you can acquire to enhance your capability as a domain expert. It is not for IT. It is for domain experts like you who are in marketing, sales, supply chain,…

You have created a video and you would like to advertise in Facebook. Do you plan to advertise in post feeds, video feeds and/or stories? That depends on who you wish to attract. According to the stats I collected, it looks like post feeds is still gives you more exposure than video feeds. I have also placed ads on stories but there was no impression at all from FB or Instagram stories. That tells me that this stories do not work well for video ads. If your target group is woman, you should restrict your ads to woman only. If not, you budget will be wiped out by men who…