Google Sheets - 1 Day Training Course
This course provides an introduction 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 additional software is needed. Multiple users can work simultaneously, view each other’s changes in real-time, and benefit from automatic saving. You will learn to open Google Sheets, create a new blank spreadsheet, and generate one from a template. You will also add, import, sort, filter, and format your data using Google Sheets and understand how to work across various file types. Formulas and functions enable quick calculations and improved data utilization. We will cover creating basic formulas, using functions, and referencing data. Additionally, you will learn how to insert charts into your spreadsheet. Sharing Google Sheets spreadsheets is straightforward. We will explore the various methods for sharing with others. We will also discuss tracking changes and managing different versions of your spreadsheets. Google Workspace facilitates collaboration with your team, clients, and others, regardless of their location. We will review the collaboration features available in Google Sheets, such as commenting, action items, and notifications.
This course is available as onsite live training in United Arab Emirates 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
Need help picking the right course?
uae@nobleprog.com or +971 4871 6715
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 live, instructor-led training in the UAE (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, accessible via the UAE (online or onsite), is designed for data analysts aiming to utilize Google Analytics for tracking and reporting website performance.
By the end of this training, participants will be able to:
- Configure Google Analytics to collect website data.
- Create and analyze reports.
- Gain insights and make data-driven decisions.
Architecting with Google Compute Engine
21 HoursThis three-day instructor-led course provides an introduction to the extensive and adaptable infrastructure and platform services offered by Google Cloud Platform, with a primary emphasis on Compute Engine. Through a blend of lectures, demonstrations, and practical labs, participants will explore and deploy various solution components, including infrastructure elements such as networks, systems, and application services. The curriculum also addresses the deployment of practical solutions, covering topics like secure network interconnection, customer-provided encryption keys, security and access management, quotas and billing, and resource monitoring.
Google BigQuery
28 HoursThis instructor-led live training in the UAE (online or onsite) is tailored for advanced-level data analysts eager to learn how to utilize Google BigQuery for data querying, optimization, and machine learning integration.
By the conclusion of this training, participants will be capable of:
- Understanding the fundamentals of Google BigQuery and its role in data analytics and cloud computing.
- Utilizing Google BigQuery for data management and complex SQL queries.
- Implementing 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 the UAE (online or onsite) targets intermediate-level IT professionals who wish to develop the skills required to deploy, manage, and operate workloads on Google Cloud and prepare for the Google Certified Associate Cloud Engineer certification.
By the end of 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 the UAE (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.
Google Cybersecurity Professional
35 HoursGain the in-demand skills that will make you job-ready in a short time through this program. No degree or prior experience is necessary.
What you'll learn
-
Comprehend the significance of cybersecurity practices and their effect on organizations.
-
Identify typical risks, threats, and vulnerabilities, along with strategies to mitigate them.
-
Use Security Information and Event Management (SIEM) tools to safeguard networks, devices, personnel, and data against unauthorized access and cyberattacks.
-
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 computer or device. You can create and edit documents directly in your web browser without needing any special software. Additionally, multiple users can work on the same document simultaneously, view changes as they happen, and benefit from automatic saving for every edit.
This course covers opening Google Docs, creating and formatting new documents, and applying templates. You will learn to enhance your documents using a table of contents, headers and footers, tables, drawings, images, and more. We will explore sharing options, including collaborator roles and permissions. You will also learn how to manage document versions, work in real-time with others, and handle comments and action items. The course includes a review of key Google Docs tools, setting preferences to match your work style, and utilizing features like Google Explore to add value to your content.
Mastering Google Earth Pro
21 HoursThis instructor-led, live training in the UAE (online or onsite) targets intermediate-to-advanced GIS professionals who wish to learn how to utilize Google Earth Pro for mapping, data visualization, and geographic analysis.
By the end of this training, participants will be able to:
- Navigate the Google Earth Pro interface and comprehend the functionality of its various tools and options.
- Efficiently explore 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.
- Utilize 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 the UAE (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: Communication, Collaboration, and Productivity
14 HoursGoogle Workspace is a comprehensive suite of cloud-based applications crafted to boost communication, teamwork, and efficiency in both corporate and educational settings. This hybrid training model integrates online and face-to-face sessions, equipping participants with actionable skills to effectively utilize Gmail, Calendar, Meet, Drive, Docs, Sheets, Slides, and Chat/Gemini through guided practice and hands-on exercises.
Delivered by an instructor via both online and onsite formats, this training targets professionals at beginner to intermediate levels who aim to leverage Google Workspace to optimize team workflows and operational processes.
Upon completion of this program, participants will be able to:
- Efficiently organize and manage emails, schedules, and meetings using Gmail, Calendar, and Meet.
- Engage in real-time collaboration through Google Drive, Docs, Sheets, and Slides.
- Utilize communication platforms like Chat/Gemini to streamline team interactions.
- Produce tangible deliverables such as schedules, collaborative reports, dashboards, and presentations.
Course Format
- Hybrid learning structure: 2 hours of virtual instruction plus 12 hours of in-person sessions.
- Interactive lectures paired with group discussions.
- Practical exercises, collaborative projects, and scenario-based simulations.
- Video tutorials accompanied by guided virtual practice activities.
Customization Options
- For a tailored version aligned with your organization’s specific workflows, please reach out to us to arrange.
Google Workspace (G Suite) Essentials
7 HoursGoogle Workspace is 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:
- Leverage Gmail for professional communications.
- Securely manage files within 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.
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 serves as a fully managed, serverless data warehouse that enables cost-effective query optimization, predictive analytics via BigQuery ML, and seamless data integration for analytic workflows. It is tailored for teams aiming to enhance query efficiency, develop machine learning models directly using SQL, and streamline reporting pipelines.
This instructor-led, live training (available online or onsite) targets teams possessing a foundational understanding of SQL who seek to refine query performance, leverage BigQuery ML for predictive modeling, and enhance data ingestion and transformation processes for reporting purposes.
Upon completion of this training, participants will be equipped to:
- Optimize BigQuery queries to boost performance and minimize expenses.
- Utilize BigQuery ML to construct, train, and assess predictive models.
- Design efficient pipelines for data ingestion and transformation tailored for reporting.
- Implement best practices for scaling analytics within Google BigQuery.
Course Format
- Interactive lectures and discussions.
- Practical labs utilizing Google BigQuery and BigQuery ML.
- Hands-on exercises focused on query optimization and pipeline design.
Customization Options
- To request a customized training session for this course, please contact us to arrange.
Operational Integration with Trello, QuickBooks, and Google Workspace
20 HoursThis course is tailored for organizations aiming to streamline their operations by connecting various digital platforms used in daily workflows, including Trello, QuickBooks, Google Workspace, and the WhatsApp API.
Delivered as an instructor-led live training (available online or on-site), this program guides participants through the process of linking and automating workflows, thereby enhancing project and financial oversight while centralizing data for better decision-making.
Upon completion of this training, participants will be able to:
- Connect and automate workflows across Trello, QuickBooks, and Google Workspace.
- Incorporate communication via the WhatsApp API 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.