Advanced Google Sheets Tips & Tricks for SEOs
In the world of complex data sets, having advanced spreadsheet skills is critical to be able to do analysis, research and reporting as well as effectively solve many other challenges in the digital marketing space.
In this course, you will learn how to create specific Google Sheets functions and, most importantly, how to apply them in your own strategies in order to make smarter decisions. Besides that, Maria will share specific scripts which will help to level up your marketing game. The course is suitable for both beginner and advanced SEO professionals.
Count Number of Words in Cell
Count Number of Characters in Cell
Combine two texts
Spilt two texts
Extract anything before and after character
Use Regextract formula
Use ImportRange formula
Use IF & IFs formula
Use Vlookup formula
Search string for certain values
Use Query Formula
How to level up import functions
Leverage growth of your SEO campaign
APIs - how to set them up
APIs - how to pull data from SC
Add-Ons for SEO
Low Hanging Fruit
Automatically Generate hreflang tags with G-Sheets
About MARIA DUBRETIC
Maria is passionate about digital marketing and loves making complex things simple. She enjoys working with data and doing quantitative research.
As a CTO of High Voltage SEO - leading international SEO agency focused on scientific SEO approach - she works on researching and developing SEO strategies, solving technical SEO challenges, process automation as well as helping clients to improve organic traffic on their websites.
Maria is a co-founder and CTO of PageOptimizer PRO - an On-Page SEO optimization tool widely used by SEO agencies and SEO professionals.
What Students are Saying
Never have I worked with anyone so technically brilliant and uncompromising when it comes to getting results. I'm proud to be a co-founder with her in more than one venture. Maria has trained pretty much everyone who's ever worked for us and I know you're going to get a TON of value out of her IMG training.
Maria is an expert at making Google sheets work for you. I have learned countless tips on how to make things that look difficult easy from Maria.
What is IMG Courses?
IMG Courses is a curated selection of SEO related courses and training from the most accomplished names in our industry. Membership includes unlimited access to a rotating selection of the finest SEO related training available and access to our private community platform and our SEO Tests library.
It's the only resource you'll ever need to stay on top of your SEO game.
Frequently Asked Questions
Your membership includes unlimited access to all training and courses within IMG Courses, access to the SEO Tests library, the online community platform and all live events within the Community Network.
Our pricing is super simple. One low monthly price for all course & network access.
There is also a discounted yearly up sell in the purchase funnel.
Pricing increases incrementally as we add more courses. See homepage for latest pricing.
Yes. As a member of IMG courses you get an invite to our monthly test reviews, as well as exclusive access to our entire archive of tests from the largest testing group in SEO.
Courses rotate in and out of IMG Courses. We will give members notice before removing any courses from the platform so they have ample opportunity to finish up any current progress. If a member wants to purchase lifetime access to a course, they can do that as well.
As we add more courses, training and tests to IMG Courses the value increases and there are more instructors who need to be remunerated. These small increases are in line with this. But the price you pay when you sign up is the price you continue to pay.
Log into your account > Click on your profile in top right corner > Personal Settings > Account > Deactivate My Account. DO NOT click ‘Permanently Delete My Account, this is bad.
Important note on cancelling: IMG Course pricing increases monthly. Should you wish to rejoin in future it will be at new pricing for that month.
Choosing to Deactivate your account will remove you immediately from the platform, so you may wish to wait until just before your next billing period to do this.
Yes. If you want lifetime access to a single course that’s offered in IMG you can purchase a single course separately. Just go to the course page and purchase
Yes we do. As an IMG Courses Affiliate you get paid a flat $20 for each new member referred. You'll find the link to register for our affiliate program in the footer of the site.
Yes, you can. Ted and Kyle host a weekly show called Ask The Expert, where they allow SEOs to jump in and talk about what they are working on, and get guidance on anything they are thinking through, or just generally chat about SEO.