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
10 powerful Excel features every user should know: 📊

Flash Fill:

Let's say you've got all the data you need––it just isn't in the right place.

"Flash Fill" is your friend.

Quickly extract pieces of text from one cell and move them to another OR combine text from multiple cells into a single place.


Camera Snapshot

Here's a little-known trick to move data between workbooks.

First, add "camera" to your quick access toolbar.

•Select your data ⇢ click 📷
•Paste to new workbook

The cool part: When you update the main workbook, the data in the picture updates as well! 🤯


Analyze Data:

I was never very good at Pivot tables, graphs, & analyzing data on my own.

Lucky for me (and you) Excel will do the heavy lifting for us.

•Select the range of data
•"Home" ⇢ "Analyze Data"

Charts, tables, & analysis––premade.

Click "insert" & you're done!


X-Lookup

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.

Here's how: 👇🏻
READING
Blake Burge \U0001f4a1
Blake Burge 💡
@blakeaburge
It's time to run your inbox––instead of it running you.

12 powerful Gmail tips every user should know: 📬

Undo Send:

Don't tell me you haven't done it.

You clicked "reply all" on a message including your boss when you meant to only reply to your friend.

Save yourself!

With Undo Send, Gmail allows you to recall a message sent in error for up to 30 seconds after you click send.


Tie emails to Tasks:

Look, we're all busy.

When your inbox is filling up faster than you can handle, it's easy to forget to reply, miss an assignment, or just plain feel overwhelmed.

Connecting emails to tasks can help.

Get reminders, add details, subtasks, and more.


Schedule Send:

With schedule send, you can draft an email at a time that works for you.

Then schedule it to be sent at a time that fits your employees' and customers' day.

In the world of remote work, this is critical.

It's a win-win.

Work on your time, send on theirs.


Confidential Mode:

Sometimes you send an email you'd prefer not live on forever.

Better yet, you'd like it if the recipient wasn't able to save, copy, or forward to someone else.

With confidential mode, you can do just that.

Set expiration dates, require passcodes, & more.
ALL
Advertisement
Blake Burge \U0001f4a1
Blake Burge 💡
@blakeaburge
10 can't miss Excel skills every single user should know: 📊

Custom Lists:

Stop wasting time entering the same customer names, product types, and generally repetitive data.

Creating custom lists is easy.

• Excel
• Preferences
• Custom Lists
• Create and click "Add"

Type the first item, then drag, and the rest of your list appears!


Data Types:

Data Types is a relatively new feature that was added to Excel in 2020.

It allows you to enter text, select data type, then extracts information based on the criteria you select.

Here's a pretty cool example using states where we can pull population data instantly:


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.


Unique:

Back in the day, Pivot Tables were my go-to for identifying unique items within large data sets.

Not anymore.

Now I use the "Unique" function in MS365 to easily identify and separate repeated items.

So simple.

Don't blink or you'll miss it:
ALL
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
This thread will make you better at Outlook: 📬

Color code your emails:

I like to keep things organized.

I'm forgetful & I get A LOT of emails.

The easiest way I've found to ensure things don't get lost is utilizing conditional formatting.

• View -> View Settings
• Conditional Formatting
• Select type
• Name the rule


Never miss a game:

Did you know you can add custom event calendars directly in Outlook?

Never miss your favorite TV show or the next big game.

• Just head to "Add Calendar"
• Select "Sports" or "TV"
• Choose the event you'd like to add.


Send delay:

Sometimes you need to write a message now but wait to deliver it until later.

Just use "Delayed Delivery."

Here's how:

• Write your email
• Select Options -> Delay Delivery
• Choose the "Do not deliver before" time


Email your calendar:

Avoid the back and forth hassle of scheduling meetings.

Simply email your calendar so people know when you're available (and when you're not.)

You can also drag items from the received calendar to your own.

Like this:
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
Sri Devi Karumariamman mandir, Chennai, Tamilnadu

