Use the CONVERT function to convert values from one measurement system to another. Among the many possibilities, by category, are: Temperature - Celsius/Fahrenheit, Distance -meters/feet and kilometers/miles, Weight - grams/ounces and kilograms/pounds, Volume -liters/quarts, and Area - acres/square miles.
- [Voiceover] If you work with different…numbering systems, and that's suggested…by the data we're seeing in…columns E, F, H, and I,…you might want to be aware of a function…called convert.…This is not a math function, but I did put it…in this category because as you click the button…on the Formulas tab for more functions,…there is a category called engineering.…And, for many people, these are likely…to be obscure, unless you're an engineer…or you work in that field.…But, you will see convert as one of the…engineering functions.…So, you can probably guess by what we're…seeing in the screen how we might use this.…
I'm looking at a map, maybe it's a…Canadian map, and this is between two cities;…it's 190 Kilometers.…I want to convert that to miles,…equal convert.…Now, if you're looking at some of the…entries that we see, over in columns E, F, H, and I,…recognize that many times you'll see…uppercase and lowercase.…These are case sensitive, you gotta…be on top of this.…If you wanna convert a number, in this…case in the number 190, that's in cell A2…
Author
Dennis Taylor
Released
5/26/2016- Understanding how the hierarchy of operators affects formula results
- Knowing when to use absolute vs. relative references
- Using Formula Builder for unfamiliar functions
- Displaying a worksheet's formulas and highlighting formula cells
- Converting formulas to values
- Creating 3D formulas to gather data from multiple sheets
- Creating and expanding nested IF functions; using AND, OR, and NOT with IF
- Looking up information with VLOOKUP, HLOOKUP, MATCH, and INDEX
- Analyzing data with the statistical functions: MEDIAN, MODE, etc.
- Using the power functions: COUNTIF, SUMIF, COUNTIFS, AVERAGEIFS, and more
- Calculating financial data such as payments
- Performing basic math
- Calculating dates and times
- Editing text with functions
- Using array formulas and functions
- Referencing data in other cells and files
- Extracting information from Excel worksheets
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome50s
-
Exercise files25s
-
-
1. Formula and Function Tools
-
2. Formula and Function Tips and Shortcuts
-
3. IF and Related Functions
-
4. Lookup and Reference Functions
-
Use MATCH and INDEX together4m 40s
-
5. Statistical Functions
-
6. Power Functions
-
7. Selected Financial Functions
-
8. Math Functions
-
9. Date and Time Functions
-
10. Text Functions
-
11. Array Formulas and Functions
-
12. Reference Functions
-
13. Information Functions
-
Conclusion
-
Next steps25s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Convert values between measurement systems with CONVERT