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
Course: 17 Minutes
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
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
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 a drawing
Editing your drawing
Inserting a hyperlink
Google Sheets: Finding, Sorting & Filtering Data
Course: 28 Minutes
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
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
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
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
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
Laat ons helpen!
| Duur: | 15 uur |
| Taal: | Engels |
| Certificaat van deelname: | Ja |
| Online toegang: | 365 dagen |
| Voortgangsbewaking: | Ja |
| Award Winning E-learning: | Ja |
| Geschikt voor mobiel: | Ja |
Datum: 29/03/2020
Goede cursus, veel verschillende aspecten. Duidelijke uitleg
