7 Excel Quick Analysis (QA) that analyze your data, so you don't have to:

10 must-know Excel shortcuts:

1. CTRL E

CTRL E makes complicated tasks easier than ever, thanks to Flash Fill. Flash Fill automatically fills data down a column based on detected patterns. Just enter how you want the data to appear, hit CTRL E, and Excel will fill the pattern down the column in a flash.

2. ALT =

Let Excel do the math for you with this shortcut! ALT = detects data in adjacent cells and automatically sums it using the SUM function. Just select an empty cell adjacent to the data that needs to be added and press ALT =.

3. ALT H O I

If you are unable to see your data, ALT H O I is here to help! Press ALT H O I to automatically adjust the column widths to fit the size of your data.

4. ALT ↓

If you are entering repetitive data in Excel, ALT ↓ is a must-know shortcut. The Alt ↓ shortcut displays a dropdown list of all values previously entered in the column. Now, you can simply select any value, which will automatically be entered into the active cell!

4 text functions you need to know:

1. TEXTSPLIT

Need to break up data in a text string into multiple rows or columns? Use the TEXTSPLIT function to split up text at a specified delimiter. For example, this function can split full names into first, middle, and last name columns by defining the col_delimiter.

2. TEXTJOIN

Now that we’ve learned how to split text, let’s learn how to combine it. The TEXTJOIN function combines values into one with a delimiter in between each value. For example, we can combine first, middle, and last name back together with a space in between each name.

3. TEXTBEFORE

Now let’s say we need to extract text from the beginning of a text string. The TEXTBEFORE function extracts text before a specified delimiter. For example, if we just want the names from this list. We can extract the names by defining the dash as the delimiter.

4. TEXTAFTER

Similarly, we can extract text from the end of a text string using the TEXTAFTER function. TEXTAFTER extracts text after a specified delimiter. If we want to extract the date and omit the names, we can define the dash as the delimiter using the TEXTAFTER function.

6 Excel features that will blow your mind:

1. Data Types (DT)

Spare yourself the google search and let Excel search for you using DT. DT pull real-time data into Excel. To convert text strings into linked DT, just select the data category under the data tab. Now, simply select the attributes you want to pull into Excel.

2. Flash Fill (FF)

Say goodbye to writing complex functions to manipulate data, and hello to FF. FF automatically fills data down a column based on detected patterns. Just enter how you want the data to appear, hit CTRL E, and Excel will auto-fill the pattern down the column!

3. Power Query (PQ)

Teleport data into Excel using PQ. PQ is a powerful tool that imports data from various sources (the web, PDFs, CSVs, etc.) into Excel. Instead of copying data from the web, just go to the Data tab > From Web > enter URL > Select the data table and hit load.

4. AutoSum (AS)

Summing data in Excel can be tedious, but not with AS! AS automatically detects data in adjacent cells and sums it using the SUM function. To use AS, select an empty cell adjacent to the data that needs to be summed and simply press ALT =.

Three methods for splitting text in Excel: 🤓

1. Flash Fill:

Flash Fill is the quickest and easiest way to split text, in my opinion. To use Flash Fill to split text, enter how you want the text to be split, and then just hit CTRL E to automatically fill the pattern down the column!

2. TEXTSPLIT

The TEXTSPLIT function is a new function used to split text at a specified delimiter. To use the TEXTSPLIT function, enter the text you want to split as the text argument and the delimiter that you want to split the text at as the col_delimiter argument.

3. Text to Columns

Text to Columns is an OG data tool used to split text into columns. To use Text to Columns, select the text you want to split > data tab > text to columns > select the delimiter(s) to split the text at > select where to insert the new data > finish.

Which method is your go-to for splitting text? Mine is Flash Fill, obviously. 😏

Follow me @exceldictionary for even more Excel tips and tricks.

And if you never want to forget my excel tips at your desk, check out my shortcut merch and ebooks.

3 things all Excel users should know: 🤯

1. AutoFit

Automatically fit all column widths to the size of the data by hitting ALT H O I.

