BC PRODUCTIVITY
Saved by @SanjayS39040530

10 Excel Formulas To 10x Your Productivity:

 You have a table of cookie sales and have to answer:

• Who sold least / most cookies by month
• Who are the top 25% / bottom 25%
• Who has the most winning months
• Who has the most losing months
• Who sold the most cookies
• How is each girl trending

Let's dive in.
• Format & shortcuts

Before you start, format your worksheet and lay out what you want to build.

Shortcuts used:

• Ctrl + space bar = Insert Column
• Shift + space bar = Insert Row
• Ctrl + shift + + = Insert
• Ctrl + R = Fill Right
• =Sum(G8:G17)
• Min and Max

Min and Max are helpful when working with large data sets.

Min returns the lowest value in a series of data.

Max returns the highest value in a series of data.

Min Formula: =Min(number1, number2...)

Max Formula: =Max(number1, number2...)
• Concatenate

Concatenate will bring strings of data together.

When you want to combine a first and last name into a single cell, it's your tool.

The formula is:

=concatenate(text1, text2, text3)

Remember to add a " " between the first and second name as text2
• Sparklines

Sparklines let's us answer the question: How is each girl trending.

With Sparklines, we can insert graphical data directly into a cell of our table as simply as:

• Select Range
• Insert Sparkline
• I choose Column
• Quartile

In statistics, a quartile divides the number of data points into four parts, or quarters, of more-or-less equal size.

It lets us know the bottom 25% of sales people and the top 25% of sales people are.

Formula: =quartile(array,quart)

quart = the quartile we want.
• Sumifs

We use sumifs when we want to add cells that meet multiple criteria, generally in a list.

In our scenario, we want to sum numbers between two quartiles.

Formula = sumifs(range, criteria1 range, criteria1, criteria2 range, criteria2)
• X-Lookup

X-Lookup is an upgraded V-Lookup.

We use it to find data in a table or range.

We are going to combine our X-Lookup with our Min and Max function.

The formula: =XLOOKUP(lookup value, lookup array, return array)

Ours will pull the min / max person by month.
• Countif

Countif will count a value that meets certain criteria.

We will use this to determine how many times someone was the minimum value or maximum value in a month.

Formula: =countif(range, criteria)
• Conditional formatting

Conditional formatting lets us highlight information for the readers.

We can either set our own rules or use preset rules, as we will in our example.

By using different colors it draws your eyes to the good, and bad.
• Finished product

You always want your finished product to look good and be consistent.

When someone reads your work and it looks good, they ask less questions.

When you are asked less questions, you are more productive.

Make your work look good.
TL;DR:

If you want to 10x your Excel productivity, learn these 10 formulas and techniques:

• Conditional formatting
• Format & shortcuts
• Min +Max formula
• Concatenate
• Sparklines
• X-Lookup
• Quartile
• Countif
• Sumifs
If you enjoyed this thread, please:

1. Follow @IAmClintMurphy
2. Share the first tweet

https://t.co/zYFc73vj2C

Until next time,

Clint Murphy

More from Productivity

Andrew Wilkinson
Andrew Wilkinson
@awilkinson
I increasingly believe that the only successful approach to productivity is treating yourself like an addict

If you want to stop drinking alcohol, don't keep it in the house 🙅

Here's how I keep myself productive:

1. Clean Out The Cupboards 📱

I use iOS Screen Time to block all social media, news, and yes, EMAIL, from my phone.

I also remove the ability to install new apps.

My wife set the code, so I don't have any easy way to get around it.

2. Add Guiderails 🚆

On my Mac, I have an automation that quits all apps each morning before I get to work and pulls up OmniFocus on the screen, so it's always the first thing I see when I open my computer and can't go down a rabbit trail.

3. Reduce Dopamine Hits 🥱

I use to spend my entire day in my inbox.

As I'd send emails, new ones would stream in constantly, and before I'd know it I'd spent 4-5 hours just responding to emails instead of moving important projects or individual work forward.

I setup @Mailman_HQ, a Gmail plug-in @mohitmamoria and I built, to only deliver email once in the morning and once in the early afternoon, and to automatically batch any emails from anyone I hadn't emailed with before at 7AM...
LIFE , PRODUCTIVITY
Farris Cash \U0001f4b5
Farris Cash 💵
@FarrisCash
A 2-minute read that'll help you 10x your potential;

Do hard shit

It doesn’t matter what it is. A cold shower, a difficult workout, writing etc. force yourself to face and work through adversity.

Discipline is a muscle you train with experience.

Stop chasing happiness

Happiness is a response to an outcome—a fleeting feeling in the moment.

