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 ЁЯТб

10 websites you didn't know you were missing (until now) :

https://t.co/vC0nCFDmk0

People are visual learners.

Easily turn your data into stunning charts, maps, and interactive stories.

Upload a spreadsheet, and return with:

тАв Animated bar charts
тАв Survey data
тАв┬аScatter plots
тАв Story maps & more


https://t.co/g9YBl2ELwq

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/wsUNfyHzFb

An online collaborative whiteboard ideal for remote meetings, brainstorming, and ideation across teams.

тАв Make flowcharts
тАв Build product roadmaps
тАв Engage in a quick retrospective

The best part?

It's free.


https://t.co/RxDEsvPB2w

My friend @thejustinwelsh brought this site to my attention recently.

If you're in the solopreneur game and need to spin up a quick landing page or website for just about anything, Carrd is tough to beat.

Simple, free, mobile responsive.

Check 'em out.
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

You May Also Like

рдорд╣рд╛рднрд╛рд░рдд рдХреА рдХрд╣рд╛рдиреА рдХреМрди рдирд╣реАрдВ рдЬрд╛рдирддрд╛редрд▓реЗрдХрд┐рди рдХреНрдпрд╛ рдЖрдкрдХреЛ рдкрддрд╛ рд╣реИ рдХрд┐ рдорд╣рд╛рднрд╛рд░рдд рдХреЗ рдЬреНрдпрд╛рджрд╛рддрд░ рдкрд╛рддреНрд░ рдХрд┐рд╕реА рди рдХрд┐рд╕реА рд╢реНрд░рд╛рдк рдореЗрдВ рдлрдВрд╕реЗ рдереЗредрдЕрдЧрд░ рдпреЗ рд╢реНрд░рд╛рдк рди рд╣реЛрддреЗ рддреЛ рдХрджрд╛рдЪрд┐рдд рдорд╣рд╛рднрд╛рд░рдд рдХреА рдХрд╣рд╛рдиреА рдХреБрдЫ рдФрд░ рд╣реЛрддреАредрд╣рд┐рдиреНрджреБ рдкреМрд░рд╛рдгрд┐рдХ рдЧреНрд░рдВрдереЛрдВ рдореЗрдВ рд╡рд┐рднрд┐рдиреНрди рд╢реНрд░рд╛рдкреЛрдВ рдХрд╛ рд╡рд░реНрдгрди рдорд┐рд▓рддрд╛ рд╣реИ рд╡ рд╣рд░ рд╢реНрд░рд╛рдк рдХреЗ рдкреАрдЫреЗ рдХреЛрдИ рдХрд╣рд╛рдиреА рдЕрд╡рд╢реНрдп рд╣реЛрддреА рд╣реИред


рдЖрдЗрдП рдЖрдЬ рдЬрд╛рдирддреЗ рд╣реИрдВ рдорд╣рд╛рднрд╛рд░рдд рдХрдерд╛ рдореЗрдВ рд╡рд░реНрдгрд┐рдд рдХреБрдЫ рд╢реНрд░рд╛рдкреЛрдВ рдХреЗ рдмрд╛рд░реЗ рдореЗрдВред

1) рд░рд╛рдЬрд╛ рдкрд╛рдгреНрдбреБ рдХреЛ рдЛрд╖рд┐ рдХрд┐рдиреНрджрдо рдХрд╛ рд╢реНрд░рд╛рдк

рдПрдХрдмрд╛рд░ рдорд╣рд╛рд░рд╛рдЬ рдкрд╛рдгреНрдбреБ рд╢рд┐рдХрд╛рд░ рдЦреЗрд▓рдиреЗ рд╡рди рдЧрдПредрдЭрд╛рдбрд┐рдпреЛрдВ рдХреЗ рдкреАрдЫреЗ рдХреБрдЫ рд╣рд┐рд▓ рд░рд╣рд╛ рдерд╛ред рдореГрдЧ рд╣реИ рд╕реЛрдЪрдХрд░ рд░рд╛рдЬрд╛ рдиреЗ рдмрд╛рдг рдЪрд▓рд╛рдпрд╛ рдЬреЛ рдЬрд╛рдХрд░ рдЛрд╖рд┐ рдХрд┐рдиреНрджрдо рдФрд░ рдЙрдирдХреА рдкрддреНрдиреА рдХреЛ рд▓рдЧрд╛редрд╡реЗ рджреЛрдиреЛ рд░рддрд┐-рдХреНрд░реАрдбрд╝рд╛ рдореЗрдВ рд▓рд┐рдкреНрдд рдереЗред

