Google Sheets – Advanced

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

Learn the advanced fundamentals of Google Sheets

1 - Introduction

1 - Google-Sheets-L2-Exercise-Projects-1579100146.zip

1 - Introduction

2 - Linking and Protecting Data

2 - Importing Data

3 - Linking Sheets

4 - Linking to Another Spreadsheet

5 - Protecting Sheets and Ranges

6 - Working with Versions

7 - Reviewing Accessibility Settings

3 - Working with Range Names

8 - What are Range Names

9 - Creating Range Names

10 - Using Range Names in Formulas

4 - Analyzing Data with Logical Functions

11 - Understanding Logical Functions

12 - Using Logical Statements

13 - Using AND and OR Functions

14 - Working with Nested IF Statements

15 - Using SUMIF AVERAGEIF COUNTIF and More

16 - Using the IFERROR Function

5 - Working with Lookup Functions

17 - Understanding Lookup Functions

18 - Using VLOOKUP

19 - Using HLOOKUP

20 - Using INDEX and MATCH

21 - Comparing Two Lists with VLOOKUP and IFERROR

6 - Working with Text Functions

22 - Using CONCAT CONCATENATE and TEXTJOIN

23 - Splitting Text to Columns

24 - Using LEFT RIGHT and MID Functions

25 - Using UPPER LOWER and PROPER Functions

26 - Using the LEN Function

27 - Removing Duplicates and Trimming White Space

7 - Working with Date Functions

28 - Understanding Date Functions

29 - Using TODAY NOW and DAY Functions

30 - Calculating YEARFRAC and NETWORKDAYS

8 - Working with Data

31 - Using Data Validation

32 - Adding Conditional Formatting

33 - Grouping and Ungrouping Data

9 - Understanding PivotTables

34 - What is a PivotTable

35 - Creating a PivotTable

36 - Working with PivotTables

37 - Creating a Chart from a PivotTable

38 - Filter Charts and Tables with Slicers

10 - Introduction to Macros and Scripts

39 - What are Macros

40 - Creating a Macro

41 - Working with Scripts

11 - Working with Forms

42 - Creating a Form

43 - Working with Forms

44 - Sending a Form

12 - Conclusion

45 - Course Recap

13 - Assessment Quiz

139,000 تومان

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

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

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

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