Trending December 2023 # Top 10 Python Libraries That You Must Know! # Suggested January 2024 # Top 15 Popular

You are reading the article Top 10 Python Libraries That You Must Know! updated in December 2023 on the website We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested January 2024 Top 10 Python Libraries That You Must Know!


Know top 10 libraries in python

Know about the features and uses of these libraries


Python is a prevalent programming language. It’s easy to use, highly interpretable, interactive, and object-oriented. Python libraries contain functions and methods that facilitate specific tasks. Also, it saves developers a significant amount of time and headache!

As a newly hired Product Growth Analyst, having a basic understanding of these libraries has eased the transition into my new role. The Python libraries have helped a lot in manipulating and representing data in a much more understandable manner, whether using Scikit-Learn to build models or Matplotlib to visualize data in a graphic format.

Let us now look at some python libraries:

Table of Contents











An open-source library developed by Google to aid in developing and training machine learning models. Data scientists can instantly develop and deploy machine learning models using TensorFlow, developed initially for computing large mathematical operations.


The visualization of computational graphs is exceptional.

Google manages libraries

Parallel Neural Network Training


Speech and image recognition

Text-based applications

Time-series analysis

Video detection

Scikit-Learn is one of the most popular and valuable python libraries in machine learning. It contains all machine learning algorithms that you might need, like linear and logistic regression, gradient boosting, support vector machines, random forests, etc.,


It contains several methods for checking the accuracy of a model on unseen data.

Provides all types of ML models for different types of data

It is an effective tool for predictive data analysis.


Model selection

Dimensionality reduction

It is open-source software used for computer vision and natural language processing. In addition to being fast and inexpensive, PyTorch is the best deep learning framework because it can accelerate the research on deep learning models.


Production Ready

Distributed Training

Robust Ecosystem

Cloud support


PyTorch is famous for providing two of the most high-level features:

Tensor computations with solid GPU acceleration support

Building deep neural networks on a tape-based auto-grade system

Matplotlib is the most commonly used library for visualization in the Python community. With endless customization in charts and graphs, the developer can use everything from histograms to scatter plots. You can choose from an array of themes and colour schemes. This library is handy for the exploratory analysis of data during machine learning projects.


It’s free and open source.

Complete control of axes properties, font properties, line styles, etc.

Low memory consumption and better runtime behaviour


Correlation analysis of variables

Visualize 95 per cent confidence intervals of the models

Outlier detection using a scatter plot etc.

Visualize the distribution of data to gain instant insights

If you want to get into the data science domain, Pandas is the library you should be mastered in. It is an open-sourced library heavily used for data exploration, manipulation, and analysis. It provides fast, flexible, and inexpensive data structures, making them easy to work with.


The capability of performing custom operations

Enhances the ease of data manipulation

Provides aggregations, concatenations, iteration, reindexing, and visualization capabilities


Used as excellent support for loading CSV files into its data frame format

Time-series-specific functionality includes date range generation, moving window, linear regression, and date shifting

This open-sourced library supports deep learning and neural networks. Model aggregation, graph visualization, and dataset analysis are among the features of Keras. Furthermore, it offers prelabeled datasets that can be imported and loaded directly. Besides being easy to use, it is versatile and suitable for innovative research.


Its Python-based nature makes debugging and exploring easier.

Modular by nature

Combining neural network models can lead to more complex models

It runs smoothly on both CPU and GPU.


Keras can make predictions and extract features in deep learning models with corresponding weights without using a new train model.

NLTK stands for Natural Language Toolkit. This library helps in processing text data, and it contains text processing libraries such as classification, tokenization, stemming, tagging, parsing, etc. It also includes 50+ corpora.


It comes with a part-of-speech tagger

N-gram and collocations

Named-entity recognition


Sentiment analysis

Topic analysis

This open-source library is used in unsupervised topic modelling and natural language processing. It was specially developed for handling extensive text collections, or corpora, utilizing data streaming and incremental online algorithms. The most distinguishing feature of Gensim is that, unlike its contemporaries, it doesn’t target only in-memory processing.


Streamed parallelized implementation of doc2vec, fastText, and word2vec algorithms

The function can handle latent Dirichlet allocation, latent semantic analysis, non-negative matrix factorization, random projections, and tf-IDF.

Statsmodel is a python library that conducts statistical tests and statistical data exploration. Statsmodels allows users to explore data, estimate statistical models and perform statistical tests.


Time series hypothesis tests: unit root, cointegration, etc.

Descriptive statistics and process models for time series analysis


Used for statistical testing

Web browsers can be automated using Selenium, an open-source tool. It supports many browsers such as Firefox, Chrome, IE, and Safari. However, using the Selenium WebDriver, we can only automate testing for web applications.


Multi-Browser Compatibility

Multiple Language Support

Speed and Performance


Selenium is an open-source and portable Web testing framework.

Selenium commands are categorized into classes, making them easier to comprehend and implement.

Selenium supports parallel test execution that reduces the time to execute similar tests.


There are many helpful Python libraries for data science in addition to these top 10 Python libraries, and which one the user chooses is mainly based on the kind of project they are engaged in. And as a next step, if you are interested in learning and mastering data science with python, head onto Analytics Vidhya Introduction to Python Certification Course. Explore other available courses, and unlock your career as a data scientist!


You're reading Top 10 Python Libraries That You Must Know!

20 ‘Spelunky 2’ Tips You Must Know!

It’s hard to perfect perfection, but Mosssmouth managed to pull it off with Spelunky 2, the sequel to everybody’s favorite, deceptively maniacal rogue-like, Spelunky HD. The newest installment in the single most hectic mashup of Indiana Jones and just about everything else doubles down on the grueling fundamentals that made it the first one the mercilessly addictive game it was and does just enough tweaking to up the craziness without detracting from the vanilla experience.

It’s treasure, traps, and secrets galore in Spelunky 2, and to help you get the most out of each run we’ve compiled a list of tips and tricks in a complete Spelunky 2 guide down below.

What’s New in Spelunky 2?

Below we run through some of the bigger changes that came in with Spelunky 2. We’ll avoid going over minor changes and the more subtle QOL tweaks and stick to the changes that impact gameplay more significantly.

Fluid Dynamics

Lava, to water, to any sort of liquid in the game, Spelunky 2 now incorporates fluid dynamics in many components of the game to add an extra layer of complexity to the madness — so be sure to account for the behavior of liquids in the game. Because like everything else in Spelunky, they can probably kill you. Just make sure you know which way gravity pulls them, first.


One of the coolest new additions with Spelunky 2 is the new Mounts. From turkeys to rock dogs to fire-breathing secret mounts, each one has their own movement mechanics and unique attacks — gotta catch ’em all!

Non-linear progression

Unlike Spelunky HD, the new Spelunky on the block actually incorporates branching levels. At key points in the game, players hit proverbial forks in the road which changes the immediate course of their run. Get to know these, because each level has its own unique constraints and caters to very different build-styles.

Items can Explode

Before you kick open the door of the shop and start blasting at the local shopkeeper, make sure to look at what he’s selling first. Items in Spelunky, worn, held, or just sitting around, can and will explode to great effect. This means being careful around flames while using jetpacks, and being wary around explosives while exercising your firearms.

The Whip’s been Nerfed

The old reliable of Spelunky weaponry, the Whip, has seen some significant changes this time around. It requires a little more finesse and getting used to, which we’ll go into with some depth later on, but can in fact be more useful if you know how to use it.

The Ghost is Buffed

Everybody’s favorite, highly impatient, insta-killing poltergeist is still around but this time he moves faster and can even split into multiple ghosts. So keep a move on.

New Secret Level

Like Spelunky HD’s super-secret Hell level, there exists an even more insane after-level reserved for only the mightiest gamers on Earth, known as the Cosmic Ocean. We won’t go into depth, since it’s a pretty massive spoiler, but if you want to learn how to get there you can read our special Spelunky 2 Cosmic Ocean Walkthrough.

Spelunky 2 Guide: 15 Tips and Tricks for Beginners and Advanced Players

1. Approach Shoplifting with Caution

While killing Shoplifters is an old mainstay of Spelunky, returning players and total newbies alike should approach the five-fingered discount with considerable caution this time around in Spelunky 2. Not only are shopkeepers tough as nails, they also have a pretty slim reaction time to any shoplifting and will come in hard. 

Also, note that many wares explode, so if you are going to start blasting (or provoke them to do so), be wary of any explosives laying around. That said, experiment, and once you get the hang of the subtleties of Spelunky combat, killing shopkeepers can be a profitable strategy indeed.

