Google Sheets - 1 Day Training Course

This live, instructor-led training in Mexico (online or on-site) targets beginner-level IT professionals who wish to use Google Cloud Platform to understand core services, deploy cloud workloads, and follow operational best practices.

By the end of this training, participants will be able to explain core Google Cloud services, deploy basic workloads, and apply security and monitoring practices.

This instructor-led live training in Mexico (online or onsite) is designed for data analysts who want to use Google Analytics to track and report website data.

By the end of this training, participants will be able to:

• Configure Google Analytics to collect website data.
• Build and analyze reports.
• Derive insights and implement data-driven strategies.

This instructor-led, live training in Mexico (online or onsite) is aimed at advanced-level data analysts who wish to learn how to use Google BigQuery for data querying, optimization, and machine learning integration.

By the end of this training, participants will be able to:

• Understand the fundamentals of Google BigQuery and its use for data analytics and cloud computing.
• Use Google BigQuery for data management and complex SQL queries.
• Implement query optimization strategies to improve performance.
• Integrate BigQuery with other Google Cloud services.

This instructor-led, live training in Mexico (online or onsite) is aimed at intermediate-level IT professionals who wish to gain expertise in managing cloud infrastructure and services on Google Cloud.

By the end of this training, participants will be able to:

• Set up and configure cloud environments using Google Cloud services.
• Manage and configure virtual machines, storage, and networking.
• Deploy and monitor applications in GCP environments.
• Implement security best practices and identity management.
• Use Google Cloud tools for automation and troubleshooting.

This instructor-led, live training in Mexico (online or onsite) is aimed at data scientists, data analysts, and developers who wish to explore AutoML products and features to create and deploy custom ML training models with minimal effort.

By the end of this training, participants will be able to:

• Explore the AutoML product line to implement different services for various data types.
• Prepare and label datasets to create custom ML models.
• Train and manage models to produce accurate and fair machine learning models.
• Make predictions using trained models to meet business objectives and needs.

This instructor-led, live training in Mexico (online or on-site) is aimed at beginner-level IT professionals who wish to manage and operate the Google Cloud Platform.

By the end of this training, participants will be able to:

• Understand the core services and infrastructure of GCP.
• Learn how to manage networks and virtual machines.
• Understand and apply general security best practices in GCP.
• Explore Kubernetes and container management in GCP.
• Learn about storage options and how to configure them.
• Deploy and configure databases on GCP.

This instructor-led live training in Mexico (online or on-site) is designed for GIS professionals at an intermediate to advanced level who wish to learn how to use Google Earth Pro for mapping, data visualization, and geographic analysis.

By the conclusion of this training, participants will be able to:

• Master the Google Earth Pro user interface and comprehend the capabilities of its various tools and settings.
• Efficiently traverse the globe using Google Earth Pro, leveraging search functions, coordinates, and different viewing modes.
• Create, modify, and apply placemarks, paths, and polygons to identify and examine specific geographic locations.
• Employ Google Earth Pro for sophisticated visualization, incorporating 3D structures, historical imagery, and Street View integration.

In this instructor-led, live training in Mexico, attendees will learn how to set up and manage a production-scale container environment using Kubernetes on Google Cloud.

By the conclusion of this training, participants will be able to:

• Configure and administer Kubernetes on Google Cloud.
• Deploy, manage, and scale Kubernetes clusters.
• Deploy containerized (Docker) applications on Google Cloud.
• Migrate an existing Kubernetes environment from on-premise infrastructure to Google Cloud.
• Integrate Kubernetes with third-party continuous integration (CI) tools.
• Ensure high availability and disaster recovery in Kubernetes.

This instructor-led live training in Mexico (available online or onsite) is designed for developers who wish to enhance their websites or web applications by integrating geo-location functionality through Google Maps.

Upon completing this training, participants will be able to:

• Embed a map into a new or existing website or web application.
• Display real-time data that synchronizes with the user’s current location.
• Build a mashup that incorporates Google Maps.
• Apply best practices for CSS and JavaScript coding.
• Design a custom map for an application.

This instructor-led, live training in Mexico (online or onsite) is aimed at beginner-level commercial managers who wish to use Google Workspace tools to enhance productivity, collaboration, and organization within their respective roles.

By the end of this training, participants will be able to:

• Understand the basics of Google Workspace.
• Effectively schedule and manage meetings using Google Calendar.
• Confidently host, join, and manage virtual meetings, and use collaboration features like screen sharing.
• Create professional documents, use collaboration features, and convert documents to various formats.
• Create, format, and share presentations, and collaborate with others on the same presentation.

