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 […]
Excel tips
Two Excel Functions That Can Save You Hours of Formatting Time
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 […]
How To Automate Monthly Reports (Even If You Aren’t An Excel Wizard)
Nielsen and Circana applications make it easy to create spreadsheet based reports that can be refreshed every month. But in some of their systems, there is minimal formatting, or you may be using they data in a way the leads you to export information and format it outside the Nielsen/Circana application. Luckily, you can easily […]