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 💡

How to get rich, learn anything, and get more done.

11 Tweets to change your life. 🧵

1/ Learn Anything:

A masterclass from my friend @SahilBloom

The 6-step framework he uses to learn anything.

(1) Identify & Establish
(2) Research
(3) Skin in the Game
(4) Engage Community
(5) Teach
(6) Reflect &


2/ A cheat sheet for building your career:

20 things you'll wish you knew sooner.

An amazing piece by @RomeenSheth on career


3/ The 5 Traits of Elite Individuals:

I'm not sure what rock I've been living under...

I've somehow just now stumbled across @NdamukongSuh's Twitter content.

It's a goldmine.

Case in point


4/ Where you are -> Where you're going:

•Be consistent
•Set higher standards
•Learn to say "no" more
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.
There are plenty of ways to waste time online.

You already know those.

Instead, here are 7 sites that will make you more productive––not less: 🖥

https://t.co/s9sbOvEe33

A free and open-source graph drawing software developed in HTML5 and JavaScript.

Its interface can be used to create diagrams such as flowcharts, wireframes, UML diagrams, and organizational charts.

No login to create and no account required.


https://t.co/CPHIaIMXxy

A free online photo editor you can use directly in your browser.

No ads, no account to create, no cookies to accept.

Just drag, drop, edit, and save.


https://t.co/g9YBl2WmnY

Looking for a way to make your presentations more engaging?

Build interactive polls, quizzes, and more allowing your audience to engage in real-time.

Using their smartphone, attendees can answer questions and the results are visualized as they happen.


https://t.co/Ww9nrWEq5T

Crowdsourced results for software you already know, but want to replace.

Featuring ratings and comments from users about their experience to help you choose the best option for you.

Find alternatives for things like MS Word, Adobe Photoshop, and more.

You May Also Like

The first ever world map was sketched thousands of years ago by Indian saint
“Ramanujacharya” who simply translated the following verse from Mahabharat and gave the world its real face

In Mahabharat,it is described how 'Maharishi Ved Vyasa' gave away his divine vision to Sanjay


Dhritarashtra's charioteer so that he could describe him the events of the upcoming war.

But, even before questions of war could begin, Dhritarashtra asked him to describe how the world looks like from space.

This is how he described the face of the world:

सुदर्शनं प्रवक्ष्यामि द्वीपं तु कुरुनन्दन। परिमण्डलो महाराज द्वीपोऽसौ चक्रसंस्थितः॥
यथा हि पुरुषः पश्येदादर्शे मुखमात्मनः। एवं सुदर्शनद्वीपो दृश्यते चन्द्रमण्डले॥ द्विरंशे पिप्पलस्तत्र द्विरंशे च शशो महान्।

—वेद व्यास, भीष्म पर्व, महाभारत


Meaning:-

हे कुरुनन्दन ! सुदर्शन नामक यह द्वीप चक्र की भाँति गोलाकार स्थित है, जैसे पुरुष दर्पण में अपना मुख देखता है, उसी प्रकार यह द्वीप चन्द्रमण्डल में दिखायी देता है। इसके दो अंशो मे पीपल और दो अंशो मे विशाल शश (खरगोश) दिखायी देता है।


Meaning: "Just like a man sees his face in the mirror, so does the Earth appears in the Universe. In the first part you see leaves of the Peepal Tree, and in the next part you see a Rabbit."

Based on this shloka, Saint Ramanujacharya sketched out the map, but the world laughed