Google Sheets - 1 Day Training Course
This course introduces you to Google Sheets, Google’s cloud-based spreadsheet tool included with Google Workspace.
With Google Sheets, you can create and edit spreadsheets directly in your web browser—no special software is required. Multiple people can work simultaneously, you can see people’s changes as they make them, and every change is saved automatically. You will learn how to open Google Sheets, create a blank spreadsheet, and create a spreadsheet from a template. 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 allow you to make quick calculations and better use your data. We will look at creating a basic formula, using functions, and referencing data. You will also learn how to add a chart to your spreadsheet. Google Sheets spreadsheets are easy to share. We will look at the different ways you can share with others. We will also discuss how to track changes and manage versions of your Google Sheets spreadsheets. Google Workspace makes it easy to collaborate with your team, clients, and others wherever they are. We will look at some of the collaboration options available to you in Google Sheets. Examples include commenting, action items, and notifications.
This course is available as onsite live training in Serbia 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 Serbia (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 Serbia (online or onsite) is targeted at data analysts who wish to use Google Analytics to track and report website data.
By the end of this training, participants will be able to:
- Set up Google Analytics to collect website data.
- Create and analyze reports.
- Gain insights and make data-driven decisions.
Google BigQuery
28 HoursThis instructor-led live training in Serbia (online or onsite) is targeted 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.
Google Certified Associate Cloud Engineer
35 HoursThis instructor-led, live training held in Serbia (available online or onsite) targets intermediate-level IT professionals who aim to acquire the skills needed to deploy, manage, and operate workloads on Google Cloud while preparing for the Google Certified Associate Cloud Engineer certification.
Upon completion of this training, participants will be able to:
- Establish and manage Google Cloud projects, resources, networking, and storage services.
- Deploy and administer applications utilizing Compute Engine, Google Kubernetes Engine (GKE), Cloud Run, and App Engine.
- Configure identity and access management, security controls, billing budgets, alerts, and cost monitoring mechanisms.
- Provision and automate cloud infrastructure using Terraform and Cloud Build.
- Monitor, troubleshoot, and optimize Google Cloud environments through 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 Serbia (online or onsite) is designed for beginner-level IT professionals who wish to manage and operate the Google Cloud Platform.
Upon completion of this training, participants will be able to:
- Grasp the core services and infrastructure of GCP.
- Learn to manage networks and virtual machines.
- Understand and implement general security best practices within GCP.
- Explore Kubernetes and container management in GCP.
- Familiarize themselves with storage options and their configuration.
- Deploy and configure databases on GCP.
Google Cybersecurity Professional
35 HoursThis program equips you with highly sought-after skills that will prepare you for the workforce in a remarkably short period. No prior degree or professional experience is necessary.
Learning Outcomes
-
Comprehend the significance of cybersecurity practices and their effect on organizational success.
-
Recognize frequent risks, threats, and vulnerabilities, along with methods to mitigate them.
-
Safeguard networks, devices, personnel, and data against unauthorized access and cyberattacks by utilizing Security Information and Event Management (SIEM) tools.
-
Acquire practical experience with Python, Linux, and SQL.
Google Docs - 1 Day
7 HoursGoogle Docs stores your files in the cloud, allowing you to access them from any device or computer. You can create and edit documents directly in your web browser without needing additional software. Additionally, it supports simultaneous multi-user editing, allows you to view changes in real time, and automatically saves every update.
This course teaches you how to open Google Docs, create and format new documents, and apply templates. You will learn to enhance your work by adding tables of contents, headers and footers, tables, drawings, and images. The course also covers document sharing, including an analysis of sharing options, collaborator roles, and permissions. You will learn to manage document versions and leverage real-time collaboration features. Furthermore, you will discover how to create and manage comments and action items, review key Google Docs tools, configure preferences to match your workflow, and use features like Google Explore to add value to your content.
Mastering Google Earth Pro
21 HoursThis instructor-led live training in Serbia (online or onsite) targets intermediate-to-advanced level GIS professionals who wish to learn how to use Google Earth Pro for mapping, data visualization, and geographic analysis.
By the end of this training, participants will be able to:
- Navigate the user interface of Google Earth Pro and understand the functionality of 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 Serbia (online or onsite) is designed for beginner-level commercial managers seeking to utilize 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: Communication, Collaboration, and Productivity
14 HoursGoogle 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.
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 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.
Optimizing Analytics and Machine Learning with Google BigQuery
14 HoursGoogle BigQuery is a fully managed, serverless data warehouse designed to support cost-efficient query optimization, predictive analytics via BigQuery ML, and seamless data ingestion for robust analytics workflows. It empowers teams to maximize query efficiency, construct machine learning models directly using SQL, and streamline their reporting pipelines.
This instructor-led live training, available both online and onsite, targets teams with a foundational understanding of SQL who aim to optimize query performance, leverage BigQuery ML for predictive modeling, and enhance data ingestion and transformation processes for reporting.
Upon completing this training, participants will be capable of:
- Optimizing BigQuery queries to boost performance and minimize costs.
- Utilizing BigQuery ML to create, train, and assess predictive models.
- Designing efficient data ingestion and transformation pipelines for reporting.
- Applying best practices for scaling analytics within Google BigQuery.
Course Format
- Interactive lectures and discussions.
- Hands-on labs utilizing Google BigQuery and BigQuery ML.
- Practical exercises focused on query optimization and pipeline design.
Course Customization Options
- To arrange customized training for this course, please contact us.
Operational Integration with Trello, QuickBooks, and Google Workspace
20 HoursDesigned for organizations aiming to streamline daily operations, this course focuses on integrating key digital platforms such as Trello, QuickBooks, Google Workspace, and the WhatsApp API.
Through this instructor-led live training, available both online and onsite, participants will learn to connect and automate workflows. The curriculum emphasizes enhancing project oversight, financial control, and information centralization to support better decision-making.
Upon completion, participants will be equipped to:
- Establish and automate workflows between Trello, QuickBooks, and Google Workspace.
- Incorporate WhatsApp API communications into operational processes.
- Construct multi-platform automation systems tailored for efficiency and control.
- Apply security measures and monitoring policies to active integrations.
- Document and sustain automated processes for long-term use.
Course Format
- Conceptual instruction combined with guided demonstrations.
- Practical exercises grounded in real-world operational scenarios.
- Hands-on practice utilizing company-specific data and tools.
Customization Options
- Tailoring content to align with your organization’s specific platforms and workflows.
- Incorporating additional tools such as Zapier, Make/Integromat, or Power Automate.
- Analyzing and designing integration flows using actual company data.