Sri Devi Karumariamman mandir is in Thiruverkadu, a suburb of Chennai. It is said that God Muruga came here and obtained the 'Vel' (spear) from His mother, Goddess Karumari (an avatar of Parvathi) 1/n


to fight the demon Suran and hence this place was called as 'Vel kadu' and became as Verkadu. As per legend Devi Karumariamman once disguised as a soothsayer visited Bhagwan Surya, the Sun God, to predict His future. 2/n


Not realising that the soothsayer is none other than Sakthi Matha, Surya ignored Her. Angered by his indifference, Devi Karumariamman immediately retreated. Bhagwan Surya lost His glory and the earth plunged into darkness. 3/n


Bhagwan Surya then realised His folly and pleaded forgiveness from Devi Karumariamman. In order to pacify mother Karumariamman, Suryadev said that His rays would fall on Her directly twice in a year and touch her feet. (in the month of Panguni (March- April) & during (Sep - Oct)


Mother Karumari Amman is worshipped here in two forms.A swayambu (self manifested) with only head visible above the ground and another one in a graceful sitting posture with all Parasakthi features,with four arms holding skull, sword, trishul, udukkai (damru). 5/n
ALL
\u0936\u094d\u0930\u0940\u092e\u093e\u0932\u0940 \u0939\u093f\u0924\u0947\u0936 \u0905\u0935\u0938\u094d\u0925\u0940
श्रीमाली हितेश अवस्थी...
@HiteshAwasthi89
Sri Parasurameswara Swamy Mandir, Gudimallam, Andhrapradesh

Gudimallam is a small village located in Chittoor district. It is seven miles away from Tirupati. This small village came to significance,due to it's very beautiful Shiva Mandir with history of thousands of years. 1/n


The main importance of the mandir lies in the Linga which is housed in the Garbhagriha of the temple & considered as the only one of such type. It is the earliest Linga discovered so far and it has been assigned to the 3rd century BCE.(Satavahana period) 2/n
ALL
Advertisement
Peggy Klaver #FBR \U0001f30a\u270a\U0001f3fb\u270a\U0001f3fd\u270a\U0001f3ff\u270a\U0001f3fc
Peggy Klaver #FBR 🌊✊🏻✊...
@Pegerella
The man who invented autocorrect should burn in hello.

It was meant to put a smile on your face. Please stop sending me instructions on how to turn my autocorrect off. 😳🤔

Texted my friends to ask if I could take their kids with me to Satan... still have not heard back from them. I meant Santa...

Thanks for all the love, I appreciate a follow. 💗
FUN
Loren Brichter
Loren Brichter
@lorenb
So it turns out that Google Chrome was making everything on my computer slow *even when it wasn’t running*, because it installs something called Keystone which is basically malware.

I made a website because this shouldn’t

Wired first reported on how bad Keystone was 11 years ago when they put it into Google Earth (they seem to put it in all their popular

The fact that Keystone hides itself in Activity Monitor is bizarre. (The only sign of it was excessive CPU usage of WindowServer which is a system process).

I don’t know if Google was doing something nefarious with Keystone, or a third party figured out how to (which Wired warned about). But either way, I’m not inclined to give Google-the-organization the benefit of the doubt (despite the many good people who work on Chrome)...

...since it's been a decade+ and this still hasn't been "fixed".

There is no reason for auto-update software to need to do what Chrome/Keystone was doing. It also has a long history of crashing Macs.
TECH
William
William
@wimgz
🛠️ OPEN BUSINESS IDEAS 🛠️

Below a list of business/product ideas I had or read about.

They are worthless if they remain ideas and if you don't overcome the challenges in building them, so feel free to copy / tweak / implement them!
👇

Better: use one and make a MVP during the #24hrstartup challenge!

😻 Product Hunt Time
A clock that displays the time it is @ProductHunt
Also displays what you should do and where you should post, at each specific time during your launch

🚧 IndieCrunch - VC free tech news
Techcrunch but only for bootstrapped companies

🎧 Kickstarter for audiobooks
A lot of awesome books are not available as audio.
Crowdfund the money to buy the audio rights + a voice actor
MAKERS