Google Sheets for Data Analysis and Workflow Automation

سرفصل های دوره

Learn to implement real-life projects in Google Sheet and also apply most of the functions in Excel too.

1. Onboarding with Googlesheets

1. Create a Gmail Account

2. Your First Googlesheet

3. The UI of Googlesheets

4. Your First Database in Googlesheets

5. Import Data in Googlesheets

2. Mathematical and Statistical Functions

1. COUNTIF, COUNTIFS, COUNTUNIQUE

2. FLOOR and CEILING

3. ROUND, ROUNDUP, ROUNDDOWN

4. ISEVEN and ISODD

5. SUM, SUMIF, SUMIFS

6. AVERAGE, AVERAGEIF, AVERAGEIFS

7. COUNT, COUNTA, MIN, MAX

8. RANK

3. Text Functions

1. LEN, LEFT, RIGHT, MID, UPPER, LOWER, PROPER, TRIM

2. REPLACE and SUBSTITUTE

3. REGEXREPLACE, REGEXMATCH, REGEXEXTRACT

4. Logical Functions

1. AND and OR

2. IF and NESTED IF

3. IFS

4. SWITCH

5. IFERROR and IFNA

5. Filter Functions

1. FILTER

2. SORT

3. UNIQUE

6. Date and Time Functions

1. ISDATE, DATEDIF, DATE

2. DAY, MONTH, YEAR, DAYS, DAYS360

3. EDATE, EOMONTH, NOW, TODAY, HOUR, MINUTE, SECOND

4. WEEKDAY, WEEKNUM, TEXT

7. Other Important Functions in Google Sheets

1. CONCATENATE and ARRAYFORMULA

2. QUERY

3. IMPORTRANGE

4. VLOOKUP

8. PROJECT 1

1. Project 1 Analyze Sales Data

9. Data Validation and Conditional Formatting

1. Data Validation - Part 1

2. Data Validation - Part 2

3. Conditional Formatting

10. Data Sharing and Security

1. Data Sharing Options with Different User Rights

11. Bonus Package Google Forms

1. Create a Data Entry Form

2. Importance of Array Formula

3. Send automated emails using FormMule

12. PROJECT 2

1. Online Leave Approval Process - Part -1

2. Online Leave Approval Process - Part -2

3. Congratulations!!

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training