When you get it you get it, you immediately raise the bar. What you have isn’t good enough for long.

Aim for joy instead.

Find joy in the process—the outcome doesn’t matter.

Define success for yourself

Don’t get caught up chasing money, fame, or job titles that society celebrates as success.

Figure out what’s important to you—define what success looks like, it'll change over time.

Avoid people and things that don’t help reach your goals.

Don't dwell on the past

Everyone makes mistakes—own them and move on.

Don’t let guilt or regret steal from your future.

Turn the page and get busy writing the next chapter of your life.
PRODUCTIVITY
Advertisement
Ben Meer
Ben Meer
@SystemSunday
How to beat Imposter Syndrome.

5 steps to have the career you want:

Have you ever felt like a fraud?

Like you haven’t earned your accomplishments?

You’re not alone.

Up to 82% of people suffer from Imposter Syndrome.

It’s the single greatest threat to your career (and reaching your potential).

Today I’ve going to break down WHY Imposter Syndrome happens

And a proven plan to overcome it.

Let’s get started.

So, why does Imposter Syndrome happen?

Credit goes to a quirky cognitive bias:

“Dunning-Kruger Effect”

Dunning-Kruger Effect

Novices experience overconfidence due to quick progression on the learning curve.

While experts’ confidence drops because they realize what they don’t yet know.

Paradoxically, the more you become an expert, the more you may feel like an imposter.
PRODUCTIVITY
Juvoni Beckford
Juvoni Beckford
@juvoni
I decided to stop lurking & take Twitter seriously around 6 months ago.

Grateful for a place to share ideas & to have grown from 900s to 7.1k since then.

Learned a lot about Twitter's algorithms over this period.

Sharing 1 tip to grow your Twitter per every 2 likes 📈 🐦


All your reach on social media is dependent on Network effects.

If you're below < 2k followers most of your tweets should be helpful replies to other larger accounts.

Don't be a "reply guy" tho. The audience of a large account can tell & the large account holder my block u.


When you borrow reach from a large account & someone clicks on your profile you should ->

Specify why people should follow you in your bio.
Give people a reason to follow you.

Titles & Social proof do help, unfortunately.

Good Format:
I Tweet About / Explore X
I Do Y
I Am Z

Your Pinned Tweet is the next possible point of converting someone into a follower.

Ideally, your pinned tweet should have a lot of social proof (likes) & summarize the essence of your bio & expand as a thread.

This is where you start to have an umbrella for your brand.

Each tweet you make should add value.

It should either:
1. Educate
2. Inspire
3. Entertain
4. Connect
5. Dispute
TWITTER , ALL , PRODUCTIVITY
Corey Wilks, Psy.D. \U0001f918
Corey Wilks, Psy.D. 🤘...
@CoreyWilksPsyD
You know how having too many open Chrome tabs bogs your computer down?

The same happens to your brain.

Unfinished tasks keep "running" in the background.

It's called the Zeigarnik Effect.

Here's how it works and what to do about it:

🧵

Quick History:

Named after Dr. Bluma Zeigarnik.

While sitting in a busy restaurant in Vienna, she noticed the waiters had better memories of unpaid orders vs. paid ones.

Once the bill was paid, they struggled to remember the exact details of the orders.

But why?

1/ Our brains are wired to remember unfinished tasks better than completed ones.

Like a to-do list, once we finish a task, our brain checks it off the list to free up mental bandwidth.

The more unfinished tasks, the more resources our brain dedicates to keeping track of them.

2/ Storytellers leverage the Zeigarnik Effect with cliffhangers.

We keep reading/watching to find out what happens next because our brains are driven to seek closure.

Once resolved, we can forget and move on.

Until then, we lean in with rapt attention.

3/ It's another reason blocking uninterrupted time for deep work is important.

What most call "multi-tasking" is actually task-switching.

The ZE is one reason we suck at it.

When we're doing something and get interrupted, our brain keeps that "tab" open—draining our CPU.
PRODUCTIVITY , ALL

You May Also Like

WORLD OF SANATAN DHARMA
WORLD OF SANATAN DHARM...
@world_sanatan
UNTOLD STORY OF QUEEN BHAVASHANKARI OF BENGAL - A 🧵u must read

Know the role of Naga Sadhus

PART-1

One of the most underrated empires to ever grace India is the kingdom of Bhurshut from central Bengal.

1/


A medieval powerhouse this kingdom stood firm against the Pathan invasion from Orissa twice, and with each time devastating the enemy forces.

Along with this, we also have to note that this was the time when the empire was under the reign of a widowed queen named Bhavashankari.

