Zehad Rian Jim
This tutorial will demonstrate how to make a conversion table in Excel. In our day-to-day life, we need to convert different units. Sometimes we need to convert meters into yards, sometimes we need pounds into grams or kg or sometimes we need the time conversion from minute to second or hour and vice versa. The table that contains most of these conversions is called Conversion Table. So, it is very important to learn how to make a conversion table in Excel.
How to Make a Conversion Table in Excel: 8 Easy Examples
We aim to learn how to make a conversion table in Excel. The Conversion Table is a table that contains most of the daily used conversions in one table. We’ll use a sample dataset overview as an example in Excel to understand easily. If you follow the steps correctly, you should learn how to make a conversion table in Excel on your own. The steps are
1. Turning Celsius into Fahrenheit in Excel
Now, we aim to turn Celsius into Fahrenheit in Excel. We will use the CONVERT function in Excel for the conversion. The steps of this example are.
Steps:
- First, insert the following formula in the E5 cell.
=CONVERT(B5,"C","F")
- Then, after pressing the Enter button, you will get the result for this cell.
2. Converting PSI into Pascal in Excel
Another important task is to convert PSI into Pascal in Excel. We will use the CONVERT function in Excel for the conversion. The steps of this example are.
Steps:
- First, insert the following formula in the E6 cell.
=CONVERT(B6,"psi","Pa")
- Finally, after pressing the Enter button, you will get the result for this cell.
3. Transformation of Litre into Cubic Meter in Excel
Next, we will try to transform Litre into Cubic Meter in Excel. We will use the CONVERT function in Excel for the conversion. The steps of this example are.
Steps:
- To begin with, insert the following formula in the E7 cell.
=CONVERT(B7,"l","m^3")
- Finally, after pressing the Enter button, you will get the result for this cell.
4. Turning Pound Mass into Gram in Excel
In this case, our goal is to turn Pound Mass into Grams in Excel. We will use the CONVERT function in Excel for the conversion. The steps of this example are.
Steps:
- First, insert the following formula in the E8 cell.
=CONVERT(B8,"lbm","g")
- Lastly, after pressing the Enter button, you will get the result for this cell.
Similar Readings
- How to Make 3D Table in Excel
- How to Make a Decision Table in Excel
- How to Create a League Table in Excel
5. Converting Meter into Yard in Excel
Afterward, we can also convert Meter into Yard in Excel. We will use the CONVERT function in Excel for the conversion. The steps of this example are.
Steps:
- First, insert the following formula in the E9 cell.
=CONVERT(B9,"m","yd")
- Finally, after pressing the Enter button, you will get the result for this cell.
6. Transformation of Minutes into Seconds and Hours in Excel
In this scenario, we want to transform Minutes into Seconds and Hours in Excel. We will use the CONVERT function in Excel for the conversion. The steps of this example are.
Steps:
- To begin with, insert the following formula in the E10 cell.
=CONVERT(B10,"mn","sec")
- In addition, after pressing the Enter button, you will get the result for this cell.
- Next, insert the following formula in the E11 cell.
=CONVERT(B11,"mn","hr")
- Finally, after pressing the Enter button, you will get the result for this cell.
7. Transformation of Meter Per Second into Mile Per Hour in Excel
Moreover, we want to transform Meter Per Second into Mile Per Hour in Excel. We will use the CONVERT function in Excel for the conversion. The steps of this example are.
Steps:
- First, insert the following formula in the E12 cell.
=CONVERT(B12,"m/s","mph")
- Secondly, after pressing the Enter button, you will get the result for this cell.
- Thirdly, right-click on the data table and select the “Get Data from Table/Range” option.
- Lastly, after that, you will get the result for this cell.
8. Turning Numbers into Percentages
Finally, we want to transform Numbers into Percentages in Excel. We will use the CONVERT function in Excel for the conversion. The steps of this example are.
Steps:
- First, arrange a dataset like the below image.
- Secondly, insert the following formula in the D5 cell.
- Thirdly, after pressing the Enter button, you will get the result for this cell. Then, use Fill Handle to use the formula for all desired cells.
- Lastly, you will get the result for all the cells.
How to Transform Range to Table and Vice Versa in Excel
Now, we want to transform Range into Table and vice versa in Excel. In our daily work, we need to convert the range to table and table to range a lot. So, it is very important to learn this method. The steps of this example are.
Steps:
- First, arrange a dataset like the below image.
- Second, right-click on the data table and select the “Get Data from Table/Range” option.
- Third, check in the Create Table box, if all the cells are inserted or not. Then press OK.
- Fourth, after pressing the Enter button, you will get the result for this cell.
- Fifth, if you want to convert the Table form into the data range then first right-click on the table.
- Sixth, select the Convert to Range option from the Table option.
- Seventh, then the confirmation box will appear on the screen. Then press Yes.
- Last, after pressing the Enter button, you will get the result for this cell.
Download Practice Workbook
You can download the practice workbook from here.
Conclusion
Henceforth, follow the above-described methods. Hopefully, these methods will help you to make a conversion table in Excel. We will be glad to know if you can execute the task in any other way. Follow the ExcelDemy website for more articles like this. Please feel free to add comments, suggestions, or questions in the section below if you have any confusion or face any problems. We will try our best to solve the problem or work with your suggestions.
Related Articles
- Create Table in Excel Using Shortcut
- Create a Table in Excel Based on Cell Value
- How to Create a Table with Existing Data in Excel
- How to Create a Table Without Data in Excel
- How to Create a Table with Merged Cells in Excel
- How to Create a Table in Excel with Multiple Columns
- How to Make a Table in Excel with Lines
- How to Create Table from Another Table in Excel
- How to Create Table from Another Table with Criteria in Excel
- How to Create a Table with Subcategories in Excel
- How to Create a Lookup Table in Excel
- How to Mirror Table on Another Sheet in Excel
- How to Create Table from Multiple Sheets in Excel
- How to Make a Table Bigger in Excel
- How to Create a Table with Headers Using Excel VBA
- How to Add New Row Automatically in an Excel Table
