Google Sheets Master Module 2 | 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.

Time Stamp Chapters (Click the time to jump to the section)
0:00 Introduction to the course
4:00 Introduction to formulas and functions
4:50 Joining the discussion
6:54 Feedback from Module 1 Project
24:00 Learning Google Sheets Functions for Data Analysis
24:50 IF function and Conditional Formatting
33:15 Sort function
37:31 Filter function
41:42 ARRAYFORMULA function
43:07 UNIQUE function
44:39 COUNTIFS function
47:28 SUMIFS function and formatting to Currency
51:44 AVERAGEIFS function
52:53 COUNTUNIQUE function
54:05 SUM and AVERAGE function
55:14 MATH OPERATIONS (+, -, * and /)
56:18 PERCENTAGE
57:20 LEN and TRIM function
1:01:26 VLOOKUP
1:13:00 SUMPRODUCT
1:15:05 CONCATENATE
1:17:23 SPLIT
1:19:05 Summarising your data (PROJECT 2 explanation)
1:19:50 How to use DATA VALIDATION
1:24:40 Answering PROJECT 2 questions
1:45:50 Arranging your results creatively
1:52:50 Explaining more on Conditional Formatting
1:56:50 Conclusion