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

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
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
Hiten Shah
Hiten Shah
@hnshah
Do you use keyboard shortcuts?

If you do, I’d love to know what your favorite app with keyboard shortcuts is...
PRODUCTIVITY
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
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

You May Also Like

Billy Bostickson \U0001f3f4\U0001f441&\U0001f441 \U0001f193
Billy Bostickson 🏴👁&👁 ...
@BillyBostickson
Enough Jaw Jaw, this is War!
1. People's Justice Courts to be set up worldwide
2. Citizens' arrests of all Identified Suspects
3. Lab Inspections
3. Harsh interrogation using MKULTRA
4. Public Show Trials video streamed live
5. Cross Questioning of suspects via Twitter & Zoom
6.


A growing list of suspects to be interrogated


Foul Traitors, Charlatans, Frauds, Bat Molesters! Frankensteins, Well Poisoners, Plotters, Deceivers!
Dr. Shipmans, Saboteurs, Devils in White Coats!


Organisations to be Investigated
WIV
Wuhan University IMA
WIBP
WCDC
BEIJING IPB
Nanjing Military Lab
SinoPharm
BARDA
NIH
EMERGENT BIOSOLUTIONS
BIOPORT
GILEAD
SIAC
QTEL
USAMRIID
FORT DETRICK
DARPA
DTRA
Metbiota
ONE HEALTH
GVP
ECOHEALTH
MITRE
BATTELLE
TUNNELL
LAURIMA GOV SERVICES


Suspects (1)
China
Zhengli Shi
Peng Zhou
George Gao
Deyin Guo
Major General Chen Wei
United States
ALEX AZAR
JONNA MAZET
ALISON O’TOOLE
ANTHONY FAUCI
BOYD YOUNT
DAVID FRANZ
DAVID KARESH
DENNIS CARROLL
DYLAN GEORGE
GEORGE PAINTER
IAN LIPKIN
JENS KUHN
JEROME HAUER
JONATHAN EPSTEIN
WORLD , ALL
Robbie Andrew
Robbie Andrew
@robbie_andrew
I doubt there are many outside of Norway that know that the Norwegian pop group A-ha was critical in the introduction of electric car incentives in Norway. I certainly didn't. Read on...


In 1989, two members of the group, Morten Harket and Magne Furuholmen were in Switzerland with environmentalist Frederic Hauge, when they came across a hobby-converted Fiat Panda. Stated range: 45 km. They snapped it up and imported it to Norway.

Photo: In Switzerland (Bellona)


On arrival in Norway, the regs didn't accommodate the registration of electric cars so it couldn't legally be driven on the road. Since it had a propane-fuelled heater, just like a motorhome, they registered it as a motorhome.

Moreover, in contrast to petrol cars, diesel cars paid registration fees based on how far they were driven, and our heroes thought this should also apply to electric cars. So the two-seater Swiss-converted Fiat Panda was registered as a diesel motorhome in Norway.

They managed (somehow) to avoid paying the one-off registration fee in 1990, and ever since then electric cars have been exempted this now-substantial fee.
Source:
HISTORY
Advertisement
Jijo Sunny
Jijo Sunny
@JijoSunny
1/ 👋 Excited to share what we’ve been building at https://t.co/GOQJ7LjQ2t + we are going to tweetstorm our progress every week!

Week 1 highlights: getting shortlisted for YC W2019🤞, acquiring a premium domain💰, meeting Substack's @hamishmckenzie and Stripe CEO @patrickc 🤩

2/ So what is Brew?

brew / bru : / to make (beer, coffee etc.) / verb: begin to develop 🌱

A place for you to enjoy premium content while supporting your favorite creators. Sort of like a ‘Consumer-facing Patreon’ cc @jackconte

(we’re still working on the pitch)

3/ So, why be so transparent? Two words: launch strategy.

jk 😅 a) I loooove doing something consistently for a long period of time b) limited downside and infinite upside (feedback, accountability, reach).
cc @altimor, @pmarca


