Udemy

Google Spreadsheet: From Level Zero with 18 Projects (2023)

Enroll Now
  • 3,081 Students
  • Updated 3/2023
4.5
(317 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
14 Hour(s) 17 Minute(s)
Language
English
Taught by
Shahbaz Haidar
Rating
4.5
(317 Ratings)

Course Overview

Google Spreadsheet: From Level Zero with 18 Projects (2023)

Start from Scratch and learn how to create dashboards

Since I am a full time Google Spreadsheet consultant, with clients all over the world, I know what are the things that are important and should be taught to students.

Google Spreadsheet is on of the most powerful tool developed by Google. It has such a vast use that almost any body in any field, can use it for some thing or the other. If you are a student, you can use it to record your readings of experiment, if you are a data analyst, you can do all analysis and automate it here, if you are a marketing or sales guys, you can have your own mini CRM set up in google sheet. The fact that it is online, adds a huge value as there is no need of having a special software and you can work on your data from any part of the world. Above all, it is free.

Google Sheet uses most of the function and formula used in Excel. So if you have worked on excel, it is a big advantage. However, for this course, prior knowledge of excel is not must, as I will start the course from level zero. 

The target of this course is not to make you a spreadsheet genius, or to memorize you all the function, but to enable you to make tools that you can actually use to solve the surrounding problems. To make use of any tool or language, you do not need to memorize each and every feature of it. But all you need to know is what are the possibilities and how to google the answers. This course will focus on the same.

This course will be your starting point to be an automation expert, because automation is the thing in present world, and maximum efficiency of a process is achieved only if it is automated. 

Here are some feedback from students, that describes the philosophy of this course:


  • "the course, is very helpful if you go for job in pvt sector these all things will help you these are very usefull and you can make your work easy by using these formulas in sheet. and save time also so thanks to udemy for this really appreciate you."
  • "The instructor goes over a lot of detail in great detail and doesn't leave anything out. I appreciate how he stays on topic and doesn't deviate from the lesson ."
  • "Learning stuff I never knew I could do. This could help me so much"
  • "I have taken many courses on Spreadsheets, And this one by far is the best I have taken. A++++"
  • "Very informative. I have learned alot of new things. I understand how dashboards are are made for presentations."



Course Content

  • 10 section(s)
  • 73 lecture(s)
  • Section 1 Introduction to Google Spreadsheet
  • Section 2 Function and Formula
  • Section 3 Dashboard 1
  • Section 4 Dashboard 2
  • Section 5 Dashboard 3
  • Section 6 [New Course] Section 1: Introduction
  • Section 7 [New Course] Section 2: Basic Functions
  • Section 8 [New Course] Section 3: Conditional Functions
  • Section 9 [New Course] Section 4: Advance Range based Functions
  • Section 10 [New Course] Section 5: Projects

What You’ll Learn

  • Get to know the elements of Google Spreadhseet
  • Format the text and cell to add aesthetic sense
  • Arranging Rows and Columns for easy navigation
  • Sharing the Spreadsheet with others for collaboration
  • Using powerful functions to get desired result
  • Perform various operations like concatenate, replace, substitute on bulk data
  • Combine multiple functions to get more complex result easily
  • Creating a dashboard to handle restaurant details
  • Create an HR tracker that can be used in any office
  • Creating Sales Dashboard
  • Using a set of data to create any dashboard with visual appeal


Reviews

  • K
    Keziah Balabag
    5.0

    Very good, easy to follow, very useful information. very comprehensive

  • M
    Maria Penalosa
    5.0

    I love how clear and straightforward he explained each subject. It made even complex strings of formulae easy to understand. He covered so many subjects in 5hrs that are all helpful to anyone who uses spreadsheets. I appreciate most of all how he turns syntax or calculation errors into fun teachable moments. Thank you and more power!

  • S
    Shivani Parwani
    3.0

    some things were not clear, i have a macbook so some things are diifferent on the google spreadsheet. the row and column increase option is not there.

  • P
    Peter Ishak
    4.5

    It is a very good course , while i am completely a beginner , i feel that it covered a lot of good material ,i'm happy that i took this course. thank you guys very much.

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed