Item number: 144842304

Google Sheets Cursus E-Learning

Item number: 144842304

Google Sheets Cursus E-Learning

129,00 156,09 Incl. tax

Google Sheets 2022 Award-winning E-Learning course Extensive interactive videos with spoken text Certified teachers Practical exercises Certificate

Brand:: Google Sheets

Discounts:

Buy 2 for €126,42 each and save 2%
Buy 3 for €125,13 each and save 3%
Buy 5 for €119,97 each and save 7%
Buy 10 for €116,10 each and save 10%
Buy 25 for €109,65 each and save 15%
Buy 50 for €100,62 each and save 22%
Buy 100 for €90,30 each and save 30%
Buy 200 for €64,50 each and save 50%

Availability:: In stock

Delivery time:: Ordered before 5 p.m.! Start today.

Startdate:

Student name (Multiple students, we will contact you):

Student email address:

Certificaat:

Award Winning E-learning
Lowest price guarantee
Personalized service by our expert team
Pay safely online or by invoice
Order and start within 24 hours

Google Sheets 2022 Course E-Learning

Order this E-Learning training Google Sheets 2022 ✓ Award-winning E-Learning course ✓ Extensive interactive videos with spoken text ✓ Certified teachers ✓ Practical exercises ✓ Certificate

Course content

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

Language	English
Qualifications of the Instructor	Certified
Course Format and Length	Teaching videos with subtitles, interactive elements and assignments and tests
Lesson duration	9:50 Hours
Progress monitoring	Yes
Access to Material	365 days
Technical Requirements	Computer or mobile device, Stable internet connections Web browsersuch as Chrome, Firefox, Safari or Edge.
Support or Assistance	Helpdesk and online knowledge base 24/7
Certification	Certificate of participation in PDF format
Price and costs	Course price at no extra cost
Cancellation policy and money-back guarantee	We assess this on a case-by-case basis
Award Winning E-learning	Yes
Tip!	Provide a quiet learning environment, time and motivation, audio equipment such as headphones or speakers for audio, account information such as login details to access the e-learning platform.

There are no reviews written yet about this 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.