will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.
Convert Measurements in Excel
Last weekend I set up a little spreadsheet in Excel to compare the cost of a trip in a rented RV versus a small car. The only gas consumption numbers I could find for the RV were in miles per gallon. Since we use the metric system here in Canada, I needed to convert everything to kilometres and litres.
Fortunately, Excel has a CONVERT worksheet function that makes the conversion easy. The only tricky part is remembering the codes for each type of unit. Most are intuitive, such as ft for foot and g for gram, but a few aren’t, like lbm for pound mass.
To calculate how many litres are in a gallon, I used the formula:
=CONVERT(1, “gal”,”l”)
In the formula, gal is the code for gallon, and l (lower case L) is the code for litre. And yes, it’s way more expensive to make the trip in an RV.
Comment from Alex J
Time: July 4, 2008, 10:58 am
The conversion function in Google is even better! Try “convert 33 mpg to liters per 100 Km” in the search line!
Comment from Debra Dalgleish
Time: July 4, 2008, 8:14 pm
Nice! Thanks for adding that.
Debra