Google Spreadsheet: From Level Zero with 18 Projects (2023)
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.
Instructor
Hi, I’m Shahbaz Haidar, CEO at Idea Rise Technologies.
I am writing codes since I was 10 years old.
One of my favourites is Google Workspace Tools, that has helped me to establish myself professionally and become an automation specialist, and productivity enthusiast. I have a proven track record of transforming workflows for businesses worldwide. During the process, I picked up HTML, CSS, Bootstrap, Javascript, jQuery and few other languages
Over the years, I’ve had the privilege of creating solutions for 300+ clients across the globe, helping them automate processes, simplify tasks, and significantly improve productivity. My expertise lies in leveraging the full power of Google Workspace tools—Sheets, Docs, Slides, Forms, Drive, and Apps Script—to design tailored solutions that solve real-world challenges.
What I Bring to the Table:
✅ Google Apps Script Automation: Streamlining workflows and eliminating repetitive tasks.
✅ Data Management & Reporting: Designing systems to automate reporting and visualize data effectively.
✅ Custom Tools & Integrations: Building tools to enhance collaboration and productivity.
✅ Web Development Basics: Creating intuitive solutions with HTML, CSS, and JavaScript.
I’m passionate about helping individuals and organizations work smarter, not harder. My approach is hands-on and practical—whether I’m developing automated dashboards, creating tools for school districts, or simplifying complex processes for businesses.
Who I’ve Helped:
From small businesses and educational institutions to large enterprises, I’ve worked across diverse industries and geographies. My solutions have saved countless hours, reduced human error, and empowered teams to focus on what truly matters.
What You’ll Get from My Courses:
My courses are designed to be easy to follow, practical, and full of actionable insights. By combining my technical expertise and real-world experience, I’ll teach you how to use the technology to solve real world problems.
With 300+ clients served globally, I’ve seen firsthand how small changes can lead to massive improvements in productivity. Now, I’m here to share that knowledge with you and help you unlock your potential.
If you’re ready to save time, streamline your work, and build the skills that matter, I’m here to guide you every step of the way.
See you in the course!