BC ALL

Saved by @rg1981

$Blake Burge \U0001f4a1$

Blake Burge 💡
@blakeaburge 4 years ago 572 views

Save to PDF Share See On Twitter

5 Excel Skills You Can Learn Today and Show Off on Monday: 📊

1. Tables + TEXTJOIN

• Select Range
• Format as table
• Combine Name Using TEXTJOIN

Note –– Changes to the formula will carry throughout the table.

2. Organize With Multiple Slicers

• Select Range
• Format as Table
• Insert Slicers of Your Choice

Select individual or multiple categories at the same time.

To select multiple click+drag or select the ✅✅✅ box.

Click the funnel to unfilter.

No need for a pivot table!

3. Quick Interactive Charts

• Select Range
• Format as Table
• Insert Slicer
• Insert Chart

Like this: 👇🏻

4. Custom Text & Icon Sets

• Create Custom Text
• Choose Icon Sets
• Apply Conditional Formatting

No one else in your office is doing this!

5. Pivot Table Grand Total Percentage

Convert numeric values to show as a percentage of the grand total.

• Select Range
• Create Pivot Table
• Right-Click On Data
• Select "Show Values As"
• Percentage of Grand Total

6. Bonus: Pivot Table Timelines

• Select Range
• Insert Pivot Table
• Choose Pivot Fields
• Insert Timeline

Now you can filter data with a cool slider based on Months, Years, Quarters, etc.

Check it out: ⬇️

Want to learn Excel?

Struggle to find the time?

Learn The Basics In 2 Emails Per Week:
https://t.co/8pXcWG2Bv1

If you enjoyed this, you'll probably like my newsletter as well.

• Software tips
• Video Tutorials
• Free Spreadsheet Templates

Join 21,000+ People and Sign Up Here:
https://t.co/8gpnSlBhyx

More from Blake Burge 💡

$Blake Burge \U0001f4a1$

Blake Burge 💡
@blakeaburge

Here are 10 Things you didn't know your Mac could do (until now) 💻

Hot Corners:

Launch various actions within your computer simply by moving your mouse to one corner of the screen or another.

• System Preferences
• Mission Control
• Hot Corners
• Select the action to launch

Specific Screenshots:

SHIFT+CMD+3 will capture your entire screen.

Did you know you can also narrow your capture to a specific portion?

It's easy, & now that I know it exists, I use it every day.

A simple SHIFT+CMD+4 and you're on your way.

Digital Signatures:

Have a PDF you need to sign?

Let's skip all the printing, physical signing, scanning, etc.

Using the "preview" app you can easily create a digital signature.

All you need is a pen, a white piece of paper, & your Mac's

File Stacks:

I'm a bit OCD when it comes to my desktop.

I like to keep things very organized and can't stand to have a bunch of different files scattered across the screen.

• Right Click
• Use Stacks
• Files are now "stacked" by type

Click a group to see the files within.

$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

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

Don't lose today planning for tomorrow.

Don't join the pack –– Lead it.

10 Stoic principles that will immediately change your life: 🧵

On Wealth:

We all want more.

More things, more money, more prestige...

Whatever 'it' is, we never seem to have enough.

But what if we measured wealth differently?

Not by what we don't have, but by what we don't need?

True wealth is found in wanting less, not having more.

On Truth:

Too often we become set in our ways.

We believe our opinion is right, and are unwilling to consider alternate perspectives.

Have an open mind.

Be willing to change.

He who thinks he knows everything knows nothing.

On Control:

Some things we can change, some we cannot.

The secret to happiness lies in the ability to differentiate between the two.

Ask yourself:

Do I have the power to change this?

If so, get to it.

If not, move on.

On Looking Back:

Quit living in the past.

I've been guilty of this, as I'm sure you have as well.

Stop worrying about what could have been or what you should have done.

Start new. Start fresh. Start today.

What's done is done, but the future has yet to be written.

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

More from All

WORLD OF SANATAN DHARM...
@world_sanatan

WHY BABUR NEVER TRIED TO ATTACK SRI KRISHNADEVARAYA ?