Google Workspace is a suite of cloud-based tools designed to enhance communication, collaboration, and productivity in both professional and academic environments. This blended training combines virtual and in-person sessions to provide participants with practical skills for effectively using Gmail, Calendar, Meet, Drive, Docs, Sheets, Slides, and Chat/Gemini, with hands-on activities and guided practice.

This instructor-led, live training (online and onsite) is aimed at beginner-level to intermediate-level professionals who wish to strengthen their use of Google Workspace to streamline teamwork and operations.

By the end of this training, participants will be able to:

• Organize and manage email, events, and meetings effectively with Gmail, Calendar, and Meet.
• Collaborate in real time using Google Drive, Docs, Sheets, and Slides.
• Apply communication tools like Chat/Gemini to streamline team interactions.
• Develop practical outputs such as schedules, collaborative reports, dashboards, and presentations.

Format of the Course

• Blended learning: 2 hours virtual + 12 hours in-person sessions.
• Interactive lecture and discussion.
• Hands-on exercises, group projects, and simulations.
• Video tutorials and guided virtual practice activities.

Course Customization Options

• To request a customized version tailored to your organization’s processes, please contact us to arrange.

This instructor-led, live training in Mexico (online or onsite) is designed for system administrators who wish to manage and deploy G Suite for organizations.

By the end of this training, participants will be able to:

• Implement Google security practices using 2SV and SSO.
• Monitor domain and service usage via reports in the Admin Console.
• Set up and configure the G Suite Admin Console.

Google Workspace is a cloud-based collection of productivity and collaboration tools designed to streamline communication, file sharing, and team productivity. This course covers the essential apps and features to help participants work more efficiently and collaboratively.

This instructor-led, live training (online or onsite) is aimed at beginner-level to intermediate-level users who wish to get the most out of Google Workspace tools for daily work and collaboration.

By the end of this training, participants will be able to:

• Use Gmail for professional communications.
• Manage files securely in Google Drive.
• Run effective meetings in Google Meet.
• Collaborate in real time with Docs, Sheets, and Slides.
• Organize schedules with Google Calendar.
• Communicate quickly using Google Chat.
• Create forms and collect responses with Google Forms.
• Capture ideas and manage tasks with Keep and Tasks.

Format of the Course

• Interactive lecture and discussion.
• Hands-on exercises and practice.
• Live demonstrations.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Google BigQuery serves as a fully managed, serverless data warehouse that enables cost-effective query optimization, predictive analytics through BigQuery ML, and effortless data ingestion for analytical workflows. It is specifically built for teams aiming to maximize query efficiency, develop machine learning models directly using SQL, and streamline reporting pipelines.

This instructor-led live training, available online or on-site, targets teams who have a fundamental understanding of SQL and wish to optimize their queries, leverage BigQuery ML for predictive modeling, and enhance their data ingestion and transformation processes for reporting purposes.

Upon completion of this training, participants will be equipped to:

• Optimize queries within BigQuery to boost performance and minimize expenses.
• Utilize BigQuery ML to construct, train, and assess predictive models.
• Design efficient data ingestion and transformation pipelines tailored for reporting.
• Implement best practices for scaling analytics within Google BigQuery.

Course Format

• Interactive lectures and discussions.
• Practical labs involving Google BigQuery and BigQuery ML.
• Real-world exercises focused on query optimization and pipeline design.

Course Customization Options

• To request customized training for this course, please reach out to us to arrange it.

This course is designed for organizations looking to streamline their operations by connecting key digital platforms used in daily workflows, including Trello, QuickBooks, Google Workspace, and the WhatsApp API.

Led by an instructor, this live training (available online or in-person) walks participants through the steps of linking and automating workflows, enhancing project and financial oversight, and centralizing data to support better decision-making.

Upon completing this training, participants will be able to:

• Connect and automate workflows between Trello, QuickBooks, and Google Workspace.
• Integrate WhatsApp API communication into operational workflows.
• Design multi-platform automation systems focused on efficiency and control.
• Implement security and monitoring policies for active integrations.
• Document and maintain automated processes in operation.

Format of the Course

• Conceptual explanations and guided demonstrations.
• Practical exercises applied to real-world operational scenarios.
• Hands-on practice using company-specific data and tools.

Course Customization Options

• Adapting the content to the company’s specific platforms and processes.
• Including additional tools such as Zapier, Make/Integromat, or Power Automate.
• Analyzing and designing real data integration flows.