๐ Simplify data transformations!
๐๐ Use the FLOOR formula to round numbers down to the nearest integer: =FLOOR(A1, 1)
#GoogleEDU
#GoogleSheets #QueenOfSpreadsheets #EduSky
๐๐ Incorporate the ROUNDUP formula to round numbers up to a specified number of decimal places:
=ROUNDUP(A1, 2)
#QueenOfSpreadsheets #GoogleSheets #GoogleEDU #EduSky
3 Google Sheets shortcuts that you will actually use.
alicekeeler.com/2026/02/24/3...
#GoogleSheets #QueenOfSpreadsheets #GoogleEDU #TeacherTech #EduSky
One of my favorite spreadsheet functions is
IF
IF(A1="","","Hello "&A1&" let's learn today")
Check for blank values with empty quotes.
#TeacherTech #QueenofSpreadsheets #GoogleEDU
yellow background organize your data sheets.new
๐งพ Organize your data effectively!
๐๐งฎ Discover the power of the FILTER formula to extract specific information: =FILTER(A1:C10, B1:B10 = "Category")
#GoogleSheets
#GoogleEDU #QueenOfSpreadsheets #GoogleWorkspace
๐งพ Organize your data effectively!
๐๐งฎ Discover the power of the FILTER formula to extract specific information: =FILTER(A1:C10, B1:B10 = "Category")
#EduSky #GoogleSheets
#GoogleEDU #QueenOfSpreadsheets
Need the day out of a date?
For example 10/6/76 you want the 6th...
=DAY(A2)
This extracts the day out of a date field.
#EduSky #QueenOfSpreadsheets #GoogleSheets
๐ค Explore advanced data insights!
๐ก๐ The IF formula lets you customize information:
=IF(C2>90, "Excellent", "Good")
#EduSky
#GoogleEDU #GoogleSheets #QueenOfSpreadsheets
๐ Organize your educational resources efficiently!
๐๐ Utilize the LEFT formula to extract a specified number of characters from the beginning of a cell:
=LEFT(A1, 5)
#GoogleSheets #GoogleEDU #QueenOfSpreadsheets #EduSky