Excel

Shortcuts

1. ctrl+E : Flash fill - matches a pattern in adjacent cell to extract data
2. ctrl+H : Find and Replace

1. ctrl+shift+1 : Number format (2 decimals)
2. ctrl+shift+2 : Time format
3. ctrl+shift+3 : Date format

Tips

Using ' before value will store value as a string in the cell

Data Viz

1. Pivot Tables
2. Heat Maps

Financial functions

1. PMT

References