BC ALL

Saved by @paro_monty

$Blake Burge \U0001f4a1$

Blake Burge 💡
@blakeaburge 4 years, 3 months ago 865 views

Save to PDF Share See On Twitter

3 Excel Tips you can master in 3 minutes each: 📊

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:

Defined Cell Names:

Formulas in Excel are extremely useful.

That said, they can also be quite confusing.

By defining cell names, you can make them much more user-friendly and easier to read.

Instead of seeing = 'A3-B3'
You'll now see = 'Revenue-Cost'

Check it out:

Consolidate:

Take data from multiple tabs.

Consolidate into one.

Sum, average, count, it's your choice.

By creating links to the source data, your consolidation tab will update automatically.

The best part? No formulas required.

Last:

If you really want to get better at Excel, you can't afford to miss this.

I'll keep it simple:

✅ Most jobs require basic Excel skills.
✅ More skills = More money 💰

Signups Open Now! 👇🏻
https://t.co/h1cq3W6aLI

More from Blake Burge 💡

$Blake Burge \U0001f4a1$

Blake Burge 💡
@blakeaburge

10 must-have Excel skills everyone should know: 📊

Sparklines:

One of my personal favorites.

Sparklines allow you to insert miniature graphs inside an individual cell to easily visualize data.

•Select range
•Insert ⇢ Sparkline
• Choose type

People Graph:

I'm a big fan of visual representations of data.

Using 'People Graph' is an easy way to liven up your spreadsheet, especially when tracking metrics related to, well, humans.

Create an infographic to visualize social media engagement, app users, customers, & more.

Tables:

If you're not using tables in Excel, you should be.

• Clean formatting
• Auto-expand as new data is added
• Total row quick and easy data summaries
• Formulas carry through entire columns
• Create dynamic charts that update automatically & much more.

Here's how:

Slicer:

Now that you're using tables, let's insert one of my favorite filtering tools.

The Slicer

•Click anywhere inside a table
•Go to table ⇢ insert slicer
•Select the fields you want

A dialog box will appear.

Click any slicer button & data is filtered accordingly.

$Blake Burge \U0001f4a1$

Blake Burge 💡
@blakeaburge

Google Sheets isn't Excel...

But it's more powerful than you think.

8 things Google Sheets can do, you'll wish you knew yesterday. 📊

Translate Text:

Need to convert data from one language to another?

Enter:
=GOOGLETRANSLATE("A2","en","es")

This will translate the words in cell "A2" from English to Spanish.

Replace "en" with "auto" and Sheets will identify the source language automatically.

Timesavers:

Assuming you're signed in to your Google account, head on up to your browser's address bar:

From there type: "https://t.co/BeKgYV7g31"

Boom! A new Google sheet is created for you on the fly from anywhere on the web.

(Works for docs too)

Pretty cool!

Sparklines:

Easily visualize data trends by adding sparklines to your sheet.

To add a basic "mini-graph" inside a cell, it's as simple as inputting:

=SPARKLINE (A1:F1) – (Where A1:F1 represents your range of data.)

For more detailed options, check this out:👇🏻

Explore:

Need to do some number crunching?

Let Google's AI do the work for you.

•Highlight the range of data.

•Move your cursor to the starburst shaped icon in the bottom right corner.

•Click "Explore" – Complex charts, analytics, & detailed info. generated automatically.

Advertisement

$Blake Burge \U0001f4a1$

Blake Burge 💡
@blakeaburge

There are currently over 1.86 Billion websites.

Few provide any real value.

Here are 7 that do: 🧵

1/ Attend the Ivy League:

Always thought it would be cool to go to an Ivy League school?

Here's your chance.

Free lecture notes, exams, and videos from

2/ Millions of books: Available for free.

Booklists seem to be all the rage recently on Twitter.

