How to export whatsapp group contacts in excel

How to export WhatsApp group contacts in excel

Nowadays WhatsApp is playing an important role for smartphone users. In smartphones, we have many apps to use that fulfil our daily needs whether it is about making online chatting, calling, video calling, making a payment, entertainment and etc. It has become a big online platform for business and entertainment and other multiple jobs today. Now here we will learn how to Export WhatsApp group contacts in excel easily.

WhatsApp Use – As we also WhatsApp for business as we already discussed in the short above but if we talk about business that creates online leads that work through WhatsApp nowadays. Creating leads for any business via WhatsApp is trending nowadays.

Whatsapp Types :

1). "Personal"

2). "Business"

PERSONAL USE

WhatsApp for personal use – We can use it for personal use as like talking to our friends, colleagues, family members or anybody via chatting, calling, or video calling. We can also use it to make online payments. That means we can say,  It has become a big online bridge between us and our contacts.

WhatsApp made our life too easy in terms of getting in touch with our contacts or anybody. It is a good social platform where we can explore many things. It has 2 more cool features that we can use.  Let us get to know about them also.

1). Messages Broadcasting

2). WhatsApp Group 

1). Messages Broadcasting – We can add the phone numbers of our friends or family members in WhatsApp and create a broadcasting list. After that whenever we want to send any particular message to everyone then we do not need to send them one by one separately. Although we can simply add those contacts to the broadcasting list and send that message to the broadcasting list and it will be delivered to everyone.

And whenever they want to reply or do a revert, we will receive their messages in our personal message box, which would not be visible to all members who are added to the broadcasting list?

2). WhatsApp Group – We also have a feature to create a WhatsApp group where we can add anybody (those who all have WhatsApp also) in the WhatsApp group and all can do chat altogether, we can also make group calls or videos calls, All messages will be visible to everyone whoever is added in the WhatsApp group. There is also one nice feature by name of emoji that we can also use in group and personal WhatsApp messages too. We can also share any website or any web link in the group even audio and videos too for entertainment purposes.

 BUSINESS USE

1). WhatsApp for business use – We can use it nowadays to create online leads for the business. Multiple features are available for our business tools. But here we are talking about the most amazing features.

1). Broadcasting Messages

2). Business WhatsApp group

1). Broadcasting Messages – As we already discussed this feature above is for personal use,  So it works as same here for business purposes also.

That means we can add our client’s phone numbers to our business broadcasting list and send them any particular message in the list and it will be sent to everyone in their personal window. We also have a feature here where we can share any web link, audio, or videos in the group for business.

2). Business WhatsApp Group – We also discussed this feature above and it also works in the same way. We can add our client’s phone numbers to a group and any messages we can put in the group will be visible to everyone and anybody can revert to those messages in the group. WhatsApp allows sharing any business web link, audio, the video also as per our choice.

NOTE –

“WhatsApp use for personal & business in MS EXCEL.”

Now we are talking about here that we can use this WhatsApp for our personal and business purpose too. For Example:-

If we have contacts in our excel file then how can we transfer them to WhatsApp that means how can we add them to WhatsApp easily?

So now here you can figure out how to send out all WhatsApp gathering contacts in exceed expectations by a few stages as it were. 

1. Open your WhatsApp in your computer’s browser.
2. Go to the rundown of contacts in WhatsApp means gathering and snapping on it.
3. Once you take your cursor on the top of the WhatsApp group centre will show you all names of contacts that are listed in the group do not take your cursor until you see all that data like your unsaved and saved contacts in there otherwise it will not work.
4.  Press the right click of the mouse on it and click INSPECT, Now you can see all your data as contacts then again press the right click of the mouse and click copy elements and paste it to the excel sheet’s cell.

Now we have received all data from the WhatsApp group to excel.

Here we have to remove unnecessary data like text or replace it with blank by using the find & replace tool in the HOME tab in the EDITING box in excel. Once all text will be deleted when we have only numbers left with maybe a comma or country code something like for the USA it is - +1 and for India +91 so on.

Simple steps – 

Now select the cell in which you have all data of numbers and go to the DATA tab in excel.

WhatsApp group contacts in excel

If you click the text-to-column option then it will split all numbers in a column from a row with country code and etc.

If you want to remove the country code, is good otherwise select the cell again and do it here with the help of the FIXED WITH and DELIMITED options.

Export WhatsApp group contacts in excel

If still numbers are not separated from the country code then there is another option to remove it. Use RIGHT FORMULA in excel and numbers will be separated.  

