BC EXCELTRICKS
Saved by @chamakta_choora

10 time-saving Excel functions you should be using: 📊

 WORKDAY:

Customers need to know when the job will be done.

The Workday function allows you to easily calculate the time between your start date and a specified number of "business days" in the future.

Automatically exclude weekends & holidays of your choosing.

Like this:
3D FORMULAS:

Let's say you want to add up the values in Column 'D' on 4 different sheets & show a single total.

Quit wasting time on SUM formulas that reference each sheet individually.

3D lets you select the 1st + last sheet in a series and dynamically include any in between.
AGGREGATE:

This function returns the result of an aggregate calculation like Average, Count, Sum, Max, or Min.

What makes it special?

Aggregate performs these functions while allowing you to ignore errors, hidden rows, blanks, and more.

Here's how:
IFS FUNCTION:

The IFS function tests multiple conditions to find out if they are true based on the criteria you provide.

Here, we're going to test if our monthly sales increased, decreased, or remained static in relation to our average.

Use '$' to lock in the reference cell.
SORTBY:

I'm a fan of organized data.

What I'm not a fan of?

Manually updating my sort every time something changes or new information is added.

Here's an easy fix.

With the SORTBY function, we can create a table that dynamically adjusts along with our data in real-time.
PROPER / CONVERT

• Proper: Quickly check your work & fix typing errors to ensure you have proper case.

Helpful when importing data from an outside source.

• Convert: Easily convert data into an alternate unit of measure.

Days –> Hours
Celsius -> Fahrenheit
+ Many more!
FILTER:

Using the Filter function we can create dashboards that allow us to view results from our data that meet specific criteria.

For example:

Here we want to see only orders that are > than the specified revenue amount.

Change the amount & the data updates automatically.
SUMIF:

The SUMIF function is particularly useful when you need to see totals segmented by category.

In our example, we see a breakdown of total revenue for the month by each department.

Just select your range, pick the criteria, and choose the column you would like to SUM.
XLOOKUP: (MS365)

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.
That's all for today!

Follow me @blakeaburge for weekly threads on business, productivity, & building a better you.

Join over 7,000 others & check out my newsletter:

"While You Were Away"

•The best of Twitter
•In your inbox
•Every Sunday
https://t.co/KPDWcXYbFv
One last thing...

If you're like me & enjoy making your day more productive, check out what https://t.co/y9mt4vGZIL is building!

• Calendar
• Meeting notes
• Tasks––in one place

You've got nothing to lose.

The basic plan is $0.00––forever. 👇🏻
https://t.co/Uo1SjNPaQW

More from Blake Burge 💡

Blake Burge \U0001f4a1
Blake Burge 💡
@blakeaburge
20 of the smartest things that have ever been said: 🧵

"Holding onto your anger is like drinking poison and expecting the other person to die.”

–Buddha

“We are what we repeatedly do, Excellence is therefore not an act but a habit."

–Aristotle

"Look at a day when you are supremely satisfied at the end.

It's not a day when you lounge around doing nothing; it's a day you've had everything to do and you've done it."

–Margaret Thatcher

“There are only two great tragedies in life: one is not getting what you want and the other is getting it.”

–Oscar Wilde
PRINCIPLES , ALL
Blake Burge \U0001f4a1
Blake Burge 💡
@blakeaburge
Think crypto is confusing?

You're right.

Let's make it easier.

Here's Crypto Terminology 101: 🧵

Altcoin:

Any coin that's not #Bitcoin