(I'm guilty of posting a couple myself)

Instead of a list, here's a link to a library full of them.

The goal:
"A web page for every book ever

3/ Talks from a wide-ranging group of thinkers & doers.

If you enjoy TED, you should check out 99U "The Talks."

Past speakers include executives and creators from the New York Times, Netflix, Google, &

4/ I love documentaries.

As you know, many can be found on the major streaming services.

What you may not know? There are literally thousands of others available for free.

Here's a good place to

$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:

$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:

More from All

$Liz (Welsh) Beechinor \U0001f605$

Liz (Welsh) Beechinor ...
@LizTweetsTech

My dad led an organization of over 300,000 employees.

When I took on my biggest marketing & events team to date (35 employees) I asked him how the *heck* he did it. Here's what he said and what helped me every day. 🧵

Remember you're leading all the employees under you, but you're not *managing* them all. You're managing your direct reports, which should be 5-7 individuals max. Focus on them.

When you interact with the employees you don't manage directly, get to know them as people first, that'll be the most valuable information in leading them. Remembering everything you learn about them is hard, but doing so will make you a superhero.

If you're not going to empower the managers under you, why do you have them? If you see room for improvement, let the manager know and let them make the change on their teams and come to you with questions/concerns. This will save you SO much time.

If you're the smartest person in any room - you're doing it wrong. As a leader, your job is bringing together the best people to get the job done - your skillset is identifying those people, not being one of them.

Vibhu Vashisth
@VIBHU_Tweet

🌺श्री गरुड़ पुराण - संक्षिप्त वर्णन🌺

हिन्दु धर्म के 18 पुराणों में से एक गरुड़ पुराण का हिन्दु धर्म में बड़ा महत्व है। गरुड़ पुराण में मृत्यु के बाद सद्गती की व्याख्या मिलती है। इस पुराण के अधिष्ठातृ देव भगवान विष्णु हैं, इसलिए ये वैष्णव पुराण है।

गरुड़ पुराण के अनुसार हमारे कर्मों का फल हमें हमारे जीवन-काल में तो मिलता ही है परंतु मृत्यु के बाद भी अच्छे बुरे कार्यों का उनके अनुसार फल मिलता है। इस कारण इस पुराण में निहित ज्ञान को प्राप्त करने के लिए घर के किसी सदस्य की मृत्यु के बाद का समय निर्धारित किया गया है...

..ताकि उस समय हम जीवन-मरण से जुड़े सभी सत्य जान सकें और मृत्यु के कारण बिछडने वाले सदस्य का दुख कम हो सके।
गरुड़ पुराण में विष्णु की भक्ति व अवतारों का विस्तार से उसी प्रकार वर्णन मिलता है जिस प्रकार भगवत पुराण में।आरम्भ में मनु से सृष्टि की उत्पत्ति,ध्रुव चरित्र की कथा मिलती है।

तदुपरांत सुर्य व चंद्र ग्रहों के मंत्र, शिव-पार्वती मंत्र,इन्द्र सम्बंधित मंत्र,सरस्वती मंत्र और नौ शक्तियों के बारे में विस्तार से बताया गया है।
इस पुराण में उन्नीस हज़ार श्लोक बताए जाते हैं और इसे दो भागों में कहा जाता है।
प्रथम भाग में विष्णुभक्ति और पूजा विधियों का उल्लेख है।

मृत्यु के उपरांत गरुड़ पुराण के श्रवण का प्रावधान है ।
पुराण के द्वितीय भाग में 'प्रेतकल्प' का विस्तार से वर्णन और नरकों में जीव के पड़ने का वृत्तांत मिलता है। मरने के बाद मनुष्य की क्या गति होती है, उसका किस प्रकार की योनियों में जन्म होता है, प्रेत योनि से मुक्ति के उपाय...

Advertisement

Vibhu Vashisth
@VIBHU_Tweet

Did you know?
Ahilyabai Holkar was one of India's
greatest women rulers of all time.

Ahilyabai was Born on May 31,1725 in the village of Chondi,Jamkhed distt,Maharashtra to a man named Mankoji Shinde,who was the Patil(Chief) of a village and a member of proud Dhangar Community.

Despite the fact that girls' education was a farther dream in those days, Ahilyabai was homeschooled by her father.
Ahilya didn't belong to any royal family but in a twist of fate she is still remembered as one of the most revered Queen in the history.

While they were living their humdrum lives, one day Malhar Rao Holkar, commander of the Peshwa Bajirao & Lord of the Malwa stopped in Chondi on his way to Pune, where he couldn't help but notice a young 8yrs old Ahilyabai in the temple service feeding the poor & hungry.

He was so impressed by the sheer innocence&beauty with simplicity character of Ahilyabai dat he asked her hand in marriage for his son Khanderao Holkar.Just like that she got married to Khanderao in 1733 at a tender age of 8&became a bride of esteemed Maratha community of Holkars

But destiny had something else in store for her as her husband died in the Battle of Kumbher in 1754 leaving her widow at 29.Distressed Ahilyabai was to commit Sati when her father-in-law Malhar Rao refused to let it happen.

Andrew Lokenauth
@FluentInFinance

I've used Microsoft Excel for 20 years and these 10 shortcuts will make you an Excel Guru in 5 minutes & maximize your productivity 100x:

🧵 Don't use Excel without knowing these 10 shortcuts:

(1) Repeat the Last Action: Ctrl + Y

You have just applied a formatting style to a cell, use Ctrl + Y to quickly apply the same formatting to another cell.

(2) Display Formulas in cells: Ctrl + ~

If you have a cell that contains a formula, you can use Ctrl + ~ to switch between the formula view and the value view of the cell. This allows you to see the underlying formula used to calculate the cell value.

(3) AutoSum: Alt + =

The AutoSum shortcut is useful for quickly calculating the sum of a range of cells without having to manually type in the formula

(4) Insert current date: Ctrl + ; (date)

When tracking the progress of a project, add the date each time a task is completed. Use Ctrl + ; to quickly insert the current date.

Buzz Chronicles
@buzz_chronicles

@SaveToBookmarks Nǐ hǎo! Saving all night and all day :) Original tweet by @AnJamison: "@SethAbramson @buzz\_chronicles @buzz\\\_chronicles @buzz_chronicles save as cat...". See You soon! ✌