Look at the preview box to set it up and numbers will be separated now which can be used as the final, all done easily in excel.

Basic MS Excel Formulas

Basic Excel 

Microsoft Excel: Basic excel is all about small or basic functions in excel. These are those functions that we usually use to do some basic work in excel like Sum, Sumif, Left and right functions, basic calculation as functions, etc. So here we will discuss the same with examples and images so that we can easily understand; what these basic functions or formulas are. So let us start to check these few basic functions. 

 

In Ms Excel, a formula is an expression that operates on values in a range of cells or a cell. For example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to cell A3 Being essentially structured as a spreadsheet program, Microsoft Excel is incredibly ground-breaking and adaptable with regards to ascertaining numbers or tackling math and building issues. It empowers you to aggregate or average a section of numbers in a matter of moments. Here we have the best Ms excel formula. 

Aside from that, You can figure out self-multiplying dividends and weighted normal, get the ideal spending plan for your publicizing effort, limit the shipment expenses or make the ideal work routine for your representatives. This is finished by entering equations in cells.

This instructional exercise expects to show you the fundamentals of Excel capacities and tell you the best way to utilize essential functions in Excel.

• Excel Basic Formulas
• 10 Basic Excel functions you must know
• Excel functions & tips 
• The basic Ms excel formula

The equation is an articulation that figures the estimation of a cell.

 For Example, =A2+A2+A3+A4 is an equation that includes the qualities in cells A2 to A4. 

The limit is a predefined spreadsheet authoritatively open in Excel. Limits perform explicit figuring in a specific request dependent on the predetermined qualities called contentions or parameters.

For instance, rather than indicating each incentive to be summed like in the above equation, you can utilize the SUM capacity to include a scope of cells: =SUM(A2:A4) 

You can find all open Excel works in the Function Library on the Formulas tab:

Basic ms excel formula

We call excel formulas to excel functions too. For inserting one into an excel file, highlight a cell in which we want to put formula or function then click the far-left icon, insert the function to use formulas and what all they do and the browsing window will look like this we have here below.

Basic ms excel formula

Want a more sorted experience then use any of the icons we have here as highlighted and such as any functions or formulas

Presently,  how about we complete a more profound plunge into probably the most critical Excel recipes and how to play out everyone in normal circumstances.

• SUM
• COUNT
• COUNTIF
• TRIM
• MAX
• MIN

SUM - This formula is one of the basic excel formulas which starts with = followed by a specific text tag denoting the formula which you want to use in excel.  

And FORMAT would be =SUM(value1,value2, etc.)

For example, an image has been attached here:-

Basic ms excel formula

Now in the image above see the values D1 to D9 are selected for getting the sum and finally, we used this formula and got a total of the selected area. That show we use the SUM formula in Ms Excel.

COUNT - It gives a total number of a selected range of any specific data. It works like the SUM equation yet gives an alternate outcome as we need from utilizing it. Let us check here in the image below.

Basic ms excel formula

Values, B2 to B9 are selected under a range for getting a total number and we got it. That show this COUNT function works in Ms Excel.

COUNTIF – We use this function to check the total count of the selected row or column with a condition. Let us check the example here to understand it in a better manner.

Example: Let's suppose we have a column from A2 to A12 and in this column, we have some names of people however some names are written as per repetition then how would we check if we would like to get the exact right number or count of any repeated name in this selected or ranged column? Check the image here below.

Basic Excel

In this case, we are going to use the COUNTIF function that helps us to check the right count of that name that has been used in the column multiple times. Here we also have a video to understand it below. Let us check this out.

Trim- This function removes the extra space from texts in cells. On other hand, we can clean extra space from text in cells in any row or column.

MAX- We use this function in excel to check the maximum number or value in any selected row or column. If we have some data in any column from 100 to 1000 (A1 to A10) we use this function to check the highest value in the ranged or selected area However, we have to remember this, that we can only use this function in excel to check the numerical data in any row or column, not in texts or text formats.

How to use data validation in ms excel

Data Validation 

When we talk about a data validation feature in excel then it is like we can explore our knowledge in excel in data validation. Data validation has many features to use which are highly user-friendly and easy to use. Here we will learn with live examples and get to know all the basic and advanced things in data validation. Data validation restricts users to make any unwanted changes in data which is validated by this using this data validation feature.

