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.
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 !!!!
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.
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.
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.
Let us see if you are now aware of what is Google Spreadsheet all about.
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:
These are widely used functions in reporting and dashboard creation.
This lesson covers three functions:
All the above functions works exactly the same way as SUM, SUMIF and SUMIFS, except, the result are averages in this cases.
Let us see if you understood the concept of Sum and Average and its different options.
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.
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.
Now we will start learning function that help you to edit strings. In this video, we have four such functions:
We will learn four functions in this video:
This is Quiz Time
IF will allow us do multiple calculations based on conditions.
Let us Recap some of the concepts
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.