10 Excel tips they should have taught you 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.
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.
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.
Protecting Sheets:
It's a crazy world out there.
You can't just go around sending your worksheets to everyone without adding some protection.
β’ Right-click on the tab of the sheet
β’ Select "Protect Sheet"
β’ Enter a password
β’ Choose what to allow users to do (or not)
It's a crazy world out there.
You can't just go around sending your worksheets to everyone without adding some protection.
β’ Right-click on the tab of the sheet
β’ Select "Protect Sheet"
β’ Enter a password
β’ Choose what to allow users to do (or not)
Limit Input:
The last thing you need is people "willy-nilly" entering whatever they want in your sheet.
Use Data Validation to set parameters for what can, and can't, be input into a given cell or range.
Limit length of text, format, or build your own custom list.
Here's how:
The last thing you need is people "willy-nilly" entering whatever they want in your sheet.
Use Data Validation to set parameters for what can, and can't, be input into a given cell or range.
Limit length of text, format, or build your own custom list.
Here's how:
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!
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!
Enter the same data in multiple cells:
Yes, I know you can copy & paste, but ain't nobody got time for that.
When you need to enter the same data in several cells try this:
β’Select all of the destination cells
β’Type a single entry
β’ Hit CMD or CNTRL + Enter
VoilΓ !
Yes, I know you can copy & paste, but ain't nobody got time for that.
When you need to enter the same data in several cells try this:
β’Select all of the destination cells
β’Type a single entry
β’ Hit CMD or CNTRL + Enter
VoilΓ !
Chart Templates:
Customizing charts to look the way you want can be a pain.
Don't let all of your hard work go to waste!
Save them.
β’ Right-click on the chart
β’ Save as template
The chart will now be listed in the insert menu for future use, no need to build it again!
Customizing charts to look the way you want can be a pain.
Don't let all of your hard work go to waste!
Save them.
β’ Right-click on the chart
β’ Save as template
The chart will now be listed in the insert menu for future use, no need to build it again!
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:
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:
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:
Incognito Cell Data:
Sometimes you have data you'd prefer not every wandering eye in the office gets to see.
With hidden values, you keep the data, but the cells appear empty.
β’ Select the cell or range
β’ Click "β" next to Number
β’ More formats
β’ Custom
β’ Type: ";;;"
Sometimes you have data you'd prefer not every wandering eye in the office gets to see.
With hidden values, you keep the data, but the cells appear empty.
β’ Select the cell or range
β’ Click "β" next to Number
β’ More formats
β’ Custom
β’ Type: ";;;"
Last:
Threads are great...
But if you really want to get better at Excel, you can't afford to miss this.
I'll keep it simple:
β Most jobs require basic Excel skills.
β More skills = More money π°
Get yours!
The next round starts Tuesday ππ»
excelfoundations1.carrd.co
Threads are great...
But if you really want to get better at Excel, you can't afford to miss this.
I'll keep it simple:
β Most jobs require basic Excel skills.
β More skills = More money π°
Get yours!
The next round starts Tuesday ππ»
excelfoundations1.carrd.co
That's it for today.
Follow me at @blakeaburge for weekly threads on business & productivity.
Join 15,000+ others & check out my newsletterββIt's free!
β’The best of Twitter
β’In your Inbox
β’Every Sunday
blake.ck.page
Follow me at @blakeaburge for weekly threads on business & productivity.
Join 15,000+ others & check out my newsletterββIt's free!
β’The best of Twitter
β’In your Inbox
β’Every Sunday
blake.ck.page
Loading suggestions...