Winkelwagen
U heeft geen artikelen in uw winkelwagen
Google Google Sheets E-learning
Google Sheets E-learning
€129,00

Goedkoper ergens anders?

Laat het ons weten!

+31367601019 [email protected]

Google Sheets E-learning

Merk: Google
|
Klik om te vergroten
€129,00 Excl. btw
€156,09 Incl. btw
  • Bestel 2 voor €126,42 per stuk en bespaar 2%
  • Bestel 3 voor €125,13 per stuk en bespaar 3%
  • Bestel 5 voor €119,97 per stuk en bespaar 7%
  • Bestel 10 voor €116,10 per stuk en bespaar 10%
  • Bestel 25 voor €109,65 per stuk en bespaar 15%
  • Bestel 50 voor €100,62 per stuk en bespaar 22%
  • Bestel 100 voor €90,30 per stuk en bespaar 30%
  • Bestel 200 voor €64,50 per stuk en bespaar 50%
Op voorraad
|
Bestel voor 16:00 uur en start vandaag.
Je hebt nog counting... uur
  • Bestellen op Factuur
  • Beste opleider 2019
  • Na Betaling Direct Starten
Cursusinhoud/-informatie

Google Sheets E-learning

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

Cursusinhoud

Google Sheets: Getting Started
Course: 17 Minutes
 
Accessing Google Sheets
Using the applicatio
Customizing your spreadsheet view
Customizing the application's display
Adding features to the application

Google Sheets: Creating, Opening & Saving Documents
Course: 48 Minutes
 
Creating & opening documents
Using templates
Importing a document
Saving your document
Organizing your sheets
Using the undo & redo tools
Protecting your document
Recovering a previous version of your document
Exporting your document in PDF format
Downloading a document to your computer
Printing your document

Google Sheets: Inserting & Manipulating Data
Course: 1 Hour, 7 Minutes

Selecting a cell
Inserting data into your cells
Deleting data from your spreadsheet
Creating automatic data lists
Hiding columns & rows
Moving data
Moving data from one sheet to another
Copying & pasting values
Transposing a data range
Adding headers
Using the spell-check
Freezing & unfreezing columns & rows
Inserting drop-down menus
Inserting menus with predefined options
Validating your data
Avoiding duplicate values

Google Sheets: Formatting Data
Course: 46 Minutes
 
Changing your cell's data type
Formatting data
Applying colors
Aligning your text
Inserting borders
Moving your formatted styles
Resizing your columns & rows
Inserting rows & columns into your spreadsheet
Using conditional formatting
Using advanced conditional formatting

Google Sheets: Illustrating Documents
Course: 22 Minutes
 
Inserting an image
Inserting a drawing
Editing your drawing
Inserting a hyperlink

Google Sheets: Finding, Sorting & Filtering Data
Course: 28 Minutes
 
Using the Find & Replace tool
Using the Find & Replace tools in a formula
Sorting the data in your spreadsheet
Filtering the data in your spreadsheet
Using the advanced filtering tools
Using filtered views

Google Sheets: Referencing Data
Course: 36 Minutes
 
Referencing cells
Choosing between absolute & relative cell references
Defining a new data range
Using data from several sheets
Calculating with constant values
Using cell references indirectly

Google Sheets: Basic Formulas
Course: 55 Minutes
Selecting & using formulas
Performing simple calculations
Repeating your formula within your spreadsheet
Creating automated cumulative totals
Changing number units
Factorizing the results of a division
Counting cells in a range
Ranking a value
Rounding a number
Using replacement formulas
Generating random numbers

Google Sheets: Charts & Graphs
Course: 1 Hour, 3 Minutes
 
Creating a quick chart
Inserting a chart
Customizing your chart
Customizing your chart's axes
Creating a pie chart
Creating a scatter chart
Creating a bubble chart
Creating a radar chart
Combining two types of charts
Placing data on a map
Creating a chart using symbols
Using Sparklines
Publishing your chart

