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

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.

What do the world's greatest leaders know about the power of persuasion that you don't?

THREAD: How you can unlock the ability to change anyone's mind.

Let's get smarter... 👇🏻

1/ As far back as the mid 300's BC, humans were fascinated by the power of persuasion.

In light of this, Aristotle developed what is known as the "Rhetorical Triangle."

A framework for persuading any audience using 3 simple appeals:

•Ethos
•Pathos
•Logos

Let's dig in...

2/ Ethos (Ethics / Character)

The first of the 3 appeals, Ethos speaks to the perceived character of the speaker.

In order to persuade anyone to do anything, they must first believe you are a credible and trustworthy source.

How do you accomplish this?

3/ Establishing Ethos: (1)

•Language: Choose verbiage that is fitting to the subject matter and audience you are trying to persuade.

•Pedigree: Do you have specific credentials or education relating to the topic being covered? If so, make it known.

👇🏻

4/ Establishing Ethos: (2)

•Rapport: Your audience must feel as though you are "in sync."

You understand and can relate to their feelings or ideas.

TL;DR

•Choose the right language
•Communicate pedigree
•Build Rapport

Trust becomes a byproduct.

Let's see an example 👇🏻

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.

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:

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

कुंडली में 12 भाव होते हैं। कैसे ज्योतिष द्वारा रोग के आंकलन करते समय कुंडली के विभिन्न भावों से गणना करते हैं आज इस पर चर्चा करेंगे।
कुण्डली को कालपुरुष की संज्ञा देकर इसमें शरीर के अंगों को स्थापित कर उनसे रोग, रोगेश, रोग को बढ़ाने घटाने वाले ग्रह

रोग की स्थिति में उत्प्रेरक का कार्य करने वाले ग्रह, आयुर्वेदिक/ऐलोपैथी/होमियोपैथी में से कौन कारगर होगा इसका आँकलन, रक्त विकार, रक्त और आपरेशन की स्थिति, कौन सा आंतरिक या बाहरी अंग प्रभावित होगा इत्यादि गणना करने में कुंडली का प्रयोग किया जाता है।

मेडिकल ज्योतिष में आज के समय में Dr. K. S. Charak का नाम निर्विवाद रूप से प्रथम स्थान रखता है। उनकी लिखी कई पुस्तकें आज इस क्षेत्र में नए ज्योतिषों का मार्गदर्शन कर रही हैं।
प्रथम भाव -
इस भाव से हम व्यक्ति की रोगप्रतिरोधक क्षमता, सिर, मष्तिस्क का विचार करते हैं।

द्वितीय भाव-
दाहिना नेत्र, मुख, वाणी, नाक, गर्दन व गले के ऊपरी भाग का विचार होता है।
तृतीय भाव-
अस्थि, गला,कान, हाथ, कंधे व छाती के आंतरिक अंगों का शुरुआती भाग इत्यादि।

चतुर्थ भाव- छाती व इसके आंतरिक अंग, जातक की मानसिक स्थिति/प्रकृति, स्तन आदि की गणना की जाती है

पंचम भाव-
जातक की बुद्धि व उसकी तीव्रता,पीठ, पसलियां,पेट, हृदय की स्थिति आंकलन में प्रयोग होता है।

षष्ठ भाव-
रोग भाव कहा जाता है। कुंडली मे इसके तत्कालिक भाव स्वामी, कालपुरुष कुंडली के स्वामी, दृष्टि संबंध, रोगेश की स्थिति, रोगेश के नक्षत्र औऱ रोगेश व भाव की डिग्री इत्यादि।

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

@SaveToBookmarks Namaste! There you go! Original tweet by @buzz_chronicles: "@SaveToBookmarks Namaste! You can find it here. Original tweet by @AchuthArora: ...". Enjoy 👌

Hi! There you go! Original tweet by @SaveToBookmarks: "@buzz_chronicles @AchuthArora @OllieEmberson @rattibha No more missed tweet 😉!

...". See You soon! 👉

In the past couple of months, 50,000,000 people read my Tweets.

That's more than the population of Canada.

My Secret?

I use the same 7 templates every time (Grab them for free) ↓

📑 Listicles

If you're starting out this one is perfect for you.

Curate lists of:

- Tools to use.
- Books to read.
- Creators to follow.
- Podcasts to listen to.

Add a question & you got a banger.

Grab this template ↓

X life-changing [books, podcasts, courses,etc..)

1. ______________
2. _____________
3. ____________
4. ___________
5. __________
6. _________
7. ________

→ What did I miss?/What else?

🔖 How to do X

This one will get you authority and fans.

Break down something you did in steps.

List them down & encourage people to go for it.

Grab the template ↓

An easy X-step process to [desired outcome]:

1. ______________
2. _____________
3. ____________
4. ___________
5. __________

6. Thank me later