We can also say that way as; When we control users putting any values in the excel sheet then this feature of excel will be called data validation. It is being used for checking the accuracy and quality of source data before using, importing or otherwise processing data. Various kinds of approval can be performed relying upon goal imperatives or destinations. Information approval is a type of information purifying. Let us learn Data Validation in detail here.

1). Open an excel sheet which consists of data.

2). Click the Data tab on the top of the ribbon.

Data Validation:- Once you click the data tab, You get these 3 options.

Data Validation Image

Data Validation:- Once you click it and you will have these 3 options.

Settings - Input Message - Error Alert

Data Validation Features

In the settings, you have ALLOW which gives the option to select any cell in the excel sheet and put a data validation If you want that your selected cell needs to have only numbers and a condition must be there such as, We can put numbers from 1000 to 15000 or any and hit the OK button then data validation will be activated in selected cells then nobody can put numbers besides we activated or made a condition there.

NOTE – Data validation does not work in the case of copy and paste. For example:- In the selected cells no other numbers can be entered but if you or anybody put the numbers in excel, select an area of the data and copy from there to paste in the selected area then numbers will be entered there without any issues.

Let us check here now:-

Data Validation Function

Copy and paste work will not be worked at all if it is done from a non-selected area in an excel sheet.

In the same way, we can put any condition or make data validation the weather in cells for TEXT or NUMBERS Can be used for data validation such as

1. Any Value
2. Whole number
3. Decimal
4. List Date
5. Time text length
6. Custom

Let us have a look here at the screenshot below.

Data Validation

First, it shows ALLOW, That means whatever condition we put here in the data by using the feature of data validation, will work accordingly.

Any Value – It gives all the options to set a condition as per or need or choice. We need to simply select the data and work as per the feature that we select in the box of data validation.  This feature of data validation, we already understood with the example above however let us come to the next one more example. Let us take another example here first to understand it in a better manner. We will work on another feature to set up a condition in the LIST in data validation. 

Data Validation

LIST – Here we are working on the LIST function, How it works, Let us check and learn in a better manner here.

First, we need to select the condition from the dialogue box as LIST and come to the next tab which is SOURCE in the dialogue box, Here we select the data where we want to put a condition as per the LIST tab.

It works in texts value If you select all the texts in ongoing then there you can see a list of names or texts which will come as a drop-down list. Then you can select any name or text value to put in the column. It will show you only those names or text that you have in the selected area.

Question:- Now there is another case that comes in, let's suppose you do not want anybody to make any changes in the text value or no editable things in it. Then how to do it?

Answer: - In this case, we do not have to select all the names or text values however, you need to put all names or text values in the dialogue box manually with a comma (,) and then hit OK.

Now it does not allow any other user to put any other text or anything in it, User has to put only the text that has been set up as a condition by this data validation feature.

With the same thing, Also we can put an error message to show that user which will ask the user not to put anything there except the validated values. This one is also an awesome feature in data validation. It needs to be done with another tab that we learned above, INPUT MESSAGE.

Question:- How to use input message?.

Answer:-  Input Message:- We can use it as if we want to put any writing a message in the cell when someone will try to type something in the cells which is already conditioned under data validation, will appear clearly, 

It can be anything you type & will be displayed anyhow. OR Now, if the user tries to enter a value that is not valid, a pop-up appears with the message, “This value doesn’t match the data validation restrictions for this cell.”

ERROR ALERT:- It also can be used for putting any value or text such as STOP, WARNING, and INFORMATION in the selected area where we already put data validation, Will be appeared when someone tries to put any value there.

Whole Numbers:- This condition we already learned above, It is about setting up a condition to put values in numbers between 2 numbers.

Decimal:- This feature provides the best thing as always, We can set up a condition in values in decimal, It will not allow the user to put values except the one mentioned in decimal, as we use it for whole numbers, In the same way, it works in decimal too.

Date:- It works as same in the date format, Whatever the format we fix or set up here as a condition, it will only show that all users. It doesn’t allow the user to put any other date format.

Text Length: - This the feature allows user t set up a condition for text length which means the text length we put, it will allow only the one we put already as a condition. Example – If you have put a condition to put only 7 letters in the name as maximum then it will not allow anybody to put more than 7 letters in the name at all.

Time:- It only shows the time that we put as a condition like other features that we learned above.

Arya

Excel tricks and functions

Microsoft Excel Tricks and Functions

Whether in you are in any field like sales or education & etc. You can not escape from Microsoft’s Excel as it is necessary nowadays with so many functions almost anybody can find a use for this. But at the same time, Few got mastered it. While the sheer capacity of the application can be scary, no uncertainty of realizing how to utilize Excel gives any understudy an edge in the working environment. Here we have some excellent tips.

