Google Docs - A Focus on Spreadsheets - Advanced View a tutorial on this topic

Description

Become proficient in creating forms which can be shared with respondents of your choice. As they respond, their answers will be stored in a spreadsheet which you can use to analyze, graph and share the results. Learn how to perform this technique and other operations, such as working with formulas and functions and using gadgets, through this informative online training series on Google's™ free and flexible spreadsheet tool.
Click here to learn about subscribing to this collection!
Click any of the highlighted titles to view free sample tutorial movies. Atomic Training subscribers to this collection have access to all of the following movies, plus thousands of tutorials on other applications.
Key # Length
1. preview Using forms 82838 1:13
2. preview Creating forms pt. 1 73777 1:57
3. locked Creating forms pt. 2 82839 1:58
4. locked Questioning with text and paragraph field types 82840 1:27
5. locked Questioning with the multiple choice field 82841 1:16
6. locked Questioning with grid and check boxes 82842 2:41
7. locked Questioning with lists and scales 82843 2:30
8. locked Editing forms pt. 1 82844 1:14
9. locked Editing forms pt. 2 82845 1:44
10. locked Editing form themes 82846 1:33
11. locked Duplicating and deleting forms 73778 2:03
12. locked Publishing a form 73779 1:23
13. locked E-mailing a form pt. 1 82847 1:17
14. locked E-mailing a form pt. 2 82848 2:56
15. locked Editing the confirmation message 73781 1:39
16. locked Inserting section breaks 82849 1:58
17. locked Viewing the results in summary form 73780 1:23
18. locked Using Go to Page pt. 1 82850 1:13
19. locked Using Go to Page pt. 2 82851 1:47
20. locked Using Go to Page pt. 3 82852 1:19
Key # Length
1. locked Sorting data 73801 2:13
2. locked Using Data Validation pt. 1 73802 2:31
3. locked Using Data Validation pt. 2 82853 1:51
4. locked Using Quick Sum 73803 0:51
5. locked Using AutoFill 73817 2:02
6. locked Using Solve pt. 1 82854 1:44
7. locked Using Solve pt. 2 82855 2:17
8. locked Using Solve pt. 3 82856 1:53
9. locked Using Solve pt. 4 82857 2:52
Key # Length
1. locked Adding a chart to your spreadsheet pt. 1 73804 2:47
2. locked Adding a chart to your spreadsheet pt. 2 73805 1:36
3. locked Editing and deleting a chart 73806 1:22
4. locked Moving and resizing a chart 73807 1:25
5. locked Moving a chart to its own sheet 73811 1:53
6. locked Exporting and saving your chart 73810 0:44
7. locked Publishing a chart 73809 2:26
8. locked Inserting an image from Google images 82858 1:11
9. locked Inserting a drawing into a spreadsheet 82859 1:15
10. locked Inserting an image from Picasa™ 82860 1:17
11. locked Inserting an image from a URL 82861 1:08
12. locked Editing an image in your spreadsheet 82862 1:14
13. locked Deleting an image in a spreadsheet 82863 0:34
14. locked Exploring four newly added chart types 90124 2:21
15. locked Creating a pivot chart 90125 0:43
16. locked Working with the Report Editor 90126 1:05
17. locked Managing your pivot table information 90127 1:39
Key # Length
1. locked Using formulas 73812 3:10
2. locked Using Sum and Count functions 73813 2:23
3. locked Using Min and Max functions 73814 1:13
4. locked Using the Average function 73815 1:00
5. locked Using formulas across sheets pt. 1 82864 1:33
6. locked Using formulas across sheets pt. 2 82865 2:19
7. locked Using the name range formula pt. 1 73818 1:52
8. locked Using the name range formula pt. 2 82866 2:07
9. locked Editing named ranges 82867 1:34
10. locked Using functions 82868 2:29
11. locked Browsing other formulas and functions pt. 1 73816 1:53
12. locked Browsing other formulas and functions pt. 2 82869 2:48
13. locked Auto-grading a form test with a function pt. 1 82870 2:17
14. locked Auto-grading a form test with a function pt. 2 82871 3:51
15. locked Auto-grading a form test with a function pt. 3 82872 2:41
16. locked Calculating a subtotal 90128 2:22
Key # Length
1. locked Using gadgets 82873 1:18
2. locked Adding gadgets to your spreadsheets 73820 1:30
3. locked Editing a gadget 82874 0:41
4. locked Moving and resizing gadgets 82875 1:14
5. locked Moving a gadget to its own sheet 82876 0:56
6. locked Deleting a gadget 82877 0:42
7. locked Publishing gadgets 82878 1:43
8. locked Browsing gadgets pt. 1 82879 1:56
9. locked Browsing gadgets pt. 2 82880 1:17
10. locked Collaborating with gadgets 82881 1:42
11. locked Creating flash cards with a gadget pt. 1 82882 2:12
12. locked Creating flash cards with a gadget pt. 2 82883 2:27
13. locked Creating flash cards with a gadget pt. 3 82884 1:30
Tutorial series by Cindy Rybaczyk
Google and Picasa are trademarks of Google, Inc.