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
Read more- Brand:
- 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.
- 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.
Loading...
OEM Office Elearning Menu Top 2 in ICT-trainingen 2024!
OEM Office Elearning Menu is trots op de tweede plaats in de categorie ICT-trainingen 2024 bij Beste Opleider van Nederland (Springest/Archipel). Dank aan al onze cursisten voor hun vertrouwen!
Reviews
There are no reviews written yet about this product.
