Create, Update, Delete

Create

• Autofill & Flashfill
• Advanced Fill Series
• Absolute & Relative References

Update

• Replace Values

Delete

• Clear Formatting

Data Formatting

Format Rows & Columns

Groups

• Groups by Rows & Columns

Segments

• IF()
• NestedIF()

Aggregation

Non Conditional

• Sum, Avg, Count, Min, Max

Conditional

Sum

• SumIF()
• SumIFs()

Average

• AverageIF()
• AverageIFs()

Count

• CountIF()
• CountIFs()

Format Values

• Null Values
• Dublicate Values
• Numerical Values

Text Values

• Case Formatting
• Trim
• Concat
• Split Text to Columns

Data Filtering

Filter by Rows & Columns

• Default Filters
• Vlookup
• Hlookup
• Xlookup

Filter by Values

• Filter by Pattern
• Filter by Range
• Filter by Size (Top_n)

Data Sorting

• Data Sorting

Saving Progress

• Macros
• Protection & Encryption