Work Smarter Not Harder.
Shave a few hours off of your week with these 5 Excel Skills: π
Shave a few hours off of your week with these 5 Excel Skills: π
Monday: VSTACK
Combine multiple Excel sheets into one (without copying & pasting): π
β’ Create a new sheet
β’ =VSTACK in cell A1
β’ Hold Shift and select all sheets
β’ Last select the range you want to stack
Done, all sheets combined into one!
Combine multiple Excel sheets into one (without copying & pasting): π
β’ Create a new sheet
β’ =VSTACK in cell A1
β’ Hold Shift and select all sheets
β’ Last select the range you want to stack
Done, all sheets combined into one!
Tuesday: REPT Graph
An alternative to Sparklines.
Did you know you can put a graph within a cell using the REPT formula in Excel?
Here's how: π
An alternative to Sparklines.
Did you know you can put a graph within a cell using the REPT formula in Excel?
Here's how: π
Wednesday: Data from Picture
π· β π
β’ Take a screenshot
β’ Insert β Data From Picture
β’ Picture From File β Select File
β’ Review Items For Accuracy
β’ Add to Worksheet
Done!
π· β π
β’ Take a screenshot
β’ Insert β Data From Picture
β’ Picture From File β Select File
β’ Review Items For Accuracy
β’ Add to Worksheet
Done!
Thursday: What-If Analysis
Calculate payments & interest.
Step 1:
β’ Enter Loan Info
β’ Payment β "PMT" Function
β’ Fill In Total Payment & Interest Paid
Step 2:
β’List Alternate Interest Rates
β’Reference starting "Interest Rate"
β’Apply "What-If" Analysis
Calculate payments & interest.
Step 1:
β’ Enter Loan Info
β’ Payment β "PMT" Function
β’ Fill In Total Payment & Interest Paid
Step 2:
β’List Alternate Interest Rates
β’Reference starting "Interest Rate"
β’Apply "What-If" Analysis
Friday: Calculated Fields
Here's an Excel Pivot Table trick I bet you're not using:
Use "Calculated Fields" to apply formulas to data within your table.
Like this: ππ»
Here's an Excel Pivot Table trick I bet you're not using:
Use "Calculated Fields" to apply formulas to data within your table.
Like this: ππ»
That's all for today!
If you enjoyed this, follow me @blakeaburge for more.
Also, check out my growing library of Excel & Google Sheets Templates designed to make your life easier.
You can find them here:
blakeburge.gumroad.com
If you enjoyed this, follow me @blakeaburge for more.
Also, check out my growing library of Excel & Google Sheets Templates designed to make your life easier.
You can find them here:
blakeburge.gumroad.com
Oh yeah, almost forgot.
You should try my newsletter.
22,000 Other People Can't Be Wrong.
It's free and you'll learn something new each week. Pretty simple.
blakeburge.com
You should try my newsletter.
22,000 Other People Can't Be Wrong.
It's free and you'll learn something new each week. Pretty simple.
blakeburge.com
Loading suggestions...