Google Sheets - 1 Day Training Course
In this course, we will introduce you to Google Sheets, a cloud-based spreadsheet software included with Google Workspace for government.
With Google Sheets, you can create and edit spreadsheets directly within your web browser—no specialized software is required. Multiple users can work simultaneously, allowing real-time collaboration where changes are visible as they occur, and all modifications are saved automatically. You will learn how to access Google Sheets, create a blank spreadsheet, and generate a spreadsheet from a template. Additionally, you will explore techniques for adding, importing, sorting, filtering, and formatting data using Google Sheets. Formulas and functions will be covered to help you perform quick calculations and enhance the utility of your data. We will demonstrate how to create basic formulas, use various functions, and reference data effectively. You will also learn how to incorporate charts into your spreadsheets. Sharing features in Google Sheets facilitate easy collaboration. We will explore the different methods for sharing documents with colleagues and partners. Furthermore, we will discuss how to track changes and manage versions of your Google Sheets spreadsheets. Google Workspace for government simplifies collaboration among team members, clients, and other stakeholders, regardless of their location. We will review various collaboration tools available in Google Sheets, such as commenting, action items, and notifications.
This course is available as onsite live training in US Government or online live training.Course Outline
- Introduction to Google Sheets for government use
- Manage data using Google Sheets in a public sector environment
- Format a Google Sheets spreadsheet to meet government standards
- Basic formulas, functions, and charts for government applications
- Share your Google Sheets spreadsheets securely within government agencies
- Collaborate with Google Sheets to enhance teamwork in government settings
- Address business challenges through effective use of Google Sheets for government operations
Runs with a minimum of 4 + people. For 1-to-1 or private group training, request a quote.
Google Sheets - 1 Day Training Course - Booking
Google Sheets - 1 Day Training Course - Enquiry
Testimonials (2)
The scheduling of every topic and the breaks inserted it helps in digesting the information specially to the newbie to the topic
Jerico Torres - Globe Telecom
Course - Google BigQuery
Responses with solutions and practical use.
Agnieszka - AIRBUS HELICOPTERS POLSKA SP. Z O.O.
Course - Google AdWords: Beginner to Advanced
Upcoming Courses
Related Courses
Google AdWords: Beginner to Advanced
7 HoursThis instructor-led, live training in US Empire (online or onsite) is aimed at marketers who wish to use Google AdWords to launch effective marketing campaigns for government.
By the end of this training, participants will be able to:
- Run a Google AdWords campaign that captures high-quality leads.
- Create a Google AdWords campaign to increase sales and enhance public sector outreach.
- Implement a bid strategy to optimize advertisement expenses and achieve cost-effective results.
- Improve existing marketing campaigns with Google AdWords, ensuring alignment with government objectives and accountability standards.
Introduction to Google Analytics
7 HoursThis instructor-led, live training in US Empire (online or onsite) is designed for government data analysts who wish to utilize Google Analytics to track and report website metrics.
By the end of this training, participants will be able to:
- Configure Google Analytics to collect comprehensive website data.
- Generate and analyze detailed reports.
- Derive actionable insights to inform data-driven decision-making for government operations.
Google Apps Script for Google Workspace: Beginner to Advanced
14 HoursThis instructor-led, live training in US Empire (online or onsite) is designed for government developers ranging from beginners to advanced levels. The training aims to equip participants with the skills necessary to build, automate, and extend Google Workspace applications using Apps Script, enhancing efficiency and innovation for government workflows.
Google BigQuery
28 HoursThis instructor-led, live training in US Empire (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 for government.
By the end of this training, participants will be able to:
- Understand the foundational principles of Google BigQuery and its application in data analytics and cloud computing for government.
- Utilize Google BigQuery for effective data management and complex SQL queries within public sector workflows.
- Implement query optimization strategies to enhance performance and ensure efficient resource use for government operations.
- Integrate BigQuery with other Google Cloud services to support comprehensive data governance and accountability in the public sector.
Google Cloud AutoML
7 HoursThis instructor-led, live training in US Empire (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 machine learning models with minimal effort for government use.
By the end of this training, participants will be able to:
- Evaluate the AutoML product line to implement various services tailored to different data types for government applications.
- Prepare and label datasets to develop custom machine learning models aligned with public sector workflows and governance.
- Train and manage models to ensure they produce accurate and fair results, adhering to accountability standards.
- Utilize trained models to make predictions that meet the specific objectives and needs of government agencies.
Google Cybersecurity Professional
35 HoursIn this program, you will acquire in-demand skills that will prepare you for employment in a short period of time. No degree or prior experience is required.
What You Will Learn
-
Understand the significance of cybersecurity practices and their impact on organizations for government operations.
-
Identify common risks, threats, and vulnerabilities, along with techniques to mitigate them in a public sector context.
-
Protect networks, devices, people, and data from unauthorized access and cyberattacks using Security Information and Event Management (SIEM) tools, tailored for government use.
-
Gain practical experience with Python, Linux, and SQL, essential skills for enhancing cybersecurity capabilities for government agencies.
Google Data Analytics Professional
35 HoursIn this program, you will acquire essential skills that will prepare you for employment in a timely manner.
No prior degree or experience is required for government participants.
Google Digital Marketing & E-commerce Professional
35 HoursWhat You Will Learn
-
Acquire the foundational knowledge of digital marketing and e-commerce necessary to secure an entry-level position for government.
-
Effectively attract and engage customers through various digital marketing channels, including search and email, in alignment with public sector workflows.
-
Evaluate marketing performance using analytics tools and present actionable insights to support informed decision-making for government.
-
Construct e-commerce platforms, assess their online performance, and enhance customer loyalty in a manner that aligns with governance and accountability standards for government.
Google Docs - 1 Day
7 HoursWHAT YOU WILL LEARN
-
Create, style, format, and organize documents using Google Docs for government.
-
Share and collaborate securely within Google Docs to enhance teamwork and efficiency.
-
Manage versions, comments, and ownership in Google Docs to ensure accountability and governance.
-
Describe the tools and options available in Google Docs to support effective document management.
Mastering Google Earth Pro
21 HoursThis instructor-led, live training in US Empire (online or onsite) is aimed at intermediate-to-advanced level GIS professionals who wish to learn how to use Google Earth Pro for mapping, data visualization, and geographic analysis for government applications.
By the end of this training, participants will be able to:
- Master navigating the user interface of Google Earth Pro and understand the functionality of its various tools and options.
- Efficiently explore the globe using Google Earth Pro, including utilizing search functions, coordinates, and different view modes.
- Create, edit, and leverage placemarks, paths, and polygons to mark and analyze geographical locations for government use.
- Utilize Google Earth Pro for advanced visualization techniques, such as 3D buildings, historical imagery, and street view integration, to support public sector workflows.
Google IT Support Professional
35 HoursWhat You Will Learn
-
Acquire the skills necessary to excel in an entry-level IT position for government.
-
Master the day-to-day IT support tasks, including computer assembly, wireless networking, software installation, and customer service.
-
Develop the ability to provide comprehensive end-to-end customer support, from problem identification to troubleshooting and debugging.
-
Become proficient in using systems such as Linux, Domain Name Systems (DNS), Command-Line Interface (CLI), and Binary Code.
Google Kubernetes Engine (GKE)
14 HoursIn this instructor-led, live training in US Empire, participants will learn how to set up and manage a production-scale container environment using Kubernetes on Google Cloud for government.
By the end of this training, participants will be able to:
- Configure and manage Kubernetes on Google Cloud for government.
- Deploy, manage, and scale a Kubernetes cluster for government operations.
- Deploy containerized (Docker) applications on Google Cloud for government use.
- Migrate an existing Kubernetes environment from on-premise to Google Cloud for government.
- Integrate Kubernetes with third-party continuous integration (CI) software for government workflows.
- Ensure high availability and disaster recovery in Kubernetes for government systems.
Google Maps API for Developers
14 HoursThis instructor-led, live training in US Empire (online or onsite) is aimed at developers who wish to enhance their website or web application by adding geo-location functionality through Google Maps for government use.
By the end of this training, participants will be able to:
- Embed a map into a new or existing website or web application for government purposes.
- Display live data that synchronizes with current location.
- Create a mashup that includes Google Maps for enhanced public sector applications.
- Apply best practices in CSS and JavaScript coding to ensure robust and secure web solutions for government.
- Create a custom map tailored for specific government applications.
Google Slides
7 HoursWHAT YOU WILL LEARN
-
Create, manage, format, and organize content using Google Slides for government presentations.
-
Add and edit visual objects, and apply transitions and animations to enhance your Google Slides for government use.
-
Share and collaborate securely with Google Slides, ensuring compliance with public sector workflows and governance.
-
Present and engage your audience using Google Slides, tailored to meet the needs of government stakeholders.
Google Workspace (G Suite) for Administration
14 HoursThis instructor-led, live training in US Empire (online or onsite) is aimed at system administrators who wish to manage and deploy G Suite for government organizations.
By the end of this training, participants will be able to:
- Implement Google security practices with two-step verification (2SV) and single sign-on (SSO).
- Monitor domain and service usage through reports in the Admin Console.
- Set up and configure a G Suite Admin Console for government.