1. Excel Nano Tips
VSTACK tip
()
Beware of the shape-shifting functions: Volatile functions
()
Visualize data with sparklines in your cells
()
Automatic list numbering with SEQUENCE and COUNTA functions
()
Remove empty columns shortcut
()
Shortcut to highlight duplicates in a data set
()
Flash fill shortcut to combine names
()
Find which items are not on a list with FILTER and COUNTIF
()
Fill a series of cells with the text above it
()
Add a bar chart to your Excel cell
()
Create a centered spreadsheet title without merging cells
()