Course Information
Course Overview
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
Skills covered in this course
Reviews
-
KKeziah Balabag
Very good, easy to follow, very useful information. very comprehensive
-
MMaria Penalosa
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!
-
SShivani Parwani
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.
-
PPeter Ishak
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.