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

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.

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!

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.

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.

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: 👇🏻

The ultimate guide to Gmail, Gsheets, and Mac Productivity:🧵

📊 -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" – Charts, analytics, & detailed info. generated automatically.

📩 -Look like you're working (when you're not)

Gmail offers scheduling... Who knew?

No need to be physically sitting at your desk, or hammering out emails on your phone after hours.

•Compose your message
•Click the dropdown next to "send"
•Click "schedule send"

💻 -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.

📊 -Finance:

Monitor stock prices, spot trends, & quickly review historical data using =GOOGLEFINANCE.

Want to see the last 60 days of closing prices for a specific ticker symbol?

Paste the formula below & voila!

=GOOGLEFINANCE("NASDAQ:TSLA","price",TODAY()-60,TODAY())