Essential Microsoft Excel Tips

1). Vlookup

2). Filters

3). Sum

4). Sumif

5). Count

6). CountA

7). Average

8). PivotTable

9). Dashboard in Excel

10). Data Validation

11). Picture Lookup

12). Hlookup

13). Data transfer from excel to word

14). Data transfer from notepad to excel

We can see a few functions above as mentioned as essential functions or formulas. Microsoft Excel has many features or functions to use however what functions are considered basic is the question here. Because first of all, we need to learn basic functions and then we can go for advanced-level excel to become a masters in excel.

Basic Functions are those functions that we use easily for basic work in excel like the sum and average, etc. These are just examples. It does not mean that only these are the basic functions, There are as many as functions considered basic like vlookup,  hlookup and many more.

As we have seen other few names as well above in the list to learn essential Microsoft excel tips, there are also a few functions we saw as advanced level excel too like creating a dashboard in excel, picture lookup, etc.

Now here will discuss the basic and advanced level functions however once we get to know about the features of basic and advanced then also we can call ourselves the master in excel.

If you have to work across different sheets & workbooks then the vlookup will help you to combine and summarise the data but when you want to use this formula or function then make sure you must have at least one column that appeared an identically in both places.

For example, you have a list of names of some people next to their email addresses in one sheet and a list of those same people’s email addresses next to their school names in another however you need the names, email addresses with company names to appear in one place.

         

The formula will be = Vlookup (lookup value, table array, column number,(range lookup)).

The screenshot is attached here for a better explained below.

Microsoft Excel tricks and functions

Filters

Filters are the best options to look at any specific data within a large data set, You can reduce the data to check certain criteria (without changing original data)

For example:- I might want to look at the subjects only from particular states.

Microsoft Excel tricks and functions

Now you can check this screenshot above, Filters have taken their places now you may have to click the filters and select the heads or subheads to check and all will be easily shown as done.

Basically what we are discussing here is that if we learn basic and advanced-level functions in excel then, of course, we can even learn new tricks in excel.

Now we will add a few functions here in the excel tricks with examples. First of all let s discuss the most important feature of excel, called MACRO.

Question:- What is macro in excel?

Answer:- When we have a task to repeat any data work that we need to make as repeatedly then we can simply record a macro for it. Macro saves time and we can run it as much as time. That is called macro.

Question:- How to record a macro in the excel sheet?

Answer:- Let's suppose we have to create data in the excel sheet where we need to perform repetitive work means there is work that we do that is coming under repetition. Now here we will record a macro so that repetition will be stopped and it will create the data itself easily. Let c how it works.

Now we are recording a macro so we need to open our excel sheet and if it is Microsoft Office 2010 then look at the last button on the top called VIEW and click on it. Once we click on it then we have many options but we need to focus on the last options as says macro. Check the screenshot below.

Recording a macro 

As per this image check in the last that we have 3 options altogether then we have to see all of them and us going to click the first one from the bottom.

1). View Macro

2). Record Macro

3). Use relative references

Now let us get the details of View Macro first.

1). View Macro – If we already recorded a macro in the excel sheet then we click this VIEW MACRO to run or view the macro in the spreadsheet.

It also has many features when we click it.

Like As:-

1)Run – This option runs the macro.

2)Edit- It gives a chance again to edit the macro coding.

3)create – Here we create the macro.

4)Delete- We can delete the macro in the excel sheet by clicking it.

5)Options – Here we get many other functions that we can check here in the screenshot below.

2). Record Macro – Here we record a macro and also we have the option to create a shortcut for running it as if like [CTRL+SHIFT+()]. Remember when we create a shortcut then we also press a shift key if we do so then we will not be confused about the shortcut key to run the macro.

Even if we forget the shortcut key then we can simply run it by clicking the first option that we have in the top VIEWMACRO, Here we get a button as RUN to run the macro.

For better understanding let us watch the video here for recording a macro.

How to learn advanced excel free.

Advanced Excel 

Advanced excel has a simple meaning of all features and functions of Microsoft Excel is used by users to handle large calculations and data processing. Large data analysing and solving big issues related to any data in Excel. Microsoft Excel is a champion among the least demanding and weighty programming applications open out there.

Now we will discuss advanced excel in detail but before proceeding let s understand what is basic excel also.

