Course: Fundamentals of Google Sheets

$449.00
$543.29 incl. vat

duration: 15 hours |

Language: English (US) |

access duration: 90 days

In this course you get an introduction of the functions of Google Spreadsheet. You wil started with google sheets documents an learn how to use, inserting en manipulating data, illustrating documents, sorting and filtering data.

Finally you learn the basic formulas, pivot tables, solving complex problems with formulas and sharing collaboration tools and the best way to work with others on the same document.

Result

After completing this course you are familiar with the functions of Google spreadsheet and the best way how to use.

Prerequisites

There is no specific knowledge required.

Target audience

End users

Fundamentals of Google Sheets

15 hours

Google Sheets: Getting Started

Course_Description=<p>Google Sheets is a web-based spreadsheet program from Google. Discover how to access the application, explore and customize the interface and spreadsheet view, and work with add-ons.</p> TargetAudience= Duration=00:17

Google Sheets: Creating, Opening &amp; Saving Documents

Course_Description=<p>Get started working with Google Sheets documents. Discover how to create, open, import, save, and protect your spreadsheets, as well as how to export, download, and print your documents.</p> TargetAudience= Duration=00:48

Google Sheets: Inserting &amp; Manipulating Data

Course_Description=<p>Spreadsheets in Google Sheets are of little value without data. Discover how to insert, delete, copy, and move data; work with columns and rows; insert drop-down menus; avoid duplicate values; and validate your data.</p> TargetAudience= Duration=01:07

Google Sheets: Formatting Data

Course_Description=<p>You can improve the appearance of your data 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.</p> TargetAudience= Duration=00:46

Google Sheets: Illustrating Documents

Course_Description=<p>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 how to add hyperlinks.</p> TargetAudience= Duration=00:21

Google Sheets: Finding, Sorting &amp; Filtering Data

Course_Description=<p>There are times you may only want to work with particular data in a spreadsheet. Discover how to use the Google Sheets tools to find and replace data, sort data, and use filters and filter views to display only specific data.</p> TargetAudience= Duration=00:28

Google Sheets: Referencing Data

Course_Description=<p>A reference tells Google Sheets which cell or cells contain the needed values. Discover absolute, relative, and indirect cell references; how to use data from several sheets; and how to create data ranges and constant values.</p> TargetAudience= Duration=00:36

Google Sheets: Basic Formulas

Course_Description=<p>Manipulate data and perform calculations using formulas in Google Sheets. Discover how to select and use formulas; copy formulas; perform ranking, counting, and rounding; use replacement formulas on text; and generate random numbers.</p> TargetAudience= Duration=00:55

Google Sheets: Charts &amp; Graphs

Course_Description=<p>Display your data visually using the built-in charting features in Google Sheets. Discover how to create, insert, label, format, and publish charts, as well as how to use Sparklines.</p> TargetAudience= Duration=01:03

Google Sheets: Pivot Tables

Course_Description=<p>Analyze data efficiently using the built-in features of Google Sheets. Discover how to work with pivot tables, including formatting, sorting, filtering, adding calculated fields, and copying and exporting pivot tables.</p> TargetAudience= Duration=00:22

Google Sheets: Conditional Formulas

Course_Description=<p>Conditional formulas let you perform a calculation on a range of values by specifying criteria that data must meet. Discover how to use the built-in conditional formulas and how to create your own conditional formulas in Goggle Sheets.</p> TargetAudience= Duration=00:53

Google Sheets: Solving Complex Problems with Formulas

Course_Description=<p>Discover how to use Google Sheets for common tasks like calculating the interest on a loan, comparing loans, creating automatic reports, and finding and managing duplicate values in your documents.</p> TargetAudience= Duration=00:35

Google Sheets: Extracting Information with Formulas

Course_Description=<p>Google Sheets includes built-in formulas to extract and analyze data. Discover how to work with some of these formulas on both data and text values, and how to use LOOKUP and VLOOKUP.</p> TargetAudience= Duration=01:02

Google Sheets: Sharing &amp; Collaboration Tools

Course_Description=<p>Easily share spreadsheets with your colleagues using Google Sheets collaboration features. Discover how to share documents with others via email and online, and how to best work with others on the same document.</p> TargetAudience= Duration=00:25

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 immediatelyThe lab enviromentconsist of complete networks containing for example, clients, servers,etc. This is the ultimate way to gain extensive hands-on experience. 

Why OnlineITCourses.com?

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 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.

frequently asked quesions

What is included?

Duration 15 hours
Language English (US)
Certificate of participation Yes
Online access 90 days
Monitor Progress Yes
Award Winning E-learning Yes
Mobile ready Yes

Also included in world's #1 eLearning portal

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.
Platform Access to our platform.
Service World's best service

Life Long Learning

Follow multiple courses? Read more about our Life Long Learning concept

read more

Contact us

Need training advise? Contact us!


contact