Google Sheets Essential Training

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

Learn how to analyze and organize data in Sheets, the popular spreadsheet tool from Google. Instructor Sally Norred starts with a tour of the Sheets interface, then shows how to enter and work with data. Sally demonstrates the formatting and formula/function features, and provides smart ways to make your data work for you.

01 - Introduction

01 - Getting organized with Google Sheets

02 - Importing exercise files to Google Sheets

02 - 1. Getting Started with Google Sheets

01 - What is Google Sheets

02 - Accessing Google Sheets with your account

03 - Navigating Google Sheets

03 - 2. Creating and Managing Spreadsheets

01 - Creating, naming, and saving a spreadsheet

02 - Copying and re-naming a spreadsheet

03 - Moving a spreadsheet

04 - Deleting a spreadsheet

05 - Importing spreadsheets from Excel and OpenOffice

06 - Importing data files

04 - 3. Editing Spreadsheets

01 - Entering and editing cell data

02 - Inserting, deleting, and clearing rows and columns

03 - Moving or copying rows, columns, and cells

04 - Editing with Find and Replace

05 - Working with multiple sheets

06 - Creating a series of numbers, letters, or dates

07 - Inserting images or hyperlinks

05 - 4. Viewing Spreadsheets

01 - Freezing rows and columns

02 - Hiding rows, columns, and sheets

03 - Using filters and creating filter views

04 - Sorting data on a spreadsheet

06 - 5. Formatting, Printing, and Publishing Spreadsheets

01 - Formatting cells, rows, and columns

02 - Using conditional formatting

03 - Printing a spreadsheet

07 - 6. Working with Spreadsheet Data

01 - See the Sum, Average, Min, Max, or Count

02 - Using formulas and functions

03 - Using IF and nested functions in formulas

04 - Creating charts and graphs

05 - Using pivot tables

06 - Using the VLOOKUP function

08 - 7. Collaborating with Google Sheets

01 - Sharing a spreadsheet with other people

02 - Collaborating and commenting on a spreadsheet

03 - Working with spreadsheet revisions

09 - Conclusion

01 - Additional resources

139,000 تومان

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

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

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

تولید کننده: LinkedIn Learning (Lynda)