Excel Template

Completed Posted Oct 21, 2014 Paid on delivery
Completed

Hi

I would like an excel expert to be able to help me set up a template that I need for grouping keywords. I need to group the following columns in different ways - AdGroups, Keywords, Search Volume & Competition Level.

I need to create a template that

1. Adgroup Name & Search Volume

2. Adgroup with filter to see keywords and Search Volume

3. Worksheet that pulls in keywords into different lists depending on the volume e.g. <500 goes into a list called longtail, >500 goes into a list called secondary

4. Worksheet that pulls in keywords into different with different intent e.g. "buy sugar" goes into a list called intent or "review sugar" goes into a template called consideration

I have attached the raw data and will go into more detail with the freelanced

Excel

Project ID: #6622050

About the project

4 proposals Remote project Active Oct 21, 2014

Awarded to:

kher78

Hello, I can lend a hand with this. The solution would most likely involve using either a custom macro or a pivot table. Let me know if you'd like to discuss in further detail as I would need to better understand More

€15 EUR / hour
(27 Reviews)
4.4

4 freelancers are bidding on average €11/hour for this job

dragos1910d

Hello sir, I am a vba and excel expert. Contact me to discuss more. Check my reviews. Kind regards, Dragos!

€10 EUR / hour
(32 Reviews)
4.7
P0L

A proposal has not yet been provided

€12 EUR / hour
(3 Reviews)
2.1
sandeeepbadam561

My dear employer, I have good skills in Excel. I can create templates for the attached excel sheet easily. Please hire me. I will take-up your assignment and complete it on time. Looking forward to listen a positive More

€8 EUR / hour
(0 Reviews)
0.0