Spreadsheets
There are two tools available to LPS staff that perform spreadsheet functions. Microsoft Excel and Google Sheets. Both are excellent options, and have their own strengths that may lead you to use one over the other depending upon your needs and situation. Both are supported by Computing Services.
Google Sheets
With Google Sheets, you can create and edit spreadsheets directly in your web browser—no special software is required. Multiple people can work simultaneously, you can see people’s changes as they make them, and every change is saved automatically.
Google Sheets is an appealing choice for organizing data or giving students experience organizing data.
PARAMETERS FOR USE: https://www.lps.org/apps/matrix/detail.cfm?app=366
Support Resources
Microsoft Excel
Microsoft Excel is Microsoft Office’s spreadsheet tool install on all LPS staff Macintosh and Windows machines.
Excel really shines when you are looking to get the most out of your data through powerful functions, or extending it into other mediums through a mail merge, for example.
Support Resources
Download Class Lists
from Synergy
Much of the data teachers work with will be collected on your own students. LPS can provide you with a spreadsheet populated with the students you teach. Directions for downloading this information can be found here.
Spreadsheet Skills
for Teachers & Staff
LPS offers a one-hour staff development workshop in which staff are introduced to the basic (sometimes overlooked) ways in which spreadsheets are used. If you are interested in bringing this session to your school, have an administrator contact Kristi Peters. Or, use the link below to learn independently.
Excel Tips & Tricks
LPS Computing Services has assembled a number of Excel tips that may be useful to office professionals based upon our history of supporting their needs. Please reach out via a help ticket if you have needs that are not addressed in this resource.
How do I...
Google Sheets | MS Excel |
|
Create and rename spreadsheets | Microsoft | |
Change the font size or color | Microsoft | |
Change the cell background color | Microsoft | |
Add or remove cell borders | Microsoft | |
Add and delete rows or columns | Microsoft | |
Move rows and columns | Microsoft | |
Cut, Copy, and Paste cell content | Microsoft | |
Autofill (use the fill handle to automatically populate cells) | LPS Document | |
Wrap text in a cell | Microsoft | |
Format numbers, dates, and currencies | Microsoft | |
Conditional formatting | LPS Document | |
Shading alternate rows (or columns) in a worksheet | labnol.org | LPS Document |
Sort a sheet's data | LPS Document | |
Sort by cell format | LPS Document | |
Sort horizontally | LPS Document | |
Switch data from columns to rows (and vice versa) with Transpose | LPS Document | |
Filter a sheet's data | LPS Document | |
Freeze or unfreeze columns & rows | Microsoft | |
Hiding or unhiding columns & rows | LPS Document | |
Copy, re-order, and delete sheets | Microsoft | |
Get notifications when data is added | ||
Add simple formulas | Microsoft | |
AutoSum (and Average, Count, Max, Min) | LPS Document | |
Insert the current date with the TODAY function | LPS Document | |
Insert the current date and time with the NOW function | LPS Document | |
Convert a date to text with the TEXT function | LPS Document | |
Count the number of cells that match specific criteria with the COUNTIF function | LPS Document | |
Join data from two or more cells into one | LPS Document | |
Combine data on two different worksheets into one worksheet with VLOOKUP | LPS Document | |
Combine data on two different worksheets into one worksheet with QUERY and IMPORTDATA | Google | LPS Document |
Removing Duplicates | LPS Document | |
Separate one column of names into multiple columns using SPLIT | LPS Document | |
Separate one column of names into multiple columns using "text to columns" | LPS Document | |
Separate one column of dates into multiple columns | LPS Document | |
Create & edit charts or graphs | Microsoft | |
Import data sets and spreadsheets | ||
Download the spreadsheet | ||
Print the spreadsheet | Microsoft | |
Locate the revision history of the spreadsheet |
You must be logged in to post a comment.