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 nstrates the formatting and formula/function features, and provides smart ways to make your data work for you.
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~Get Your Files Here !/01 - Introduction/01 - Getting organized with Google Sheets.mp4
3.1 MB
~Get Your Files Here !/01 - Introduction/01 - Getting organized with Google Sheets.srt
1.6 KB
~Get Your Files Here !/01 - Introduction/02 - Importing exercise files to Google Sheets.mp4
3.7 MB
~Get Your Files Here !/01 - Introduction/02 - Importing exercise files to Google Sheets.srt
2.8 KB
~Get Your Files Here !/02 - 1. Getting Started with Google Sheets/01 - What is Google Sheets.mp4
4.1 MB
~Get Your Files Here !/02 - 1. Getting Started with Google Sheets/01 - What is Google Sheets.srt
5 KB
~Get Your Files Here !/02 - 1. Getting Started with Google Sheets/02 - Accessing Google Sheets with your account.mp4
4.5 MB
~Get Your Files Here !/02 - 1. Getting Started with Google Sheets/02 - Accessing Google Sheets with your account.srt
3.8 KB
~Get Your Files Here !/02 - 1. Getting Started with Google Sheets/03 - Navigating Google Sheets.mp4
14.7 MB
~Get Your Files Here !/02 - 1. Getting Started with Google Sheets/03 - Navigating Google Sheets.srt
10 KB
~Get Your Files Here !/03 - 2. Creating and Managing Spreadsheets/01 - Creating, naming, and saving a spreadsheet.mp4
7.4 MB
~Get Your Files Here !/03 - 2. Creating and Managing Spreadsheets/01 - Creating, naming, and saving a spreadsheet.srt
5.8 KB
~Get Your Files Here !/03 - 2. Creating and Managing Spreadsheets/02 - Copying and re-naming a spreadsheet.mp4
7 MB
~Get Your Files Here !/03 - 2. Creating and Managing Spreadsheets/02 - Copying and re-naming a spreadsheet.srt
5 KB
~Get Your Files Here !/03 - 2. Creating and Managing Spreadsheets/03 - Moving a spreadsheet.mp4
6.1 MB
~Get Your Files Here !/03 - 2. Creating and Managing Spreadsheets/03 - Moving a spreadsheet.srt
4.8 KB
~Get Your Files Here !/03 - 2. Creating and Managing Spreadsheets/04 - Deleting a spreadsheet.mp4
5.6 MB
~Get Your Files Here !/03 - 2. Creating and Managing Spreadsheets/04 - Deleting a spreadsheet.srt
4.6 KB
~Get Your Files Here !/03 - 2. Creating and Managing Spreadsheets/05 - Importing spreadsheets from Excel and OpenOffice.mp4
6.6 MB
~Get Your Files Here !/03 - 2. Creating and Managing Spreadsheets/05 - Importing spreadsheets from Excel and OpenOffice.srt
5 KB
~Get Your Files Here !/03 - 2. Creating and Managing Spreadsheets/06 - Importing data files.mp4
4.2 MB
~Get Your Files Here !/03 - 2. Creating and Managing Spreadsheets/06 - Importing data files.srt
3.4 KB
~Get Your Files Here !/04 - 3. Editing Spreadsheets/01 - Entering and editing cell data.mp4
9.8 MB
~Get Your Files Here !/04 - 3. Editing Spreadsheets/01 - Entering and editing cell data.srt
7.9 KB
~Get Your Files Here !/04 - 3. Editing Spreadsheets/02 - Inserting, deleting, and clearing rows and columns.mp4
5.1 MB
~Get Your Files Here !/04 - 3. Editing Spreadsheets/02 - Inserting, deleting, and clearing rows and columns.srt
4 KB
~Get Your Files Here !/04 - 3. Editing Spreadsheets/03 - Moving or copying rows, columns, and cells.mp4
4.8 MB
~Get Your Files Here !/04 - 3. Editing Spreadsheets/03 - Moving or copying rows, columns, and cells.srt
3.8 KB
~Get Your Files Here !/04 - 3. Editing Spreadsheets/04 - Editing with Find and Replace.mp4
6.7 MB
~Get Your Files Here !/04 - 3. Editing Spreadsheets/04 - Editing with Find and Replace.srt
4.1 KB
~Get Your Files Here !/04 - 3. Editing Spreadsheets/05 - Working with multiple sheets.mp4
9.6 MB
~Get Your Files Here !/04 - 3. Editing Spreadsheets/05 - Working with multiple sheets.srt
6.3 KB
~Get Your Files Here !/04 - 3. Editing Spreadsheets/06 - Creating a series of numbers, letters, or dates.mp4
5.4 MB
~Get Your Files Here !/04 - 3. Editing Spreadsheets/06 - Creating a series of numbers, letters, or dates.srt
4.4 KB
~Get Your Files Here !/04 - 3. Editing Spreadsheets/07 - Inserting images or hyperlinks.mp4
11.1 MB
~Get Your Files Here !/04 - 3. Editing Spreadsheets/07 - Inserting images or hyperlinks.srt
7.1 KB
~Get Your Files Here !/05 - 4. Viewing Spreadsheets/01 - Freezing rows and columns.mp4
5.3 MB
~Get Your Files Here !/05 - 4. Viewing Spreadsheets/02 - Hiding rows, columns, and sheets.mp4
5.5 MB
~Get Your Files Here !/05 - 4. Viewing Spreadsheets/02 - Hiding rows, columns, and sheets.srt
3.5 KB
~Get Your Files Here !/05 - 4. Viewing Spreadsheets/03 - Using filters and creating filter views.mp4
13 MB
~Get Your Files Here !/05 - 4. Viewing Spreadsheets/03 - Using filters and creating filter views.srt
7.9 KB
~Get Your Files Here !/05 - 4. Viewing Spreadsheets/04 - Sorting data on a spreadsheet.mp4
9 MB
~Get Your Files Here !/05 - 4. Viewing Spreadsheets/04 - Sorting data on a spreadsheet.srt
5 KB
~Get Your Files Here !/06 - 5. Formatting, Printing, and Publishing Spreadsheets/01 - Formatting cells, rows, and columns.mp4
13.2 MB
~Get Your Files Here !/06 - 5. Formatting, Printing, and Publishing Spreadsheets/01 - Formatting cells, rows, and columns.srt
8.4 KB
~Get Your Files Here !/06 - 5. Formatting, Printing, and Publishing Spreadsheets/02 - Using conditional formatting.mp4
11.7 MB
~Get Your Files Here !/06 - 5. Formatting, Printing, and Publishing Spreadsheets/02 - Using conditional formatting.srt
6.1 KB
~Get Your Files Here !/06 - 5. Formatting, Printing, and Publishing Spreadsheets/03 - Printing a spreadsheet.mp4
8.6 MB
~Get Your Files Here !/06 - 5. Formatting, Printing, and Publishing Spreadsheets/03 - Printing a spreadsheet.srt
7.9 KB
~Get Your Files Here !/07 - 6. Working with Spreadsheet Data/01 - See the Sum, Average, Min, Max, or Count.mp4
8.8 MB
~Get Your Files Here !/07 - 6. Working with Spreadsheet Data/01 - See the Sum, Average, Min, Max, or Count.srt
5.1 KB
~Get Your Files Here !/07 - 6. Working with Spreadsheet Data/02 - Using formulas and functions.mp4
13.7 MB
~Get Your Files Here !/07 - 6. Working with Spreadsheet Data/02 - Using formulas and functions.srt
9.6 KB
~Get Your Files Here !/07 - 6. Working with Spreadsheet Data/03 - Using IF and nested functions in formulas.mp4
13.6 MB
~Get Your Files Here !/07 - 6. Working with Spreadsheet Data/03 - Using IF and nested functions in formulas.srt
7.3 KB
~Get Your Files Here !/07 - 6. Working with Spreadsheet Data/04 - Creating charts and graphs.mp4
11.4 MB
~Get Your Files Here !/07 - 6. Working with Spreadsheet Data/04 - Creating charts and graphs.srt
8.3 KB
~Get Your Files Here !/07 - 6. Working with Spreadsheet Data/05 - Using pivot tables.mp4
10.7 MB
~Get Your Files Here !/07 - 6. Working with Spreadsheet Data/05 - Using pivot tables.srt
7.2 KB
~Get Your Files Here !/07 - 6. Working with Spreadsheet Data/06 - Using the VLOOKUP function.mp4
12.3 MB
~Get Your Files Here !/07 - 6. Working with Spreadsheet Data/06 - Using the VLOOKUP function.srt
6.1 KB
~Get Your Files Here !/08 - 7. Collaborating with Google Sheets/01 - Sharing a spreadsheet with other people.mp4
10.9 MB
~Get Your Files Here !/08 - 7. Collaborating with Google Sheets/01 - Sharing a spreadsheet with other people.srt
8.1 KB
~Get Your Files Here !/08 - 7. Collaborating with Google Sheets/02 - Collaborating and commenting on a spreadsheet.mp4
12.1 MB
~Get Your Files Here !/08 - 7. Collaborating with Google Sheets/02 - Collaborating and commenting on a spreadsheet.srt
8.6 KB
~Get Your Files Here !/08 - 7. Collaborating with Google Sheets/03 - Working with spreadsheet revisions.mp4
8.7 MB
~Get Your Files Here !/08 - 7. Collaborating with Google Sheets/03 - Working with spreadsheet revisions.srt
5.5 KB
~Get Your Files Here !/09 - Conclusion/01 - Additional resources.mp4
3 MB
~Get Your Files Here !/09 - Conclusion/01 - Additional resources.srt
2.4 KB
~Get Your Files Here !/Bonus Resources.txt
386 B
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 1/01_03/Navigating.xlsx
40.8 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 1/Google Sheets Glossary_2024.pdf
29.9 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 2/02_02/Solar Panel Chart.xlsx
4.5 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 2/02_03/Solar Panel Chart.xlsx
4.5 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 2/02_04/Solar Panel Chart.xlsx
4.5 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 2/02_05/Solar Panel Chart - Excel Format .xlsx
8.8 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 2/02_05/Sunshine Chart - Excel Format.xlsx
14.3 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 2/02_06/Solar Panel Chart - csv format.csv
201 B
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 3/03_01/cells.xlsx
41.7 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 3/03_02/inserting.xlsx
4.5 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 3/03_03/moving.xlsx
4.5 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 3/03_04/find_replace.xlsx
40.9 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 3/03_05/sheets.xlsx
40.7 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 3/03_06/series.xlsx
4.4 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 3/03_07/hyperlinks.xlsx
40.9 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 3/03_07/images.xlsx
25.9 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 3/03_07/KEco-Logo-100.jpg
630.7 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 4/04_01/freeze.xlsx
10.5 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 4/04_02/hide.xlsx
10.5 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 4/04_03/filter.xlsx
15.2 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 4/04_04/sort.xlsx
14.4 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 5/05_01/format.xlsx
5.4 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 5/05_02/conditional_formatting.xlsx
5.5 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 5/05_03/print.xlsx
41.1 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 6/06_01/calculations.xlsx
13.1 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 6/06_02/formulas.xlsx
15.9 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 6/06_03/if_functions.xlsx
5.5 KB
~Get Your Files Here !/Ex_Files_Google_Sheets_EssT/Exercise Files/Ch 6/06_04/charts.xlsx