By the end of this course, you will be able to
How to navigate Google Sheets, how to adjust the way data and information are displayed, and how to use data tools such as sorting, subtotaling, and filtering.
How to write formulas quickly and easily with the point-and-click method, how to create powerful calculations, and what some of the spreadsheets' secrets and shortcuts are.
How to automate data, how to create professional dashboards using Google Data Studio to visualize your data, and how to create online forms with Google Forms.
Course details
- 4 h 44 m/49 lessons
- Last updated: 17/11/2020
- 1 learning resources
- Course completion certificate
Course Content
Introduction
Cell Basics
Modifying Columns, Rows and Cells
Cell Formatting 1
Cell Formatting 2
Introduction
Cell Basics
Modifying Columns, Rows and Cells
Cell Formatting 1
Cell Formatting 2
Cell Formatting 3
Cell Formatting 4
Numbers Formatting
Sheets Formatting
Mathematical Operators
Creating Formulas
Tips and Tricks
Working with Functions
Practicing on database 1
Practicing on database 2
Using Count
Date and Time
Date and Time Functions
Using google translate in Google Sheets
Using Pivot Table
Split and Trim
V Look Up
Inserting in Google Sheets 1
Inserting in Google Sheets 2
Freezing in Google Sheets
Using slicer
Protection in Google Sheets
Add-ons in Google Sheets
Using Macros in Google Sheets
Wrapping up Google Sheets
Introduction to Google Forms
Google Form Interface
Changing Google Form Design
Adding Questions in Google Form 1
Adding Questions in Google Form 2
Adding Questions in Google Form 3
Sections in Google Form
The Settings of Google Form
Linking Responses with Google Sheets
Wrapping up Google Forms
Introduction to Google Data Studio
Linking Google Sheets with Data Studio
Inserting in Google Data Studio 1
Inserting in Google Data Studio 2
Inserting in Google Data Studio 3
Schedule Email Delivery
Fixing the Dashboard
Wrapping up Google Data Studio
Summary
About this course
The way we’re using spreadsheets is changing, and more of our work and collaboration is done through online channels. Spreadsheets have also moved online, with Google Sheets being an online spreadsheet program that provides the solutions many companies need right now. In the past, the main requirement companies had was a solid knowledge of Microsoft Excel; now, companies are looking for more. In this course, you will learn the ins and outs of Google sheets, and you will understand the different tools and uses of one of the most important programs of your professional life.
Course requirements and prerequisites
No prior knowledge of Google Sheets is needed.
Mentor
Moamen Said
Learning and Development Consultant/Gamification Expert
9,630 Learners
4 Courses