I would like to say that the best program I've ever used for analyzing my data is excel. Since the late 90's Excel was there for me and is still here today. I'm not saying I didn't try other programs like R Studio , Power Bi and Tableau but excel is still helping me on my day by day routine. The list below will give you my top functions and use cases with Excel. 1. VLOOKUP This function is by far my favorite one. The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position. Syntax VLOOKUP( value, table, index_number, [approximate_match] ) 2. CONCATENATE The word concatenate is just another way of saying "to combine" or "to join together". The CONCATENATE function allows you to combine text from different cells into one cell. In our example, we can use it to combine the text in column A and column B to create a co
Before I start this post. I would like to thank TED talks for helping me enrich my world of marketing and more. One of the best talks I ever heard was made by Simon Sinek and was about how great leaders inspire action. In this post I would like to emphasis the change in my approach towards contacting customers and in which way to do it. Simon presented the following diagram: We need to talk to our customers from the inside to the outside. Conveying why we do things, how we do it and at last the what we do. As Simon said, people follow the why you do it and not the what you do. Then he spoke about the innovators and the late adapters using the following diagram: Where he brakes down your customers into groups, where the innovators pass your story along with the early adopters. The 80/20 rule also can be adjusted according to this diagram: 1. The Innovators - 2.5% - your top VIPs 2. Early Adopters - 13.5% - 2nd level VIPs 3. Early Majority - 4