2. Make Use of the Sacrifice System!

The new Kali Altars reward you for sacrificing pets on their bloodstained pedestals with progressively better items — culminating in some excellent items like the Kapala that heals you with blood spilled by creatures.

3. Carry the Ghostpot to the Door

The Ghostpot contains a diamond worth 5K, but when you crack it open it spawns the unfriendliest ghost in the Spelunky universe that normally waits three minutes before ruining your day.

To circumvent this, carry the pot to the door to each level and crack it open right before heading out. Note that enemies and other hazards can just as easily crack it open along the way, so keep your eyes peeled. You know, more than usual.

4. There is Always a Shop on 1-2 or 1-3

Take note of the fact that there is always a shop on 1-2 or 1-3 and prepare accordingly. It’s completely randomized after that, so if you want to stock up before beginning your journey in earnest, it’s wise to either cash in a couple of diamonds or otherwise pad the wallet (or get ready to throw down with the shopkeeper for some “free” supplies).

5. Carry an Item at All Times

A good rule of thumb in Spelunky 2 is to always have an item. Anything and everything can come in handy. Even a rock. Especially a rock. You can throw items at enemies, use them to activate traps or break barricades, and generally find numerous ways to make them useful. You can’t carry bodies or large items between levels, but you can carry smaller things like rocks and arrows. This ties into our next tip:

6. Practice Throwing

Acquaint yourself with the “weight” and trajectory of thrown items in Spelunky 2. Not everything has the same throw distance or arc, so training your reflexes to account for these differences can be what keeps you alive on that glorious, personal record-breaking run.

7. Get the Udjat Eye

The Udjat Eye is nothing new to Spelunky. Like in the previous game, it grants players access to the Black Market (which is now just a sub-area, rather than its own level, and thus subject to the three-minute Ghost timer!) and reveals hidden treasure, but it is also used to unlock another secret area in one of the new biomes.

8. Use Tactical Head-Bounces

Ropes are great and all. They can be used to climb, descend safely, drop down into spikes or even be thrown at your enemies. And that’s why they should be used sparingly. A great way to reach a high ledge without using a rope when you don’t have a specialty item/mount is to hold up while bounce-killing an enemy. You can either try and time it or knock the enemy out and quickly place them where you’re going to make the jump.

9. Break Pots at a Distance

As containers, pots can be full of all sorts of wonderful items. Like gold, jewels, and venomous creatures. That last one might be more of an acquired taste. If you’re not a fan of scorpions, cobras, or even aliens, be sure to throw the pot a good distance away to break it open rather than smashing it open with your whip.

10. Don’t Free Fall

11. Turkeys Are Your Best Friend (and You Their Worst Enemy!)

Turkeys are a wonderful addition to Spelunky 2, and the first rideable mounts you’ll encounter in the game. Aside from being a huge boost to your movement dynamics, you can also be decidedly non-vegan and blow them up with a bomb or other source of fire to cook them. Cooked Turkeys increase your max HP by 1, making them worth the effort whenever an easy one comes your way.

12. Practice Cooking Bombs

Apart from learning how to throw, another key skill that veteran players of Spelunky swear by is the practice of “cooking” your bombs like a grenade. This involves dropping the bomb at your feet to start the 2.4-second timer, picking it up, and throwing it again — timing the explosion to detonate the bomb wherever you want within range.

It takes some serious practice and won’t be something you get the hang of immediately, but once you’re a well-oiled bomb-cooking machine you can basically turn any bomb into a poor man’s sticky bomb.

13. Back-whip

While whipping has been nerfed with a serious reduction in animation speed, many players might not be aware of the utility of the three-stage whip attack. The new whip attack actually strikes one tile behind and above you before striking in front of you — meaning if you really want to hit something quick, pull a trick-move and look the other way before swatting at your enemy.

14. Don’t Fear Spikes

Spikes will kill you a lot. A lot. But that doesn’t mean you have to be afraid of them. New Spelunky 2 players should note that you can actually descend safely into spikes with a rope, and actually walk into spikes from the side without a problem. The only way they kill is by falling on top of them.

15. You Can Whip Arrows (With Practice)

There are few things more annoying than Arrow Traps. Set on auto-fire, come anywhere within six tiles and you’re getting an arrow in the face. You can trigger the trap with an enemy, or a thrown item like a rock.

Even fancier, for those who don’t have anything to trigger the trap ahead of time, is to go full Geralt of Rivia and just deflect the thing with your whip. A well-timed whip will do the trick, but note that it takes practice. 

5 Spoiler-Ish Tips:

Below are a series of tips that involve some spoilers that newer players looking to organically explore the game may want to steer clear from. These involve specific discoveries that some people would rather stumble upon the old fashioned way: with a whole lot of death, despair, and eventual elation. 

1. Quillback’s Level Never Changes

2. Leprechauns Fulfill the Stereotype

A new mob, Leprechauns, can drop an item called 4-Leaf Clovers on death that sets the Ghost timer to five minutes and spawns a rainbow that can be bombed to reveal a pot of gold with a few thousand.

3. Vlad’s Got Enemies

On every 2-1 Volcana, there is a secret door that, when unlocked, reveals an imprisoned Van Horsing that will insta-kill Vlad the Vampire King for you later on if you rescue him. Just find the key, find Van Horsing, and let the geriatric vampire hunter do the rest.

4. Ghost Bling is Potent Bling

In 1-4, if you have Quillback destroy all of the bone piles (or bomb them all yourself), a secret door marked by a very faint bas relief of a Ghost’s face (same on that’s on the Ghostpot) will be revealed that can only be entered if you’re afflicted with a Curse.

As much as it sucks to be cursed, once inside you gain access to a “Ghost Shop” that contains 3 gift boxes for 20k each. The loot is completely randomized but can be as crazy as a Kapala alongside other useful loot, or something relatively mundane.

5. Most of Spelunky 2 is Almost Impossible to Reach

There is a secret after-level, called the Cosmic Ocean, that takes the powers of a demigod to reach, and the nigh-literal powers of 1.5 Gods to actually beat. If you’re interested in making the attempt, be sure to check out our complete, step-by-step walkthrough on how to reach that sacred and absolutely terrifying place.

11 Essential Digital Marketing Components You Must Know

What are the Components of Digital Marketing?

In this section, we will talk about some of the key components of digital marketing. It will help you gain a deeper understanding of this industry.

Web Advertising



Social Media Marketing

Content Marketing

Email Marketing

Mobile Marketing

Affiliate Marketing

Marketing Analytics

Programmatic Advertising

Tracking Tools

Web Advertising

Your website is the central hub of your business, allowing you to brand yourself in a way that’s meaningful to your target audience. It’s also where you can easily connect with your customers and develop a sales funnel that will allow you to turn them into buyers. Before you start creating a website, it’s important that you take the time to consider how it will look and feel. This will allow you to build a strong brand identity and attract more potential customers.

Search Engine Optimization (SEO)

Search engine optimization is a process that aims to improve the visibility of your website in search results. According to a study, 75 percent of people do not look past the first page of results when searching for a certain product or service. Having a high search ranking helps boost the number of people who are looking for your business and provides you with more opportunities to contact them. SEO professionals are very in demand; they are the person who helps improve a website’s search engine ranking. This job title also refers to the process of developing and implementing strategies that will help improve a website’s online presence.

Social Media Marketing

One of the most effective ways to boost website traffic is through social media marketing, which is a process that involves posting content on various social media platforms, such as Instagram, Twitter, and Facebook. This type of marketing can have a powerful viral effect, as it allows businesses to show their products and services to thousands of potential consumers. However, due to the increasing number of people who use these platforms, it is now more important than ever that you are very strategic with your marketing efforts.

Content Marketing

You can create and distribute various types of digital content, such as blog posts, whitepapers, and case studies, to help your target market. These can then be used to attract potential customers.

Email Marketing

One of the most effective ways to promote your business is through email marketing. It allows you to reach out to potential customers and provide them with the information they need to make informed decisions. This method can also help you build a strong relationship with your potential customers.

Mobile Marketing Affiliate Marketing

In digital marketing, affiliate marketing is a type of activity that involves selling a company’s product and then receiving a commission. This is very convenient and effective because it allows you to streamline the sales process. Just link your website to a product that you want to promote and get a commission when a customer makes a purchase.

Marketing Analytics

