Blake Burge
Blake Burge

@blakeaburge

8 Tweets 8 reads Dec 22, 2022
5 Excel Skills you should have learned in school (but didn't): 📊
Combine Text using "&"
Let's say you have a list of First & Last names you need to combine.
• Select the destination cell
• For our example the function will be:
👉🏻 =A3&" "&B3
• Press "Enter"
It's that easy.
Transpose Data:
Sometimes you have data organized in Rows when you'd rather it be in Columns, or vice-versa.
With the Transpose command, you're only a couple of clicks away.
CTRL or CMD+C to Copy the range of data
Click the arrow next to "Paste"
Select "Transpose"
Done.
Did you know you can paste data from Excel into Word or PowerPoint and...
It will update automatically?
• Copy from Excel
• "Paste Special" in Word
• Select "Paste link"
• MS Excel Worksheet Object
The picture in Word updates as data changes in Excel!
Ever wonder how much time has passed between two dates?
With the DATEDIF function, it's easy to find out.
=DATEDIF(A5,B5,"D")
• "A5"=Start date cell
• "B5"=End date cell
• "D"=Time interval value you'd like to see
D=Days
M=Months
Y=Years
Like this:
Index Match:
People love combining the INDEX + MATCH functions, and for good reason.
INDEX - Finds a value at a given location within a range.
MATCH - Finds the location of an item within a range.
Put them together, and you're unstoppable.
Here's a quick example:
Thanks for reading!
I have two goals:
• Helping you learn
• Saving you time
Whenever you're ready, I've created a library of Excel & Google Sheets templates you can use.
→ Get in shape
→ Build better habits
→ Manage your money
Find 'em here:
blakeburge.com
If you enjoyed this tweet, you'd probably like my newsletter as well.
Join 23K+ others and sign up below.
It's free and you'll get new tutorials every Sunday.
blakeburge.com

Loading suggestions...