Ether (#ETH) is the second most popular coin overall and the most well-known Altcoin.

Ether is the native cryptocurrency on the Ethereum blockchain.

There are thousands of other altcoins, but for now, this is the one to know.

Bitcoin: (#BTC)

The first decentralized digital currency.

Launched in 2009 by an unknown person or organization known only as "Satoshi Nakamoto."

It is the most famous, and most valuable cryptocurrency.

Blockchain:

The core tech behind Bitcoin and most other cryptocurrencies.

An open, distributed, general ledger where transactions are organized into blocks which are then connected using cryptography.

Coin:

A store of digital value that lives on a blockchain.

Some blockchains, such as Bitcoin, use the same name for both the network and the coin.

Stable coins are another type of cryptocurrency which are backed by fiat currency (e.g the US dollar) or commodities such as Gold.
CRYPTO
Advertisement
Blake Burge \U0001f4a1
Blake Burge 💡
@blakeaburge
I built a monthly budget & expense tracker in Google Sheets this week.

Here's a breakdown of how it works and a free template you can use: 📊

First things first:

There are about 1,000,000 different ways you can budget your money.

But if you're looking for a financial advisor, that ain't me.

I'm just sharing a simple template that anyone can use to get started.

(Link at the end)

Wanna know how it works?

Read on:👇🏻


Step 1: Setup

We'll start by creating our framework.

Put simply:

• What do we want to track?
• How often?

I prefer to track finances on a monthly basis.

Begin by renaming one tab (or worksheet) within your doc & creating another.

Tab 1 - "YTD Dashboard"
Tab 2 - "January"


Step 2: What to track?

For the sake of time & simplicity, I've gone ahead & populated January with a few sample ideas:

• High-level categories: Income, Savings, & Expenses.

• Subitems below each:

Income → Salary
Housing → Lawn Care
Utilities → Electric

And so on...


Step 3: Basic Formatting

I like things to be formatted in a similar manner across sheets.

A few quick rules of thumb I've used here:

• Headings: Merge + Center, ⬆ Font, Bold
• Sheet Gridlines: Turned off
• Subitems: Heavy borders
• Totals: ⬆ Font, Bold

For example:
ALL
Blake Burge \U0001f4a1
Blake Burge 💡
@blakeaburge
What do the world's greatest leaders know about the power of persuasion that you don't?

THREAD: How you can unlock the ability to change anyone's mind.

Let's get smarter... 👇🏻


1/ As far back as the mid 300's BC, humans were fascinated by the power of persuasion.

In light of this, Aristotle developed what is known as the "Rhetorical Triangle."

A framework for persuading any audience using 3 simple appeals:

•Ethos
•Pathos
•Logos

Let's dig in...


2/ Ethos (Ethics / Character)

The first of the 3 appeals, Ethos speaks to the perceived character of the speaker.

In order to persuade anyone to do anything, they must first believe you are a credible and trustworthy source.

How do you accomplish this?

3/ Establishing Ethos: (1)

•Language: Choose verbiage that is fitting to the subject matter and audience you are trying to persuade.

•Pedigree: Do you have specific credentials or education relating to the topic being covered? If so, make it known.

👇🏻

4/ Establishing Ethos: (2)

•Rapport: Your audience must feel as though you are "in sync."

You understand and can relate to their feelings or ideas.

TL;DR

•Choose the right language
•Communicate pedigree
•Build Rapport

Trust becomes a byproduct.

Let's see an example 👇🏻
ALL
Blake Burge \U0001f4a1
Blake Burge 💡
@blakeaburge
The 5-step system I use to automate my brain and never forget anything: 🧠

It's well documented that the amount of information we're bombarded with these days is unprecedented.

• Keeping track of it
• Capturing Ideas as they come
• Allowing yourself space to distill it later

None of this happens without a plan.

Here's how to get started:

We'll use a simple set of (3) software platforms to:

• Quickly Capture ideas as they come
– Google Tasks

• Automate sending them to a database
– Zapier

• Organize and categorize for action later
– Notion

All Free.

First things first.

You'll need to set up an account (if you don't have one already) with each of the platforms listed above.

Don't worry––for what we're going to build, the free plans for each should work just fine.

•Google
•Notion
•Zapier


OK, let's start building

1st––Google Tasks

• In your Gmail inbox, it's in the right-side panel

• Or download the app for quick access on your phone.

This is where I capture ideas "on the fly"

No structure, no organization, we'll worry about that later.

Just capture ideas!
ALL

You May Also Like

\u0936\u094d\u0930\u0940\u092e\u093e\u0932\u0940 \u0939\u093f\u0924\u0947\u0936 \u0905\u0935\u0938\u094d\u0925\u0940
श्रीमाली हितेश अवस्थी...
@HiteshAwasthi89
Stambheshwar Mahadev Temple, Kavi Kamboi, Bharuch, Gujarat

Stambheshwar Mahadev is a Hindu Temple dedicated to Bhagwan Shiva, located in Kavi Kamboi in Bharuch District District of Gujarat, India. The Temple is about 150 years old. 1/n


The Temple is also known as the Submerging temple. The Temple is flanked by the Arabian Sea on one side and the Bay of Cambay on the other side.

As per legend, Tarakasura troubled the common people, sages and devas a lot. 2/n


Hence, Bhagwan Kartikeya k!lled him, but later he felt guilty for killing a demon who was a great devotee of Shiva. He went to Prabhu Vishnu and told about his guilty. Bhagwan Vishnu advised him to install a Shiva Linga to get relief from the sin. 3/n


As advised, he installed the Shiva Linga in this place and prayed to Bhagwan Shiva to forgive his sin.
The temple is located in Kavi Kamboi between the shores of Bay of Cambay and the Arabian Sea. This Temple is very simple temple in terms of architecture. 4/n


Every day, during the high tide hours, the temple submerges, and when the tide level becomes normal, the temple reappears again. The Temple houses a 4 feet high Shiva lingam. The Lingam can be seen during low tide. The visit to the temple should be planned in such a way that..5/n
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
raina douris
raina douris
@RahRahRaina
fascinated by this man, mario cortellucci, and his outsized influence on ontario and GTA politics. cortellucci, who lives in vaughan and ran as a far-right candidate for the italian senate back in 2018 - is a major ford donor...


his name might sound familiar because the new cortellucci vaughan hospital at mackenzie health, the one doug ford has been touting lately as a covid-centric facility, is named after him and his family

but his name also pops up in a LOT of other ford projects. for instance - he controls the long term lease on big parts of toronto's portlands... where doug ford once proposed building an nfl stadium and monorail... https://t.co/weOMJ51bVF


cortellucci, who is a developer, also owns a large chunk of the greenbelt. doug ford's desire to develop the greenbelt has been

and late last year he rolled back the mandate of conservation authorities there, prompting the resignations of several members of the greenbelt advisory
WORLD
\u092c\u094d\u0930\u093e\u0939\u094d\u092e\u0923\u094b\u0902 \u0915\u093e \u0907\u0924\u093f\u0939\u093e\u0938\U0001f441\ufe0f\U0001f441\ufe0f
ब्राह्मणों का इतिहास👁️...
@BRAHMIN_0052
MOHIYAL_BRAHMIN_KING
RAJA_PORUS
King_Porus_History

1)King Porus was a famous Indian king, his real name was #Purushotama. He belonged to PURU tribe mentioned in #RIG_VEDA, the Ancient books of India.


