Google Sheets course
Choose Turko for your digital marketing training. Over 225 hours of training for all levels. We look at the financing options and we prepare the file for you if possible. Check out our various training programs!
The objective of the Google Sheets course is to be able to master the basics of Google Sheets, understand the different functionalities and working techniques specific to the tool in a context applied to digital marketing. Choose Turko for developing your organization’s Google Sheets skills today.
Our Google Sheets course
- Introduction to Google Sheets
- Overview of the interface and terminologies
- Manage Google Sheet files, convert Excel files to Google Sheet and import data
- Content management (formatting, style, create rows and columns, tabs, Insert images)
- Data validation, filters and conditional formatting
- Collaboration tools and version (Share, comment, insert a note, versioning, personal filters)
- Overview of certain specific elements (functions, graphics, pivot tables)
- Keyboard shortcuts and speed techniques
- The VLOOKUP, SUM, SUMIF, IF functions
- Variables and names ranges
- Add-ons
- Charts and graphs
- Integration with Google suite
- Overview of Google App Script: Make a function with a timer
- Overview of Google App Script: Make a function that will be displayed on a cell
- Analyzing data from Search Console or Google Analytics using Google Sheets
- Analyzing data from Google Ads using Google Sheets
- Introduction to Supermetrics, an overview of the interface and features
- Example using Supermetrics and Google Analytics
- Example using Supermetrics and Adwords
- Example using Supermetrics and Facebook
- Making a Google Sheets dashboard with Supermetrics and Google Analytics + Adwords + Facebook
- How to make a recurring report
Our training courses
Objectives:
To be able to audit, analyze growth potential and prioritize potential actions in order to develop and implement a measurable SEO strategy.
Modules:
- Introduction to SEO
- Keyword research
- Search Console and analysis tools
- Content analysis and site structure
- Technical analysis
- Inbound links and ranking factors
- Action plan
Hours: 29*
* Maximum for this training. The number of hours varies according to the desired modules.
Objectives:
Understand the concepts and the features of the Google Ads platform. Be able to manage and optimize campaigns on Google Ads.
Modules:
- Introduction to Google Ads
- Keywords & “Match Types”
- Efficient writing of “Ad Copy” & Ad extensions
- Campaign settings
- Conversion tracking and performance reports
- Account structures
- “Ad-Rank” and “Quality score”
- Manage a campaign
- Adword Editor and analysis tools
- Audiences
- Google Display network
- Youtube ads
- Product feeds (Google Shopping and Merchant Center)
- “Discovery” ads
Hours: 37*
*Maximum for this training. The number of hours varies according to the desired modules.
Objectives:
Understand the concepts and features behind the Facebook Ad platform. Be able to manage and optimize a Facebook and Instagram ad campaign.
Modules:
- Introduction to Facebook Ads and strategies
- Configurations and functionalities
- The Ad Manager and the tools
- Campaign settings
- Performance monitoring and reporting
- Facebook catalog (product feed)
Hours: 22*
*Maximum for this training. The number of hours varies according to the desired modules.
Objectives:
Understand the challenges and goals of a content marketing campaign. Understand the role of content marketing inside an inbound marketing strategy. To be able to build a strategy and choose the right levers to attract and convert customers. Be able to deploy a content marketing strategy.
Modules:
- Introduction to content marketing
- The angles, the channels, the hooks, the “inbound” content
- The content calendar and action plan
- Distribution strategy
Hours: 15*
*Maximum for this training. The number of hours varies according to the desired modules.
Objectives:
Understand and implement a communication and audience management strategy on social networks. Understand the technicalities of each platform, as well as their tools and functionalities. Measure the impact of social media efforts as part of a global strategy.
Modules:
- Introduction to social media
- Social listening and monitoring
- Social media strategies and communication plan
- Facebook for Business
Hours: 42*
*Maximum for this training. The number of hours varies according to the desired modules.
Objectives:
Understand the features of the Google Analytics platform. Understand the concept and various functionalities of the tool in order to be able to analyze performance, detect optimization opportunities and identify tracking issues. Be able to configure performance goals and re-targeting audiences.
Modules:
- Introduction to Google Analytics
- Interface and features
- Reports
- Conversion goals and performance monitoring
- Analysis tools and techniques
- Audiences, e-commerce and re-targeting
Hours: 18*
*Maximum for this training. The number of hours varies according to the desired modules.
Objectives:
Understand the concept and features behind the Google Tag Manager software. Be able to configure pixels, Google Analytics events and other tracking implementations.
Modules:
- Introduction à Tag Manager
- Interface and features
- The notions of “tags”, “triggers” and “variables”
- Variables and data-layer
- Event configurations and conversion goals
Hours: 13*
*Maximum for this training. The number of hours varies according to the desired modules.
Objectives:
Understand the basic and more advanced features of Google Sheets. Understand the different functionalities and working techniques specific to the tool in a context applied to digital marketing. Be able to analyze data inside Google Sheets.
Modules:
- Introduction to Google Sheet
- Techniques and features
- Data analysis on Google Sheets (practical cases)
- The Supermetrics “add-ons”
Hours: 15*
*Maximum for this training. The number of hours varies according to the desired modules.
Objectives:
Understand the basic concepts of the Agile methodology in the context of a digital marketing project. Understand the concepts “Epics”, “User Stories”, “Scrum”, “Sprint” and “Backlog”. Be able to plan a “sprint” and do it’s review (retrospect).
Modules:
- Introduction to the Agile methodology
- The Scrum concept
- Sprints
Hours: 7*
*Maximum for this training. The number of hours varies according to the desired modules.
Objectives:
Learn basic notions in HTML, Javascript and CSS in order to understand important technical concepts of the web. Learn about popular web tools and plugins that help in executing a successful performance marketing project. Develop a basic knowledge of popular web plugins and e-commerce platforms and how to optimize them for digital marketing performance.
Modules:
- Introduction to HTML, Javascript and CSS
- Popular web tools in web marketing
- Optimize WordPress
- Optimize Shopify, Woocommerce and Magento
Hours: 27*
*Maximum for this training. The number of hours varies according to the desired modules.
What we offer
Cost-effective training programs
Strategic Involvement
We understand your “big picture”. Our tailor-made training courses adapt to your digital transformation objectives. During the training, we offer concrete help on your campaigns to support you in the implementation of your marketing plan.
Solutions suited for your reality
Whether it is 1-on-1 coaching or in a group, we offer a program adapted to your reality by using your digital assets directly as examples. We make sure that the skills learned are aimed to accelerating your return to activities.
How we stand out
Pre filled submission application
When available, we look into the various subsidies available and gather the submission information for you. We will then tell you how to proceed with Service Québec (or other organizations).
Learning Methodology
We provide an environment that is conducive to learning and the development of new skills. We follow up on the academic progress of candidates.
Certified experts
Our trainers are first and foremost experienced technicians who work directly on digital campaigns. They are certified, experienced and available to help you.
Case Study: Desjardins
Find out how Turko Marketing’s training helped Desjardins in their UX and content department to keep up to date with good SEO practices
What our customers say
Frequently Asked Questions
For more information on the existing programs in place, please see the official page on the site of the Government of Quebec.
- Employers
- Self-employed workers (incorporated or unincorporated) with employees
- Co-operatives
- Social economy enterprises
- Non-profit and community organizations active in communities
- Employee and employer associations
- Professional associations
- Employer groups
- Workers’ organisations
For more information on the program, please see the official page on the site of the Government of Quebec.
Each training has a predefined plan, which includes several modules, so that we can offer you a complete training if you do not have a specific request.
However, all our training courses are customizable and can be adapted to the specific needs of your team. Contact us for a free detailed quote.
We admit from 1 to 10 people for each training course.
Digital marketing agency professionals understand your challenges as well as your online marketing needs. In fact, they’ve already acquired the skills and knowledge you’re looking for. You’ll benefit from their extensive digital experience and technical tips and tricks. Digital agencies are always informed and up-to-date with the latest trends in their industry; they will be able to train you on the most recent platforms and best practices. Finally, you won’t just benefit from the experience of one trainer. In fact, you will take advantage of the know-how of an entire team that you can access throughout your training.
Fill out the application form by clicking on the button at the very top or bottom of the page.
Then, if you are eligible, we will quickly get in touch with you and schedule an appointment to explain the next steps.
Latest articles