In addition to the various elements of digital marketing, you should also consider analytics as a vital part of your strategy. Having the necessary tools and resources to monitor and analyze your campaigns will allow you to improve the effectiveness of your marketing efforts. One of the most important factors that you can consider when it comes to improving your marketing ROI is keeping track of the performance indicators that are related to your campaigns.

Programmatic Advertising Tracking Tools Conclusion

Almost everyone is involved in some form of digital marketing activity, whether they are buyers or sellers. The scope of this industry is wide, and it has become very easy to connect with potential customers and sell goods online.

There are many aspects of digital marketing that every person should know in order to be successful online. In this article, we’ll talk about eleven of the most crucial elements. But there is more to learn in order to excel in this field.

7 Amazing Excel Custom Number Format Tricks (You Must Know)

Excel Custom Number formatting is the clothing for data in excel cells. You can dress these the way you want. All you need is a bit of know-how of how Excel Custom Number Format works.

With custom number formatting in Excel, you can change the way the values in the cells show up, but at the same time keeping the original value intact.

For example, I can make a date value show up in different Date formats, while the underlying value (the number that represents the date) would remain the same.

In this tutorial, I will cover everything about custom number format in Excel, and also show you some really useful examples that you can use in your day-to-day work.

So let’s get started!

Before I show you the awesomeness of it, let me briefly explain how custom number formatting works in Excel.

By design, Excel can accept the following four types of data in a cell:

A positive number

a negative number


Text strings (this can include pure text strings as well as alphanumeric strings)

Another data type that Excel can accept is dates, but since all date and time values are stored as numbers in Excel, these would be covered as a part of the positive number.

For any cell in a worksheet in Excel, you can specify how each of these data types should be shown in the cell.

And below is the syntax in which you can specify this format.

Note that all these are separated by semi-colons (;).

Anything that you enter in a cell in Excel would fall in either of these four categories and hence a custom format for it can be specified.

If you mention only:

One format: It is applied to all four sections. For example, if you just write General, it will be applied for all four sections.

Two formats: The first one is applied to positive numbers and zeros, and the second one is applied to negative numbers. Text format by default becomes General.

Three Formats: The first one is applied to positive numbers, the second one is applied to negative numbers, the third is applied to zero, and the text disappears as nothing is specified for text.

If you want to learn more about custom number formatting, I would highly recommend the Office Help section.

How this works and where to enter these formats are covered later in this tutorial. For now, just keep in mind that this is the syntax for the format for any cell

Then you open a new Excel workbook, by default all the cells in all the worksheets in that workbook have the General format where:

Positive numbers are shown as is (aligned to the left)

Negative numbers are shown with a minus sign (and aligned to the left)

Zero is shown as 0 (and aligned to the left)

Text is shown as is (aligned to the right)

And in case you enter a date, it’s shown based on your regional setting (in DD-MM-YYYY or MM-DD-YYYY format).

So by default, the cell’s number formatting is:


Where each data type is formatted as General (and follow the rules I mentioned above, based on whether it’s a positive number, negative number, 0, or text)

Now the default setting is alright, but how do you change the format. For example, if I want my negative numbers to show up in red color or I want my dates to show up in a specific format then how do I do that.

You can find some of the commonly used number formats in the Home tab within the Number group.

It’s a drop-down that shows many of the commonly used formats that you can apply to a cell by simply selecting the cell and then selecting the format from this list.

For example, if you want to convert numbers into percentages or converted dates into short date format or long-form date format, then you can easily do it by using the options in the dropdown.

Format cells dialog boxes where you get the maximum flexibility when it comes to applying formats to a cell in Excel.

It already has a lot of premade formats that you can use, or if you want to create your own custom number format, then you can do that as well.

Here is how to open the Format Cells dialog box;

This will open the Format Cells dialog box. Within it, you will find all the formats in the Number tab (along with the option to create Custom cell formats)

You can also use the following keyboard shortcut to open the format cells dialog box:

CONTROL + 1 (all the Control key and then press the 1 key).

In case you’re using Mac, you can use CMD + 1

Now let’s have a couple of practical examples where we will create our own custom number formats.

Also read: Cell References in Excel (Absolute, Relative, and Mixed)

Now let’s have a couple of practical examples where we will create our own custom number formats.

Sometimes, you may have a need to hide the content of the cell (without hiding the row or column that has the cell).

A practical case of this is when you are creating an Excel dashboard and there are a couple of values that you use in the dashboard but you do not want the users to see it. so you can simply hide these values

Suppose you have a dataset as shown below and you want to hide all the numeric values:

Here is how to do this using custom formatting in Excel:

Select the cell or the range of cells for which you want to hide the cell content

Open the Format Cells dialog box (keyboard shortcut Control + 1)

Enter the following format in the Type field: ;;;

How does this work?

The format for four different types of data types is divided by semicolons in the following format:

In this technique, we have removed the format and only specified the semicolon, which indicates that we do not want any formatting for the cells. This is an indication for Excel to hide any content that is there in the cell.

Note that while this hides the content of the cell, it’s still there. so if you have numbers that you have hidden, you can still use these in calculations (which makes this a great trick for Excel dashboards and reports).

By default, negative numbers show up with a minus sign (or within parenthesis in some regional settings).

You can use custom number formatting to change the color of the negative numbers and make them show up in red color.

Suppose you have a dataset as shown below and you want to highlight all the negative values in red color.

Below are the steps to do this:

Select the range of cells where you want to show negative numbers in red

Open the Format Cells dialog box (keyboard shortcut Control + 1)

Enter the following format in the Type field:


The above format will make your cells with negative values show in red color.

How does this work?

When you only specify two formats as the custom number format, the first one is considered for positive numbers and 0, and the second one is considered for negative numbers (the next value by default becomes the general format).

In the above format that we have used, we have specified the color that we want that format to take up in the square brackets.

So while the negative numbers take the general format, they are shown in red color with a minus sign.

In case you want to make the negative numbers stop in red color within parenthesis (instead of the minus sign), you can use the below format:


One amazing thing about custom number formatting is that you can add a prefix or a suffix text to a number, while still keeping the original number in the cell.

For example, I can have ‘100’ show up as ‘$100 Million’, while still having the original value in the cell so that I can use it in calculations.

Suppose you have a dataset as shown below and you want to show these numbers with a dollar sign and the word million in front of it.

Below are the steps to do this:

Select the dataset where you want to add the text to the numbers

Open the Format Cells dialog box (keyboard shortcut Control + 1)

Enter the following format in the Type field:

$General "Million"

Note that this custom number format will only affect numbers. If you enter text in the same cell, it would appear as it is.

How does this work?

In this example, to the general format, I have added the word million in double-quotes. anything that I add in double-quotes to the format is shown as is in the cell.

I also added the dollar sign before the general format so that all my numbers also show the dollar sign before the number.

Note: If you’re wondering why the dollar sign is not in double-quotes while the word Million is in double-quotes, it’s because Excel recognizes dollar as a symbol that is often used in custom number formatting, and doesn’t require you to add double quotes to it. You can go ahead and add double quotes to the dollar sign, but when you close the format cells dialog box and open it again, you will notice that Excel has removed it

Also read: Format Numbers to Show in Millions in Excel

With custom number formatting, you can assess a maximum of two conditions, and based on these conditions you can apply a format to the cell.

