Google Sheets Tutorial 2023 – Beginner To Expert in 6 Hours

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

Google Sheets Made Easy - Expert Instructor with 25 Years of Experience - Quickly Learn The Fundamentals of Spreadsheets

1. Course information

1.1 course outline - Google Sheets - From Beginner To Expert - Todd McLeod.pdf

1. Welcome

2.1 course outline - Google Sheets - From Beginner To Expert - Todd McLeod.pdf

2.2 Here is a Google Drive folder with all of the files..html

2. Using the course files

3.1 All of the files for this google sheets course can be found here.html

3.2 course outline - Google Sheets - From Beginner To Expert - Todd McLeod.pdf

3. All of the course files are here.html

4.1 course outline - Google Sheets - From Beginner To Expert - Todd McLeod.pdf

4. Getting your certificate

2. An introduction to Google Sheets

1.1 All course files.html

1.2 course outline - Google Sheets - From Beginner To Expert - Todd McLeod.pdf

1. Understanding Google Sheets

2.1 All course files.html

2. Two essential skills files And moving files

3.1 All of the course files.html

3. Opening Google Sheets and creating a file

4.1 All of the course files.html

4. File operations with Google Sheets

5.1 All of the course files.html

5. A brief preview of sharing a Google Sheet

6.1 All of the course files.html

6. Google drive, sheets, excel, And file extensions

7.1 All of the course files.html

7. Exploring Google Sheets interface

8.1 All of the course files.html

8. Keyboard shortcuts

3. Hands-on exercises

1.1 All of the course files.html

1.2 Here is a link to the file!.html

1. Hands-on exercise #1

4. Getting started with Google Sheets

1.1 All of the course files.html

1. A cool preview of Google Docs

2.1 All of the course files.html

2. Managing files in Google Drive

3.1 All of the course files.html

3. Mouse pointer awareness

4.1 All of the course files.html

4. Adding data to Google Sheets

5.1 All of the course files.html

5. Formatting numbers in Google Sheets

6.1 All of the course files.html

6. Making selections in Google Sheets

7.1 All of the course files.html

7. Using the status bar for quick answers

8.1 All of the course files.html

8. Managing files in Google Drive

5. Hands-on exercises

1.1 All of the course files.html

1. Hands-on exercise #2

2.1 All of the course files.html

2. Hands-on exercise #3

6. The fundamentals of spreadsheets

1.1 All of the course files.html

1. Writing a formula

2.1 All of the course files.html

2. Relative And absolute references

3.1 All of the course files.html

3. Creating a gradebook

4.1 All of the course files.html

4. Creating charts

7. Hands-on exercises

1.1 All of the course files.html

1. Hands-on exercise #4

2.1 All of the course files.html

2. Hands-on exercise #5

8. Working with functions in Google Sheets

1.1 All of the course files.html

1. An introduction to functions

2.1 All of the course files.html

2. The sum function And range notation

3.1 All of the course files.html

3. Exploring functions and documentation

4.1 All of the course files.html

4. Using the average function And documentation

5.1 All of the course files.html

5. Creating a gradebook with the functions

6.1 All of the course files.html

6. Using the max and min functions, And documentation

7.1 All of the course files.html

7. Using the rand and randbetween functions, And documentation

8.1 All of the course files.html

8. Comparing concat and concatenation, And documentation

9.1 All of the course files.html

9. Using the textjoin function And documentation

10.1 All of the course files.html

10. Splitting text on a delimiter and using textjoin

11.1 All of the course files.html

11. Using xlookup, and not using vlookup And hlookup

9. Hands-on exercises

1.1 All of the course files.html

1. Hands-on exercises #6

2.1 All of the course files.html

2. Hands-on exercises #7

3.1 All of the course files.html

3. Hands-on exercise #8

4.1 All of the course files.html

4.2 Here is a poem.html

4. Hands-on exercise #9

5.1 All of the course files.html

5. Hands-on exercise #10

6.1 All of the course files.html

6. Hands-on exercises #11

10. Progressing with Google Sheets

1.1 All of the course files.html

1. Inserting And deleting columns And rows

2.1 All of the course files.html

2. Moving columns, rows, ranges, and cells

3.1 All of the course files.html

3. Managing your worksheets in Google Sheets

4.1 All of the course files.html

4. Freezing rows And columns

5.1 All of the course files.html

5. Hiding rows And columns

6.1 All of the course files.html

6. Working with versions

11. Hands-on exercises

1.1 All of the course files.html

1. Hands-on exercise #12

12. Formatting in Google Sheets

1.1 All course files.html

1. Formatting And feeling

2.1 All course files.html

2. Changing font formatting

3.1 All course files.html

3. Adding border And fill formatting

4.1 All course files.html

4. The paintbrush formatting tool

5.1 All course files.html

5. Alternating colors (row striping)

6.1 All course files.html

6. Conditional formatting

7.1 All course files.html

7. Table formatting

13. Hands-on exercises

1.1 All course files.html

1. Hands-on exercise #13

14. Importing And exporting files with Google Sheets

1.1 All course files.html

1. Converting Microsoft Excel files to Google Sheets

2.1 All course files.html

2. Exporting Google Sheets to Microsoft Excel

3.1 All course files.html

3.2 Gapminder Data.html

3.3 Gapminder Tools.html

3. Importing other files types into Google Sheets

4.1 All course files.html

4.2 GapMinder Tools.html

4. My favorite statistical site

15. Hands-on exercises

1.1 All course files.html

1. Hands-on exercise #14

16. Working with data in Google Sheets

1.1 All course files.html

1. Gathering data with a form

2.1 All course files.html

2. Generating data - The Outdoor Gear Coop

3.1 All course files.html

3. Generating data - the name generator

4.1 All course files.html

4. Removing duplicates

5.1 All course files.html

5. Filtering data

6.1 All course files.html

6. Sorting data

17. Hands-on exercises

1.1 All course files.html

1. Hands-on exercise #15

18. Pivot tables

1.1 All course files.html

1. An introduction to pivot tables

2.1 All course files.html

2. Exploring different pivot tables

3.1 All course files.html

3. Pivot charts

4.1 All course files.html

4. Pivot tables, charts, and slicers

19. Hands-on exercises

1.1 All course files.html

1. Hands-on exercise #16

20. Macros

1.1 All course files.html

1. Introduction to macros

2.1 All course files.html

2. Another macro example

21. Hands-on exercises

1.1 All course files.html

1. Hands-on exercise #17

22. Printing, sharing, And collaborating in Sheets

1.1 All course files.html

1. Printing your Google Sheets

2.1 All course files.html

2. Sharing a Google sheet

3.1 All course files.html

3. Working with others on a Google Sheet

4.1 All course files.html

4. Protecting a Google Sheet

5.1 All course files.html

5. Using data validation to ensure valid data

23. Congratulations

1. Great work!

2. Bonus lecture

189,000 تومان

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

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

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

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