She wasn’t even born in a royal family and yet she achieved what most of the kings couldn’t do

This begs the question, why does no one remember this great kingdom?

3/

Bhurshut empire thrived from 15th century till late 18th century as an independent kingdom while acting as tributary state with full autonomy.

4/

What’s even more puzzling is that no one knows about the great queen Bhavanshakari who thrashed the Pathans single handedly without the aid of their allies.

5/
ALL
Steve
Steve
@braidedmanga
Ivor Cummins has been wrong (or lying) almost entirely throughout this pandemic and got paid handsomly for it.

He has been wrong (or lying) so often that it will be nearly impossible for me to track every grift, lie, deceit, manipulation he has pulled. I will use...


... other sources who have been trying to shine on light on this grifter (as I have tried to do, time and again:


Example #1: "Still not seeing Sweden signal versus Denmark really"... There it was (Images attached).
19 to 80 is an over 300% difference.

Tweet: https://t.co/36FnYnsRT9


Example #2 - "Yes, I'm comparing the Noridcs / No, you cannot compare the Nordics."

I wonder why...

Tweets: https://t.co/XLfoX4rpck / https://t.co/vjE1ctLU5x


Example #3 - "I'm only looking at what makes the data fit in my favour" a.k.a moving the goalposts.

Tweets: https://t.co/vcDpTu3qyj / https://t.co/CA3N6hC2Lq
FINANCE , ALL
Advertisement
Anu Satheesh
Anu Satheesh
@AnuSatheesh5
Beautiful story of Shri Krishna, Mata Rukmini & Satyabhama which teaches the importance of Bhakthi.
Devotion is important than anything.
#bhakthi
🕉
Satyabhama, royal princess was very proud of herself. Rukmini was very humble, her devotion was pure to Shri Krishna.


One day, Rishi Narada( Kalahapriya) arrived in Dwaraka and met Sathyabhama. In between the conversation he hinted that Krishna exhibits affection more to Rukmini than her. Worried Sathyabhama asked what can should be done to gain Krishna's undivided attention.
@SriramKannan77


Narada asked Satyabhama to make a vow, that she will hand over Krishna to him as a slave, if she cannot trade wealth equivalent to Krishna's weight. Narada thus convinces Sathyabhama that Krishna will admire her for sacrificing all her wealth for him.


Sathyabhama was sure that she have enough wealth to balance Krishna.

She went to Krishna and told about her vow to Narada. Krishna patiently listened to her and accepted the challenge. Satyabhama arranged to bring large scales to weigh and brought all her precious jewels.


Krishna patiently sat on one plate of the Scales (tula). Sathyabhama started piling up the gold, jewels on the other plate. She kept adding more and more wealth, but the pan with Krishna did not even budge. Even after keeping all her jewels the scale did not move a little
RELIGION
Erik Torenberg
Erik Torenberg
@eriktorenberg
1/ Some initial thoughts on personal moats:

Like company moats, your personal moat should be a competitive advantage that is not only durable—it should also compound over time.

Characteristics of a personal moat below:


2/ Like a company moat, you want to build career capital while you sleep.

As Andrew Chen noted:


3/ You don’t want to build a competitive advantage that is fleeting or that will get commoditized

Things that might get commoditized over time (some longer than


4/ Before the arrival of recorded music, what used to be scarce was the actual music itself — required an in-person artist.

After recorded music, the music itself became abundant and what became scarce was curation, distribution, and self space.

5/ Similarly, in careers, what used to be (more) scarce were things like ideas, money, and exclusive relationships.

In the internet economy, what has become scarce are things like specific knowledge, rare & valuable skills, and great reputations.
LIFE
Jeannette Ng \u5433\u5fd7\u9e97
Jeannette Ng 吳志麗...
@jeannette_ng
So, you’re a writer and you’re worried about writing outside your immediate experiences and identities.

Here is the thread of practical advice for you.

EXAMINE YOUR MOTIVES. Why do you want to write this?

Are you trying to solve racism/sexism/colonialism with your work?

As writers we love stories about heroic writers whose work has changed the world. And as such we like to look to our own writing to solve societal problems.

And I understand this completely, not the least because I’ve felt the pull.

But if you’re looking to play saviour with your words, it is unlikely that you will do the marginalised people you are trying to save justice.

And I understand this very often comes from place of good intentions, but there is a reason that most of the moralising plays written by white abolitionists are deeply uncomfortable to read.

It is incredibly easy for works looking to play saviour to become patronising or traffic in simplistic stereotypes that ultimately hurt the people they are looking to rescue.
WRITING