Working Smart with Microsoft Excel

Create Table
Quick insert of new row
Quick Formatting using Table Style
Turn on quick summary with Subtotal
Cleaning Up Duplicate Entry
Convert Table as Range

Adding up value with SUMIF / SUMIFS
Finding number of entry with COUNTIF / COUNTIFS
Average up value with AVERAGEIF / AVERAGEIFS
return an alternative result with IFERROR

Dropdown list to limit entries
Restrict value entry for number and date
Custom user defined restriction

Vertical search for exact matching data using VLOOKUP
Horizontal search for matching data using HLOOKUP
VLOOKUP as alternative for Nested IF function
Multiple searches with INDEX and MATCH

Highlight Cell Rules
Using Data Bars
Using Icon Sets
Creating New Rules with Formula