Basic excel consists of some of the basic functions or formulas in excel Now we used the word basic so it does not mean that basic excel is nothing or not needed to learn. Basic excel has also an important role because if we do not understand basic steps or functions in excel then, of course, we will have an issue understanding advanced excel.

Basic Excel

Now as we said basic excel is also important to learn so here we will add some basic functions first to understand.

Basic functions consist of those functions that we can see below. Let us have a look here.

Sum: This function is very nice as we can use it to add the numbers as a sum means we can add any columns or rows that consist of numbers.

Count: We can use this function easily to count the cells or rows if there is data in cells.

For example.

If A1: A10 =Count(A1: A10), If we mention any numbers in cells, would be counted except text in cells. This means if we mention numbers in cells those would be counted but if we mention texts in cells they will not be counted. It gives a final result of the count function based on numbers in cells.

Count Function

This is called the COUNT function in excel.

Average: This function counts the cells and calculates the average of the total cells that consists of numbers not texts, Let us take an example here.

If we mention any numbers in cells in rows or columns like this below.

A1: A10 = Average(A1: A10)

This function will only calculate the cells where numbers are mentioned in the data and if we mentioned some texts in there then the text will be ignored.

Average Function

 Now we have seen that in the image above all data has been calculated as per the Average function and the outcome is 537 finally which is an average of the total data that we have in the above cells in excel. Also, we can see texts in some cells which were ignored by this average function.

Though there are many basic functions in excel which are very important to learn before we go to an advanced level in excel. Now here we will discuss advanced excel with formulas and examples. 

Advanced Excel Topics

1. Pivot Table & Reporting
2. Pivot Charts
3. VBA & Macros
4. Conditional Formatting
5. Data Validation

1. Creating a Dashboard in Excel
2. Advanced Vlookup
3. Advanced Hlookup
4. Advanced Excel tricks
5. Data Tables

1. Tables & Formatting
2. Index+Match
3. Formula Auditing
4. Array Formulas
5. Sumifs

When we talk about Advanced Excel then we must say that if anybody knows about advanced excel then he or she feels very easy to handle any kind of data processing. Advanced excel simply makes people smart because when you learn it and you can crunch the data smartly.

If we talk about even one of the advanced excel functions which is Conditional Formatting gives an easy solution to work as per any data conditions. With help of this feature, data can be highlighted with conditions needed in excel.

If Function

Meaning of IF Instruction: According to Microsoft Excel, IF articulation is characterized as a capacity that "checks whether a condition is met, returns one esteem assuming True and another esteem assuming False".

Advanced Excel- IF function 

The best other feature which is mentioned above is PIVOT-TABLE which is being used in Ms excel to acknowledge any huge data and convert that into a summarizing way which will be an easy way to check and acknowledge.

Now when we talk about PIVOT-CHART so, of course, we should know about Pivot-Table as Pivot-Chart will be used after putting the Pivot-Table function in the Excel sheet. 

When this Pivot-table is ready then we can simply create a Pivot-Chart by using an INSERT tab and create a Pivot-Chart as it is there in the drop-down option OR When you will click anywhere in the chart then it will easily appear as a chart ribbon.

Data Tables – It helps users to analyse a massive amount of data for a solution.

Vlookup helps users to find any particular value or text in any data Vertically. Which is a very usual and important function nowadays. Even MIS users also need it so they learn it and go with advanced lookup too then.

What is Advanced Vlookup?

When we use Vlookup with multiple conditions in excel, Called advanced Vlookup. Nothing is different as it is just a way of handling huge data.

HLOOKUP in EXCEL:- It helps users to find the values Horizontally and Advanced Hlookup is handling huge data with multiple conditions in excel.

         

          

When we want to add numbers in the range like starting from 01 to 150 or any number with one criterion, Called Sumif in excel. When we add multiple criteria then it is called the SUMIFS function in excel.

Data Validation is also one of the best advanced excel functions as it helps users to put conditions in data like as per numbers or texts. For example:- If we need numbers from 01 to 250 then we can put this condition so that numbers will appear above 250 in the column or row accordingly.

Question:- How to use the Sum function in excel called a basic feature of ms excel?

Answer:- The syntax is as follows:

=SUM(B2: B7)

Advanced Excel -  Sum Function

Now Dashboard in excel is something the most important and interesting functions also in Ms excel. It gives a complete solution to summarize the data in a basic and dynamic way. It would be created with Pivot-Table and then can be converted into charts or basic Tables in excel.