Google Spreadsheet: From Level Zero
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
Requirements
- You 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.
Description
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."
Who this course is for:
- If 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.
Course content
- Preview02:29
- Preview10:07
- 10:55Advance Formatting
- 11:15Cell Freeze, Filters and Data Format
- 3 questionsKnowing about Google Spreadsheet
Instructor
![Shahbaz Haidar](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.2 Instructor Rating
- 852 Reviews
- 4,885 Students
- 5 Courses
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.