Artikelnummer: 144842304

Google Sheets Cursus E-Learning

Artikelnummer: 144842304

Google Sheets Cursus E-Learning

129,00 156,09 Incl. btw

Google Sheets 2022 Bekroonde E-Learning cursus Uitgebreide interactieve video's met gesproken tekst Gecertificeerde docenten Praktische oefeningen Certificaat

Lees meer

Merk:: Google Sheets

Kortingen:

Koop 2 voor €126,42 per stuk en bespaar 2%
Koop 3 voor €125,13 per stuk en bespaar 3%
Koop 5 voor €119,97 per stuk en bespaar 7%
Koop 10 voor €116,10 per stuk en bespaar 10%
Koop 25 voor €109,65 per stuk en bespaar 15%
Koop 50 voor €100,62 per stuk en bespaar 22%
Koop 100 voor €90,30 per stuk en bespaar 30%
Koop 200 voor €64,50 per stuk en bespaar 50%

Beschikbaarheid:: Op voorraad

Levertijd:: Voor 17:00 uur besteld! Start vandaag. Gratis Verzending.

Startdatum:

Naam Cursist (Meerdere cursisten, wij nemen contact met u op):

E-mailadres cursist:

Certificaat van deelname::

Award Winning E-learning
De laagste prijs garantie
Persoonlijke service van ons deskundige team
Betaal veilig online of op factuur
Bestel en start binnen 24 uur

Google Sheets 2022 Cursus E-Learning Training

Beste deze E-Learning training Google Sheets 2022 ✓ Bekroonde E-Learning cursus ✓ Uitgebreide interactieve video's met gesproken tekst ✓ Gecertificeerde docenten ✓ Praktische oefeningen ✓ Certificaat

Cursusinhoud

Getting started in Google Sheets 2022

Course: 28 Minutes

Overview: Using functions in Sheets 2022
Creating a named function in Sheets 2022
Working with the LAMBDA function in Sheets 2022
Using the MAP & REDUCE functions in Sheets 2022
Using the BYROW & BYCOL functions in Sheets 2022
Using the SCAN function in Sheets 2022
Using the MAKEARRAY function in Sheets 2022
Using the XLOOKUP function in Sheets 2022
Using the XMATCH function in Sheets 2022

Creating & managing sheets in Google Sheets 2022

Course: 45 Minutes

Overview: Using functions in Sheets 2022
Creating a named function in Sheets 2022
Working with the LAMBDA function in Sheets 2022
Using the MAP & REDUCE functions in Sheets 2022
Using the BYROW & BYCOL functions in Sheets 2022
Using the SCAN function in Sheets 2022
Using the MAKEARRAY function in Sheets 2022
Using the XLOOKUP function in Sheets 2022
Using the XMATCH function in Sheets 2022

Inserting & managing data in Google Sheets 2022

Course: 43 Minutes

Overview: Using functions in Sheets 2022
Creating a named function in Sheets 2022
Working with the LAMBDA function in Sheets 2022
Using the MAP & REDUCE functions in Sheets 2022
Using the BYROW & BYCOL functions in Sheets 2022
Using the SCAN function in Sheets 2022
Using the MAKEARRAY function in Sheets 2022
Using the XLOOKUP function in Sheets 2022
Using the XMATCH function in Sheets 2022

Formatting data in Google Sheets 2022

Course: 40 Minutes

Overview: Using functions in Sheets 2022
Creating a named function in Sheets 2022
Working with the LAMBDA function in Sheets 2022
Using the MAP & REDUCE functions in Sheets 2022
Using the BYROW & BYCOL functions in Sheets 2022
Using the SCAN function in Sheets 2022
Using the MAKEARRAY function in Sheets 2022
Using the XLOOKUP function in Sheets 2022
Using the XMATCH function in Sheets 2022

Enhancing documents in Google Sheets 2022

Course: 46 Minutes

Overview: Enhancing documents in Sheets 2022
Inserting rows & columns
Resizing your columns & rows
Hiding columns & rows
Freezing & unfreezing columns & rows
Inserting an image
Inserting a drawing
Editing your drawing
Inserting a hyperlink
Inserting people chips
Inserting borders
Adding headers
Knowledge Check: Enhancing documents in Sheets 2022

Collaborating on a document in Google Sheets 2022

Course: 44 Minutes

Overview: Collaborating on a document in Sheets 2022
Publishing your document on the web
Sending your document via email
Protecting your document
Sharing a spreadsheet
Adjusting sharing options
Working with other users on the same document
Inserting comments in your document
Assigning tasks
Managing comments
Knowledge Check: Collaborating on a document in Google Sheets 2022

Finding & filtering data in Sheets 2022

Course: 42 Minutes

Overview: Finding & filtering data in Sheets 2022
Using the Find & Replace tools
Using the Find & Replace tools in a formula
Sorting the data in your spreadsheet
Filtering the data in your spreadsheet
Using the advanced filtering options
Sorting and filtering data with colors
Using filtered views
Using slicers
Customizing slicers
Grouping data
Knowledge Check: Finding & filtering data in Sheets 2022

Using data in Sheets 2022

Course: 54 Minutes

Overview: Using data in Sheets 2022
Referencing cells in Sheets 2022
Using absolute, mixed & relative cell references in Sheets 202
Defining a new data range in Sheets 2022
Using data from multiple sheets in Sheets 2022
Calculating with constant values in Sheets 2022
Using cell references indirectly in Sheets 2022
Inserting drop-down menus in Sheets 2022
Inserting menus with predefined options in Sheets 2022
Validating your data in Sheets 2022
Inserting checkboxes in Sheets 2022
Viewing embedded Office files in Sheets 2022