2) Porus ruled the Punjab region and expanded his kingdom between the Jhelum River and Chenab River in the Indian Subcontinent. He was a legendary warrior and more war skills. He made the army most powerful with war skills. Even Alexander had also made difficulty to defeat Porus.

3)Word of Mouth Oral tradition in #Mohyal_Brahmin families since ancient times has kept the Great Saga of their Great Elder known to them as Maharaja “ #Puru” alive.

4) When #Alexander the Great invaded India in 326 BC he was challenged near Taxila by a mere chieftain of the Area. He was King #Porus, a #Vaid_Mohyal. After his encounter with Porus, Alexander met with more resistance near Multan where the forces were predominantly #Mohyal.

5)The Bali rulers of Multan fiercely engaged with Alexander's army in skirmishes in which many senior Generals died. Later during the long and bitter fighting in #Multan, Alexander got hurt by an arrow which pierced his chest ,
RELIGION
Alex Stamos
Alex Stamos
@alexstamos
The entire discussion around Facebook’s disclosures of what happened in 2016 is very frustrating. No exec stopped any investigations, but there were a lot of heated discussions about what to publish and when.


In the spring and summer of 2016, as reported by the Times, activity we traced to GRU was reported to the FBI. This was the standard model of interaction companies used for nation-state attacks against likely US targeted.

In the Spring of 2017, after a deep dive into the Fake News phenomena, the security team wanted to publish an update that covered what we had learned. At this point, we didn’t have any advertising content or the big IRA cluster, but we did know about the GRU model.

This report when through dozens of edits as different equities were represented. I did not have any meetings with Sheryl on the paper, but I can’t speak to whether she was in the loop with my higher-ups.

In the end, the difficult question of attribution was settled by us pointing to the DNI report instead of saying Russia or GRU directly. In my pre-briefs with members of Congress, I made it clear that we believed this action was GRU.
TECH