Home » Google Sheets

Opleiding: Google Sheets

Bij: OEM Office Elearning Menu

 

OEM Office Elearning Menu

P.J, Oudweg 4
1314 CH ALMERE
 

Inhoud van de cursus

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 &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 commentnote 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

Toelatingseisen: wat heb je nodig?

Er is geen specifieke voorkennis vereist.

Duur van de cursus

15 uur

Bijzonderheden

Award Winning E-learning

Plaatsen / leslocaties

Heel Nederland, E-learning, Online

Algemene informatie over de cursus

Bestel deze geweldige, bekroonde Google Sheets e-learning cursus online, 1 jaar 24/7 toegang tot uitgebreide interactieve video's, toespraken, praktische taken en voortgangsbewaking. Na de cursus ontvang je een certificaat van deelname.

Duur: 15 uur
Taal: Engels
Certificaat van deelname: Ja
Online toegang: 365 dagen
Voortgangsbewaking: Ja
Award Winning E-learning: Ja
Geschikt voor mobiel: Ja

Informatie aanvragen

Gegevens aangeduid met een * zijn verplicht in te vullen.
jaar
 
resterend: tekens
 
0bE75 Typ de code exact over: (hoofdlettergevoelig)
 
Copyright 2009-2021 Particuliereopleidingen.nl | Algemene voorwaarden | Overzicht van onze aanbieders | Adverteren