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!

20 Free Hidden Gem Websites That You Wish You Knew :

1. Internet Archive

It is a service that preserves archived content from the internet, including pdfs, ebooks, and sites that are no longer live.

It has books, movies, software, music, websites, and pretty much any media that could be uploaded on the internet.

2. Coursera

It is a powerful tool for free online education and includes courses from top universities, museums, and trusts.

The site is useful if you’re looking to study many different topics, or want courses from different schools and groups.

3. Project Gutenberg

It is a library of quality books that covers almost every field of education

The site has over 60,000 public domain books in the catalog.

If you’re looking for great classic books, this is a great website.

4. Tubi

It is a great site for movies, TV shows and watching live TV for free.

With over 50,000 shows and movies available and more being added all the time, Tubi TV is quickly growing to become a TV favorite for internet users everywhere.

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.

20 Documentaries to Watch In Your 20s

1)

2)Genius

3)Man on Wire

4) Our Planet

5)A Life On Our Planet

10 websites where you can learn anything for free:

1. Udemy

Udemy is an online learning and teaching marketplace with over 185000 courses and 49 million students.

Although most of the courses were premium on this site, some of them were available for free.

2. Edx

EdX is a learning platform that gives students from any country the opportunity to take free online courses offered by premier Universities such as Harvard and

3. Instructables

Instructables is a website specializing in user-created and uploaded do-it-yourself projects, which other users can comment on and rate for quality.

4. Cooksmarts

Cook Smart is the exciting way to learn new recipes & improve cooking skills while using any device. Learn from top-notch professional

I have a master's degree in business.

But I’ve learned 10x more from reading newsletters.

Here are 10 FREE newsletters that will teach you about business:

1/

Morning Brew (@morningbrew)

Get insightful and informative business news that's fun to read and will get you up-to-date with everything going on in the business world in 5

2/

Robinhood Snacks (@RobinhoodSnacks)

If you're looking for a super short recap of what happened in the stock market, this newsletter is for you. You'll get a recap of market news in just

3/

Milk Road (@MilkRoadDaily)

A daily newsletter that will be your tour guide and teacher for all things Web3. It will also keep you in the loop on the coolest projects happening in

4/

The Pomp Letter (@APompliano)

The Pomp Letter is a must-read for anyone interested in Bitcoin and finance. Pomp does an excellent job of explaining how Bitcoin and the economy work and what's going on with

If you haven't read these 21 books, you shouldn't be leading anyone:

1) Multipliers by @LizWiseman

What you'll learn:

- How you might be accidentally holding your team back
- What you can do (Action items!) to help everyone on your team be at their

2) Radical Candor by @kimballscott

What you'll learn:

- How to give feedback that creates change
- How to build better relationships in the

3) The Five Dysfunctions of a Team by @patricklencioni

What you'll learn:

- Why team culture starts with Trust
- How you can build a team invested in the results of the

4) Lead With a Story

What you'll learn:

- How to tell a story that inspires your team and help influence
- How to engage an audience, regardless of the

12 Books That Will Change Your Life in 12 Months

1) The Psychology of Money

2)Think Again

3)Rich Dad Poor Dad

4)Laws of Human Nature

5) Deep Work

You could pay $100,000+ for a college degree OR...

You could use the internet to get a top-tier college-level education for free.

Here are 20 FREE online learning platforms:

1/

Coursera (@coursera)

Coursera has 150+ university partners and 2,700+ courses. The instructors are from the world's top universities and courses include recorded video lectures, discussion forums, and graded

2/

Udemy (@udemy)

Udemy has 100,000+ courses in 50 languages. Unlike other online education platforms driven by content from colleges and universities, Udemy allows content creators to curate their own courses and teach them

3/

Codeacademy (@Codecademy)

Codeacademy teaches you how to code in multiple programming languages. They have trained 45+ million people in topics such as web development, programming, computer science, and data

4/

Stanford Online (@StanfordOnline)

Stanford Online offers free online courses, professional certificates, advanced degrees, and executive education. The courses are from Stanford Law School, Stanford Business School, and Stanford Medical

Naval Ravikant is one of the most respected investors of our time.

He credits reading 1-2 hours per day as the main reason he's been so successful.

Here are 20 books @naval recommends reading:

1/

"The Rational Optimist" by @mattwridley

"The most brilliant and enlightening book I've read in years."

–Naval

2/

"Surely You're Joking, Mr. Feynman!" by Richard P. Feynman

"Learn about the inner mindset and external state of someone who was absolutely brilliant."

–Naval

3/

"Meditations" by Marcus Aurelius

"One of my favorite books of all time."

–Naval Ravikant

4/

