Prerequisites
This course requires Basic knowledge in Spreadsheets. Knowledge in basic Logical and Lookup Functions are recommended.
Course Description
Course Description
This Virtual Class course on Google Sheets is intended for participants who has basic knowledge in spreadsheets and want to discover more innovative ways on data collection from Google Forms. One of the essential activities in business is data gathering or collection. In this course, you will discover a modern and accessible way of collecting data thru online forms using Google platform. Since everyone has an access on the internet now a days, it will be easier to acquire information from them via web with regards to surveys, evaluations, taking orders, registration, and a lot more.
Course Objectives
At the end of this course, the participant should be able to:
-
Create and modify forms for both Microsoft and Google
-
Learn different tricks to easily gather data from Forms
Course Content
Lesson 1: Introduction to forms
-
Intro to Google Forms
-
Designing Forms
-
Linking Forms
Lesson 2: discovering form features
-
Utilize Option features
-
Creating Surveys, Registrations and Orders
Lesson 3: data collection
-
Extraction of Data collected from Forms
-
Organize Data Gathered
-
Summarize using Pivot table basics
Who Should Join
Experienced users who want to maximize their learning and finding innovative ways to gather data. This also targets people who rely on MS Excel to do data entry and want to discover a faster and reliable way to collect data in a more accessible and compact way.