Course: Working with Google Sheets
duration: 15 hours |
Language: English (US) |
access duration: 180 days |
Details
Google Sheets is a web-based spreadsheet program from Google. With Google Sheets, you can create and edit spreadsheets anywhere, and collaborate with others on the same sheet at the same time. With Google Sheets, your data stands out in colorful charts. The built-in formulas, pivot tables, and conditional formatting options save a lot of time and make common spreadsheet tasks much easier.
This training offers you a good basic knowledge to work with Google Sheets.
In this training you will learn, among other things:
- Save workbooks as Excel, CSV or HTML file.
- Manage version history of a document.
- Tools for inserting, editing and modifying data.
- Use formatting tools in Google Sheets and insert and edit images and hyperlinks.
- Collaborate with others on a document.
- Search, sort and filter data.
- Using basic formulas.
- Using formulas to analyze and manage data.
Result
After following this training, you will have tools to work with Google Sheets.
Prerequisites
No specific prior knowledge is required. This training is suitable for people who have no experience with Google Sheets.
Target audience
End users, Everyone
Content
Working with Google Sheets
Google Sheets: Navigating & Configuring
Google Sheets is a web-based spreadsheet program from
- Google.
- Discover how to access the application and explore the Google
- Sheets home page. From this interface, learn how to open your
- spreadsheets for editing. You will also see how to customize the
- interface and spreadsheet view, and work with add-ons.
Google Sheets: Creating & Managing documents
Explore the basics of creating, saving and managing spreadsheets
in Google Sheets.
Discover the multiple ways and places to save your spreadsheet,
including on your computer and on Google Drive. Continue by
learning how to save a workbook as an Excel, CSV or HTML file.
See how to manage a document's version history, and recover unsaved
documents. Finally, learn how to configure your spreadsheet
settings before printing or saving it as a PDF file.
Google Sheets: Inserting & Managing data
This course focuses on inserting and managing data in your
worksheets.
Google Sheets includes a variety of tools for inserting, editing,
and customizing data. Learn how to insert data and how to create an
automatic list of numbers, dates, or codes. You will also see how
to select a cell or a cell range for copying and how to use the
'paste special' options to reuse formats or formulas.
Finally, learn how to insert data with the Explore tool and how to
improve your data with the Spelling tool.
Google Sheets: Formatting data
You can improve the appearance of your data by using the formatting tools in Google Sheets. Discover how to work with data types, apply color, align text, resize columns and rows, and use conditional formatting formulas.
Google Sheets: Enhancing your documents
Improve the display of your data using the insertion tools in Google Sheets. Discover how to add more columns, rows, and cells to insert more data in a worksheet. You will also learn how to manage and customize rows and columns by changing their size and applying borders.
Spreadsheets in Google Sheets do not have to contain only data. Explore various methods for inserting images, including how to create, insert, and edit drawings, as well as hyperlinks. All these tools can be useful for creating first-rate headers for your documents.
Google Sheets: Working with others on a document
Easily share spreadsheets with your colleagues using Google
Sheets collaboration features.
Discover how to share documents with others via email and select
the most suitable format for sharing your spreadsheet. If you
prefer to release your documents to a wider audience you can
publish your spreadsheet via a link or by embedding code in a
blog.
To work with other users in real-time, discover how to set up
sharing options for individuals or to create a link available for
anyone in your organization. You will also learn how to communicate
and interact with other editors, for example, by adding comments or
assigning tasks.
Google Sheets: Finding, Sorting & Filtering Data
There are times you may only want to work with particular data
in a spreadsheet. Discover how to use the Google Sheets tools to
easily find and replace data.
You will also learn how to sort your data and use filters to
display only the data you need.
Google Sheets includes other advanced options for sorting and
filtering data with colors and conditions.
In this course, you will discover other tools for filtering your
data, such as filter views and slicers. Finally, learn how to group
and ungroup your data to choose the information you want to
display.
Google Sheets: Referencing & Managing Data
While working in Google Sheets, you will often use a cell value
- in a formula or another location.
- Discover how to use absolute, mixed, and relative cell references
- in formulas or to extract values from other cells. These cell
- references will also be useful to create a formula with data from
- multiple sheets. Lastly, learn how to define data ranges for
- creating different types of menus using the data validation
- tool.
Google Sheets: Using Basic Formulas
This course will focus on manipulating data and performing basic
calculations using formulas in Google Sheets.
First, discover how to manually select and use formulas in a cell,
as well as to get access to the full list of functions available in
Google Sheets.
You will also see how to copy formulas to quickly fill out a table.
Other functions will allow you to rank, count, and round values in
a sheet. Google Sheets' functions are useful for manipulating text
as well. For example, to replace specific characters or a text
string. Finally, learn how to create formulas to generate random
numbers and remove whitespace.
Google Sheets: Using Formulas to Calculate & Manage Data
Discover how to use Google Sheets for common tasks like
- calculating the interest on a loan and comparing loans. This course
- will also teach you how to build formulas to find and manage
- duplicate values in your spreadsheets.
- Google Sheets includes built-in formulas to extract and analyze
- data. Learn how to work with some of these formulas on both data
- and text values, and use the LOOKUP and VLOOKUP formulas.
Google Sheets: Analyzing Data with Tables & Charts
Analyze data efficiently using the built-in features of Google
Sheets. In this course, you will discover how to analyze your data
with pivot tables and charts.
Learn how to work with pivot tables, including formatting, sorting,
filtering, adding calculated fields, and copying and exporting
pivot tables.
Another alternative to visually display your data is to use the
built-in chart features in Google Sheets. Learn how to create and
insert charts in your document.
Google Sheets: Using Different Types of Charts
Google Sheets offers a huge variety of different chart types and
- styles for presenting and analyzing your data in attractive and
- interesting ways.
- Learn how to insert, format, and manipulate Pie, Radar, Scatter,
- Bubble, Map, and Combo charts. You will also see how to share your
- charts by downloading a copy or publishing via a link or embedded
- code.
Google Sheets: Performing Conditional Calculations
Conditional formulas let you perform a calculation on a range of
- values by specifying the criteria that data must meet. Discover how
- to use the built-in conditional formulas and how to create your own
- conditional formulas in Google Sheets. In this course, you will
- also learn how to use conditional formulas to translate data or to
- keep your information up to date.
Google Sheets: Using Formulas to Obtain Data
Google Sheets includes built-in formulas to extract and analyze data. Discover how to work with some of these formulas on both numeric and text values, and how to use LOOKUP and VLOOKUP.
Course options
We offer several optional training products to enhance your learning experience. If you are planning to use our training course in preperation for an official exam then whe highly recommend using these optional training products to ensure an optimal learning experience. Sometimes there is only a practice exam or/and practice lab available.
Optional practice exam (trial exam)
To supplement this training course you may add a special practice exam. This practice exam comprises a number of trial exams which are very similar to the real exam, both in terms of form and content. This is the ultimate way to test whether you are ready for the exam.
Optional practice lab
To supplement this training course you may add a special practice lab. You perform the tasks on real hardware and/or software applicable to your Lab. The labs are fully hosted in our cloud. The only thing you need to use our practice labs is a web browser. In the LiveLab environment you will find exercises which you can start immediately. The lab enviromentconsist of complete networks containing for example, clients, servers,etc. This is the ultimate way to gain extensive hands-on experience.
Sign In
WHY_ICTTRAININGEN
Via ons opleidingsconcept bespaar je tot 80% op trainingen
Start met leren wanneer je wilt. Je bepaalt zelf het gewenste tempo
Spar met medecursisten en profileer je als autoriteit in je vakgebied.
Ontvang na succesvolle afronding van je cursus het officiële certificaat van deelname van Icttrainingen.nl
Krijg inzicht in uitgebreide voortgangsinformatie van jezelf of je medewerkers
Kennis opdoen met interactieve e-learning en uitgebreide praktijkopdrachten door gecertificeerde docenten
Orderproces
Once we have processed your order and payment, we will give you access to your courses. If you still have any questions about our ordering process, please refer to the button below.
read more about the order process
Een zakelijk account aanmaken
Wanneer u besteld namens uw bedrijf doet u er goed aan om aan zakelijk account bij ons aan te maken. Tijdens het registratieproces kunt u hiervoor kiezen. U heeft vervolgens de mogelijkheden om de bedrijfsgegevens in te voeren, een referentie en een afwijkend factuuradres toe te voegen.
Betaalmogelijkheden
U heeft bij ons diverse betaalmogelijkheden. Bij alle betaalopties ontvangt u sowieso een factuur na de bestelling. Gaat uw werkgever betalen, dan kiest u voor betaling per factuur.
Cursisten aanmaken
Als u een zakelijk account heeft aangemaakt dan heeft u de optie om cursisten/medewerkers aan te maken onder uw account. Als u dus meerdere trainingen koopt, kunt u cursisten aanmaken en deze vervolgens uitdelen aan uw collega’s. De cursisten krijgen een e-mail met inloggegevens wanneer zij worden aangemaakt en wanneer zij een training hebben gekregen.
Voortgangsinformatie
Met een zakelijk account bent u automatisch beheerder van uw organisatie en kunt u naast cursisten ook managers aanmaken. Beheerders en managers kunnen tevens voortgang inzien van alle cursisten binnen uw organisatie.
What is included?
Certificate of participation | Yes |
Monitor Progress | Yes |
Award Winning E-learning | Yes |
Mobile ready | Yes |
Sharing knowledge | Unlimited access to our IT professionals community |
Study advice | Our consultants are here for you to advice about your study career and options |
Study materials | Certified teachers with in depth knowledge about the subject. |
Service | World's best service |
Platform
Na bestelling van je training krijg je toegang tot ons innovatieve leerplatform. Hier vind je al je gekochte (of gevolgde) trainingen, kan je eventueel cursisten aanmaken en krijg je toegang tot uitgebreide voortgangsinformatie.
FAQ
Niet gevonden wat je zocht? Bekijk alle vragen of neem contact op.