Google Sheets - 1 Day Training Course
This course provides an introduction to Google Sheets, Google’s cloud-based spreadsheet solution included with Google Workspace.
Google Sheets allows you to create and edit spreadsheets directly in your web browser without the need for special software. Multiple users can work on the same document simultaneously, view each other’s changes in real time, and benefit from automatic saving. You will learn how to open Google Sheets, create a blank spreadsheet, and use a template to get started. You will also discover how to add, import, sort, filter, and format your data, as well as how to work across different file types. Formulas and functions enable quick calculations and more effective data usage. We will explore creating basic formulas, utilising functions, and referencing data. You will also learn how to add charts to visualise your data. Sharing Google Sheets spreadsheets is straightforward, and we will examine the various methods available for sharing. Additionally, we will discuss how to track changes and manage versions. Google Workspace facilitates seamless collaboration with your team, clients, and stakeholders, regardless of 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 South Africa 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?
southafrica@nobleprog.co.za or +27 (0)10 005 5793
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 South Africa (online or on-site) 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 South Africa (online or on-site) is tailored for data analysts wishing to use Google Analytics to track and report website data.
Upon completion of this training, participants will be able to:
- Configure Google Analytics to gather website data.
- Build and interpret reports.
- Derive insights and make data-driven decisions.
Architecting with Google Compute Engine
21 HoursThis three-day instructor-led programme introduces learners to the robust and adaptable infrastructure and platform services offered by Google Cloud Platform, with a primary emphasis on Compute Engine. Through a blend of instructional presentations, demonstrations, and practical hands-on labs, participants explore and deploy various solution components, including infrastructure elements such as networks, compute systems, and application services. The course also addresses the deployment of practical solutions, covering topics such as secure network interconnection, customer-supplied encryption keys, security and access management, quotas and billing, and resource monitoring.
Google BigQuery
28 HoursThis instructor-led, live training in South Africa (online or onsite) is aimed at advanced-level data analysts who wish to learn how to use Google BigQuery for data querying, optimisation, and machine learning integration.
By the conclusion of this training, participants will be able to:
- Grasp the fundamentals of Google BigQuery and its application in data analytics and cloud computing.
- Utilise Google BigQuery for data management and executing complex SQL queries.
- Apply query optimisation strategies to enhance performance.
- Integrate BigQuery with other Google Cloud services.
Google Certified Associate Cloud Engineer
35 HoursThis instructor-led, live training in South Africa (online or on-site) 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.
Google Cloud AutoML
7 HoursThis instructor-led live training in South Africa (online or onsite) is designed for data scientists, data analysts, and developers keen on exploring AutoML products and features to create and deploy custom ML training models with minimal effort.
Upon completion of this training, participants will be able to:
- Explore the AutoML product range to implement various services for different 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.
Google Cloud Platform Basics and Management
21 HoursThis trainer-led, live training in South Africa (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 HoursIn this programme, you will acquire highly sought-after skills that will make you job-ready in a remarkably short period. No degree or prior experience is required.
What you will learn
-
Grasp the significance of cybersecurity practices and their impact on organisations.
-
Identify common risks, threats, and vulnerabilities, as well as techniques to mitigate them.
-
Protect networks, devices, personnel, and data from unauthorised access and cyberattacks using Security Information and Event Management (SIEM) tools.
-
Gain hands-on experience with Python, Linux, and SQL.
Google Digital Marketing & E-commerce Professional
35 HoursKey Learning Outcomes
-
Master the fundamentals of digital marketing and e-commerce to acquire the skills required for securing an entry-level position.
-
Attract and engage customers via digital marketing channels such as search engines and email.
-
Assess marketing performance through analytics and effectively present key insights.
-
Establish e-commerce stores, analyse online performance metrics, and foster customer loyalty.
Google Docs - 1 Day
7 HoursWith Google Docs, your documents are stored in the cloud, and you can access them from any computer or device. You create and edit documents right in your web browser; no special software is required. Even better, multiple people can work at the same time, you can see people’s changes as they make them, and every change is saved automatically.
In this course, you will learn how to open Google Docs, create and format a new document, and apply a template to a new document. You will learn how to enhance your documents using a table of contents, headers and footers, tables, drawings, images, and more. You will learn how to share your documents with others. We will discuss your sharing options and examine collaborator roles and permissions. You will learn how to manage versions of your documents. Google Docs allows you to work in real time with others on the same document. You will learn how to create and manage comments and action items in your documents. We will review a few of the Google Docs tools. You will understand how to set your preferences to suit your own work style and explore how to use tools such as Google Explore to add value to your content.
Mastering Google Earth Pro
21 HoursThis instructor-led, live training in South Africa (online or onsite) is designed for intermediate to advanced GIS professionals eager to master Google Earth Pro for mapping, data visualisation, and geographic analysis.
Upon completion of this training, participants will be able to:
- Navigate the Google Earth Pro interface with confidence and understand the functionality of its various tools and options.
- Efficiently traverse the globe using Google Earth Pro, leveraging search functions, coordinates, and different view modes.
- Create, edit, and utilise placemarks, paths, and polygons to mark and analyse geographical locations.
- Leverage Google Earth Pro for advanced visualisation, including 3D buildings, historical imagery, and Street View integration.
Google IT Support Professional
35 HoursWhat you will learn
-
Acquire the essential skills needed to thrive in an entry-level IT role.
-
Master daily IT support duties, such as assembling computers, configuring wireless networks, installing software, and providing customer service.
-
Develop the ability to deliver comprehensive customer support, from problem identification to troubleshooting and debugging.
-
Gain proficiency in systems such as Linux, Domain Name Systems, Command-Line Interface, and Binary Code.
Google Kubernetes Engine (GKE)
14 HoursIn this instructor-led, live training in South Africa, participants will learn how to set up and manage a production-scale container environment using Kubernetes on Google Cloud.
By the end of this training, participants will be able to:
- Configure and manage Kubernetes on Google Cloud.
- Deploy, manage and scale a Kubernetes cluster.
- Deploy containerised (Docker) applications on Google Cloud.
- Migrate an existing Kubernetes environment from on-premise to Google Cloud.
- Integrate Kubernetes with third-party continuous integration (CI) software.
- Ensure high availability and disaster recovery in Kubernetes.
Google Maps API for Developers
14 HoursThis instructor-led, live training in South Africa (online or onsite) is aimed at developers who wish to enhance their website or web application by adding geo-location functionality through Google Maps.
By the end of this training, participants will be able to:
- Embed a map into a new or existing website or web application.
- Display live data that synchs with current location.
- Create a mashup that includes Google Maps.
- Apply good CSS and JavaScript coding practices.
- Create a custom map for an application.
Google Slides: Professional Presentation & Collaboration
7 HoursGoogle Slides empowers you to design and deliver polished presentations tailored for sales pitches, project updates, training modules, and various other professional needs.
All your Google Slides presentations are securely stored in the cloud, allowing you to build them directly within your web browser without the need for additional software. A key advantage is the ability for multiple users to work on the same slides simultaneously; you can view changes in real time as they occur, with every edit automatically saved. Throughout this course, you will learn to open Google Slides, initiate a blank presentation, and utilise pre-designed templates. You will delve into themes and layout options, exploring how to add and format content, as well as incorporate speaker notes. Enhancing your slides will be a core focus, covering the integration of tables, images, charts, and more. You will also master the use of slide transitions and object animations to create engaging visual effects. The curriculum covers slide organisation techniques, including duplicating and arranging slides, importing existing content, copying slides, and hiding specific sections. You will acquire skills in sharing presentations with others, managing collaborator permissions, tracking changes, and handling version control. Google Slides boasts numerous features that streamline team collaboration, and you will learn to leverage comments and action items for effective teamwork. As the ultimate objective is to present your work, you will explore various presentation tools and techniques for delivering your slides with confidence.