Use of Text to Column in Microsoft Excel by WASEEM WEB WORK

Text to Column 

Today is our topic very easy and very important in Professional life but also important for students who are working in Microsoft Excel. Here the question is what is it mean?

So, the answer is that Text to Column means separation of data from one cell or column in different other columns as per requirement.

Use of Text to Column

We use this option in Microsoft Excel where we have data together numeric and text in one cell. 

for example, we have data of employe code and name together (0001001Adnan). If we have a large number of data in the same position mentioned above separation will be very difficult one by one. So we need to use the option of Text to Column which helps us and separates the data within a seconds.

Go to Data Menue ==> Select the Text to Column option

Then select Fixed width ==> and then Next ==> then select the range of data that you want to separate from the data with the help of a mouse. Then click next and click Finish. So last time you need to click okay and your data will be separated as you required.

For further explanation watch below tutorial:







For further information about our team click on WASEEMWEBWORK &

and also visit our youtube channel for more tutorials like this click here 

For contact to us, use our email Address WASEEM WEB WORK

How to use list from Data Validation in Microsoft Excel

List from Data Validation in Microsoft Excel

How to create a list from Data validation in Microsoft Excel?

This tutorial related to the question mentioned above which is in detail.

First of all Happy New year 2020 to all 

When a person has a large number of data and wants to save time, this option will help in time-saving. Because this option is the easiest way to use in forms filling. If you survey, research or belong to HR or any other field where you need to fill forms with the help of Microsoft Excel. You can use this option for different fields. For example, your form consists of Gender, Qualification, Marital Status or disease, etc.

Let explain how this option works in Microsoft Excel?

Step by Step

Open Microsoft Excel
Go to Data Menu
then go to Data validation

and select the data validation option from the list:

Then select the setting and open the drop-down menu.

Select the list and put the source data and then click on Okay.

Done!

For practical these steps watch the tutorial on our youtube channel or click below on the video.






Visit our facebook page Waseem Web Work
Or
visit our youtube channel Waseem Web Work

Basic formulas MIN, MAX and AVG in Microsoft excel by Waseem Web Work

Basic formulas in Microsoft Excel: MIN, MAX, AVERAGE

Today's topic very easy and basic level learning for beginners who did not start learning excel can start learning from our youtube channel Waseem WebWork. This tutorial especially provides you basic concepts of excel formulas. We can find many types of results with the help to excel. Now let see how can we use a different formula in Microsoft Excel.

1: MIN formula: 

In this formula, we find the very lowest value from our data. Use of this formula in Microsoft Excel =MIN(Number 1: Number 2 etc.). For example, we have 1 to 10 numbers and if we use this formula the result will be 1 because of its lowest number in the data.

2: MAX formula: 

With the help of this formula, we can find the maximum or highest value from the available data. Use of this formula like this =MAX(number 1: number2 etc.). For example, we have data 1 to 10 numbers so if we apply this formula the result will be 10 because of the highest number.

3: Average formula: 

With the help of this formula, we can find the average or mean value from the data.
Use of this formula =AVERAGE(number1: number2 etc.). For example, if we have data from 1 to 10 so we can calculate in different ways like one method is that we add all numbers =(1+2+3+4+5+6+7+8+9+10)/10 but the easiest way to find the mean or average look below:

Waseem Web Work

In the below tutorial you can learn practical using of these formulas. watch and share 






Visit our facebook page for further information and don't forget like the page.

Also, visit our youtube channel WaseemWebWork and subscribe to our channel.

How to create Hyperlink in Excel 2013 Urdu/Hindi

Hyperlink in Microsoft Excel 2013



We brought a simple and briefly tutorial about Hyperlink. In this tutorial, we explained two types of Hyperlink one is Internal and the other is external. Internal Hyperlink means to connect sheets in a file with buttons or links. External means to connect other documents with one documents. Internal sheets or external documents both for job holders are very important because of time-saving. You know when an employee works on different documents or sheets in one time so move from document to another document is easiest way is Hyperlink.



It is also important for the Sales department who work in different documents like Sales, Stock, Trade Offers, etc. They use different documents for different tasks. Computer operators can easily use this link in their work to save time. By this link, we do not search for our documents in our System because when we click on the button or link the document open within a seconds.



Watch this video for detail about Hyperlink or visit our youtube channel.

---------------------------------------------------------------------------------------







I hope this video will help you to understand the hyperlink using.





Don't forget to subscribe to our channel and visit our facebook page for further information about WaseemWebWork.

How to calculate data in Microsoft Excel? Urdu

Calculation with Basic Functions in Microsoft Excel:

The biggest problem in these to calculate a large number of data without any error/mistakes. If we remind the past and for a minute think that time How the people calculate a large number of data? I think it would be more time consuming and expensive at that time. But recently, the time in which we use computer applications for a different type of works through which we can complete our work or task within a short time than before. 

One of the best applications in Information Technology is Microsoft Excel which is used for calculation in the different departments in the Organization for collecting, sorting, and presenting the data. From collecting to presenting the data each and every step is related to formulas through which we calculate our data in different shapes like Sum, Minus or Subtraction, Percentage, Division, and Multiplication, etc.

One by one now is going to discuss in detail below:

1. Sum 

  

Sum function uses for Adding some data or we can say that plus different figures form the data. For example =1+2+3+4=10, we can calculate this formula in different types in Microsoft Excel but here we are using one of them in below screenshot:

The formula should be like this in Microsoft Excel SUM(number1, [number2], …), instead of numbers 1 and 2 we can use a range of data like in the above screenshot look from C9: D9 means the range from C9 to D9. So we can expand this formula from C9 to Z9 and so on.

2. Subtraction or Minus

As we discussed in the above for Sum Function, we are using the Subtraction function in Microsoft Excel as well. =5-3=2, so the question is that how can we calculate in Microsoft Excel? Look in the below screenshot:

Here in the above screenshot, the function for subtraction is E9-D9 (60-50) which is equal to 10. So it is very simple to calculate subtraction in Microsoft Excel. Visit this link for tutorial related to this topic click here 

This is how you can calculate your data even small or large within a seconds and without omission or commission errors. I hope you will share your opinion about this information.

For further information visit our facebook page click here WaseemWebWork

You can visit our youtube channel click here WaseemWebWork for learning these tips practically and don't forget to subscribe our channel for upcoming videos

For contact us, you can email us click on WaseemWebWork