image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

Google Sheets and Forms are two incredibly powerful office apps that Google provides for free! 


This course will show you how to use Google Sheets to create incredibly powerful and complex spreadsheets, while being able to easily share and collaborate with others all over the world. Make your data stand out with beautiful charts and graphs, and save time with built-in formulas and conditional formatting. 


Learn how to effortlessly collect and organize information with Google Forms. Manage event registrations, quickly take polls, collect email addresses, and more!


Get started now and learn how to use these two tools together and do some amazing things!
Who this course is for:
Business professionals with a desire to increase efficiency and accessibility
High school and college students
People looking to transition from Microsoft to Google products
Anyone who uses office productivity software

What you'll learn

Be able to create, edit, and share spreadsheets quickly and efficiently

Understand and add charts to spreadsheets

Understand how to work with and filter data

Gain a basic understanding of formulas and how to apply them

Create forms and surveys

Collect and analyze data from forms and surveys

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Introduction
2
1.1-Introduction
1.2-Benefits of Google Office Apps
2-Google Sheets
12
2.1-Google Sheets Intro
2.2-Document Setup and History
2.3-Editing the Spreadsheet
2.4-Using Comments
2.5-Printing and Downloading
2.6-Filtering Data
2.7-Intro to Charts
2.8-Chart Types: Bar, Scatter and Pie
2.9-Formulas
2.10-Working with Data
2.11-Sheets Tips, Add-Ons and Templates
2.12-Google Sheets Section Quiz
3-Google Forms
9
3.1-Google Forms Intro
3.2-Form Setup
3.3-Add and Edit Questions
3.4-Validate Answers
3.5-Add Sections
3.6-Sharing the Form and Collecting Responses
3.7-Add-Ons
3.8-Google Forms Section Quiz
3.9-BONUS: Attaching Files to Forms
4-What Now?
1
4.1-Wrapping it all Up