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.
10 powerful Excel features every user should know: đ
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.
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! đ¤Ż
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!
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: đđť
One of my personal favorites.
Sparklines allow you to insert miniature graphs inside an individual cell to easily visualize data.
â˘Select range
â˘Insert ⢠Sparkline
⢠Choose type
Often, a geographical representation of your data can be quite useful.
Need to see where the majority of your customers live?
Interested in which states are driving the most revenue?
â˘Select your range of data
â˘Insert ⢠Map
It's that easy.
Easily track 31 different metrics related to companies of your choice.
⢠Enter ticker symbols
⢠Select the "Data" tab
⢠Select "Stocks"
⢠Choose the metrics you'd like to track.
As you can tell, I'm a big fan of visualizing data.
Conditional formatting is one of the best (and easiest) ways to do this.
Let's face it, if your data looks good, you look good.
Spice it up by adding data bars, heat maps, or icon sets to show trends:
If you've spent any time working in spreadsheets at all you know one thing:
They're only as good as the data entered.
My favorite way to ensure consistency & accuracy is Drop Down lists.
It's easy & guarantees the data will be entered correctlyââevery time.
OK, I'll be honest.
I'm not sure how "powerful" this is, but man, it looks cool.
Did you know you can add your own custom background images to your spreadsheets?
You didn't? Me either.
Check it out:
If you learned something new today:
Follow me @blakeaburge for weekly threads on business, productivity, & building a better you.
Check out my newsletter:
"While You Were Away"
â˘The best of Twitter
â˘In your inbox
â˘Every Sunday
https://t.co/KPDWcYfMx3
https://t.co/Mmvfz7aPpD
12 Google Sheets formulas guaranteed to \U0001f4c8 your productivity today:
— Blake Burge \U0001f4a1 (@blakeaburge) January 21, 2022
More from Blake Burge đĄ
Success isn't a mistake.
8 steps to build the life you want. đ§ľ
Clock In:
It's time to go to work.
There are no magic bullets & "get-rich-quick" doesn't exist in the real world.
Immerse yourself in learning, have a bias toward action, be willing to do what others won't.
Do this & you won't need to look for results, they'll find you.
Work from the top down:
The fastest way to get from where you are to where you want to be?
Find someone who's already there.
Learn from them, seek advice, & follow the path they've forged.
Reach out.
People are more willing to help than you think.
Persist:
The bigger your goals, the more likely it is they'll take longer to achieve.
Most people fail when they quit right before their plan is beginning to work.
By stopping, they never know how close they actually were.
Be consistent. Keep going.
h/t@visualizevalue
Build your personal brand:
We're all selling something, often it's ourselves.
Give before you get.
Provide value, be unique, be consistent.
Once people know what to expect from you, they'll come back for more.
The best advertisement in the world is repeatable results.
8 steps to build the life you want. đ§ľ
Clock In:
It's time to go to work.
There are no magic bullets & "get-rich-quick" doesn't exist in the real world.
Immerse yourself in learning, have a bias toward action, be willing to do what others won't.
Do this & you won't need to look for results, they'll find you.
Work from the top down:
The fastest way to get from where you are to where you want to be?
Find someone who's already there.
Learn from them, seek advice, & follow the path they've forged.
Reach out.
People are more willing to help than you think.
One of the only true shortcuts in life is finding an expert and apprenticing under them.
— James Clear (@JamesClear) July 23, 2021
Persist:
The bigger your goals, the more likely it is they'll take longer to achieve.
Most people fail when they quit right before their plan is beginning to work.
By stopping, they never know how close they actually were.
Be consistent. Keep going.
h/t@visualizevalue
Build your personal brand:
We're all selling something, often it's ourselves.
Give before you get.
Provide value, be unique, be consistent.
Once people know what to expect from you, they'll come back for more.
The best advertisement in the world is repeatable results.
More from Reading
If you want to get rich and live your best life...
10 threads to make you healthy, wealthy, and wise:
1/ Learn a bit of psychology to better understand yourself.
Not from me. From a doctor.
@dremilyanhalt breaks down psych concepts to help you name your feelings and
2/ Define what self-care is to you.
Practice it. Often.
Incredible life lessons from mom, marketing executive, and CEO @AmandaMGoetz.
This thread will blow your mind.
3/ Know your worth.
Pay attention to red flags in business. Stand up for yourself when it's time.
No one knows this better than founder, executive, and influencer marketer,
4/ If you want to get rich, be willing to think outside the box.
Consider unsexy, cash-flowing small businesses.
@Codie_Sanchez is the expert in this and she writes a killer newsletter on building
10 threads to make you healthy, wealthy, and wise:
1/ Learn a bit of psychology to better understand yourself.
Not from me. From a doctor.
@dremilyanhalt breaks down psych concepts to help you name your feelings and
PSYCHOLOGY MEGATHREAD:
— Dr. Emily Anhalt (@dremilyanhalt) February 11, 2020
40 of my favorite psychological concepts, introduced as thoroughly as I could manage in 280 characters or less.
These are core human behaviors that play out in all relationships, & are explored through therapy.
Enjoy, ask questions, & add your own!
2/ Define what self-care is to you.
Practice it. Often.
Incredible life lessons from mom, marketing executive, and CEO @AmandaMGoetz.
This thread will blow your mind.
Things I know at 35,
— Amanda Goetz (@AmandaMGoetz) July 27, 2021
I wish I had known at 25.
\U0001f9f5/
3/ Know your worth.
Pay attention to red flags in business. Stand up for yourself when it's time.
No one knows this better than founder, executive, and influencer marketer,
Emails like this where you need to "prove" your rates, while simultaneously being told you are "overpriced" are never worth the response (unless you're responding with a clapback). pic.twitter.com/nmVmQJHVI5
— Brittany | Influencer Marketing + Social Media (@MissBeeBright) August 10, 2021
4/ If you want to get rich, be willing to think outside the box.
Consider unsexy, cash-flowing small businesses.
@Codie_Sanchez is the expert in this and she writes a killer newsletter on building
I was burned out in finance, working on someone else's schedule, tired of having my time tied to $.
— Codie Sanchez \U0001f4a5 (@Codie_Sanchez) April 9, 2021
So I started investing in cash-flowing biz's.
Not sexy startups, but boring businesses.
One of my fav small deals netted $67k a year, $100k at close... w/ quarters
A thread: pic.twitter.com/Mv0diWoPeB
You May Also Like
1/âWhat would need to be true for you toâŚ.Xâ
Why is this the most powerful question you can ask when attempting to reach an agreement with another human being or organization?
A thread, co-written by @deanmbrody:
2/ First, âXâ could be lots of things. Examples: What would need to be true for you to
- âFeel it's in our best interest for me to be CMO"
- âFeel that weâre in a good place as a companyâ
- âFeel that weâre on the same pageâ
- âFeel that we both got what we wanted from this deal
3/ Normally, we arenât that direct. Example from startup/VC land:
Founders leave VC meetings thinking that every VC will invest, but they rarely do.
Worse over, the founders donât know what they need to do in order to be fundable.
4/ So why should you ask the magic Q?
To get clarity.
You want to know where you stand, and what it takes to get what you want in a way that also gets them what they want.
It also holds them (mentally) accountable once the thing they need becomes true.
5/ Staying in the context of soliciting investors, the question is âwhat would need to be true for you to want to invest (or partner with us on this journey, etc)?â
Multiple responses to this question are likely to deliver a positive result.
Why is this the most powerful question you can ask when attempting to reach an agreement with another human being or organization?
A thread, co-written by @deanmbrody:
Next level tactic when closing a sale, candidate, or investment:
— Erik Torenberg (@eriktorenberg) February 27, 2018
Ask: \u201cWhat needs to be true for you to be all in?\u201d
You'll usually get an explicit answer that you might not get otherwise. It also holds them accountable once the thing they need becomes true.
2/ First, âXâ could be lots of things. Examples: What would need to be true for you to
- âFeel it's in our best interest for me to be CMO"
- âFeel that weâre in a good place as a companyâ
- âFeel that weâre on the same pageâ
- âFeel that we both got what we wanted from this deal
3/ Normally, we arenât that direct. Example from startup/VC land:
Founders leave VC meetings thinking that every VC will invest, but they rarely do.
Worse over, the founders donât know what they need to do in order to be fundable.
4/ So why should you ask the magic Q?
To get clarity.
You want to know where you stand, and what it takes to get what you want in a way that also gets them what they want.
It also holds them (mentally) accountable once the thing they need becomes true.
5/ Staying in the context of soliciting investors, the question is âwhat would need to be true for you to want to invest (or partner with us on this journey, etc)?â
Multiple responses to this question are likely to deliver a positive result.
1. Project 1742 (EcoHealth/DTRA)
Risks of bat-borne zoonotic diseases in Western Asia
Duration: 24/10/2018-23 /10/2019
Funding: $71,500
@dgaytandzhieva
https://t.co/680CdD8uug
2. Bat Virus Database
Access to the database is limited only to those scientists participating in our âBats and Coronavirusesâ project
Our intention is to eventually open up this database to the larger scientific community
https://t.co/mPn7b9HM48
3. EcoHealth Alliance & DTRA Asking for Trouble
One Health research project focused on characterizing bat diversity, bat coronavirus diversity and the risk of bat-borne zoonotic disease emergence in the region.
https://t.co/u6aUeWBGEN
4. Phelps, Olival, Epstein, Karesh - EcoHealth/DTRA
5, Methods and Expected Outcomes
(Unexpected Outcome = New Coronavirus Pandemic)
Risks of bat-borne zoonotic diseases in Western Asia
Duration: 24/10/2018-23 /10/2019
Funding: $71,500
@dgaytandzhieva
https://t.co/680CdD8uug
2. Bat Virus Database
Access to the database is limited only to those scientists participating in our âBats and Coronavirusesâ project
Our intention is to eventually open up this database to the larger scientific community
https://t.co/mPn7b9HM48
3. EcoHealth Alliance & DTRA Asking for Trouble
One Health research project focused on characterizing bat diversity, bat coronavirus diversity and the risk of bat-borne zoonotic disease emergence in the region.
https://t.co/u6aUeWBGEN
4. Phelps, Olival, Epstein, Karesh - EcoHealth/DTRA
5, Methods and Expected Outcomes
(Unexpected Outcome = New Coronavirus Pandemic)
The Eye of Horus. 1/*
I believe that @ripple_crippler and @looP_rM311_7211 are the same person. I know, nobody believes that. 2/*
Today I want to prove that Mr Pool smile faces mean XRP and price increase. In Ripple_Crippler, previous to Mr Pool existence, smile faces were frequent. They were very similar to the ones Mr Pool posts. The eyes also were usually a couple of "x", in fact, XRP logo. 3/*
The smile XRP-eyed face also appears related to the Moon. XRP going to the Moon. 4/*
And smile XRP-eyed faces also appear related to Egypt. In particular, to the Eye of Horus. https://t.co/i4rRzuQ0gZ 5/*
I believe that @ripple_crippler and @looP_rM311_7211 are the same person. I know, nobody believes that. 2/*
Today I want to prove that Mr Pool smile faces mean XRP and price increase. In Ripple_Crippler, previous to Mr Pool existence, smile faces were frequent. They were very similar to the ones Mr Pool posts. The eyes also were usually a couple of "x", in fact, XRP logo. 3/*
The smile XRP-eyed face also appears related to the Moon. XRP going to the Moon. 4/*
And smile XRP-eyed faces also appear related to Egypt. In particular, to the Eye of Horus. https://t.co/i4rRzuQ0gZ 5/*
@franciscodeasis https://t.co/OuQaBRFPu7
Unfortunately the "This work includes the identification of viral sequences in bat samples, and has resulted in the isolation of three bat SARS-related coronaviruses that are now used as reagents to test therapeutics and vaccines." were BEFORE the
chimeric infectious clone grants were there.https://t.co/DAArwFkz6v is in 2017, Rs4231.
https://t.co/UgXygDjYbW is in 2016, RsSHC014 and RsWIV16.
https://t.co/krO69CsJ94 is in 2013, RsWIV1. notice that this is before the beginning of the project
starting in 2016. Also remember that they told about only 3 isolates/live viruses. RsSHC014 is a live infectious clone that is just as alive as those other "Isolates".
P.D. somehow is able to use funds that he have yet recieved yet, and send results and sequences from late 2019 back in time into 2015,2013 and 2016!
https://t.co/4wC7k1Lh54 Ref 3: Why ALL your pangolin samples were PCR negative? to avoid deep sequencing and accidentally reveal Paguma Larvata and Oryctolagus Cuniculus?
Unfortunately the "This work includes the identification of viral sequences in bat samples, and has resulted in the isolation of three bat SARS-related coronaviruses that are now used as reagents to test therapeutics and vaccines." were BEFORE the
chimeric infectious clone grants were there.https://t.co/DAArwFkz6v is in 2017, Rs4231.
https://t.co/UgXygDjYbW is in 2016, RsSHC014 and RsWIV16.
https://t.co/krO69CsJ94 is in 2013, RsWIV1. notice that this is before the beginning of the project
starting in 2016. Also remember that they told about only 3 isolates/live viruses. RsSHC014 is a live infectious clone that is just as alive as those other "Isolates".
P.D. somehow is able to use funds that he have yet recieved yet, and send results and sequences from late 2019 back in time into 2015,2013 and 2016!
https://t.co/4wC7k1Lh54 Ref 3: Why ALL your pangolin samples were PCR negative? to avoid deep sequencing and accidentally reveal Paguma Larvata and Oryctolagus Cuniculus?