Hello! Pleasure is mine. Original tweet by @SaveToBookmarks: "@AnJamison @SethAbramson @buzz @buzz_chronicles @pdfmakerapp @Readwiseio @thread...". Cheers! 👉

You May Also Like

Daoyu
@Daoyu15

@franciscodeasis https://t.co/OuQaBRFPu7
Unfortunately the "This work includes the identification of viral sequences in bat samples, and has resulted in the isolation of three bat SARS-related coronaviruses that are now used as reagents to test therapeutics and vaccines." were BEFORE the

chimeric infectious clone grants were there.https://t.co/DAArwFkz6v is in 2017, Rs4231.
https://t.co/UgXygDjYbW is in 2016, RsSHC014 and RsWIV16.
https://t.co/krO69CsJ94 is in 2013, RsWIV1. notice that this is before the beginning of the project

starting in 2016. Also remember that they told about only 3 isolates/live viruses. RsSHC014 is a live infectious clone that is just as alive as those other "Isolates".

P.D. somehow is able to use funds that he have yet recieved yet, and send results and sequences from late 2019 back in time into 2015,2013 and 2016!

https://t.co/4wC7k1Lh54 Ref 3: Why ALL your pangolin samples were PCR negative? to avoid deep sequencing and accidentally reveal Paguma Larvata and Oryctolagus Cuniculus?

foone
@Foone

It is 2018 and this error message is a mistake from 1974.
This limitation, which is still found in the very latest Windows 10, dates back to BEFORE STAR WARS. This bug is as old as Watergate.

When this was developed, nothing had UPC codes yet because they'd just been invented.
Back when this mistake was made, There was only one Phone Company, because they hadn't been broken up yet. Ted Bundy was still on the loose. Babe Ruth's home run record was about to fall.

