Transforming your syndicated data into business insight
For many years, I used Excel and never knew about VLOOKUP. Oh, the hours I wasted! I’m writing this post to save you from the same sad, productivity-sapping fate. What is VLOOKUP? It’s a simple Excel function that allows you to pull information from one data set to another, based on some matching value. While […]
Did you check out my post about automating reports in Excel? I showed the right way to set up reports (so you won’t have to reformat when you get new data). Now I want to share more about two handy Excel functions: RIGHT and PROPER. I used these for the retailer name, date and […]
Nielsen and IRI applications make it easy to create spreadsheet based reports that can be refreshed every month. But in their older systems like Nielsen Nitro and IRI XLerate, there is minimal formatting. Their newer web-based systems like Nielsen Answers and IRI Liquid Data apply more formatting but that formatting doesn’t necessarily look […]
