Google Apps Fundamentals
Understanding Google Apps from the basics
Our Google Apps online course is designed to give you the skills to use google cloud applications efficiently and understand key functions. From using Google Docs, Google Slides, Google Sheets and more you will improve your productivity.
-
Online Learning
-
Study at your own pace
-
67 Part course
-
6 CPD hours per course
-
12 Months unlimited access
-
Instant access, start NOW!
Google Apps
Online Learning
67-part course
Instant Access to Online Learning -
Sign Up & Start Now
$199
Gmail account required (free version)
Paying by direct debit? - Click here. Access granted once funds cleared for this method.
Bundle Offer Google Apps & Google Sheets Advanced
Both Courses
Instant Access to Online Learning -
Sign Up & Start Now
$295
Gmail account required (free version)
Paying by direct debit or cheque? - Click here. Access granted once funds cleared for this method.
Course content - 67 Tutorials - 5 hrs 24 Min 45 Sec
2-1 Google Docs - Signing in and creating a document 2:55
2-2 Navigating in Google Docs 5:31
2-3 Google Docs - Naming, saving and accessing a document 2:58
2-4 Google Docs - Creating, renaming and moving a document 4:26
2-5 Google Docs - Changing document editing modes 2:29
2-6 Google Docs - Creating paragraphs and tabs 6:45
2-7 Google Docs - Formatting text using Styles 6:42
2-8 Google Docs - Adding bullets and numbers 3:09
2-9 Google Docs - Changing line spacing 2:40
2-10 Google Docs - Using Cut, Copy and Paste to duplicate and move text 4:40
2-11 Google Docs - Working with headers, footers and page numbers 5:29
2-12 Google Docs - Inserting, resizing and moving and image 6:30
2-13 Google Docs - Inserting a Google Drawing 5:22
2-14 Google Docs - Setting page margins, orientation and colour 1:56
2-15 Google Docs - Printing a document 3:57
2-16 Google Docs - Emailing a document 2:44
2-17 Google Docs - Sharing a document with others 3:39
3-1 Google Slides - Creating a blank presentation and adding text and pictures 2:55
3-2 Google Slides - Adding, removing and rearranging slides 3:42
3-3 Google Slides - Formatting text 4:35
3-4 Google Slides - Change the slide layout and background 4:43
3-5 Google Slides - Adding text boxes 3:46
3-6 Google Slides - Adding and aligning images and shapes 9:49
3-7 Google Slides - Changing object layering and grouping 3:06
3-8 Google Slides - Applying masks to images 3:25
3-9 Google Slides - Adding video and diagrams 8:59
3-10 Google Slides - Creating a chart 7:45
3-11 Google Slides - Add slide transistions and animations 3:31
3-12 Google Slides - Adding speaker notes 2:35
3-13 Google Slides - Sharing Slides 2:58
3-14 Google Slides - Viewing previous slide revisions 3:50
3-15 Google Slides - Printing, emailing and downloading slides 5:16
3-16 Google Slides - Using Presenter view and running a presentation 4:29
4-1 Google Sheets - Creating a new spreadsheet and entering text, numbers and dates 6:57
4-2 Google Sheets - Copying, moving and deleting a spreadsheet4:15
4-3 Google Sheets - Editing cell content4:37
4-4 Google Sheets - Applying text and column formatting6:59
4-5 Google Sheets - Formatting cell colour, numbers and dates6:58
4-6 Google Sheets - Inserting and deleting columns, duplicting, deleting and renaming sheets4:58
4-7 Google Sheets - Using Cut, Copy, Paste and Fill6:14
4-8 Google Sheets - Using Find and Replace3:21
4-9 Google Sheets - Addition and Division6:23
4-10 Google Sheets - Multiply and Divide6:55
4-11 Google Sheets - Using the SUM function to calculate totals5:18
4-12 Google Sheets - Calculating an average4:23
4-13 Google Sheets - Using the Count, Min and Max Functions5:57
4-14 Google Sheets - Printing and viewing sheets6:26
5-1 Navigating in Gmail 3:48
5-2 Gmail - Creating and sending email 2:09
5-3 Gmail - Adding recipients (CC, BCC) 3:35
5-4 Gmail - Sending Google Drive links and attaching files to emails 4:04
5-5 Gmail - Setting email options 4:18
5-6 Gmail - Replying to and forwarding email 3:01
5-7 Gmail - Selecting, deleting and marking messages as unread 2:37
5-8 Google Contacts - Creating a contact Page 3:01
5-9 Google Contacts - Adding details to contacts Page 3:01
5-10 Google Contacts - Importing contacts from other sources Page 3:01
5-11 Google Calendar - Creating an event with reminders and inviting guests7:06
5-12 Google Calendar - Sharing a calendar3:23
5-13 Google Calendar - Adding another person's shared calendar3:23
Google Sheets Advanced
Understanding Google Sheets from the basics to advanced
Our Google Sheets course is designed to give the new spreadsheet user the skills to start using Google Sheets in the workplace. From using simple formulas such as the SUM function to formatting data and the basics of spreadsheets.
This course is perfect for those transitioning from Excel to Google Sheets as well.
-
Online Learning
-
Study at your own pace
-
52 Part course
-
6 CPD hours per course
-
12 Months unlimited access
-
Instant access, start NOW!
Google Sheets
Online Learning
52-part course
Instant Access to Online Learning -
Sign Up & Start Now
$199
Paying by direct debit or cheque? - Click here. Access granted once funds cleared for this method.
Bundle Offer Google Apps & Google Sheets Advanced
Both Courses
Instant Access to Online Learning -
Sign Up & Start Now
$295
Paying by direct debit or cheque? - Click here. Access granted once funds cleared for this method.
Course content - 52 Tutorials - 5 hrs 30 Min 15 Sec
1 Google Sheets Advanced Introduction 1:33
1-1 Google Sheets Advanced - Accessing Google Sheets and Basic Google Sheets Operations 7:33
1-2 Google Sheets Advanced - Applying text and column formatting 7:00
1-3 Google Sheets Advanced - Cut, Copy, Paste and Fill 6:15
1-4 Google Sheets Advanced - Basic Formulas and Functions - Multiply and Divide 6:58
1-5 Google Sheets Advanced - Basic Formulas and Functions - Addition and Division 6:23
1-6 Google Sheets Advanced - Basic Formulas and Functions - Using SUM and AVERAGE functions 9:01
2-1 Google Sheets Advanced - Creating a named range and using in a formula 5:02
2-2 Google Sheets Advanced - Using the IF function to test for a condition 6:48
2-3 Google Sheets Advanced - Nested IF Function using IF, OR and AND functions 11:55
2-4 Google Sheets Advanced - Creating totals from another sheet 3:35
2-5 Google Sheets Advanced - Creating a total with data from another spreadsheet 8:59
2-6 Google Sheets Advanced - Using Vlookup, Index and Match to find statuses in a table 14:45
2-7 Google Sheets Advanced - Using an array with Vlookup 10:29
2-8 Google Sheets Advanced - Extracting and combining characters with Concatenate, Left, Mid and Right functions 6:39
4-1 Google Sheets Advanced - Importing a Comma Separated Values file 4:33
4-2 Google Sheets Advanced - Import and link to data from another spreadsheet 6:57
4-3 Google Sheets Advanced - Split data into columns 3:26
4-4 Google Sheets Advanced - Cleaning up imported dates using the Date, Left, Right and Mid functions 10:07
4-5 Google Sheets Advanced - Repeating data using IFS and ISBLANK functions 8:28
4-6 Google Sheets Advanced - Combining data into a single cell using Join and Trim 6:01
4-7 Google Sheets Advanced - Creating an index column using Vlookup and Unique functions 11:02
4-8 Google Sheets Advanced - Creating a filter and using custom formulas 6:42
4-9 Google Sheets Advanced - Creating a filter using the filter function 05:19
4-10 Google Sheets Advanced - Create a filter view 4:12
4-11 Google Sheets Advanced - Duplicating, renaming and deleting filter views 4:40
4-12 Google Sheets Advanced - Sorting a list by one column 3:46
4-13 Google Sheets Advanced - Calculating a single subtotal 5:16
6-1 Google Sheets Advanced - Highlighting duplicate numberic values using Conditional Formatting 8:33
6-2 Google Sheets Advanced - Creating an interactive form with checkboxes 5:55
6-3 Google Sheets Advanced - Applying a custom number and date format 9:24
6-4 Google Sheets Advanced - Creating a sparkline using the function 5:26
6-5 Google Sheets Advanced - Creating a sparkline using Insert Chart 2:59
8-1 Google Sheets Advanced - Sharing a spreadsheet with other people 5:41
8-2 Google Sheets Advanced - Editing a shared spreadsheet in real time 5:29
8-3 Google Sheets Advanced - Viewing, copying and naming versions of a spreadsheet 4:18
8-4 Google Sheets Advanced - Adding, Deleting and Sending comments 4:58
8-5 Google Sheets Advanced - Emailing spreadsheet collaborators 2:42
8-6 Google Sheets Advanced - Chatting with other spreadsheet users 3:47
8-7 Google Sheets Advanced - Publishing a spreadsheet to the internet 3:35
Customised Group Training
Customised Group Training is available for G Suite.
- Training Needs Analysis
- Use our computer training rooms venue in Perth CBD at no additional cost
- Class sizes 2 to 24 attendees
- Includes all resources electronic manual for each attendee or hard copy additional
Please email us for comprehensive details and a proposal on how we can make your next corporate training event a success.
Complete Online Google Course Bundle - Both Courses $295 - RRP $398
-
Over 10 hours on-demand tutorials
-
Study at your own pace
-
Detailed online training manuals
-
6 CPD hours per course
-
12 Months unlimited access
-
Access anytime
-
Certificates of completion
