Google Sheets for Office Work
3.9 (12 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
30 students enrolled

Google Sheets for Office Work

Using Google Applications to help improve your spreadsheet efficacy
3.9 (12 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
30 students enrolled
Created by Robert Lee
Last updated 11/2017
English
English [Auto-generated]
Current price: $16.99 Original price: $24.99 Discount: 32% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 8 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Use Google Sheets in building informative dashboard
  • Use Google Sheets in import/export data from multiple online sources
  • Use Google Sheets in analyzing business data
  • Use Google Sheets in building survey tool
  • Use Google Sheets in building project management tool
Requirements
  • Familiarity with Spreadsheets
  • Interests in Office Computing
  • Basic Computer Skills
  • Internet Connection
Description

Hi, My name is Robert, I am an senior business analyst with over a decade of experience working as data specialist consulting to both big corporate and small medium enterprises. First I would like to thank you for your interest in this course. It is the fruit of my combined experiences and technical know-hows from my years. I decided to share it with you due to my passion in teaching people, to use data in their business, for improvement and profit. Let's introduce you to the course.

This course is an beginner guide to Google powerful cloud based spreadsheet application, Google Sheets. You will receive detailed step by step instructions in using Google Sheets power functions and add-on suite in achieving your business requirements. The aim is for you to increase your proficiency in office work, especially those type of work which involve managing data and/or collaborating in large teams.

IF you're successful in finishing this course, you would have built a solid foundation in utilizing clouding technology and Google powerful array friendly functions and add-on. Which together make Google Sheets and much more flexible, convenient and powerful spreadsheet application than any other spreadsheet apps, and yes, I am including Microsoft Excels. This is not mentioning due to being an online application, Google Sheets naturally enable its users to freely collaborate disregard their geographic or time differences. 

Due to all those advantages, I am excited to invite you to join us in this course and take advantage of the FREE tool provided for us by our  friends at Google. Let make the most of the 8 hours we have everyday, get back time in your day working on new career moves, or just spending more quality time for yourself. So, what are you waiting for? Let's start!!!

Who this course is for:
  • Business Professionals
  • Data Analysis Professionals
  • Business Students
  • Spreadsheet Wranglers
Course content
Expand all 56 lectures 07:46:42
+ Getting Start with Google Sheets User Interface
4 lectures 36:59
Create a Google Account and Access Google Sheets
07:06
ToolBar Part 1
10:28
ToolBar Part 2
09:15
ToolBar Part 3
10:10
+ Working with Data in Spreadsheets
5 lectures 54:35
SpreadSheets Cores
10:26
Data Types: Text; Number & Date - Part 1
10:41
Data Types: Text; Number & Date - Part 2
12:57
Conditional Formatting
10:45
Alternating Formatting
09:46
+ Speedup with Functions
33 lectures 03:59:21
Functions Introduction
02:30
Filter - Sort - Unique
11:43
ImportRange
09:15
SparkLine - GoogleTranslate - GoogleFinance
07:59
EDATE
03:07
Switch
07:37
IFS
08:13
IF - AND - OR
16:56
The Logical Check Functions
13:05
VLOOKUP
09:08
HLOOKUP
04:20
INDEX and MATCH
12:56
RANDBETWEEN and ROUND
04:27
SUMIFS
05:36
COUNTIFS
05:29
MAXIFS and MINIFS
10:18
AVGIFS
05:16
PRODUCT and SUMPRODUCT
06:09
COUNTBLANK and COUNTUNIQUE
04:33
RANK
03:51
SMALL and LARGE
03:35
ABS
02:24
LEFT and RIGHT
02:41
MID
03:01
SEARCH and FIND
05:06
REPLACE
03:29
UPPER and LOWER
02:18
PROPER
03:22
LEN; TRIM and SUBSTITUTE
09:42
FORECAST
09:33
QUERY - Part 1
16:39
QUERY - Part 2
14:08
QUERY - Part 3
10:55
+ Sharing and Collaboration
2 lectures 20:29
Sharing; Add Comment and Note
18:15
Google Sheet Keyboards Shortcuts
02:14
+ Google Sheet Addons
6 lectures 58:05
Addons Intro
03:26
Installing Addons
03:23
8 Useful Addons to Supercharge your spreadsheet
14:00
Supermetrics
20:41
Sheetgo
07:44
Google Apps Script Intro - Example - Caveat
08:51
+ Final Section
4 lectures 41:50
Build A Business Dashboard
26:48
Build A Feedback Collecting Tool
05:48
Build A Schedule Board
04:02
Course Wrap-ups
05:12