Managing & calculating data in Sheets 2022

Course: 46 Minutes

Overview: Managing & calculating data in Sheets 2022
Calculating the interest on a loan in Sheets 2022
Comparing loans in Sheets 2022
Finding duplicate values in your spreadsheet in Sheets 20223
Counting the total number of duplicates in Sheets 2022
Managing duplicate entries in Sheets 2022
Avoiding duplicate values in Sheets 2022
Finding data in a database in Sheets 2022
Performing calculations using your database in Sheets 2022
Finding a value in a double-entry table in Sheets 2022
Performing a search across two tables in Sheets 2022

Using basic formulas in Sheets 2022

Course: 47 Minutes

Overview: Managing & calculating data in Sheets 2022
Calculating the interest on a loan in Sheets 2022
Comparing loans in Sheets 2022
Finding duplicate values in your spreadsheet in Sheets 2022
Counting the total number of duplicates in Sheets 2022
Managing duplicate entries in Sheets 2022
Avoiding duplicate values in Sheets 2022
Finding data in a database in Sheets 2022
Performing calculations using your database in Sheets 2022
Finding a value in a double-entry table in Sheets 2022
Performing a search across two tables in Sheets 2022

Using functions in Sheets 2022

Course: 32 Minutes

Overview: Using functions in Sheets 2022
Creating a named function in Sheets 2022
Working with the LAMBDA function in Sheets 2022
Using the MAP & REDUCE functions in Sheets 2022
Using the BYROW & BYCOL functions in Sheets 2022
Using the SCAN function in Sheets 2022
Using the MAKEARRAY function in Sheets 2022
Using the XLOOKUP function in Sheets 2022
Using the XMATCH function in Sheets 2022

Using formulas to get data in Sheets 2022

Course: 40 Minutes

Overview: Using formulas to get data in Sheets 2022
Getting to know your data in Sheets 2022
Retrieving date information in Sheets 2022
Displaying & retrieving information about your data in Sheets 2022
Finding the largest & smallest values in a list in Sheets 2022
Separating your data in Sheets 2022
Combining data in Sheets 2022
Comparing two lists in Sheets 2022
Inserting data automatically in Sheets 2022
Identifying errors in formulas in Sheets 2022

Using charts in Sheets 2022

Course: 41 Minutes

Overview: Using charts in Sheets 2022
Creating a pie chart in Sheets 2022
Creating a scatter chart in Sheets 2022
Creating a bubble chart in Sheets 2022
Creating a radar chart in Sheets 2022
Creating a table chart in Sheets 2022
Combining two types of charts in Sheets 2022
Placing data on a map in Sheets 2022
Using Sparklines in Sheets 2022
Publishing your chart in Sheets 2022

Analyzing tables & customizing charts in Sheets 2022

Course: 47 Minutes

Overview: Analyzing tables & customizing charts in Sheets 2022
Analyzing your data with a pivot table in Sheets 2022
Developing your pivot table in Sheets 2022
Sorting & filtering a pivot table in Sheets 2022
Adding calculated fields to your pivot table in Sheets 2022
Copying & exporting your pivot table in Sheets 2022
Creating a quick chart in Sheets 2022
Editing a chart in Sheets 2022
Customizing your chart in Sheets 2022
Customizing your chart's axes in Sheets 2022
Connecting a sheet to BigQuery in Sheets 2022
Managing your connected sheet in Sheets 2022

Performing calculations in Sheets 2022

Course: 41 Minutes

Overview: Performing calculations in Sheets 2022
Using conditional formulas in Sheets 2022
Inserting a conditional sum formula in Sheets 2022
Creating multiple conditions in Sheets 20224
Performing complex conditional formulas in Sheets 2022
Using IF, OR & AND in conditional formulas in Sheets 2022
Viewing data in different languages in Sheets 2022
Using reference positions in conditional formulas in Sheets 2022
Keeping your table updated with conditional formulas in Sheets 2022
Creating automatic reports in Sheets 2022

Taal	Engels
Kwalificaties van de Instructeur	Gecertificeerd
Cursusformaat en Lengte	Lesvideo's met ondertiteling, interactieve elementen en opdrachten en testen
Lesduur	9:50 uur
Voortgangsbewaking	Ja
Toegang tot Materiaal	365 dagen
Technische Vereisten	Computer of mobiel apparaat, Stabiele internetverbindingen Webbrowserzoals Chrome, Firefox, Safari of Edge.
Support of Ondersteuning	Helpdesk en online kennisbank 24/7
Certificering	Certificaat van deelname in PDF formaat
Prijs en Kosten	Cursusprijs zonder extra kosten
Annuleringsbeleid en Geld-Terug-Garantie	Wij beoordelen dit per situatie
Award Winning E-learning	Ja
Tip!	Zorg voor een rustige leeromgeving, tijd en motivatie, audioapparatuur zoals een koptelefoon of luidsprekers voor audio, accountinformatie zoals inloggegevens voor toegang tot het e-learning platform.

Er zijn nog geen reviews geschreven over dit product.

OEM Office Elearning Menu Genomineerd voor 'Beste Opleider van Nederland'

OEM Office Elearning Menu is trots genomineerd te zijn voor de titel 'Beste Opleider van Nederland' door Springest, een onderdeel van Archipel. Deze erkenning bevestigt onze kwaliteit en toewijding. Hartelijk dank aan al onze cursisten.