A🧵u must read

It is very well known that Babur considered Krishna Dev Raya as the strongest ruler of the entire subcontinent, and Vijayanagar empire the strongest during that time in India.

1/10

The Vijayanagar empire reached its peak during 1509-1529 around the reign of Krishna Dev Raya.

Vijayanagar’s famed elephant brigade 👇

2/10

At his command there were over 50000 elite troops with a regiment of Portuguese gunners and 3200 cavalry with 600 elephants.

3/10

Along with that more than four hundred thousand ( four lakh) peasant levies and irregular military made this empire one of the largest in all of South Asia.

A typical Vijayanagar levie soldier 👇

4/10

During Baburs invasion, Krishna Dev Raya ruled supreme in all of deccan.

In fact, in an all our brawl, Krisha Dev Raya will beat Babur fair and square.

Babur could muster at max 50000 troops with 50 canons.

While Krishna Dev Raya had these numbers in Hampi alone

5/10

Devdutta
@Devdutta96

Please please please take your cyber security seriously even if you don’t consider yourself a high risk person. Here are a few easy things to start with. 1/n

Switch from WhatsApp to Signal and enable disappearing messages. Most of us cannot stop using WhatsApp entirely but at least turn off back ups to Google Drive or iCloud. 2/n

Do not have private conversations using the messaging service on any social media platform like Facebook, Instagram or Twitter. 3/n

Switch from Gmail to ProtonMail or any other secure email service provider. 4/n

Switch from Google Docs to CryptPad or RiseUp Pad.

Advertisement

$\u0b85\u0bb8\u0bcd\u0ba4\u0bbf\u0ba9\u0bbe\u0baa\u0bc1\u0bb0\u0ba4\u0bcd\u0ba4\u0bc1 \u0b85\u0bb0\u0b9a\u0bbf\U0001f478$

அஸ்தினாபுரத்து அரசி👸...
@SivaRoobini555

#தினம்_ஒரு_திருவாசகம்
தொல்லை இரும்பிறவிச் சூழும் தளை நீக்கி
அல்லல் அறுத்து ஆனந்தம் ஆக்கியதே – எல்லை
மருவா நெறியளிக்கும் வாதவூர் எங்கோன்
திருவாசகம் என்னும் தேன்

பொருள்:
1.எப்போது ஆரம்பித்தது என அறியப்படமுடியாத தொலை காலமாக (தொல்லை)

2. இருந்து வரும் (இரும்)

3.பிறவிப் பயணத்திலே ஆழ்த்துகின்ற (பிறவி சூழும்)

4.அறியாமையாகிய இடரை (தளை)

5.அகற்றி (நீக்கி),

6.அதன் விளைவால் சுகதுக்கமெனும் துயரங்கள் விலக (அல்லல் அறுத்து),

7.முழுநிறைவாய்த் தன்னுளே இறைவனை உணர்த்துவதே (ஆனந்த மாக்கியதே),

8.பிறந்து இறக்கும் காலவெளிகளில் (எல்லை)

9.பிணைக்காமல் (மருவா)

10.காக்கும் மெய்யறிவினைத் தருகின்ற (நெறியளிக்கும்),

11.என் தலைவனான மாணிக்க வாசகரின் (வாதவூரெங்கோன்)

12.திருவாசகம் எனும் தேன் (திருவா சகமென்னுந் தேன்)

முதல்வரி: பிறவி என்பது முன்வினை விதையால் முளைப்பதோர் பெருமரம். அந்த ‘முன்வினை’ எங்கு ஆரம்பித்தது எனச் சொல்ல இயலாது. ஆனால் ‘அறியாமை’ ஒன்றே ஆசைக்கும்,, அச்சத்துக்கும் காரணம் என்பதால், அவையே வினைகளை விளைவிப்பன என்பதால், தொடர்ந்து வரும் பிறவிகளுக்கு, ‘அறியாமையே’ காரணம்

