10 powerful Excel features every user should know: đ
Flash Fill:
Let's say you've got all the data you needââit just isn't in the right place.
"Flash Fill" is your friend.
Quickly extract pieces of text from one cell and move them to another OR combine text from multiple cells into a single place.
Camera Snapshot
Here's a little-known trick to move data between workbooks.
First, add "camera" to your quick access toolbar.
â˘Select your data ⢠click đˇ
â˘Paste to new workbook
The cool part: When you update the main workbook, the data in the picture updates as well! đ¤Ż
Analyze Data:
I was never very good at Pivot tables, graphs, & analyzing data on my own.
Lucky for me (and you) Excel will do the heavy lifting for us.
â˘Select the range of data
â˘"Home" ⢠"Analyze Data"
Charts, tables, & analysisââpremade.
Click "insert" & you're done!
X-Lookup
If you're an old-school Excel user, there's no doubt you're familiar with V-Lookup.
X is the new & improved version, here's why:
â˘Lookup array does NOT have to be only on the left-hand side.
â˘Allows you to return multiple values at the same time.
Here's how: đđť