рдЬрдм рд░рд╛рдЬрд╛ рдиреЗ рдЙрдиреНрд╣реЗрдВ рджреЗрдЦрд╛ рддреЛ рдмрд╣реБрдд рджреБрдЦреА рд╣реБрдП рдХрд┐ рдпреЗ рдореБрдЭрд╕реЗ рдХреНрдпрд╛ рдкрд╛рдк рд╣реЛ рдЧрдпрд╛редрдмрд╣реБрдд рдХреНрд╖рдорд╛ рдпрд╛рдЪрдирд╛ рдХреЗ рдмрд╛рдж рднреА рдХрд┐рдиреНрджрдо рдЛрд╖рд┐ рдиреЗ рдкрд╛рдгреНрдбреБ рдХреЛ рд╢реНрд░рд╛рдк рджреЗ рджрд┐рдпрд╛ рдХрд┐ рдЬрдм рднреА рд╡реЛ рдХрд┐рд╕реА рд╕реНрддреНрд░реА рдХреЛ рдХрд╛рдо рднрд╛рд╡рдирд╛ рд╕реЗ рд╕реНрдкрд░реНрд╢ рдХрд░реЗрдВрдЧреЗ рдЙрд╕реА рдХреНрд╖рдг рдЙрдирдХреА рдореГрддреНрдпреБ рд╣реЛ рдЬрд╛рдПрдЧреАредрдкрд╢реНрдЪрд╛рддрд╛рдк рдХрд░рдиреЗ, рд╡реЗ рд╕рд┐рдВрд╣рд╛рд╕рди рдкреЗ рдЕрдиреНрдзреЗ рд░рд╛рдЬрд╛ рдзреГрддрд░рд╛рд╖реНрдЯреНрд░ рдХреЛ рдмреИрдард╛рдХрд░...


..рд╕реНрд╡рдпрдВ рдЕрдкрдиреА рд░рд╛рдирд┐рдпреЛрдВ рдХреБрдВрддреА рд╡ рдорд╛рджреНрд░реА рдХреЗ рд╕рд╛рде рд╡рди рдЪрд▓реЗ рдЧрдПредрдкрд╛рдВрдбрд╡реЛрдВ рдХрд╛ рдЬрдиреНрдо рднреА рдХреБрдВрддреА рдХреЛ рдЛрд╖рд┐ рджреБрд░реНрд╡рд╛рд╕рд╛ рджреНрд╡рд╛рд░рд╛ рджрд┐рдП рдЧрдП рдордВрддреНрд░ рд╕реЗ рд╣реБрдЖ рдерд╛ рдЬрд┐рд╕рдореЗ рдХрд┐рд╕реА рднреА рджреЗрд╡ рдХрд╛ рд╕реНрдорд░рдг рдХрд░ рдЙрд╕ рджреЗрд╡ рд╕реЗ рдХреБрдВрддреА,рдкреБрддреНрд░ рдкреНрд░рд╛рдкреНрдд рдХрд░ рд╕рдХрддреА рдереАредрдПрдХ рдмрд╛рд░ рдорд╛рджреНрд░реА рдкреЗ рдореЛрд╣рд┐рдд рд╣реЛ рдЬрдм рдкрд╛рдВрдбреБ рдиреЗ рдЙрд╕реЗ рд╕реНрдкрд░реНрд╢ рдХрд┐рдпрд╛,рдЙрд╕реА рдХреНрд╖рдг рдкрд╛рдВрдбреБ рдХреА рдореГрддреНрдпреБ рд╣реЛрдЧрдпреАред


2) рдЙрд░реНрд╡рд╢реА рдХрд╛ рдЕрд░реНрдЬреБрди рдХреЛ рд╢реНрд░рд╛рдк

рдорд╣рд╛рднрд╛рд░рдд рдпреБрджреНрдз рд╕реЗ рдкрд╣рд▓реЗ рдЬрдм рдЕрд░реНрдЬреБрди рджрд┐рд╡реНрдпрд╛рд╕реНрддреНрд░ рдкреНрд░рд╛рдкреНрдд рдХрд░рдиреЗ рд╕реНрд╡рд░реНрдЧ рдЧрдП рддреЛ рд╡рд╣рд╛рдВ рдЙрд░реНрд╡рд╢реА рдирд╛рдо рдХреА рдЕрдкреНрд╕рд░рд╛ рдЙрди рдкрд░ рдореЛрд╣рд┐рдд рд╣реЛ рдЧрдпреАред рдЕрд░реНрдЬреБрди рдиреЗ рдЬрдм рдЙрдиреНрд╣реЗрдВ рдЕрдкрдиреА рдорд╛рддрд╛ рдХреЗ рд╕рдорд╛рди рдмрддрд╛рдпрд╛ рддреЛ рдпрд╣ рд╕реБрдирдХрд░ рдЙрд░реНрд╡рд╢реА рдХреНрд░реЛрдзрд┐рдд рд╣реЛ рдЧрдпреА рдФрд░ рдЕрд░реНрдЬреБрди рдХреЛ рд╢реНрд░рд╛рдк рджреЗ рдбрд╛рд▓рд╛ рдХрд┐ рддреБрдо рдирдкреБрдВрд╕рдХ рдХреА рднрд╛рдВрддрд┐...