SEO Tools and Tips - D3 (Data-Driven Documents) - Ayima

SEO tools and tips

Tips / January 11, 2019

Whether its basketball, pubic speaking, or SEO, mastering the fundamentals is key. Sure, you may be able to alter a data set manually or copy a strange looking formula, but if you want to be prepared for the challenges of tomorrow, this article will get you a long way.

Mikkel Sciegienny at has been involved with SEO for five years and in this blog post he will share 15 important tips for mastering Excel.

Excel is one of the most widely used software programs in the world, and is used in niches you can’t even think of. But in many niches and industries, there are work processes that scream for Excel.

One of the common factors for these work processes is that they include a lot of data that sometimes needs to be cleaned up before it makes sense. Other common factors are keeping track of stuff like emails, replies and links. Lots of links.
Luckily there’s a tool that’s so powerful and flexible that it covers all this – can you guess what software program I am talking about?
As an SEO professional, Excel skills can ease up your work and increase your productivity – which will make you an even better SEO.

In this article, I’ll teach you the tips you need to know to improve your Excel skills in a matter of minutes. This article and the examples are written for Excel 2016 on a machine running Windows, but almost all of the tips are universal for Excel 2007/10/13/16 for Windows, although the layout may look a bit different on your version.
We start off with the easy tips and progress to the more advanced ones.

Tip 1 - Freeze panes:

Don’t lose track of your headers

When working with tons of rows and columns, freezing the column headers will make it a lot easier to keep track of the data you’re looking for.
Scroll to the top of your spreadsheet. Go to the ‘View’ tab on the ribbon (that’s the fancy word for the menu with all the buttons by the way). Then click the ‘Freeze Panes’ button.