2. AutoFill

Automatically fill data down columns by hitting CTRL E.

3. AutoSum

Automatically sum all data at once by hitting ALT =.

Work smarter, not harder, with these Excel tips. 😏

Follow me @exceldictionary for even more Excel tips and tricks.

And if you never want to forget my excel tips at your desk, check out my shortcut merch and

Starting my 2nd thread on Sringeri Parampara. This will cover the Jagadgurus after Sri Vidyaranya to Sri Shivabhinava Nrisimha Bharati.

It is really very tough to match the brilliance and achievements of Vidyaranya. After whom came 15 - Chandrashekara Bharati [1386-1389].

The next Acharya was Nrisimha Bharati [1389-1408]. Harihara raya found a town for this Acharya - Narasimhapuram. Acharya helped the king by guiding him in political affairs. He also initiated the kind with mahamantras for spiritual development.

Subsequent Acharyas were
15-Puroshottama Bharati [1408 - 1448]
16-Shankara Bharati[1448 - 1455]
17-Chandrasekhara Bharati II [1455 - 1464]
18- Nrisimha Bharati II [1464 - 1479]
19-Puroshottama Bharati II [1479 - 1517]

20-Ramachandra Bharati [1517 - 1560]. Sadashiva Raya was emporer of Vijayanagara during this time.
21-Nrisimha Bharati III [1560 - 1573]
22-Nrisimha Bharati IV [1573 - 1576]
23-Nrisimha Bharati V [1576 - 1600]

24-Abhinava Nrisimha Bharati [1600-1623]. When he visited Malahanikareswara temple for first time he noticed there was no Vinayaka there so he took piece of turmeric and drew outline of Ganesha on a pillar and offered puja.

LACHIT BORPHUKAN : AN UNSUNG WARRIOR OF THE AHOM KINGDOM & THE GREAT BATTLE OF SARAIGHAT

Originally named as Lachit Deca, Lachit Borphukan, the fierce and invincible Ahom Commander, was born during the early 17th century at Betioni in the Golaghat district of modern Assam.

His father, Momai Tamuli Borbarua was the ‘Governor’ of the kingdom and also ‘Commander-in-Chief’ of Ahom army under King Pratap Singha during his reign starting from 1603 to 1639. Lachit received military training from an early age and joined the Ahom King Jayadhvaj Singha...

...(1648-1663) as a scarf-bearer.  The post ‘scarf-bearer’ or ‘Soladhara Barua’ is considered as a part of the incumbent king’s personal staff. Owing to his military training Lechit was appointed "Ghora Barua", Supdt. of the Royal horses. When Chakradhwaj Singha became king..

..of Ahom dynasty in 1663,he appointed him Suptd. of The Royal Guards &finally he was appointed as Borphukan by the king.Then onwards,he was known as Lachit Borphukan.Borphukan used to be top councillor in Ahom Kingdom. This position was embedded with executive & judicial powers.

Assam was facing incessant Islamic invasion since Jan1662, when Mughal General Mir Jumla II attacked Ahom capital Gargaon. He never defeated Ahom king Jayadhwaja Singha as king retreated to hill &continued Guerrilla warfare.Prolonged fight &prospect of stalemate disturbed Jumla.

*The Evidence Collection*

There is overwhelming evidence of election fraud. Therefore it is the duty of the Executive, Legislative, & Judicial branches to throw out the fraudulent votes & to honor their oath to protect & defend the Constitution of the USA.🇺🇸🦅

A list below.🔻

1/ Navarro Report: The Immaculate Deception - Six Key Dimensions of Election Irregularities -

2/ Analysis of 3,000 U.S. counties shows Joe Biden received 5.6 % more votes in counties using Dominion Voting Systems (Video) -

3/ Antrim Michigan Dominion Voting Systems Forensics Report -

4/ Evidence Grows: ’20 Election Was Rigged -

@Artofphysique_ @buzz_chronicles @rattibha @SaveToBookmarks save as Workouts