QA-QAGDFWADV

Ladda ner som PDF

Google Apps - Drive Advanced

This course follows on from your knowledge of the basic functionality of Google Drive and its suite of productivity tools, to dive a little deeper into using more of the advance features of Google Docs, Sheets and Slides. More advanced features of drawing and forms will also be covered.

Target Audience

This course is suitable for any individual who needs to use Google Drive to store, share, edit and collaborate on files. Using Google's productivity tools to a more advanced level. Attendees will learn about the more advanced features of Google apps, whether it be a document, spreadsheet or a presentation.

This course can be customised to meet your organisation's specific requirements or Google environment, please contact us for further details.

Prior knowledge

  • Attended the Experience Google Drive course, or have equivalent knowledge
  • Experience in web browsing
  • Some experience of working in Google apps is recommended
  • Basic skills with Microsoft Office applications, or equivalent

Objectives:

  • Work with some of the more advanced features of Google Docs including (but not restricted to) Tables, Charts, Table of Contents, Bookmarks and Page Breaks
  • Work with advanced features of Google Sheets, including advanced formulas and functions, filters, charts, PivotTables and sharing
  • Work with the advanced features of Google Slides, such as adding videos, tables, and animation to slides, as well as using presenter view and the drawing Tools
  • Work with the advanced features of forms, such as adding logic questions, sections and pages, as well as advanced settings
  • Investigate some useful add-ons available for the various Google Drive apps to enhance functionality

Course Outline:

Module 1 - Google Documents

  • Topic A - Creating Tables in Google Docs
  • Topic B - Inserting Images
  • Topic C - Inserting References
  • Topic D - Table of Contents
  • Topic E - Controlling Page Appearance
  • Topic F - Proofing a Document

Module 2 - Google Sheets

  • Topic A - Creating Advanced Formulas
  • Topic B - Calculate Data across Spreadsheets
  • Topic C - Using Specialised Functions
  • Topic D - Sorting and Filtering Data
  • Topic E - Creating Charts
  • Topic F - Introduction to Pivot Tables
  • Topic G - Data Validation
  • Topic H - Conditional Formatting
  • Topic I - Protection

Module 3 - Google Slides

Objectives:

  • Work with some of the more advanced features of Google Docs including (but not restricted to) Tables, Charts, Table of Contents, Bookmarks and Page Breaks
  • Work with advanced features of Google Sheets, including advanced formulas and functions, filters, charts, PivotTables and sharing
  • Work with the advanced features of Google Slides, such as adding videos, tables, and animation to slides, as well as using presenter view and the drawing Tools
  • Work with the advanced features of forms, such as adding logic questions, sections and pages, as well as advanced settings
  • Investigate some useful add-ons available for the various Google Drive apps to enhance functionality

Course Outline:

Module 1 - Google Documents

  • Topic A - Creating Tables in Google Docs
  • Topic B - Inserting Images
  • Topic C - Inserting References
  • Topic D - Table of Contents
  • Topic E - Controlling Page Appearance
  • Topic F - Proofing a Document

Module 2 - Google Sheets

  • Topic A - Creating Advanced Formulas
  • Topic B - Calculate Data across Spreadsheets
  • Topic C - Using Specialised Functions
  • Topic D - Sorting and Filtering Data
  • Topic E - Creating Charts
  • Topic F - Introduction to Pivot Tables
  • Topic G - Data Validation
  • Topic H - Conditional Formatting
  • Topic I - Protection

Module 3 - Google Slides

  • Topic A - Creating and Editing Tables
  • Topic B - Inserting Options
  • Topic C - Slide Master
  • Topic D - Animation and Transition


Module 4 - Forms

  • Topic A - Google Forms Applications Window
  • Topic B - Inserting Objects
  • Topic C - Creating a Form from Google Sheet Data
  • Topic D - Creating a Quiz

Module 5 - Drawings

  • Topic A - Creating Advanced Drawings
  • Topic B - Inserting Images

Module 6 - Google My Maps

  • Topic A - Creating and Customising a Map

Please note: for Attend from Anywhere customers an additional screen is required for this course to work through remote desktop labs and view training information.

Utbildningen levereras i samarbete med

Kursfakta

Kurs-ID: QA-QAGDFWADV
Längd: 2 dagar
Pris exkl moms: 10 500 kr
Inregistrering: 09.00
Kursstart: 09.30
Kursslut (ca): 17.00

Frågor om kursen?

Har du frågor om kursens innehåll, leveransdatum/ort eller behöver en företagsanpassad variant? Fyll i formuläret nedan!


Avtalsrabatter och kampanjer kan ej nyttjas på denna kurs.


Ort och datum

Cloud Access
i Läs mer

Delta på kursen från ditt hem, jobb eller annan plats.

30 mar-31 mar
Boka nu!
27 aug-28 aug
Boka nu!

Tipsa