Čtvrtek v 10:00 (dopolední)

The Power of Power Query: Learn How to Create Automated PPC Search Tools in Less than 3 Hours

Jazyk školení: Angličtina | VŠEM, Mapa

1 000,00 Kč (bez DPH)

Daniel Zrůst

Senior Digital Marketing Specialist | Avast


Daniel works for Avast where he's managing worldwide Search campaigns & taking care of all advertising data. Two years ago, he discovered Power Query in Excel and has started to use this business intelligence tool for automating routine PPC tasks, bulk campaign management & reporting. Soon, he realised that Power Query is an absolute PPC Search powerhouse no one's using. In his free time, Daniel publishes articles about Power Query on his blog ExcelinPPC.com

Proč jít na školení?

You want to start learning something absolutely new and become early adopter

You want to learn how to save hundreds of hours per year on common PPC Search tasks

You are tired of copy’n’paste operations in Excel/AdWords Editor

You want to learn how to create various keyword combinations on scale with ease

You are tired of freezing in standard Excel when working with large datasets.

You want to become an Excel go-to person in your team

Co se naučíte?

During real exercise on YOUR PC, you will learn how to create an automated refreshable template for creating new ready-to-upload campaigns, ad groups, keywords & ads in the Power Query extension in Excel. Demo is here.

Potřebné znalosti

You should know how to open Excel :-) You should also know that functions like IF and VLOOKUP exist in Excel. (You don’t have to be able to use them). You should also know how to bulk upload e. g. new keywords to AdWords Editor.

Doplňující informace

You need to bring your PC to the workshop. Power Query is not supported on Mac. The solution is to use Parallels with Windows version of Excel or to connect to a virtual machine running Windows Excel. Users with Excel 2013 & 2010: You need to download and install Power Query. Don’t worry. It’s for free. It’s an official Microsoft product. Start here. Users with Excel 2016: You don’t need to anything, Power Query (aka “Get & Transform”) is already integrated.

Další školení z odpoledního bloku

Marketing Festival s.r.o.
Renneská třída 393/12
639 00 BRNO - Štýřice

IČ: 01646486
DIČ: CZ01646486

Bankovní účet: 2600413633 / 2010
IBAN CZ5920100000002600413633
SWIFT: FIOBCZPPXXX