Google Spreadsheet: Beginner to Dashboard Creater
4.4 (69 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,954 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Google Spreadsheet: Beginner to Dashboard Creater to your Wishlist.

Add to Wishlist

Google Spreadsheet: Beginner to Dashboard Creater

Create your own reports and have edge over your peers
Bestselling
4.4 (69 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,954 students enrolled
Created by Shahbaz Haidar
Last updated 5/2017
English
Current price: $10 Original price: $80 Discount: 88% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Analyze set of data
  • Create visually appealing reports based on data
  • Create dashboard for day to day operations
View Curriculum
Requirements
  • Should Understand English
  • Should understand basic Maths (Addition, subtraction, multiplication etc)
  • Have some logical sense
Description

One who follow the conclusion derived by looking at data, is bound to succeed. You can not be standing behind everyone and looking what he/she is doing and recording data about him/her. You need smart solution. You need amazing Dashboards. This will help to track the progress in real time and also analyze them at certain intervals. When people used to record data in notebooks, biggest problem for them was that they could not get meaning out of those recorded data at frequent intervals. But now since we have tools like google spreadhseet, we MUST use them . This course will take you all the way from ground zero to creating amazing dashboards and reports that can change the way you do your job.

Who is the target audience?
  • Young Professionals
  • Managers
  • Individual who wish to become freelancers
Students Who Viewed This Course Also Viewed
Curriculum For This Course
32 Lectures
04:49:22
+
Introduction to Google Spreadsheet
4 Lectures 34:46

Data is the present and the future. Most of us have an assumption that handling data and creating reports, tracking processes is a difficult task. My motive of this course is to bust this myth.
Google spreadsheet is a very handy tool to track all the processes, progresses and plans. It is very easy to learn and very interesting to implement. 

By the end of this course, you will realize that the dashboards and reports you have been looking at, made by others, were so easy to make and so awarding to follow.

Automation of data is yet a great benefit of using google spreadsheet because it allows multiple stake holders to contribute at one place.

Welcome to the journey !!!!

Preview 02:29

Starting from level zero, we will create a gmail account and passing through Google Drive, we will land on to our first spreadsheet.

We will also look at options available for text formatting, like bold, italics, background color, font color, size etc.

Preview 10:07

After completing this video, you would be able to format text on  the spreadsheet like changing font size, color, font, back ground color etc. This will help you in designing the report or dashboard, so that it is user friendly and soothing to the eyes.

Advance Formatting
10:55

Filter and data formatting, are tools for viewing data in an ordered way. For example, if you have 10,000 rows of data, that has list of schools in your country. Now if you want to see list of schools that are in your city, instead of going through entire list of the country, you will add filter of your city, and the list will now show schools of your city only.

Cell Freeze, Filters and Data Format
11:15

Let us see if you are now aware of what is Google Spreadsheet all about.

Knowing about Google Spreadsheet
3 questions
+
Function and Formula
17 Lectures 02:13:06

Going forward, you will be learning about different functions available for use in google spreadsheet. If you have knowledge of Microsoft Excel, learning Google spreadsheet would be very easy as 90% of the functions are same. 

In this video, we cover three functions:

  1. SUM() : This enables you to find sum of numbers, series of numbers or combination of both.
  2. SUMIF(): When you want to find sum of a series of number based on a condition, you use SUMIF. For example, from a sheet containing all employees' attendance of a company, you want to see number of leaves for Finance department.
  3. SUMIFS(): When you want to find sum of a series of number based on more than one condition, you use SUMIFS. For example, from a sheet containing all employees' attendance of a company, you want to see number of leaves for Finance department, who are Male.

These are widely used functions in reporting and dashboard creation.

Sum, Sumif and Sumifs
14:02

This lesson covers three functions:

  1. AVERAGE()
  2. AVERAGEIF()
  3. AVERAGEIFS()

All the above functions works exactly the same way as SUM, SUMIF and SUMIFS, except, the result are averages in this cases.

Average, Avergaeif and Averageifs
07:43

Let us see if you understood the concept of Sum and Average and its different options.

It is the Quiz Time: SUM & AVERAGE
3 questions

Since we are learning on an actual sheet, I decided to provide you that sheet for practice. So this lecture will tell you how to share sheets with other and how to use sheets shared by others. Since many students would be accessing this sheet, I have shared as "View Only". You will make a copy of the sheet and use it for learning purpose. All the steps for how to do it, is covered in this lecture.

Sharing and Making a Copy
03:47

Coming back to functions, in this video, we will cover two variations of a function that enables you too count number of elements in a range.

  • COUNT: This counts only the numeric value in a range
  • COUNTA: This counts numeric as well as Text elements in a range.
Count, Counta
04:51

Now we will start learning function that help you to edit strings. In this video, we have four such functions:

  • CONCATENATE: This is used to join more than one string to form a single string
  • LEN: This is used to find length or number of characters present in a string
  • LEFT: This enables you to extract certain characters from left of a string
  • RIGHT:  This enables you to extract certain characters from right of a string
Concatenate, Left, Right and Len
09:20

We will learn four functions in this video:

  • REPLACE: This helps you to replace certain number of characters in a string with a new set of characters or sub string
  • SUBSTITUTE: This replaces a defined sub-string in a cell to a new sub-string
  • FIND: This returns the character position of a sub-string in a string
  • SPLIT: Splits a long string a cell separated by delimiters to multiple strings in separate cells 
Replace, Substitute, Find and Split
07:26

This is Quiz Time

Let us Recap
3 questions

Search, Join, Text and Value
09:44

Countblank, Sqrt, Floor, Rand and Randbetween
07:39

Floor, Ceiling, Subtotal, Count and Countifs
07:51

IF will allow us do multiple calculations based on conditions.

if
10:16

And, Or
05:47

Not, IsBlank
05:48

IsEmail, IfError
04:36

Vlookup
11:16

Let us Recap some of the concepts

Quiz Time
3 questions

Match and Index
07:41

Filter, Sort and Unique
10:58

Date
04:21
+
Dashboard 1
3 Lectures 31:28
Restaurant Order Detail: Part 1
11:06

Restaurant Order Detail: Part 2
05:51

+
Dashboard 2
3 Lectures 24:46
HR Tracker: Part 1
09:40


HR Tracker: Part 3
09:56
+
Dashboard 3
5 Lectures 01:05:16

Sales Dashboard: Part 2
14:16

Sales Dashboard: Part 3
16:28

Sales Dashboard: Part 4
09:05

About the Instructor
Shahbaz Haidar
4.4 Average rating
69 Reviews
1,954 Students
1 Course
Entrepreneur

When I started my career as a Marketing Manager, the biggest problem I had was recording the events happening around me. Then I realized Google Spreadsheet need to be a part of my life. After that I have never looked back. At least more than 10 companies are using Sheets and Dashboards that I designed for them. Now I also design dashboards as a freelancer.