Google Sheets - 1 Day Training Course
This course introduces you to Google Sheets, the cloud-based spreadsheet application included with Google Workspace.
Google Sheets allows you to create and edit spreadsheets directly in your web browser without requiring any special software. Multiple users can work on the same document simultaneously, view real-time edits, and benefit from automatic saving. You will learn how to open Google Sheets, create a blank spreadsheet, and set up a spreadsheet from a template. Additionally, you will add, import, sort, filter, and format your data using Google Sheets and learn how to work across different file types. Formulas and functions enable quick calculations and improved data utilization. We will cover creating basic formulas, using functions, and referencing data. You will also learn how to add charts to your spreadsheets. Sharing Google Sheets documents is straightforward, and we will explore the various sharing options available. We will also discuss tracking changes and managing versions of your spreadsheets. Google Workspace simplifies collaboration with your team, clients, and others, regardless of location. We will review collaboration features in Google Sheets, such as commenting, action items, and notifications.
This course is available as onsite live training in Argentina or online live training.Course Outline
- Introduction to Google Sheets
- Manage data using Google Sheets
- Format a Google Sheets spreadsheet
- Basic formulas, functions, and charts
- Share your Google Sheets spreadsheets
- Collaborate with Google Sheets
- Business challenge
Open Training Courses require 5+ participants.
Google Sheets - 1 Day Training Course - Booking
Google Sheets - 1 Day Training Course - Enquiry
Testimonials (2)
The final day which is the Machine Learning Topic
John Erick Baltazar - Globe Telecom
Course - Google BigQuery
It was a really good training course, well prepared and explained by the trainer with great hands on experience on GCP.
Mircea
Course - Google Cloud Platform Basics and Management
Upcoming Courses
Related Courses
Google Cloud Platform Fundamentals and Core Service
24 HoursThis instructor-led, live training in Argentina (online or onsite) is aimed at 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.
Introduction to Google Analytics
7 HoursThis instructor-led live training in Argentina (available online or onsite) is designed for data analysts who want to employ Google Analytics to monitor and report on website data.
By the conclusion of this training, participants will be able to:
- Configure Google Analytics to collect website data.
- Create and analyze reports.
- Derive insights and make data-driven decisions.
Google BigQuery
28 HoursThis instructor-led, live training in Argentina (online or onsite) is designed for advanced-level data analysts aiming to learn how to use Google BigQuery for data querying, optimization, and machine learning integration.
Upon completion of this training, participants will be capable of:
- Gaining a solid understanding of Google BigQuery fundamentals and its application in data analytics and cloud computing.
- Leveraging Google BigQuery for data management and executing complex SQL queries.
- Applying query optimization strategies to enhance performance.
- Integrating BigQuery with other Google Cloud services.
Google Certified Associate Cloud Engineer
35 HoursThis instructor-led, live training in Argentina (online or onsite) is designed for intermediate-level IT professionals aiming to acquire the skills necessary to deploy, manage, and operate workloads on Google Cloud while preparing for the Google Certified Associate Cloud Engineer certification.
Upon completing this training, participants will be able to:
- Set up and manage Google Cloud projects, resources, networking, and storage services.
- Deploy and administer applications using Compute Engine, Google Kubernetes Engine (GKE), Cloud Run, and App Engine.
- Configure identity and access management, security controls, and billing budgets, alerts, and cost monitoring.
- Provision and automate cloud infrastructure using Terraform and Cloud Build.
- Monitor, troubleshoot, and optimize Google Cloud environments using Cloud Monitoring and Cloud Logging.
- Understand the capabilities of Vertex AI and Google Cloud AI services for common business and operational use cases.
Google Cloud Platform Basics and Management
21 HoursThis instructor-led, live training in Argentina (online or onsite) 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.
Mastering Google Earth Pro
21 HoursThis guided live training in Argentina (available online or onsite) targets GIS professionals at the intermediate to advanced level who intend to learn how to utilize 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 interface and comprehend its various tools and options.
- Efficiently navigate the globe using Google Earth Pro, including the use of search functions, coordinates, and various view modes.
- Create, edit, and utilize placemarks, paths, and polygons to mark and analyze geographical locations.
- Use Google Earth Pro for advanced visualization, including 3D buildings, historical imagery, and street view integration.
Google Workspace for Commercial Managers
7 HoursThis instructor-led, live training in Argentina (online or onsite) targets beginner-level commercial managers who wish to leverage Google Workspace tools to enhance productivity, collaboration, and organization within their respective roles.
Upon completing this training, participants will be able to:
- Grasp the fundamentals of Google Workspace.
- Effectively schedule and manage meetings using Google Calendar.
- Confidently host, join, and manage virtual meetings, and utilize collaboration features such as screen sharing.
- Create professional documents, leverage collaboration features, and convert documents into various formats.
- Create, format, and share presentations, and collaborate with others on the same presentation.
Google Workspace: Communication, Collaboration, and Productivity
14 HoursGoogle Workspace is a comprehensive suite of cloud-based solutions designed to boost communication, teamwork, and efficiency in both corporate and educational settings. This hybrid training program integrates virtual and face-to-face sessions to equip participants with practical skills for effectively utilizing Gmail, Calendar, Meet, Drive, Docs, Sheets, Slides, and Chat/Gemini, supported by interactive exercises and guided practice.
Delivered as an instructor-led, live session (available online and on-site), this course is tailored for beginner to intermediate-level professionals looking to leverage Google Workspace to optimize team workflows and operational processes.
Upon completion of this training, participants will be able to:
- Efficiently organize and manage emails, events, and meetings using Gmail, Calendar, and Meet.
- Engage in real-time collaboration through Google Drive, Docs, Sheets, and Slides.
- Leverage communication tools such as Chat and Gemini to streamline team interactions.
- Create practical deliverables, including schedules, collaborative reports, dashboards, and presentations.
Course Format
- Blended learning approach: 2 hours of virtual instruction plus 12 hours of in-person training.
- Interactive lectures and group discussions.
- Hands-on exercises, team projects, and simulation activities.
- Video tutorials accompanied by guided virtual practice tasks.
Customization Options
- To request a customized version aligned with your organization’s specific workflows, please contact us to arrange.
Google Workspace (G Suite) Essentials
7 HoursGoogle Workspace offers a cloud-based suite of productivity and collaboration tools designed to streamline communication, file sharing, and team efficiency. This course introduces the essential apps and features to help participants work more efficiently and collaboratively.
This instructor-led, live training (available online or onsite) is tailored for beginner to intermediate users who want to maximize the potential of Google Workspace tools in their daily work and collaboration.
Upon completing this training, participants will be able to:
- Utilize Gmail for professional communications.
- Manage files securely in Google Drive.
- Conduct effective meetings via Google Meet.
- Collaborate in real time using 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.
Course Format
- Interactive lectures and discussions.
- Hands-on exercises and practice.
- Live demonstrations.
Customization Options
- To request a customized training for this course, please contact us to arrange.
Optimizing Analytics and Machine Learning with Google BigQuery
14 HoursGoogle BigQuery is a fully managed, serverless data warehouse that facilitates cost-effective query optimization, predictive analytics via BigQuery ML, and seamless data ingestion for analytical workflows. It is engineered for teams seeking to maximize query efficiency, develop machine learning models directly using SQL, and streamline reporting pipelines.
This instructor-led live training, available online or onsite, targets teams with a foundational understanding of SQL who aim to optimize queries, utilize BigQuery ML for predictive modeling, and enhance data ingestion and transformation processes for reporting.
Upon completing this training, participants will be equipped to:
- Optimize BigQuery queries to boost performance and lower costs.
- Employ BigQuery ML to construct, train, and assess predictive models.
- Design efficient data ingestion and transformation pipelines 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 a customized training session for this course, please contact us to make arrangements.
Operational Integration with Trello, QuickBooks, and Google Workspace
20 HoursThis program is tailored for organizations aiming to optimize their operations by connecting various digital platforms utilized in daily workflows, including Trello, QuickBooks, Google Workspace, and the WhatsApp API.
This instructor-led, live training session (available online or onsite) walks participants through the process of linking and automating workflows, thereby enhancing project and financial oversight while centralizing information to support better decision-making.
Upon completion of this training, participants will be capable of:
- Connecting and automating workflows between Trello, QuickBooks, and Google Workspace.
- Integrating WhatsApp API communication into operational workflows.
- Designing multi-platform automation systems focused on efficiency and control.
- Implementing security and monitoring policies for active integrations.
- Documenting and maintaining automated processes in operation.
Course Format
- 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.