Google Sheets: Pivot Tables
Course: 24 Minutes
 
Analyzing your data with a pivot table
Developing your pivot table
Sorting & filtering a pivot table
Adding calculated fields to your pivot table
Copying & exporting your pivot table
 

Google Sheets: Conditional Formulas
Course: 53 Minutes

Using conditional formulas
Inserting a conditional sum formula
Creating multiple conditions
Performing complex conditional formulas
Using IF & OR in conditional formulas
Using reference positions in conditional formulas
Keeping your table up to date with conditional formulas
Viewing data in different languages
Creating a multi-language version of your worksheet

Google Sheets: Solving Complex Problems with Formulas
Course: 33 Minutes

Calculating the interest on a loan
Comparing loans
Creating automatic reports
Finding duplicate values in your spreadsheet
Finding duplicates in your document
Managing duplicate entries

Google Sheets: Extracting Information with Formulas
Course: 1 Hour, 2 Minutes

Getting to know your data
Retrieving date information
Displaying information on your data
Retrieving information on your text
Finding the largest & smallest values in a list
Separating your data
Combining data
Comparing two lists
Inserting data automatically
Finding data in a database
Performing calculations using your database
Finding a value in a double entry table
Performing a search across two tables
Identifying errors in formulas

Google Sheets: Sharing & Collaboration Tools
Course: 25 Minutes

Adding a comment or note to your document
Sending your document via email
Publishing your document on the web
Adjusting the share settings for your document
Working with another user on the same document
Sending an email to your collaborators
Adjusting the discussion notification settings

Google Sheets: Creating, Opening & Saving Documents
Course: 53 Minutes

Creating & opening documents
Using templates
Importing a document
Saving your document
Organizing your sheets
Using the undo & redo tools
Protecting your document
Recovering a previous version of your document
Exporting your document in PDF format
Downloading a document to your computer
Printing your document
Creating custom templates

Google Sheets: Inserting & Manipulating Data
Course: 1 Hour, 26 Minutes

Selecting a cell
Inserting data into your cells
Deleting data from your spreadsheet
Creating automatic data lists
Hiding columns & rows
Moving data
Moving data from one sheet to another
Copying & pasting values
Transposing a data range
Adding headers & footers
Using the spell-check
Freezing & unfreezing columns & rows
Working with data via the Explore tool
Grouping data
Inserting drop-down menus
Inserting menus with predefined options
Validating your data
Avoiding duplicate values
Automating tasks with the Macro tool

Google Sheets: Basic Formulas
Course: 1 Hour

Selecting & using formulas
Performing simple calculations
Repeating your formula within your spreadsheet
Creating automated cumulative totals
Changing number units
Factorizing the results of a division
Counting cells in a range
Ranking a value
Rounding a number
Using replacement formulas
Generating random numbers
Inserting checkboxes

Google Sheets: Extracting Information with Formulas
Course: 1 Hour, 5 Minutes

Getting to know your data
Retrieving date information
Displaying information on your data
Retrieving information on your text
Finding the largest & smallest values in a list
Separating your data
Combining data
Comparing two lists
Inserting data automatically
Finding data in a database
Performing calculations using your database
Finding a value in a double entry table
Performing a search across two tables
Identifying errors in formulas
Customizing the formula options in your spreadsheet

Heeft u niet gevonden wat u zocht?
Laat ons helpen!
Specificaties
Algemene eigenschappen
Duur: 15 uur
Taal: Engels
Certificaat van deelname: Ja
Online toegang: 365 dagen
Voortgangsbewaking: Ja
Award Winning E-learning: Ja
Geschikt voor mobiel: Ja
Beoordelingen
5,0/5
average of 1 review(s)
Door: Jesse
Datum: 29/03/2020

Goede cursus, veel verschillende aspecten. Duidelijke uitleg

Schrijf uw beoordeling!
Schrijf uw beoordeling!




Wij slaan cookies op om onze website te verbeteren. Is dat akkoord? Ja Nee Meer over cookies »