SpreadSheet Daily

#5

#4

#3

#02

#01

Day 043:
Query (Part8, aggregating GROUPs of items)

Day 042:
Query (Part7; sum, max, and other aggregates)

Day 041:
Query (Part6, Average of a column)

Day 040:
QUERY (Part 5, selection based on multiple criteria)

Day 039:
QUERY (Part4, using NOT in WHERE)

Day 038:
QUERY (Part 3, Using "GREATER THAN OR EQUAL")

Day 037:
QUERY (Part2)

Day 036:
Query (Part 1)

Day 035:
Example (Split & Arrayformula)

Day 034:
EOMONTH - gives the end of month date

Day 033:
EDATE - gives date several months before or after a given date

Day 032:
SPARKLINE - simple graph in cell

Day 031:
DATEDIF - Count years between dates

Day 030:
VLOOKUP - (Sorted Key for Range Match)
SSS deduction Calculation as sample

Day 029:
TRANSPOSE - change position

Day 028:
GOOGLETRANSLATE
Translate Languages to another Languages.

Day 027:
Sum and SumIf

Day 026:
UNIQUE - list the unique items from list of items with multiple copies

Day 025:
Sort Data by a Column

Day 024:
Net Working Days
Days between dates excluding WEEKENDS and HOLIDAYS

Day 023:
Count Net Working Days (Exclude Weekends)

Day 022:
Restrict Cell Data to Date only

Day 021:
SWITCH function
Alternative of nested IF

Day 020:
ARRAYFORMULA (Extra)
Using single formula to perform operation on range/s of data