அறியாமைக்கு ஆரம்பம் கிடையாது. நமக்கு ஒரு பொருளைப் பற்றிய அறிவு எப்போதிருந்து இல்லை? அதைச் சொல்ல முடியாது. அதனாலேதான் முதலடியில், ஆரம்பமில்லாத அஞ்ஞானத்தை பிறவிகளுக்குக் காரணமாகச் சொல்லியது. ஆனால் அறியாமை, அறிவின் எழுச்சியால், அப்போதே முடிந்து விடும்.

The Secret CFO
@SecretCFO

If you are the CEO or CFO at a business who banks with SVB; here are some things you CAN do over the weekend

1. Build a 4 week rolling daily receipts and payments style cashflow forecast.

2. Gear up finance team to actualize & reforecast every AM by 10am

3. Schedule a Daily Cash Management Crisis call for 10am every day. CEO to chair

4. Redirect any future cash receipts / revenue into non SVB accounts. Don’t throw fresh money on the fire.

5. If SVB is your only current bank. Open accounts with 2 other AA or A rated banks.

6. Go supplier by supplier and grade them a, b or c
a - showstoppers
b - pay if you can
c - don’t pay

You want as few a’s as possible, ideally none.

7. Find out how to get your $250k FDIC cash.

8. If you are able to pull any deposits or bonds back into a non SVB account. Do it. Put hands on any liquid you can.

9. Communicate a salary deferral plan with your top team. CEO takes the most pain $ and %. Important signal.

10. Elevate sign off of all new POs to CEO and CFO jointly. Don’t sign any off.

11. Make a list of ‘survival headcount’. The bare minimum on which the business can operate.

You may need this to prioritize payroll later.

Angela Jamison
@AnJamison

@SethAbramson @buzz\_chronicles @buzz\\\_chronicles @buzz_chronicles save as category @pdfmakerapp grab @pdfmakerapp grab this @readwiseio save @readwiseio save thread @threader compile summarize @Threadreaderapp unroll please @ttttreads unroll @unrollthread.com @SaveToBookmarks

You May Also Like

Katie Mack
@AstroKatie

Light travels at about 1 foot per nanosecond.

Hold your hand up 12 inches from your face: you’re seeing your hand as it was a nanosecond ago. Everything you look at is, to one degree or another, in the past. The farther away in space, the more ancient in time.

You can’t see the Sun as it is now, but you can see it as it was about 8 minutes ago. You can’t see Alpha Centauri now, but you can see it 4.4 years ago. You can see the Andromeda Galaxy as it was 2.5 million years in the past. And so on.

With powerful telescopes, we can see galaxies whose light has been traveling to us for more than 13 billion years. We see them shining in a universe that’s still young, where gravity has just begun to pull matter together into stars and galaxies.

We can see something even more distant, and more ancient, than the first galaxies. If we peer out far enough, in between the galaxies, we can see parts of the Universe that are so far away, it has taken the light from that distance almost the entire age of the cosmos to reach us.

$Antonio Garc\xeda Mart\xednez$

Antonio García Martíne...
@antoniogm

Observing the public conversation around FB, and the private ones happening among techies and ex-FBers, I think the mutual misunderstanding is worse than when I set out two years (and 500 pages) ago to (in a small way) bridge that gulf.

We're basically fucked.

The tech world has gotten so huge, self-reinforcing, and insulated from reality they can no longer even vaguely look at themselves (and their actions) as others do. They just live on a different planet than most people.

Conversely, the average tech consumer doesn't understand the technology that has slowly taken over their lives, and their designated emissaries to figure it out--politicians, pundits, regulators, journalists--understand it barely better than they do, and have their own agendas.

To say more than generalities for a moment, here's what I think is likely the core problem.

Techies take weird, improbable visions, and make them realities: some BS pitch deck to a VC, mixed with money and people, really does turn into some novel thing.

Most people work inside a legacy industry that's evolved that way over time (usually for good reasons), and they think about the future via some analogy with their present (which is a function of a long-ago past). The interruption that tech will introduce is often hard to grasp.

Advertisement

