Google Spreadsheet: From Level Zero with 18 Projects (2023)

Start from Scratch and learn how to create dashboards

Created by: Shahbaz Haidar
Creating Technology to Boost Productivity

What Will I 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.

Target audience

• 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.