You will find useful yet simple excel tips that has saved me countless hours processing data. Although there are insanely advanced ways to use Excel, this blog post will be continously updated with practical beginner tips that most people would need to use. This is for 2013 but some features are liklely to be found in older versions as well.
For example, I download a organic search terms report from ahrefs and want to remove all rows that have branded terms.
Before adding them to Rank Tracker, I don’t want to target a ton of branded terms so this quick method is great for removing them along with related misspellings.
Another simple yet overlooked feature in Excel.
Just select the rows/cells that you want to check for duplicate values and click the REMOVE DUPLICATES button in the DATA tab.
Check back later…more coming soon. Got a quick and practical excel tip you use daily?
Let us know and we’ll post it here with a credit to you.