"Sapiens" by @harari_yuval

"Best book I've read in [2015]."

–Naval

20 Speeches that will inspire you to achieve greatness:

1/

Steve Jobs

2005 Stanford Commencement Address

Watch here:

2/

Arnold Schwarzenegger (@Schwarzenegger)

2009 USC Commencement Address

Watch

3/

Admiral William H. McRaven

2014 University of Texas Commencement Address

Watch

4/

Elon Musk (@elonmusk)

2012 Caltech Commencement Address

Watch

In 2014, I was the Chief Business Officer of WhatsApp.

And I helped negotiate the $22 billion sale to Facebook.

Today, I regret it.

Here’s where things went wrong:

WhatsApp was founded in 2009 by Jan Koum and Brian Acton.

2 years in (2011), I joined the team as Chief Business Officer.

And in 2012/13, we were approached by Zuck & Facebook about an acquisition.

We declined and decided to keep growing instead.

But then…

FB approached us again early 2014 with an offer that made it look like a partnership:

• Full support for end-to-end encryption
• No ads (ever)
• Complete independence on product decisions
• Board seat for Jan Koum
• Our own office in Mountain View
• Etc.

If you used WhatsApp in early days, you remember what made the product special:

International communication.

For people (like myself) with family in multiple countries, WhatsApp was a way to stay connected—without paying long-distance SMS or calling fees

How WhatsApp made money was by charging users $1 to download the app.

And Facebook (said they) supported our mission & vision.

Brian even wrote this famous note:

Elon Musk keeps tweeting that he loves free speech. So here's a thread with just a few of the countless examples showing he couldn't care about it less (🧵)

1. There's the time he called Vernon Unsworth, the man who helped rescue 12 boys trapped in a mine in Thailand, a “pedo guy” and paid $50,000 to an investigator to dig up Unsworth’s life. Why? Because Unsworth called his failed attempt help the boys himself a “PR stunt.”

2. Then there's the story of John Bernal, who was fired six days after posting a YouTube video of a Tesla

3. Then, there's Martin Tripp, a technician at a Tesla plant in Nevada who blew the whistle on the company. Musk allegedly hired people to hack and spy on Tripp after he cast doubts on Tesla’s environmental

4. Musk also is anti free-speech when it comes to labor organizing. Tesla worker Richard Ortiz was fired for trying to organize with the United Auto Workers, a move that was declared illegal by a labor board.

This thread will make you better at Excel: 📊

Automatic Abbreviations:

If you're like me, autocorrect is more of an annoyance than a help.

Let's change that.

Set up your own custom list of abbreviations, and bend its powers to your will.

Type 'TBD'
Press 'Enter"
Output = 'To be determined'

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.

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! 🤯

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.

Name one movie you never get tired of.

7 powerful concepts everyone should teach their children:

Compound interest:

Large outcomes are often the result of small gains in performance compounding over the course of years and decades.

Small improvements may look tiny in isolation, but they result in gigantic outcomes when you zoom out.

Evolution by natural selection:

People and culture evolve through a process of generational iteration.

In every generation, the fittest organisms reproduce to create the next generation - while the unfittest die away.

Most things in our world are the result of this process.

Evolution-environment disconnect:

We evolved in the scarcity of jungles but find ourselves in the abundance of cities with unlimited food and pleasures.

Our biology isn't equipped to deal with this abundance - which often leads to addiction and obesity.

Many things around us are designed to exploit this evolutionary disconnect:

• Added sugar to exploit your taste buds
• Pornography to exploit your sex drive
• Social media to exploit your social instincts

Recognizing and limiting these things is critical for a healthy life.

If you struggle to take critical feedback, read this:

The common advice on this topic is more suited for the playground than the boardroom:

-> Don't take it personally
-> Don't get emotonal
-> Count to 10

WTF?

If you’re an accomplished professional trying to find your way to the top...

This is your roadmap.

1/ Picture Yourself

You're a mosaic.

Every experience, every mistake, every resounding success adds to the picture of you.

And you, being human, can grow & evolve.

The fuel for that growth?

Feedback

And the clearer you see yourself, the easier you can place each piece.

2/ Declare Your Intention

Don't wait for people to come at you w/ feedback.

Focus them where you want to grow.

-> Tell them your gap
-> Show them you're working on it
-> Solicit their advice
-> Tell them you applied it

Your desire + action = their perception of your growth.

3/ Ask For It

Use every interaction to improve.

Don't ask: What could I have done better?

Do ask: Do you think ___ landed? If no, why not?

Targeted:
-> Minimizes the onus placed on the giver
-> Starts a more natural conversation
-> Preempts other feedback
-> Focuses them