3 Excel hacks that will blow your mind. Who knew all three?! #excel

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

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

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

1. Running Total

Calculating data metrics like running total can be tricky, but not with QA. Select the data you want to calculate > QA > Totals tab > Running Total. As you can see, Excel auto-calculated the running total and even inserted all the formulas for us!

2. % Total

Now that we know how to calculate the running total with QA, let’s learn how to calculate % of the total. Select the data you want to calculate > QA > Totals tab > % Total. Once again, Excel auto-calculated % of the total for each value and inserted all the formulas!

3. Sparklines

Visualizing data trends isn’t required… but it should be. QA can quickly visualize trends for you by adding sparklines. Select the data you want to visualize > QA > Sparklines tab > Line. Now just fill the sparklines down using the fill handle.

4. Creating Charts

Lets say you want to create a compelling data chart but don’t know where to begin… QA is here to help! Select data you want to graph > QA > Charts tab > browse the charts QA made. Now you can select any chart you like and insert it right into your worksheet.

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.

ANCIENT BHARAT WAS CALLED VISHWAGURU, AND IT REALLY DESERVED IT.

India had a well developed education system centuries before the westerners arrived and called us uncivilized. Education was always given a great importance in Indian civilisation since times immemorial.

Ancient India had the Gurukulas and Ashramas as the epicentres of the knowledge and enlightenment. Bigger Gurukulas served as the centres of higher education called universities. Besides these universities, temples also emerged as the major learning centres.

Studying the Holy Scriptures, character building, personality development, responsibilities towards self,family and society,discipline and preservation of the ancient culture and heritage were the key embodiments of education.

This kind of education system made ancient India, a centre of knowledge all over the world. Many foreign students came to India for education and India was called the 'Vishwaguru'.
Takshshila and Nalanda were the two prominent universities of ancient India.

But were these only Universities of ancient India?The answer is 'No'.Let's learn about these gems of our education system that flourished across ancient India & be proud.

NALANDA UNIVERSITY
This was the oldest university of ancient India.Situated in Nalanda distt. of Bihar...

NARHARI AND BHAGWAN PANDURANG/VITTHAL

Once a goldsmith by the name of Narhari lived in Pandharpur. He excelled in his craft. He had vowed not to look at Pandurang or visit his mandir ever, as he was a Shiva Bhakt.
One day, a wealthy merchant visited him.

He wanted a gold girdle studded with precious gems, to be made for Prabhu Vitthal. Narhari refused to make it as it was for Vitthal.
After many requests, he agreed to make the girdle but asked the merchant to bring the measurement from the mandir as he himself would not go there

The measurement was given n he made the girdle. When the girdle was put on Vitthal, it was loose. Narhari had to shorten it. Now the girdle became tight. So Narhari was forced to take measurement on his own. He had to go to the mandir but went blindfolded to avoid seeing Vitthal

In the Mandir, when blindfolded Narhari touched Vitthal, he felt as if he was touching Shiva with matted hair, the moon, snake in His neck and Trishul in His hand. Ecstatic with joy, he removed the blindfold to see Shiva but he found the murti of Vitthal with Rukmini there.

He realised the truth that there was no difference between Vitthal and Shiva. Narhari at once fell at the feet of Panduranga. He then took the measurement of the waist of Vitthal and this time the ornament fit the Murti perfectly.

Narayan Hari🙏🏻

@buzz_chronicles @AchuthArora @Abhirajputfit @rattibha Thanks bro!

Your tweet has been saved.

To access and manage your bookmarks, please register with savetobookmarks .com.

9 Python resources that will fast-track your learning

🧵👇

1️⃣ Introduction to Python Programming

✔️ Learn to solve practical problems with Python
✔️ Enhance your skill set
✔️ Boost your hirability through innovative, independent learning.

2️⃣ Introduction to Computer Science and Programming Using Python

✔️ Introduction to computer science
✔️ A tool to solve real-world analytical problems
✔️ Computational thinking and Data

3️⃣ Learn Python the HARD WAY

✔️ The Hard Way Is Easier
✔️ Learn Python through 52 exercises
✔️ Starting from

4️⃣ Python for Everybody Specialization

✔️ Learn to program
✔️ Analyze data with Python
✔️ Gather, clean, analyze, and visualize