Wir benutzen Cookies nur für interne Zwecke um den Webshop zu verbessern. Ist das in Ordnung? Ja Nein Für weitere Informationen beachten Sie bitte unsere Datenschutzerklärung. »

Google Sheets E-Learning Kurs

Google Sheets E-Learning Kurs

134,56 160,13 Inkl. MwSt.

Bestellen Sie diesen einzigartigen E-Learning Kurs Google Sheets online, 1 Jahr rund um die Uhr Zugriff auf umfangreiche interaktive Videos, Fortschritte durch Berichte und Tests.

Lesen Sie mehr
Marke:
Google
Verfügbarkeit:
Auf Lager
  • Award Winning E-learning
  • De laagste prijs garantie
  • Persoonlijke service van ons deskundige team
  • Betaal veilig online of op factuur
  • Bestel en start binnen 24 uur

Google Sheets E-Learning Ausbildung

Am besten dieses E-Learning Ausbildung Google Sheets ✓ Preisgekrönter E-Learning Kurs ✓ Umfangreiche interaktive Videos mit Kommentaren ✓ Zertifizierte Lehrer ✓ Praktische Übungen ✓ Zertifikat

Kursinhalt

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
Unterrichtsdauer 14:03 Stunde
Sprache Englisch
Online-Zugang 365 Tage
Teilnahmeurkunde Ja
Preisgekröntes Online-Training Ja

Es wurden noch keine Bewertungen für dieses Produkt abgegeben.

Bewertungen

Es wurden noch keine Bewertungen für dieses Produkt abgegeben.

Microsoft Office SCORM e-Learning

Wilt u Microsoft Office e-Learning SCORM hosten in het LMS van uw organisatie? Neem contact met ons op.

Bewertung der Schüler

Springest: 8.9, Edubookers: 8.5

Qualitätsgarantie

Preisgekröntes E-Learning & zertifizierte Tutoren

Microsoft Partner

und Certiport Partner

Nicht Gut, Geld Zurück

und eine Starter-Garantie