Last Updated 05/2017
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 32 lectures (4h 49m) | Size: 784 MBStart from Scratch and learn how to create dashboards
What you'll learnGet 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
RequirementsYou should have a basic understanding of English language as the course uses this language
You should have understanding of day to day maths like addition, subtraction etc.
A thirst to learn new things and improve your personality.
DescriptionSince 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."
Who this course is forIf you are a student and you want to add another skill set in your resume, this course is for you. Having relation with data and knowing how to use them, gives you an edge always.
If you are a working professional and and has some messy data and number of unrelated spreadsheets, this course will help you clean those mess and organize the way you work.
If you are a manager, this course will help you to handle your team more efficiently, as you can create spreadsheet and share with your team and ask them to update. You get all data at one place in real time and your own dashboard will give you all that you need.
If yo want to be a freelancer, this is a good place to start with. There is huge demand of google sheet experts and companies need them to fix their internal mess as well as data analysis.
HOMEPAGE
https://www.udemy.com/course/google-spreadsheet-reporting-dashboards-with-real-examples/
Warning! You are not allowed to view this text.
Warning! You are not allowed to view this text.