Introduction Welcome 00:00:57
What's new? 00:00:55
Using the exercise files 00:00:45
1. Getting Started Introducing Google Apps 00:02:23
Creating and managing your Google account 00:02:56
Exploring supported documents 00:01:38
2. Navigating the Documents List Understanding the interface 00:03:03
Sorting and filtering the Documents list 00:04:00
Searching the Documents list 00:02:39
3. Organizing Documents with Collections (Folders) Creating collections (folders) 00:03:01
Sharing collections (folders) 00:02:55
4. Uploading and Exporting Uploading files to Google Docs 00:03:35
Converting files to the Google Docs format 00:03:41
Exporting and downloading files from Google Docs 00:02:42
5. Creating and Formatting Documents Creating and naming a new document 00:01:57
Navigating the document interface 00:05:08
Formatting the text 00:03:20
Inserting images 00:03:25
Inserting links 00:02:08
6. Creating and Formatting Spreadsheets Creating and naming new spreadsheets 00:01:31
Navigating the spreadsheet interface 00:05:13
Formatting text in cells 00:02:10
Formatting number, date, and currency styles 00:03:01
Manipulating rows and columns 00:04:09
7. Using Functions, Formulas, and Charts Using formulas 00:03:47
Using functions 00:03:42
Finding functions 00:05:16
Creating and designing charts 00:03:33
8. Creating and Formatting Presentations Creating and naming a new presentation 00:02:07
Changing slide theme and format 00:02:20
Adding, copying, deleting, and moving slides 00:02:20
Formatting slide text 00:03:26
Adding images, shapes, and media to slides 00:05:45
9. Presenting and Publishing Presentations Displaying in Presentation mode 00:01:04
Publishing a presentation to the web 00:03:15
Importing from and exporting to PowerPoint 00:04:17
10. Creating and Formatting Forms Planning to design a form 00:04:37
Creating a new form and adding

s 00:06:25
Viewing the live form 00:01:26
Collecting form responses via email and the web 00:02:09
Analyzing form responses 00:03:18
Modifying and disabling a form 00:02:39
11. Sharing Documents Introduction to document sharing 00:06:10
Sharing a private document with an editor or viewer 00:07:02
Changing document privacy settings 00:07:56
Sending messages to collaborators 00:01:47
Sending documents as attachments 00:01:54
12. Simultaneous Editing and Collaboration Editing and collaborating simultaneously in documents 00:02:15
Editing and collaborating simultaneously in spreadsheets 00:02:26
Editing and collaborating simultaneously in presentations 00:02:28
Adding comments 00:03:29
Viewing the revision history 00:04:00
Reverting to a previous version 00:02:08
13. Using Templates Using templates from the Template Gallery 00:04:17
Creating a template 00:01:35
Submitting a template 00:02:19
14. Troubleshooting Troubleshooting error messages 00:03:15
Troubleshooting common sharing issues 00:03:57
Finding resources for help 00:03:23
15. Conclusion Additional resources 00:01:17