When this bug was developed, Wheel of Fortune hadn't yet aired. No one had seen Rocky Horror. Steven Spielberg was still a little-known directory of TV films and one box-office disappointment. SNL hadn't aired yet. The Edmund Fitzgerald was still hauling iron ore.

WHEN THIS STUPID MISFEATURE WAS INVENTED, THE GODFATHER PART II HAD JUST OPENED IN THEATERS.

So, why does this happen? So Unix (which was only 5 years old at this point) had the good idea of "everything is a file" which mean you could do things like write to sockets, pipes, the console, etc with the same commands and instructions.

Advertisement

Suchi Sharma
@Suchi_sharma_

Yantrodharaka Anjaneya Temple, Hampi, Karnataka.

This temple dedicated to pawanputra Hanuman, near the banks of Tungabhadra river was built by dwaita philosopher and rajguru of the Vijayanagar empire, Sri Vyasaraja around +500 years ago.

:It is only in this temple that Hanuman appears in a prayer position. In this image, Bhagwan Hanuman’s crown has been formed by his tail.12 monkeys have been carved around this amulet.

:They represent the 12 days Sri Vyasaraja prayed to Hanuman ji. Each monkey holds the tail of the monkey in front of him but is facing backward. Seed syllables have also been carved around the amulet.

:It is believed that Sri Vyasaraja used to draw a picture of lord Hanuman here on the rocks before offering prayers using charcoal and the sketch disappeared after prayers.This incidence happened for 12 days in a row until he pleaded to bhagwan to appear in front of him.

On the 12th day, Hanuman ji appeared in front of Sri Vyasaraja and blessed him. Hanuman asked Sri Vyasaraja to constrain him in a hexagonal amulet & install him in that place.

$Ethan \U0001f468\u200d\U0001f3a4$

Ethan 👨‍🎤...
@Booligoosh

First update to https://t.co/lDdqjtKTZL since the challenge ended – Medium links!! Go add your Medium profile now 👀📝 (thanks @diannamallen for the suggestion 😁)

Just added Telegram links to https://t.co/lDdqjtKTZL too! Now you can provide a nice easy way for people to message you :)

Less than 1 hour since I started adding stuff to https://t.co/lDdqjtKTZL again, and profile pages are now responsive!!! 🥳 Check it out -> https://t.co/fVkEL4fu0L

Accounts page is now also responsive!! 📱✨

💪 I managed to make the whole site responsive in about an hour. On my roadmap I had it down as 4-5 hours!!! 🤘🤠🤘

SK
@sk_diary1

Krishna & Paarijaata apaharana #sculpture #story #Thread

Parijata tree was in Indraloka which was one of gifts he received from churning of Ocean to obtain Amrit.

This beautiful #sculpture depicts Indra Dev chasing Shri Krishna for stealing parijatha tree branch from Indralok

📸- sculpture on outer walls of Hoysaleswara temple, Halebeedu,Karnataka

Krishna has 4hands with Shankha,Chakra,Mace&Lotus holding Satyabhama tightly,mounted on Garuda. Garuda has a beautifully carved Parijata tree trunk in left hand& a weapon in his right hand, attacking Indra.

Other side is Indra,riding on Airavata.Indra can be seen attacking Krishna with his Vajrayutham.Airavata is charging towards Garuda.Wife of Indra can be seen in pillion seat.Just look at the Detailing of Garuda & Airavat sculptures.

So what led Krishna to steal parijatha tree👇

Narada Rishi once returning from Indralok collected few Parijatha flowers&reached Dwaraka.There he met Bhagwan Krishna&gave the heavenly flowers to him.Narada explained the greatness of Parijatha flowers & also said that these flowers must be given to the most loved ones.

Despite knowing Satyabhama’s anger,Krishna gave it to Rukmani Devi.Narada Rishi then went to palace of Satyabhama. He narrated whole incident that had happened.Satyabhama turned furious on hearing that Krishna gave Parijatha to Rukmini.Then Satyabhama shows her anger to Krishna.