For example, suppose you have a list of scores for some students, you want to show the text Pass or Fail based on the score (where any score less than 35 should show ‘Fail’, else it should show ‘Pass’.

Below are the steps to show scores as Pass or Fail instead of the value using custom number format:

Select the dataset where you have the scores

Open the Format Cells dialog box (keyboard shortcut Control + 1)

Enter the following format in the Type field: [<35]"Fail";"Pass"

Below is how your data would look after you have applied the above format.

Note that it does not change the value in the cells. The cell continues to have the scores in numeric values while displaying ‘Pass’ or ‘Fail’ depending on the cell value.

How does this work?

In this example, the condition needs to be specified within the square brackets. custom number formatting then evaluates the value in the cell and applies the format accordingly.

So if the value in the cell is less than 35, then the number is hidden, and instead the text ‘Fail’ is shown, adding all other cases, ‘Pass’ is shown.

Similarly, if you want to convert a range of cells that have 0’s and 1’s into TRUEs and FALSEs, you can use the below format:


Remember that you can only use two conditions in custom number formatting. If you try and use more than two conditions, it is going to so your prompt letting you know that it cannot accept that format.

Sometimes, when you download your data from databases since there are empty are filled with value such as Not Available or NA or –

With custom number formatting, you can hide all the text values while keeping the numbers as is. this also ensures that your original data is intact (as you are not deleting the text value, you’re just simply hiding it)

Suppose you have a data set as shown below where you want to hide all the text values:

Below are the steps to do this:

Select the dataset where you have the data

Open the Format Cells dialog box (keyboard shortcut Control + 1)

Enter the following format in the Type field:

General; -General; General;

Note that I have used the General format for numbers. You can any format you wish (such as 0, 0.#, #0.0%). Also, note that there is a negative sign (-) before the second General format, as it represents the format for negative numbers.

How does this work?

In this example, since we wanted to hide all the text values, we simply didn’t specify the format for it.

And since we specified the format for the other three data types (positive number, negative number, and zero), Excel understood that we have purposefully left the format for the text value empty, and it should not show anything if a cell has a text string.

With custom number formatting, you can also change the numbers and make them show up in percentages.

Suppose you have a data set as shown below, and you want to convert these numbers to show the equivalent percentage value:

Below are the steps to do this:

Select the cells where you have the numbers (that you want to convert to percentage)

Open the Format Cells dialog box (keyboard shortcut Control + 1)

Enter the following format in the Type field:


This will change the numbers to their percentages. For example, it changes from 0.11 to 11%.

If all you want to do is converted a number into its equivalent percentage value, a better way to do this would be to use the percentage option in the format cells dialog box.

Where custom formatting can be useful is when you want more control over how you want to show the percentage value.

For example, if you want to show some additional text with the percentage, all you want to show negative percentages in red color then it is better to use custom formatting

If you work with large numbers, you may want to show these in a different unit. for example, if you have the sales data of some companies, you may want to show the sales in millions or billions (while still keeping the original sale value in the cells)

Thankfully, you can easily do that with custom number formatting.

Suppose you have a data set as shown below, and you want to show these sales values in millions.

Below are the steps to do this:

Select the cells where you have the numbers

Open the Format Cells dialog box (keyboard shortcut Control + 1)

Enter the following format in the Type field:


The above would give you the result as shown below (values in millions in one digit after the decimal):

How does this work?

In the above format, a zero before the decimal indicates that Excel should show the entire number (exactly as it is in the cell), and a 0 after the decimal indicates that it should show only one significant digit after the decimal point.

So 0.0 would always be a number with one digit after the decimal point.

When you add a comma after the 0.0, it will shave off the last three-digit of the number. For example, 123456 would become 123.4 (the last three digits are removed, and since it has to show 1 digit after the decimal point, it shows 4)

If you think about it, it’s similar to dividing the number by 1000. So if you want to show a number in the ‘millions’ unit, you need to add 2 commas, so that it would shave off the last 6 digits.

And if you also want to show the word million or the alphabet M after the number, use the below format

0.0,, "M"

You May Also Like the Following Excel Tutorials:

9 Android Lollipop Tricks That You Should Know

Android 5.0 Lollipop is by far the biggest change made to Android since its inception. It came up with a visual overhaul in the form of Material Design which is Google’s attempt to unify the design and experience across all its products. While the visual changes were the most noticeable, Google also made a number of internal improvements within the platform like project Volta for battery optimization and making Android ready for x64 based SoCs.

9 Best Android 5.0 Lollipop Tricks You didn’t Know 1. Lollipop Easter egg

We all love the Easter eggs in each revision of Android, and that goes the same for Lollipop. Head over to the Settings app and tap on About Phone.Tap multiple times on the Android Version number. You’ll be greeted as expected, by a Lollipop.

Tap on it a few more times and now you’re playing Flappy Android? We all loved Flappy bird so much that Google baked it right into the system.

2. Search Within Settings

This was a feature that was long overdue. While Android is pretty straight forward with its offerings, it can become a little overwhelming for new users to get around it, especially the settings app. Some of the most essential configurations might sometimes get buried in the endless options, and it’s frustrating to find them, well that changes with Lollipop. You can directly hit the search icon to look for the options within the settings app.

3. Built in Flashlight

Before Lollipop, you needed to install a third party flashlight app, now you don’t. You get access to the flashlight toggle right from the quick settings.

4. Guest Accounts

5. Customize Notifications

Notifications aren’t something new to Android. But on Lollipop, notifications are supercharged. On lollipop you get the notifications right on to your lock screen and you can even see the contents of the notifications from the lock screen itself. You can act upon them by double tapping them or dismiss them by swiping them away. But sometimes you do not want crucial messages or emails to appear on the lock screen in that case you can head over to Settings and tap on Sounds & notification and tap on When device is locked and tap on Hide sensitive notification content. On enabling the option”Hide sensitive notification content”, your notification contents will now remain hidden.

Apart from that, you can also change the notification permissions on a per-app basis. Tap on App Notifications and then tap on the app whose notifications priority you want to edit, and you can either block notifications completely or prioritize them, so that they are always on top.

6. Screen Pinning

It’s a common scenario while using your Android phone. You might be enjoying your favorite YouTube clip and you accidentally touch the home button and your experience is interrupted. To avoid this, the screen pinning feature comes into play.

Go to the Settings and tap on Security. Turn on Screen Pinning. Now, tap on the recent apps button and you see a Pin icon on the bottom. Tap on it and now no matter what you touch, the screen remains pinned to the Display, avoiding accidental interaction.

7. Priority Notifications

On updating to Lollipop the first new addition that you might have come across on the volume slider is “priority notifications”. It acts as a “Do not disturb” mode for android which is like Google’s Implementation of Motorola Alert which either temporarily disables all the notifications or allows only your starred contacts to get past it.

In simple words, on priority mode your phone will buzz/ring only when a specified (starred) contact pings you, in all other situations, it will remain silent. If you happen to select “None”, you won’t get any notifications whatsoever,“Even for your alarms”.

8. Inbuilt Battery Saver

9. Smart Lock

On an average a typical Android user unlocks his device around 110 times a day. While this offers security but it wastes a lot of time. The smart lock feature on Lollipop detects if the phone’s in your pocket or your bag and keeps it unlocked for you. It does so by using the accelerometer. Once you set it down and device is not moving it locks down again. Same goes if it’s connected to a trusted Bluetooth device, as long as your device is connected to your smartwatch or your PC (a trusted device) the lock screen will be disabled and when its not connected, it will be re-enabled.

SEE ALSO: How To Play Android Games on PC

Useful Whatsapp Tips And Tricks That You Should Know

No matter how religiously you use a particular app, there are always certain features that you might not know about the app. Same is the case with the celebrated app, WhatsApp. WhatsApp is loaded with a bunch of features and settings that although clearly visible, might not have attracted your attention. Because who has the time to go through all the lavish settings.

Stay updated with all the new feature of WhatsApp

Umm, we do. 🙂 We checked every nook and corner of WhatsApp Android app and made it easy for you to enjoy the beauty of WhatsApp. So, here we present to you an assortment of WhatsApp tips and tricks for Android.

Let’s go!

Customize to your heart’s content

Change the color of an emoji

Emojis are meant to be fun and expressive, not bland and restrictive — that typical emoji-yellow isn’t really flattering. Thankfully, WhatsApp lets you express your colors, without any hassle, whenever you feel like it. Please note that you cannot change the color of the emojis in regular chats; the rules only apply to images you send/forward and status updates. 

Step 1: Open the image you want to send/set as your status — we’ll use the latter to demonstrate.

Step 2: Tap on the emoji button and take your pick.

Step 3: Once the emoji pops up on the screen, run your finger over the slider.

Step 4: Once satisfied, just move your finger from the slider and hit send.

Step 5: Similarly, if you’re looking to add a speech bubble, adjust the slider to change the color.

Additionally, you could rotate the bubble with two fingers to rotate the direction of the arrow.

Change font color and style of text

If you thought changing the color of emojis was fun, you’re going to be thrilled to see the things you can do to texts. Not only can you change the color of texts, but you can also tweak the style of the texts. Once again, these customizations aren’t applicable to regular chats and are for texts on forwarded/uploaded images and status updates.

Step 1: Open the image you want to send/set as your status — we’ll use the latter to demonstrate.

Step 2: Tap on the text button and write something.

Step 3: Change the color by adjusting the adjacent slider.

Step 4: Now, to change the style of the text, press and hold the slide and drag across your screen. You’ll get three different font styles — apart from the default — to choose from. Let go of the slider to finalize your selection.

Tune WhatsApp sounds and notifications

Turn off conversation tones

There is a reason why this tip gets the number one rank. However, other tips are not in any particular order.

Okay dear WhatsApp users, you must have noticed that during an ongoing chat there is an annoying sound that plays while sending and receiving messages. Well, you can turn that off. I repeat, YOU CAN TURN THAT OFF. And you should. Please!

Also read: 8 cool new WhatsApp Status Tips and Tricks

To turn off conversation tones, follow the steps:

Open WhatsApp messenger and tap the three vertical dots in the top right corner.

Select “Settings” from the menu and then tap “Notifications”.

Uncheck the “Conversation tones” to disable the sound for incoming and outgoing messages.

The steps are facile, so no excuse.  😛

Keep separate tone for individual chats and groups

By default, both group notifications and individual chat notifications have same tone on WhatsApp. If you are like me, who likes to differentiate between the two incoming notifications using their tone, you should keep a different tone for group and individual chats. And thankfully, WhatsApp allows you to do that.

To keep separate tone for WhatsApp chats and groups, follow the steps:

Open WhatsApp messenger and tap the three vertical dots in the top right corner.

Select “Settings” from the menu and then tap “Notifications”.

Change the tone for individual chats in “Notification tone” under Message notifications and for group chats, change the tone in “Notification tone” under Group notifications.

Similar to custom ringtones on your device, WhatsApp lets you keep separate notification tone for each of your contacts. You can keep custom tone for as many contacts as you want. Moreover, you can set custom notifications for different groups as well.

Also read:  A beginners guide to the WhatsApp status.

To set custom notifications, follow the steps:

Open the individual WhatsApp chat thread and tap the three vertical dots in the top right corner.

Select “View contact” from the menu and then tap “Custom Notifications”.

Enable “Use custom notifications”  and change the notification settings as per your liking.

You can change notification tone, ringtone, vibration, light and even popup notification in the setting.

Psst. To keep custom tone for a group, follow same steps for groups as well.

Reset notifications

After fiddling with notification settings of WhatsApp, if you are not satisfied with the result and want to return to the default notifications, you can do that by following the steps given below.

Open WhatsApp messenger and tap the three vertical dots in the top right corner.

Select “Settings” from the menu and then tap “Notifications”.

Tap the three vertical dots in the top right corner and hit “Reset notification settings”.

All your WhatsApp notification settings shall return to the default values.

Bothered by annoying people on WhatsApp? Well, just mute them! If you don’t want to receive notifications from a particular individual and block is not an option for you, try muting them. Similarly, if you are part of good-for-nothing WhatsApp groups and can’t exit from them, “Mute” might be your savior.

Also read: Facebook Stories: 7 tips and tricks you should use

To mute a conversation, follow the steps:

Open an individual or the group chat that you want to mute.

Tap the three vertical dots in the top right corner and hit “Mute”.  You will be asked to select the time period for which you want to mute the conversation. Select the time and tap Ok.

Alternatively, long touch an individual or a group chat thread under the “chats” on WhatsApp home screen and tap the speaker icon with a line on it to mute the conversation.

To unmute an individual or a group chat, repeat the steps in any of the two methods.

However, if you can’t take it anymore and would prefer to block the contact, follow the steps:

Open the chat thread that you want to block.

Tap the three vertical dots in the top right corner and hit “More”.

Tap “Block” from the menu.

Keep in mind: You cannot block a group, you can only exit from a group.

Download and send WhatsApp stickers

How to get WhatsApp stickers

WhatsApp released the ‘Stickers’ feature last year which gave users another way of interacting with friends and family. WhatsApp stickers are pretty cool and you can send stickers exactly as you would on Facebook Messenger.

Well, to use WhatsApp stickers, you’d first have to update your WhatsApp application if you haven’t yet updated the app since a few months.

Also read: WhatsApp stickers: How to use and everything you need to know

Sending WhatsApp stickers

Sending these cool stickers is pretty easy and there are a few pre-included stickers for you to quickly send.

Open up the chat to which you want to send the stickers in.

Next, tap on the Emoji button in the Type a message field.

Then tap on the Sticker icon which would be the icon on the right of the GIF icon.

From here, you would be able to see all your installed stickers on the device.

Simply tap on the sticker you want to send and it would be sent just like any other message.

Animated Sticker Previews

Though this feature has not been enabled as of yet, WhatsApp has been working on this upgrade for a while and we can hopefully expect an update soon. Once WhatsApp releases the update you will be able to preview the sticker from the notification panel of your phone. So keep your WhatsApp updates and stay tuned for this cool upgrade!

Play around with WhatsApp messages

Format your messages

WhatsApp allows you to format your text using simple formatting methods such as bold, italic and strikethrough. The feature was introduced a while ago and lets you bold, italicize or strikethrough any part or the entire text. In addition to these, you can even change the font of the text to Monospace.

Also read: Facebook app: Tips and tricks you should know

However, to utilize this gift you have to add few characters before and after the text i.e. you have to enclose your text within the characters. Hence, you need to remember the characters, which are as follows:

Bold: Add * before and after the text that you want to make bold. Example *Android Soul*

Italic: Add _ before and after the text that you want to italicize. Example _ Android Soul_

Strikethrough: To add a strikethrough, enclose the text in ~ Example ~Android Soul~

Monospace: To change the font to monospace, enclose the text in ` ` ` . Example ` ` `Android Soul` ` `. Yes, the character ` should be written thrice on either side.

Psst.. Soon, you won’t need to remember the characters as WhatsApp will allow you to format the text with the help of buttons. This feature was recently seen in the WhatsApp Beta and soon it will be live for everyone.

Change WhatsApp font size

Whether you are fond of large text or small text, WhatsApp offers you an option to change the size of the text in the conversations.

To do so, follow the steps:

Open WhatsApp messenger and tap the three vertical dots in the top right corner.

Select “Settings” from the menu and then tap “Chats”.

Tap “Font size” and from the popup menu select the font size that you want to use.

Bookmark messages or mark messages as favorite

As is evident from the title, you can mark messages as favorite to access them later. In WhatsApp terminology, the feature is known as “star”. For instance, during a group chat, if a person mentions something important that you might need in future, you don’t have to read the entire thread to find that particular text, you can “star” the message and later when you need it, same will be available under the “starred messages”.

Also read: Facebook Messenger: Tips and Tricks

To retrieve the starred messages, open WhatsApp messenger and tap the three vertical dots in the top right corner. Select “Starred messages” from the menu.

Search for a particular message

Apparently many people don’t know that “search” in WhatsApp not only allows you to search for contacts, but you can also search for messages on WhatsApp. Meaning, WhatsApp messages are searchable. You can search for a particular text, no matter how old it is, or in which thread it is present.

Moreover, you can even search for a text separately in an individual conversation or a group chat.

To search a text from entire WhatsApp history, tap the magnifying icon in the top bar and enter your search term. You can even search for contact names and group name in this search.

To search a text in an individual chat or a group conversation, open the chat thread and tap the three vertical dots in the top right corner followed by selecting “Search” from the menu. Use the arrow keys to move to the next word.

Quote messages

Also read: Top 10 Snapchat tips and tricks

Tag people

This feature works only in group conversations, primarily because why would anyone want to tag a person in individual chats.

To tag people in group conversations, type @ and then select the contact that you want to tag. Other than the group notifications, they will be notified separately that you have tagged them.

Mark messages as unread

Consider the scenario; you are busy and unable to reply to the not-so-important messages. You keep them unread with the hope that you will reply later. But suppose while replying to an important message on WhatsApp you accidently open one of the unread messages.

Also read: Instagram guide and tips for beginners

Now, both you and I know that if you don’t reply to the message at that moment, you will never reply eventually. So to be on the safer side, it’s better to mark the messages as unread and set a visual reminder so that later when you are free, you can reply to the messages.

To mark messages as unread, follow the steps:

Long press the individual chat thread on the WhatsApp home screen.

Tap the three vertical dots in the top right corner and select “Mark as unread” from the menu.

Keep in mind: Even if you mark the message as unread after reading it, the other person will still get blue ticks and read receipts.

Find the exact time when your message was read

Particularly useful in group conversations but works in individual chats as well, the feature allows you to know the exact time when your message was delivered and when the other person read it.

Put your detective cap on and let’s crack the case.

Also read: Instagram tips and tricks using 3rd party apps

To find out the exact time when your message was read, long press/touch the sent message from your side and then tap the information icon (i) in the top bar. Ta-da! You will see a detailed log, with the time when the message was read. Tap the contact name to view “delivered” time.

Broadcast messages / Send a message to multiple people

Do you want to send a message to multiple people at the same time? Say hi to broadcasts. Instead of creating a group, you can send messages to multiple people using broadcasts. The message is delivered to individual chat thread and even the replies are sent only to the sender.

To send a broadcast, follow the steps:

Open WhatsApp messenger and tap the three vertical dots in the top right corner.

Select “New broadcast” from the menu.

Select the contacts to whom you want to send the broadcast and then enter your message.

This little paragraph doesn’t do justice to the amazing feature of broadcast. Hence, here is a detailed guide on how to use WhatsApp broadcast.

Strike gold with privacy

Blue ticks ruining relationships since forever. The only reason that justifies the presence of blue ticks and read receipts on social media can be the cycle that it creates. Once your relationship is destroyed, you come back to social media to whine about it, you make new friends and blue ticks again kill the relationship, hence the cycle continues.

Also read: Snapchat features borrowed by Facebook, WhatsApp and Instagram

There is a simple solution to save you from the mental torture and that is to properly configure the WhatsApp privacy settings.

Hide WhatsApp last seen

WhatsApp gives you three privacy options for your last seen: Everyone, your contacts, and Nobody. Everyone means all the people who have saved your number in their address book can see your last seen irrespective of whether you have saved their number or not. My contacts means only the people who are in your address book can see your last seen (if your number is saved with them as well). Lastly, Nobody means no one can see your last seen, be it your contacts or others. Last seen will be completely hidden.

There is a twist in the tale, if you keep the privacy setting to “nobody”, then you also won’t be able to view others last seen. So, basically, if you want to remove last seen for a particular person, keep the setting to “My contacts” and remove them from your contact. You are welcome. 🙂

To change the last seen setting, follow the steps:

Open WhatsApp messenger and tap the three vertical dots in the top right corner.

Select “Settings” from the menu and then tap “Account”, followed by “Privacy”.

Tap “Last seen”, and choose the option – Everyone, My contacts, Nobody, as per your need.

Turn off blue ticks and hide read receipts

Similar to last seen, blue ticks are annoying and that too on another level. You can turn off blue ticks and hide read timestamp so that when you read the message, other people will only see gray double ticks and not blue ticks. Also, no time will be shown on the “read” receipt.

Also read: Google Assistant Tips and Tricks.

However, again similar to last seen, if you turn off the read receipt, you won’t be able to see double ticks and read receipt.

To turn off read receipt, follow the steps:

Open WhatsApp messenger and tap the three vertical dots in the top right corner.

Select “Settings” from the menu and then tap “Account”, followed by “Privacy”.

Turn off “Read receipts”.

Bonus tip: Turning off the read receipts also comes handy if you want to check new WhatsApp status secretly, without letting other people know about it.

Moreover, you can similarly configure privacy for your profile photo, About and the new WhatsApp status in the privacy setting of WhatsApp.

Hide notifications from lock screen

There is no direct way to hide WhatsApp notification content from the lock screen. However, there is a simple trick, not even a trick, but Android functionality that permits you to hide notification content.

To prevent your messages from being read by people, you will have to disable the lock screen notifications. And to do so, follow the steps:

Open Android device settings.

Go to “Apps/Application Manager” followed by “WhatsApp”.

Tap “Notifications”.

Enable “Hide notifications on lock screen”. This setting is known by different names on different devices. But, it would have “lock screen” in the name, so look for the same. That rhymes. 🙂

Anyway, doing this will hide the content of WhatsApp notifications from your lock screen.

Hide chats from appearing under conversation list

Many times, we don’t want to delete a chat but neither like its presence under the conversation list. So what should we do under the circumstances?

Also read: Cool hidden features of your Android device

A nifty feature “Archive chat” comes to the rescue. By archiving a chat, although, you remove it from blatant conversation list, the same lives happily under the “archive chats” where nobody sees it.

To archive a chat, follow the steps:

Long touch the conversation thread that you want to archive or hide from appearing under chats.

Tap the archive icon present in the top bar to archive the chat.

To view archived chats, scroll down to the end of conversation list and tap “archived chats”.

When you receive a message from an archived chat thread, it will be removed from the archived chats automatically and will appear under the conversation list.

Time-saving shortcuts and settings

Add chat shortcut on home screen

Do you regularly chat with a person or a group? Make your life easy by adding the chat shortcut on your home screen.

To do so, follow the steps:

Open WhatsApp messenger and long touch the conversation chat thread under “Chats”.

Tap the three vertical dots in the top right corner and select “Add chat shortcut” from the menu.

A shortcut for the chat is created on your home screen, as you can see in the above screenshot.

Pin conversations

If you are not fond of adding shortcuts to your home screen, don’t worry. WhatsApp has another built-in feature that will make your life easy in this busy world. We are talking about conversation pinning. With chat pinning, you can pin up to 3 chats to the top of your WhatsApp chat list.

Even if you get a new message from a contact other than the pinned contact/group, the pinned chat will not go down the chat list, it will remain at its current top position. Chat pinning is indeed very helpful and one never misses a message from favorite pinned groups and contacts.

To pin a chat to the top, long touch the chat and tap the pin icon in the top bar. To unpin a chat, again long press the chat and tap the unpin icon.

Send multiple photos on WhatsApp

If you want to share pictures taken at a wedding, party or any other event with your WhatsApp friend or a group, you don’t need to send it one by one, WhatsApp bestows the favor to send multiple photos to a particular chat/group in one go.

Also read: Best pre-installed Android widgets that you should know about

There are two methods to do so.

First Method:

Open the chat/group thread with whom you want to share multiple photos.

Tap the attachment icon and select gallery from the popup menu.

Tap one of the photos that you want to send.

You will see a white add icon in the bottom left corner. Tap it to select multiple photos and finally tap Send.

Second Method

Open the chat/group thread with whom you want to share multiple photos.

Tap the attachment icon and select gallery from the popup menu.

In the top right corner, tap the multiple selection icon.

Tap and select your photos and press OK.

Send the photos.

Shortcut: Alternatively, instead of tapping a photo once in the gallery, long touch a photo that you want to send, you will see “1 selected” in the top bar. Tap other photos that you want to send and with each tap, the count for “selected” will change. Hit OK when you are done selecting the pictures and tap send.

Moreover, if you want to send multiple photos to multiple people in one go, use the Broadcast feature of WhatsApp.

Send recent photos with one tap

The default method to send recent photo continues to be via the “Attachment option” – tap the attachment button – select gallery -open the album and choose your photo. However, there is a very simple shortcut to send recent photos without all the hullabulla.

Also read:How to scan documents using Android phone and store them online for easy access.

And that happens to be the camera icon on the right side of the typing area. Tap it and you will see recent photos in the bottom scroll. Tap the photo and send it. However, you can only send one photo at a time by this method.

Further, if you want, you can even write on the photos, and that results in our next tip.

Write on WhatsApp photos

Whether you want to write on new photos or photos present in your gallery, WhatsApp caters to both. This is extremely helpful when you want to mark something on your photo. Moreover, you can even add stickers and colorful text to your photos.

To write on photos, once you select the photo from the gallery or capture a new photo from WhatsApp camera, you will get three options in the top bar – Sticker, text, and doodle. Use them as per your wish and beautify your photos.

Change WhatsApp number on your device without deleting chats and other settings

WhatsApp makes it very easy to switch numbers on the same device. All your chats, group conversations, and settings will remain untouched. Although group conversations that you are a part of will be notified that you have changed the number to so and so, individual conversations will not have the slightest idea until you personally text them.

Also read: How to backup your Android Phone

To change WhatsApp number, follow the steps:

Open WhatsApp messenger and tap the three vertical dots in the top right corner.

Select “Settings” from the menu and then tap “Account”.

Tap “Change number” and hit “Next” in the top bar.

Enter your old and new number to receive the OTP on the new number.

After verification, WhatApp will be active on your new number, with all your old chats intact.

WhatsApp add-ons

Use WhatsApp in a web browser

Working on your laptop and don’t want to constantly use the mobile phone to chat on WhatsApp? Say hi to WhatsApp web. With WhatsApp web, you can chat with your WhatsApp buddies through any web browser. All you need to do is scan the QR code from your mobile phone and connect the two.

Also read: How to record video of screen on Android

Here are the steps to use WhatsApp in a browser

Open chúng tôi on your laptop browser.

Open WhatsApp messenger on your phone and tap the three vertical dots in the top right corner.

Select “WhatsApp web” from the menu.

Scan the code available on your laptop browser using the phone camera.

That’s it. All your chats will now be available on your laptop browser.

There is a WhatsApp desktop client for both Windows and Mac that you can download from here.

Move your WhatsApp conversations with you while switching phones

Got a new phone? Congrats 😉

But wondering how to move WhatsApp conversations from the old device to the new one? There is an extremely easy way to do that with Google Drive. All you need to do is backup your conversations to Google drive from your old device and then they will be accessible from your new device as well.

Here’s what you need to do:

Open WhatsApp messenger on your old phone and tap the three vertical dots in the top right corner.

Select “Settings” from the menu and then tap “Chats”.

Tap “Chat backup” and under “Back up to Google Drive” select any of the time-period that you like. If you want to immediately move the conversations, hit “Only when I tap Backup” followed by selecting your Google drive account.

Tap “Backup” on the chat backup screen.

On the new device register with your number and you will be prompted about the Google Drive backup. Select the same Drive account to which you saved your backup and voila all your old conversations will now be on your new device, including media files.

Also read: How to detect when your Android device is being stolen?

Be among the first ones to get new WhatsApp features using WhatsApp Beta

WhatsApp Beta program, like any other Beta (pre-release version), is essentially used to gather feedback regarding new features before they are made public. However, you can use the same program to get all the new features before others.

To enroll into WhatsApp Beta, open WhatsApp in Play store and scroll down to find “Become a beta tester”. Tap “I’m in” option. And you are a Beta tester now.

Keep in mind: You will get frequent WhatsApp updates.

Create GIFs in WhatsApp

Love GIFs? Want to create your own GIFs from WhatsApp videos? You can do so. WhatsApp provides you a built-in feature to create GIFs.

Also read: How to create text GIFS on Android

To do so, open the video in video editor of WhatsApp, decrease the time limit of video to 6 or less than 6 seconds, you will see the camcorder icon in the top right corner changes to GIF. Tap it to create the GIF. Here is a detailed guide on how to create GIFs in WhatsApp.

                                 Boost your security

If you don’t mind frequent updates and a few rogue bugs here and there, becoming a WhatsApp beta tester is the best way to ensure you get the latest updates before anyone else. The Facebook-owned app has started rolling out an update for the beta version of the app. Dubbed as version 2.19.221, the update introduces fingerprint unlocking to Android devices.

There’s an option to tweak the amount of time your authentication stays valid, while a toggle has been added to hide sender info and chat content in the Notification Shade.

Miscellaneous tips

Share To Facebook

Have put up something cool as your WhatsApp status, the beta version of the app allows you to share the update directly to Facebook. If you have the Facebook app up and running on your smartphone, you’ll have an Add to Facebook Story option just under your WhatsApp status update.

Every one of us has at least a couple of WhatsApp contacts who abuse the status feature by adding way too many photos. The stable version of the app has an option to mute updates, but there’s no way to hide them for good.

Thankfully, we know for certain that the company is working on hiding muted updates, as it has already been made available on the beta version.

Quick Media Edit

If you are enrolled in the WhatsApp beta program, you can edit incoming/outgoing media files quite effortlessly.

Here’s how to:

Step 1. Tap on the incoming/outgoing file you want to edit.

Step 2. Tap the three-dot icon.

Step 3. Tap Edit.

It’s to be noted that the edited image doesn’t replace the original one and will be sent out as a copy.

Read deleted messages

WhatsApp released a cool new feature which basically lets users delete a sent message before a fixed time limit. However, there’s a way to read a deleted WhatsApp message if the message came as a notification on your device.

If you’re interested in figuring out how to read deleted WhatsApp messages on your Android device, then here’s how to do so.

Download and install any notification logging application from the Google Play Store.

We recommend using the

Notification History Log

app although any app which saves notifications should do the trick


Once you’ve installed the notification logging application, whenever you receive any message notification on WhatsApp, the message would

be saved

on the Notification logging application


In case the sender deletes the message from WhatsApp, you would still be able to read the message via the Notification logging application


Share any type of file

Did you know you could share any type of via WhatsApp and more


, if you want to share images without WhatsApp’s compression, then we’d suggest sending images using this cool trick


Open the persons chat to whom you wish to send the files.

Tap on the attachment icon and then tap on Document.

Next, tap on Browse other docs… and select the file which you want to send.

Swipe in from the left to select the category of files you want to send. You could even share files stored in your Google Drive.

Listen to a voice recordings via the earpiece

At times,

we might

not have access to earphones/headphones

in order to

listen to a voice message since it might be something you wouldn’t want people around you to hear



, the app’s got you covered.

There’s a nifty little trick within WhatsApp that lets you listen to a voice message via the earpiece hence you won’t have to worry about eavesdroppers


The only thing you need to do is play the recording and bring the phone to your ears.

That’s all.

It’s as simple as taking a call is and you would be able to hear the voice recording via the earpiece rather than the device’s speaker


Add multiple administrators to WhatsApp groups

Be default, a person who creates a WhatsApp group is the admin of the group. However, the admin can bestow the “admin powers” on others as well by making them the admin of the group. The new admins also enjoy the same powers that are available with the original admin.

To add an admin, follow the steps:

Open the group chat and tap the three dots in the top right corner.

Tap “Group info”.

Under the participants, long touch the participant that you want to make an admin. From the popup menu select “Make group admin”.

Repeat the procedure if you want to add more admins.

Free up device storage by deleting media sent via WhatsApp

WhatsApp creates a copy of every media file that you send via the platform. Meaning, even if you send a photo, video, GIF, audio, or a document that already exists on your device, WhastApp will create a copy and save it in its own folder, thus taking up device storage.

Also read: How to sync a local folder with Google Drive on your Android device

The media files under “sent” are not visible in your gallery, so basically, a person doesn’t know that this even exists. Moreover, even if you “clear” the chat, sent media files will remain intact.

Hence, if you want to free/clean up device storage, follow the steps to delete sent media files from WhatsApp:

Open the device file manager.

Navigate to “WhatsApp” folder.

Tap “Media”.

Under each of the folders; WhatsApp Images, WhatsApp Animated Gifs, WhatsApp video, WhatsApp documents and WhatsApp audio you will find a folder “Sent”. Tap “Sent” folder and delete all the content.

View WhatsApp usage

Are you interested in finding out how many WhatsApp messages you have sent or received? If yes, that’s possible with the help of “Network usage” stats in WhatsApp. In addition to listing the number of sent and received messages, it also lists other figures such as media bytes sent/received, number of outgoing calls, status bytes etc.

To view your WhatsApp network usage, follow the steps:

Open WhatsApp messenger and tap the three vertical dots in the top right corner.

Select “Settings” from the menu and then tap “Data usage”.

Tap “Network usage” to view the detailed stats.

Check if WhatsApp is connected or not

To make sure, if WhatsApp is properly running on your device, you can use the built-in WhatsApp feature to check the connectivity status.

Also read: Best Android icon packs that you should try

To do so, follow the steps:

Open WhatsApp messenger and tap the three vertical dots in the top right corner.

Select “Settings” from the menu and then tap “Help”.

Under help, tap “System status”.

You will get a message informing you if WhatsApp is operating normally or not.

Cast a spell with WhatsApp tricks

Read WhatsApp messages without giving “Read” receipts or blue ticks

In one of the tips, we have already mentioned how to turn off the read receipts and blue ticks. But the tip has a drawback, it applies to everyone i.e nobody will be able to see your read receipts, moreover, even you lose the ability to see when your own sent messages have been read.

There are two tricks, which help you dodge blue ticks for a particular person or for that matter, everybody, without you losing the ability to see read receipts.

Also read: Are you a parent of a toddler? Here’s how your Android device can help you

First method – Using Widget

To covertly read all the incoming messages, without letting the senders know that you are reading them, you have to add WhatsApp widget on your home screen.

To do so, follow the steps:

Long touch an empty space on your home screen to add widgets. Select widgets.

Look for WhatsApp 4*2 widget.

Hold and drag the widget to your homescreen.

Voila! You will now be able to see all your incoming messages in this widget without changing your last seen or getting a blue tick.

Second method – Using Airplane mode

This method is slightly hectic as you would have to repeat the steps again and again to dodge blue ticks.

Here’s what you’ll need to do:

When you receive a message, turn on Airplane mode on your device.

Open WhatsApp messenger and read the message.

Close WhatsApp messenger

Turn off Airplane mode.

Congrats for reading the message without the read receipt. The message will remain unread in the sender’s eyes. However, remember that the next time you launch WhatsApp without Airplane Mode enabled, the blue ticks will re-appear.

Send WhatsApp messages without changing your last seen

Apparently, with a sweet little trick, you can send messages without changing your last seen. To use this trick follow the steps:

Open Google Assistant on your device.

Say, “send a WhatsApp message to ‘name of the contact’”. You will then have to dictate your message. Once you feel the message is correct, tap the send button.

Voila! Your message will be sent without opening the app and thus, last seen remains unchanged. This trick also helps you in writing hands-free using your voice.

Also read: What Google Assistant and Apple Siri have to say about Samsung Bixby

Keep status blank or send blank messages

There are two ways to keep status blank.

First method:

Open Google Chrome and copy any empty space between two words.

Open the status /about in WhatsApp, and paste the copied empty space.

Press Ok.

Voila! Your status will be blank. However, if you try this trick by entering space from spacebar, it won’t work. So, it’s necessary to copy the empty space from Chrome.

Second method:

Copy paste  this character in status/about on WhatsApp.

Chat with the person who has blocked you

Yes, you read that right. If a person blocks you, there is a simple way to chat with them. Although, practically you are still blocked but this neat trick helps you in contacting them again.

Also read: How to create GIFs using your Android phone

Here is how to do it:

Ask your mutual friend to create a new WhatsApp group and to add you and the person who blocked you in the group.

As simple as that, you can now chat with the person who has blocked you, without them unblocking you. If the conversation is going to be a private one, ask your mutual friend to leave the group.

Hide WhatsApp media from gallery

Although the outgoing media is not visible in the device gallery, incoming WhatsApp media gets a separate folder in the device gallery. If you don’t want incoming images and video to show up in your device gallery, you can hide it with this simple trick.

Follow the steps:

Open the file manager on your device.

Go to file manager settings and enable “Show hidden files”.

Navigate to WhatsApp folder and tap “Media” folder.

Add . in front of WhatsApp images and WhatsApp video i.e. rename the WhatsApp Images and WhatsApp Video folder to .WhatsApp Images and .WhatsApp Video.

This will hide the folders from your device gallery. To get these folders back, rename and remove the . present in their names.

Keep in mind: If “Show hidden files” is not active on your device, the folders will disappear from your file manager as well. Therefore, to get them back enable “Show hidden files”.

Listen to WhatsApp voice messages via internal speaker

By default, WhatsApp voice messages are played through the device speakerphone. And obviously, the voice messages will be audible to everyone near you.  There is a simple trick to play the audio through the internal speaker – it is the same speaker that you use to hear people during a call.

Also read: Android Ringtones: How to edit, create and set custom tones

To listen to WhatsApp audios discreetly, do the following:

When you receive a voice message, tap the play button and move the phone near your ear. Thanks to the proximity sensor of your device, the speakers will switch automatically.

Use WhatsApp to save memos or notes

What is one app that you always use? I’m presuming it’s the WhatsApp. So, why not use the app to store notes/memos on the go.

To do so, follow the steps:

Create a group and add one of your friends in the group. It is necessary to add at least one person to create a group.

Once the group is created, remove your friend from the group.

That’s it. Now send messages to this group to save them as memos or notes on your device. And you can even create other groups if you want to keep different types of notes under separate groups on WhatsApp.  Moreover, for easy distinction between them, you can rename them and keep a picture as per your preference.

Transfer files to/from PC using WhatsApp

“What? How is that possible?” Is that your reaction to the title? Well, as they say, “nothing is impossible”. So, yeah, even this is possible.

We have already mentioned above that you can use WhatsApp on your desktop browser using WhatsApp web. Combine WhatsApp web and the above tip (WhatsApp to save notes), you get a new method to transfer files, documents, links to/from mobile to PC.

If you are still confused, here are the steps:

Create a WhatsApp group with your friend, as you did above. Remove your friend.

Open chúng tôi on your PC.

Send the files, documents, links to this group from your mobile and you will be able to retrieve them on your PC in the same group.

Similarly, the method works for PC to mobile transfer as well.

Also read: How to Send, Receive and Request money ($$) using Email on Gmail Android app

Copy WhatsApp status

If you ever wanted to make someone’s WhatsApp status as your own, without manually typing it, WhatsApp must have left your dreams unfulfilled, since WhatsApp doesn’t allow you to copy someone’s status. You have to write it manually.

However, throw in WhatsApp web and you have a new trick to copy status. Open WhatsApp web, copy the status, and use it as your own – all through the WhatsApp web. No need to type it manually.

Use multiple WhatsApp accounts on the same device

There are two methods to use multiple WhatsApp accounts on the same device. First via a third party app and second using the “users” feature of Android. We have already done them in detail. You can check the first method here and second method here.

Use one WhatsApp account on two mobile devices

In case you want to use one WhatsApp account on two devices, there is a sweet trick to do it. Check our detailed guide here that explains stepwise how to pursue it.

Use a full-size image as your profile picture without cropping it

While putting up a profile picture on WhatsApp, you must have noticed that it crops the image to fit it in the square shape, thus ruining your image. Nonetheless, you can use a full-size image as your display picture without cropping it.

To do so, follow the steps:

Download Picsart app on your device or any other app that supports square fit.

Open your image in PicsArt app and tap “Square fit”. Your image will be scaled to fit in a square.

Save the image and use this square image as your WhatsApp profile picture.

Also read: How to create video slideshow of photos on Android

Get desktop notifications for WhatsApp messages

Other than WhatsApp web, if you want to receive WhatsApp notifications on the desktop, you have to use third party apps. One of the most popular app that makes it possible to get WhatsApp notifications on your desktop is “Pushbullet” app.

While the primary functionality of the app is to transfer links and files between devices, it also provides a feature to mirror notifications from mobile to desktop.

To get desktop notifications for WhatsApp messages, follow the steps:

Install Pushbullet on your mobile device and desktop.

Open Pushbullet and login to your account via mobile and PC.

On mobile Pushbullet, tap the three horizontal bars in the top left corner and select “Notification mirroring” from the menu. Enable “Notification Mirroring”. Select your desktop.

If you only want WhatsApp notifications to be mirrored on the desktop, tap “Choose which apps to enable” and select WhatsApp from the list, otherwise keep it unchanged.

That’s it. Now you will get all your WhatsApp notifications on your desktop.

Recover deleted chats or messages

Uh oh! So you accidently deleted an important chat on WhatsApp and there is no way you remember the details of the chat.

What do you do?

Well, thanks to the backup feature of WhatsApp you can easily restore your old deleted chats/messages on WhatsApp. Moreover, you can restore messages as old as 3-4 days.

WhatsApp automatically saves your chats every day at 2 AM, so if you delete a conversation that happened before 2 AM, you can restore it. However, keep in mind when you restore the backup, you lose the conversations that happened after 2 AM. So, be careful regarding that.

Also read: How to secretly record voice on your Android device

To restore recently deleted messages, follow the steps:

Uninstall WhatsApp. Don’t delete your account or WhatsApp data.

Reinstall WhatsApp and sign up with the same number.

You will be prompted that a backup has been found. Tap restore to recover your recently deleted messages.

Further, if you want to recover messages that were present on your device before 2-3 days, you can do that as well. Follow the steps:

Open the file manager on your device.

Go to the folder WhatsApp followed by databases.

You will find many databases there, one with the namedb.crypt12 and others in the format msgstore-YYYY-MM-DD.1.db.crypt12. The last two digits can vary from device to device. Select the database that you want to restore depending on the date of the database and rename it from msgstore-YYYY-MM-DD.1.db.crypt12 to msgstore.db.crypt12. Use same last digits that are present on your device.

Now, uninstall WhatsApp.

Reinstall WhatsApp and sign up with the same number.

You will be prompted that a backup has been found. Tap restore to recover deleted messages.

Make Group Video and Audio calls

With a recent update, WhatsApp has implemented the ability to bring group video and voice calling to the mobile app. Now every time you make a video call or an audio call, you can add up to 6 more participants to join you (total 8 people can communicate at once).

Make sure that you have WhatsApp updated to the latest version.

Open the chat window for any one of the contacts you want to group video or audio call.

Once the call has connected, tap on the Add Participant icon on the top-right corner of the screen.

From the list of WhatsApp contacts, add the person you want to invite to the group video or voice call.

You can add up to 6 more people once you have connected to a video or voice call.

→ Download WhatsApp messenger Android app

Update the detailed information about Top 10 Python Libraries That You Must Know! on the website. We hope the article's content will meet your needs, and we will regularly update the information to provide you with the fastest and most accurate information. Have a great day!