Why does a marketer need Excel?

In addition to counting money or keeping track of projects, Excel can massively process a huge amount of information with the click of a couple of buttons.

For example, I constantly use Excel to create or adjust a feed, to work with downloading information from the site, systematizing data and bulk deleting or correcting data. 

Now I will show you a couple of useful commands that will make your work easier and save a lot of time. 

1. Find and Select

A very useful function for searching for empty cells in a table or the row you need.

For example, I recently created a product feed for the Merchant Center. And I had 4 products rejected because I did not have the Description field filled in. To avoid manually searching for these fields among 1,500 products, there is aFind and Select button on the “Home” tab.
Select the row in which we want to find information, click Find and Select, then Select a group of cells, Empty cells.

And so, in a couple of seconds, we found that cells 513 to 517 are empty. Now we’ll fix everything in a couple of minutes and we’re ready. 

1. Find and Replace (Ctrl+H)

The next useful function is Find and Replace – this is my most frequently used function. 

For example, in the Price column, I need to change the periods to commas in fractional numbers. I select a column (or individual cells can be), press Ctrl+H, in the Find line I write Period, in Replace – Comma and click Replace All.

If you want to bulk delete information, simply leave the “Replace with” field empty. 

1. How to Find and Remove Duplicates in Excel tables

There are often cases when two columns of information contain the same data and they need to be somehow selected and deleted. Now I’ll show you how to do this in a couple of clicks.

The “Conditional Formatting” function will help us.

Select the columns, click Conditional Formatting, Cell Selection Rules, Repeating Values

Our duplicates are highlighted in red.

Next, in the “Data” tab, click “Filter”, Sort by color and select the color of our duplicates.

This way, we first filter one column, remove the filter and then the second column

Now just delete the unnecessary data and you’re done.

1. How to merge information from two cells in Excel

If you have two cells and you need to combine data from them, the ampersand sign “&” will help you. (Ctrl+7 in English layout)

In the third cell, write the formula “=Cell1&Cell2”. If you need a space or any other character between values, just add it to the formula in quotes. “=Cell1&” “&Cell2”

1. How to freeze the first row in an Excel table

Sometimes you need a cell, row or column to follow you around the sheet all the time. To do this, in the “View” tab, click “Freeze area” and select the desired option, for example “Freeze top row”

That’s it, the line is fixed.

This was the last function for today. Thank you for your attention.