Linkedin - Google Sheets Essential Training
Course details
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
1. Introduction/1. Getting organized with Google Sheets.mp4 4.72 MiB 1. Introduction/2. Importing exercise files to Google Sheets.mp4 4.60 MiB 2. Getting Started with Google Sheets/1. What is Google Sheets.mp4 4.75 MiB 2. Getting Started with Google Sheets/2. Accessing Google Sheets with your account.mp4 5.67 MiB 2. Getting Started with Google Sheets/3. Navigating Google Sheets.mp4 19.04 MiB 3. Creating and Managing Spreadsheets/1. Creating naming and saving a spreadsheet.mp4 9.35 MiB 3. Creating and Managing Spreadsheets/2. Copying and re-naming a spreadsheet.mp4 8.78 MiB 3. Creating and Managing Spreadsheets/3. Moving a spreadsheet.mp4 7.72 MiB 3. Creating and Managing Spreadsheets/4. Deleting a spreadsheet.mp4 6.84 MiB 3. Creating and Managing Spreadsheets/5. Importing spreadsheets from Excel and OpenOffice.mp4 8.26 MiB 3. Creating and Managing Spreadsheets/6. Importing data files.mp4 5.28 MiB 4. Editing Spreadsheets/1. Entering and editing cell data.mp4 11.99 MiB 4. Editing Spreadsheets/2. Inserting deleting and clearing rows and columns.mp4 6.29 MiB 4. Editing Spreadsheets/3. Moving or copying rows columns and cells.mp4 5.96 MiB 4. Editing Spreadsheets/4. Editing with Find and Replace.mp4 8.77 MiB 4. Editing Spreadsheets/5. Working with multiple sheets.mp4 12.00 MiB 4. Editing Spreadsheets/6. Creating a series of numbers letters or dates.mp4 6.67 MiB 4. Editing Spreadsheets/7. Inserting images or hyperlinks.mp4 14.05 MiB 5. Viewing Spreadsheets/1. Freezing rows and columns.mp4 6.76 MiB 5. Viewing Spreadsheets/2. Hiding rows columns and sheets.mp4 6.93 MiB 5. Viewing Spreadsheets/3. Using filters and creating filter views.mp4 16.75 MiB 5. Viewing Spreadsheets/4. Sorting data on a spreadsheet.mp4 11.89 MiB 6. Formatting Printing and Publishing Spreadsheets/1. Formatting cells rows and columns.mp4 17.32 MiB 6. Formatting Printing and Publishing Spreadsheets/2. Using conditional formatting.mp4 15.84 MiB 6. Formatting Printing and Publishing Spreadsheets/3. Printing a spreadsheet.mp4 10.69 MiB 7. Working with Spreadsheet Data/1. See the Sum Average Min Max or Count.mp4 11.33 MiB 7. Working with Spreadsheet Data/2. Using formulas and functions.mp4 17.79 MiB 7. Working with Spreadsheet Data/3. Using IF and nested functions in formulas.mp4 17.86 MiB 7. Working with Spreadsheet Data/4. Creating charts and graphs.mp4 14.14 MiB 7. Working with Spreadsheet Data/5. Using pivot tables.mp4 13.86 MiB 7. Working with Spreadsheet Data/6. Using the VLOOKUP function.mp4 17.41 MiB 8. Collaborating with Google Sheets/1. Sharing a spreadsheet with other people.mp4 13.73 MiB 8. Collaborating with Google Sheets/2. Collaborating and commenting on a spreadsheet.mp4 15.54 MiB 8. Collaborating with Google Sheets/3. Working with spreadsheet revisions.mp4 11.37 MiB 9. Conclusion/1. Additional resources.mp4 3.90 MiB Ex_Files_Google_Sheets_EssT.zip 953.12 KiB