4/ https://t.co/GOQJ7LjQ2t domain 🍻

It started with a cold email. Guess what? He was using BuyMeACoffee on his blog, and was excited to hear about what we're building next. Within 2w, we signed the deal at @Escrowcom's SF office. You’re a pleasure to work with @MichaelCyger!

5/ @ycombinator's invite for the in-person interview arrived that evening. Quite a day!

Thanks @patio11 for the thoughtful feedback on our YC application, and @gabhubert for your directions on positioning the product — set the tone for our pitch!
TECH
Vibhu Vashisth
Vibhu Vashisth
@VIBHU_Tweet
हिमालय पर्वत की एक बड़ी पवित्र गुफा थी।उस गुफा के निकट ही गंगा जी बहती थी।एक बार देवर्षि नारद विचरण करते हुए वहां आ पहुंचे।वह परम पवित्र गुफा नारद जी को अत्यंत सुहावनी लगी।वहां का मनोरम प्राकृतिक दृश्य,पर्वत,नदी और वन देख उनके हृदय में श्रीहरि विष्णु की भक्ति अत्यंत बलवती हो उठी।


और देवर्षि नारद वहीं बैठकर तपस्या में लीन हो गए।इन्द्र नारद की तपस्या से घबरा गए।उन्हें हमेशा की तरह अपना सिंहासन व स्वर्ग खोने का डर सताने लगा।इसलिए इन्द्र ने नारद की तपस्या भंग करने के लिए कामदेव को उनके पास भेज दिया।वहां पहुंच कामदेव ने अपनी माया से वसंतऋतु को उत्पन्न कर दिया।


पेड़ और पौधों पर रंग बिरंगे फूल खिल गए और कोयलें कूकने लगी,पक्षी चहकने लगे।शीतल,मंद,सुगंधित और सुहावनी हवा चलने लगी।रंभा आदि अप्सराएं नाचने लगीं ।किन्तु कामदेव की किसी भी माया का नारद पे कोई प्रभाव नहीं पड़ा।तब कामदेव को डर सताने लगा कि कहीं नारद क्रोध में आकर मुझे श्राप न देदें।

जैसे ही नारद ने अपनी आंखें खोली, उसी क्षण कामदेव ने उनसे क्षमा मांगी।नारद मुनि को तनिक भी क्रोध नहीं आया और उन्होने शीघ्र ही कामदेव को क्षमा कर दिया।कामदेव प्रसन्न होकर वहां से चले गए।कामदेव के चले जाने पर देवर्षि के मन में अहंकार आ गया कि मैने कामदेव को हरा दिया।

नारद फिर कैलाश जा पहुंचे और शिवजी को अपनी विजयगाथा सुनाई।शिव समझ गए कि नारद अहंकारी हो गए हैं और अगर ये बात विष्णु जी जान गए तो नारद के लिए अच्छा नहीं होगा।ये सोचकर शिवजी ने नारद को भगवन विष्णु को ये बात बताने के लीए मना किया। परंतु नारद जी को ये बात उचित नहीं लगी।
ALL
Ramblings of a Sikh
Ramblings of a Sikh
@RamblingSingh
1/ Jassa Singh Ahluwalia & his role in the history of Shri Harmandir Sahib (A Thread)


2/ Jassa Singh was born in 1720/21 at a village called Ahlu in the Lahore District of Punjab.


3/ Jassa Singh was educated in Delhi, in Persian, Arabic & more, under the care & supervision of Mata Sundari Ji.

Mata Sundari Gurdwara in Delhi.


4/ In 1733, Jassa Singh's mama, Thag Singh (ਤਾਗ ਸਿੰਘ), requested Mata Sundari Ji's permission to take Jassa Singh back to Punjab.


5/ At first Mata Ji refused but eventually gave permission for Jassa Singh to go with his mama, giving Jassa Singh a blessing and weapons, informing him, it was now the right time to take up arms.
HISTORY