Скачать или смотреть Excel - How To Use Excel For Unit Conversion - Episode 1211.115

Microsoft Excel Tutorial: Using the CONVERT function to convert units in Excel.

Welcome to another episode of the MrExcel netcast. In this episode, we will be diving into the Convert function in Excel, which used to be a part of the Analysis tool pack but is now a core function in Excel 2007 and 2010. This function is perfect for converting between different units of measurement, such as inches to centimeters or pounds to kilograms.

To use the Convert function, simply enter =CONVERT and then the number you want to convert, followed by the from_unit and to_unit. For example, if we want to convert 123 inches to centimeters, we would enter =CONVERT(123,"in","cm"). The function will then return the converted value, which in this case is 312 cm.

One helpful tip is to use the FX button next to the function to access the Excel help topic for the Convert function. This will show you all the different units of measurement that can be used with this function, including distance, time, pressure, and more. It is important to note that the abbreviations used in the function are case sensitive, so be sure to enter them correctly.

While the Convert function is great for converting between different units of measurement, it cannot be used for currency conversions. However, it is still a powerful tool for quickly and accurately converting between various units. Thank you for tuning in to this episode of the MrExcel netcast, and be sure to join us next time for more Excel tips and tricks!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...

Table of Contents
(00:00) How To Use Excel For Unit Conversion
(00:21) Converting from Metric to Imperial
(00:31) CONVERT three arguments
(00:43) Convert from pounds to kilograms
(00:53) Convert Fahrenheit to Celsius
(01:03) Convert tablespoons to teaspoons
(01:14) Convert Meters to miles, nautical miles to statute miles, Angstroms to Picas
(01:26) Joules to Ergs, Horsepowers to Watts, Tesla to Gauss
(01:38) US Pints to UK Pints
(01:51) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelformula #excelformulasandfunctions

This video answers these common search terms:
how to switch excel from metric to imperial
how to use convert function in excel
excel calculation to convert units
excel function to convert metric to imperial
how to use excel for unit conversion
convert units in excel cell
excel convert measurement units
excel unit conversion formula
using excel for metric conversion
excel unit conversion tutorial
convert units with excel formula

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...

Convert English to Metric and more with the versatile CONVERT function.