Google Sheets Master Module 1 | Prime Tech Academy

Описание: Sign up now for our FREE certificate training tagged Google Sheets Master Class - From Beginner To Expert.
A practical step-by-step training on data analysis with Google for Excel and Non-Excel Users!
Come set yourself up for success in data analysis with Google Sheets.

Register here for FREE to access the course and get certified: https://bit.ly/Google-Sheet

Join WhatsApp group of analysts for support: https://chat.whatsapp.com/LO4sUeOgrL0...

Do your projects and get your certificate.

Projects Link: https://docs.google.com/document/d/1L...


Time Stamp Chapters (Click the time to jump to the section)
0:00 Introduction to the course
3:00 Introduction to Google Sheets
3:22 Joining the discussion & Pre-Quiz
8:12 Expectation
9:00 Launching into Google Sheets
13:37 Importing data into your Sheet
17:50 Working on the Sheet
21:54 Formatting our data to make it great for work
29:40 Applying Filters
40:10 Pasting Options (Paste Special)
44:50 Appling Sorting
48:25 Interactive Session (Questions and Answer)
55:40 Solving Real Life Business Problem
57:10 Creating Google Form to get data into spreadsheet to solve the problem
1:04:28 Filling the Google Form Survey in real time
1:10:30 Linking and accessing the form response in a Google Sheet
1:13:45 Time to analysing the data collected
1:14:30 Creating Data Sheet and using formula to draw the responses to it
1:19:40 Formatting the Data Sheet
1:22:15 Analysing the data set
1:50:05 Making Inference from the analysis
1:53:50 Project 1 Questions
1:54:55 Sharing Options for your Google Sheets
1:57:34 Conclusion, Questions and Answers