Google Sheets – Beginner

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

Designed to teach students the fundamentals of Google Sheets.

1 - Introduction

1 - Google-Sheets-L1-Exercise-Projects-1578665934.zip

1 - Introduction

2 - Getting Started with Google Sheets

2 - What is Google Sheets

3 - Opening Google Sheets

4 - Importing and Converting Spreadsheets to Sheets

5 - Navigating the Sheets User Interface

6 - Understanding Sheet Components

7 - Using the File Menu

8 - Creating a Spreadsheet

9 - Saving a Spreadsheet

10 - Accessing Help

3 - Entering Data

11 - Navigating a Spreadsheet by Mouse or Keyboard

12 - Working with Cell and Ranges

13 - Using Various Data Selection Techniques

14 - Working with Common Sheet Commands

15 - Working with Copy and Paste

16 - Understanding Data Types

17 - Formatting Values

18 - Using Autofill Handle

19 - Inserting Links

4 - Understanding Formula Basics

20 - What are Formulas and Functions

21 - Understanding the Components of a Formula

22 - Understanding Calculation Hierarchy and the Order of Operations

23 - Creating Basic Formulas

24 - Working with Basic Functions and Autosum

25 - Using Cell References

26 - Using Explore

5 - Formatting a Spreadsheet

27 - Formatting and Aligning Data

28 - Modifying Columns and Rows

29 - Using Borders and Fill

30 - Using Paint Format

31 - Inserting Notes or Comments

32 - Inserting Checkboxes

33 - Applying a Theme

6 - Managing Spreadsheets

34 - Using Zoom Tools

35 - Working with Sheets

36 - Working with Spreadsheet Tabs

37 - Hiding and Unhiding Spreadsheets

38 - Sorting Sheets Data

39 - Filtering Sheets Data

40 - Using Filter Views

41 - Using Freeze Panes

7 - Printing a Spreadsheet

42 - Using Find and Replace

43 - Using Spell Check

44 - Preparing a Spreadsheet for Printing

45 - Changing Spreadsheet Settings

46 - Finalizing Printing

47 - Downloading and Emailing Files

48 - Sharing a Spreadsheet

8 - Creating Charts

49 - Inserting a Chart

50 - Formatting a Chart

51 - Moving and Sizing a Chart

52 - Creating a Scorecard Chart

9 - Working with Graphics

53 - Inserting Images

54 - Creating Drawings

10 - Conclusion

55 - Course Recap

11 - Assessment Quiz

139,000 تومان

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

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

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

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