Do Access (Database Operations) in Excel
Complex query; Join; Aggregation (group by)

Kill Duplicates

1-Step Summary
Much simpler than Pivot Table
Aggregate in Median, Count Unique, Mode ...
More powerful than SubTotal
Output to a simple table (list)

Merge (join) Tables by Column(s) (fuzzy) Match

Match 2 Tables by 1 or multiple columns

Link Tools
Break broken link, clean up link error

Complex Filter
Set multiple complex criteria
Filter blank, duplicates, exclude, invert

Advanced Sort
Multi-level sort; Random sort

Fill Blank Cells Scattered in Selected Area(s)
Fill Linear or Date Series in each block
Fill Down, Up, Right, Left in each block

Fill range by Random Numbers/Dates

Deleting Tools
Delete empty rows & columns
Delete hidden, visible, or by any criteria

Extract Visible Rows

Transform Tables
Split table by values in column(s)
Transpose CrossTab to list
Shift columns

Convert Texts and Dates
Cast data types (beyond formatting)