$\u0936\u094d\u0930\u0940\u092e\u093e\u0932\u0940 \u0939\u093f\u0924\u0947\u0936 \u0905\u0935\u0938\u094d\u0925\u0940$

श्रीमाली हितेश अवस्थी...
@HiteshAwasthi89

Varahi Amman, Madurai, Tamilnadu

Vaarahi is one of the Saivite Shakti deities with the group of goddesses known as SAPTAMATAS.
They are: Brahmi, Maheshwari, Kaumari, Vaishnavi, Vaarahi, Mahendri and Chamundi. 1/n

They are the Shakti (female) equivalents of their male counterparts. Vaarahi is the Shakti of Bhairavar who is one of the Amsam of Bhairavar.Created from the boar avatara of Vishnu, Vaarahi is often associated with Goddess Kamala (one of the Mahavidyas). 2/n

She is also called Dandini (Lady Commander of the forces of the Mother-Goddess, symbolizing the might of SriVidya). As Vaarahi ("hog-faced" or "the great consumer") she destroys evil forces that obstructs the devotees' progress, paralyses the enemies 3/n

and led the devotees ultimately to SriVidyas. She is also called Panchami). With Kurukalla, she is accorded the parental status to Sri-Chakra (Lalita Tripura-Sundari). While Kurukalla represents the full moon, Vaarahi represents the new-moon. 4/4

Jai Maa Varahi 🙏

Tag for 📷 credit

$Anumah, Abdulraheem Okehi \U0001f468\u200d\U0001f52c\U0001f1f3\U0001f1ec \U0001f1eb\U0001f1f7 \U0001f1f5\U0001f1f9 \U0001f1ea\U0001f1f8$

Anumah, Abdulraheem Ok...
@AnumahABD

Department List of UCAS-China PROFESSORs for ANSO, CSC and UCAS (fully or partial) Scholarship Acceptance
1) UCAS School of physical sciences Professor
https://t.co/9X8OheIvRw
2) UCAS School of mathematical sciences Professor

3) UCAS School of nuclear sciences and technology
https://t.co/nQH8JnewcJ
4) UCAS School of astronomy and space sciences
https://t.co/7Ikc6CuKHZ
5) UCAS School of engineering

6) Geotechnical Engineering Teaching and Research Office
https://t.co/jBCJW7UKlQ
7) Multi-scale Mechanics Teaching and Research Section
https://t.co/eqfQnX1LEQ
😎 Microgravity Science Teaching and Research

9) High temperature gas dynamics teaching and research section
https://t.co/tVIdKgTPl3
10) Department of Biomechanics and Medical Engineering
https://t.co/ubW4xhZY2R
11) Ocean Engineering Teaching and Research

12) Department of Dynamics and Advanced Manufacturing
https://t.co/42BKXEugGv
13) Refrigeration and Cryogenic Engineering Teaching and Research Office
https://t.co/pZdUXFTvw3
14) Power Machinery and Engineering Teaching and Research

Christina Warren
@film_girl

A brief thread on Jovan Hutton Pulitzer, the crazy con man who is now claiming to have hacked into the Georgia voting machines in Fulton County. 90s kids and tech aficionados might remember Jovan as the inventor of the CueCat, the dumbest gadget of all time.

Also, for anyone who wants to claim that Jovan Hutton Pulitzer (not his given name, but one he changed legally after the CueCat debacle) invented QR Codes: he did not. Like that other right-wing crazy man who claimed to have invented email, Jovan didn’t invent QR Codes.

He did invent the CueCat, a product that somehow raised $185 million dollars for a tethered barcode scanner for magazines and newspapers, so you could get ads from your ads. As I said, the dumbest product of all time. Good backup barcode scanners after they were hacked, however

Oh, that’s another thing. When CueCat was a thing, its systems were hacked. I guess that’s what makes Jovan a security expert. His bankrupt company from 20 years ago was hacked and widely mocked. He’s a genius.

In recent years, Jovan pivoted to being a treasure hunter who was featured on and widely mocked on Curse of Oak Island, because the man is insane.