0 comments on Let’s see how Excel can help with metric and American Standard conversions

Let’s see how Excel can help with metric and American Standard conversions

Let Excel do the currency and metric conversions you need for your global business or travel. The following Excel functions can be used in Europe with the metric system (officially called International System of Units or SI) and the euro currency. Once you calculate the spreadsheet functions, you can use the various Excel apps to run the programs on your smartphone or tablet.

Fahrenheit to Celsius

To convert temperatures from Fahrenheit to Celsius, subtract 32 from the Fahrenheit number, then divide the difference by 1.8. For example, 175 degrees Fahrenheit minus 32 equals 143, divided by 1.8 equals 79.44 degrees Celsius (close enough for a manual calculation). For Celsius to Fahrenheit, do the opposite: Multiply the temperature by 1.8 and then add 32 to the product.

1. Enter 10 Fahrenheit numbers in cells A2-A11.

2. Enter this formula in cell B2: =(A2*1.8)+32.

3. Copy the formula down thru B11 and press Enter.

fahrenheit to celcius

4. Highlight column A. Under the Home tab’s Cells group, click Format > Format Cells.

5. Choose the Number tab and scroll down to Category > Custom.

6. In the Type field, enter 0.0, then press Alt+0176 on the numeric keypad, and click OK.

Notes: Alt+0176 is a combination keystroke: Hold down the Alt key, press 0176, then release both. Alt-key symbols do not work with the numbers across the top, only with the keypad. The format for Fahrenheit looks like this: 0.0°

7. Follow the same instructions for Celsius, but add a capital ‘C’ after the degree symbol: 0.0° C.

Format cells fahrenheit

02 Format Cells Fahrenheit

Dollars to euros

Before you can convert dollars to euros and vice versa, you must check the exchange rate, which you can get by searching online using the current date (or calling a bank). Once you have that rate (e.g., 1.30 euros to 1 dollar), divide the dollars by 1.3 (which, for $100 is 76.92 euros).

1. Enter 10 numbers (to represent dollars) in A2 through A11.

2. Enter today’s exchange rate for dollars to euros in cell C2: 0.94

3. Enter this formula in B2: =A2*$C$2. Use the Absolute Reference function key F4 to add the dollar signs, or enter them manually.

Note: In this case, we want to multiply each of the values in column A by the exchange rate in cell C2. The Absolute Reference/dollar signs tell Excel not to use Relative cell references (cell addresses that change based on the relative location).

4. Copy the formula from B2 down to B11.

Dollar to Euros

Convert Dollars to Euros

5. Press Ctrl+1 to access the Format Cells menu.

6. From the Number tab, select Currency.

7. On the right side of the dialog window, click the down arrow beside the Symbol field.

8. Choose Euro from the list, and click OK.

Dollar to Euros

Format for Dollars to Euros

Miles to kilometers (per hour)

Most European countries except the United Kingdom, use kilometers (i.e., six-tenths of a mile) instead of miles. In decimal terms, a kilometer (km) is 0.62 miles, and a mile is 1.61 kilometers.

1. Enter 10 numbers (to represent miles) in A2 through A11.

2. Enter the conversion number for miles to kilometers in cell C2: 0.621371

3. Enter this formula in B2: A2/$C$2.

4. Again, use function key F4 to make the value in C2 absolute.

5. Copy the formula down to B11.

6. Use the Decrease Decimal button under the Home tab’s Number group to decrease the decimal places to four.

Miles to Kilometer

Convert Miles to Kilometers

Feet to meters

One meter is 3.28 feet—a tad longer than a yard. Therefore, 10 meters is 32.8 feet, or about 11 yards. For driving purposes, one thousand meters equal 1 kilometer, which is 0.62 miles. This one is easy.

1. Enter 10 numbers (to represent feet) in A2 through A11.

2. Enter the conversion factor for feet to meters in cell C2: 3.28

3. Enter this formula in B2: =A2/$C$2

4. Use function key F4 to make the value in C2 absolute.

5. Copy the formula down to B11.

6. Use the Decrease Decimal button under the Home tab’s Number group to decrease the decimal places to four.

Feet to Meters

Convert feet to meters

Feet per minute to meters per second

1. Enter 10 numbers (to represent feet) in A2 through A11.

2. Enter the conversion factor in cell C2: 196.858144

3. Enter this formula in B2: A2/$C$2

4. Again, use function key F4 to make the value in C2 absolute.

5. Copy the formula down to B11.

6. Use the Decrease Decimal button under the Home tab’s Number group to decrease the decimal places to four.

Feet to Meters

07 Feet per minute to meters per second

Liters to gallons, quarts, pints, etc.

A liter is a little more then a quart. More precisely, there are 3.8 liters in 1 gallon. For gasoline; however, just multiple the number of liters by four to get the approximate per-gallon price, which, by the way, is in euros, not dollars.

1. Enter 10 numbers (to represent liters) in A2 through A11.

2. In B1, enter the header Gallons; in C1, enter Quarts; and in D1, enter Pints.

3. Enter this formula in B2: =A2/3.785411784

4. Enter this formula in C2: =A2*1.0566882094326

5. Enter this formula in D2: =A2*2.1133764188652

6. Use function key F4 to make the values Absolute.

5. Copy the formulas down to B11, C11, and D11.

6. Use the Decrease Decimal button under the Home tab’s Number group to decrease the decimal places to four.

Convert Liters to Gallons, Quarts, and Pints

Tips about European conversions

As you work with European numbers, you’ll notice some key differences:

1. Notice the way numbers are written. For example, ones swing upward and look like the caret symbol, fours look like triangles on a stick, and sevens are crossed.

2. Dates are written as day/month/year, and commas are written as decimal points, while decimals replace commas.

3. Phone numbers use periods instead of dashes, and the pound sign is never used as a number sign.

4. The bottom floor in hotels and apartments is called the ground floor. The first floor is what we’d call the second story.

5. Street addresses are not chronological or based on which side of the street the building resides.

6. Lastly, phone numbers, area codes, and postal codes are quite different.

Source and Image Copyright: PC World

0 comments on Office Setup Product Key FAQ’s

Office Setup Product Key FAQ’s

Where to enter your Office product key

Applies To: Office 2016 Office for home Office 2016 for Mac Office 2013

If your purchase of Office came with a product key, you enter your product key on a website. After you enter your key, you can download and install Office, or you can renew your Office 365 subscription.

Example of an Office product key:

XXXXX-XXXXX-XXXXX-XXXXX-XXXXX

Office Product Sample Key

My product key isn’t working

First, make sure that you’re entering the key correctly on the right site. If you aren’t sure which site to use, you can enter your product key using the www.office.com/setup. If your product key is valid, the Virtual support agent provides a link to download Office. The Virtual support agent can also let you know if your product key has been blocked and can connect you to a live agent.

If your Office product key doesn’t work, or has stopped working, you should contact the seller and request a refund. If you bought a product key separate from the software, it’s very possible the product key was stolen or otherwise fraudulently obtained, and subsequently blocked for use. Unfortunately, there are many dishonest sellers who offer stolen, abused, or otherwise unauthorized Microsoft product keys for sale. Sometimes these product keys are printed on counterfeit labels or cards with a download link to Microsoft software, and sometimes they’re distributed with software media that is unauthorized for resale, such as promotional media, original equipment manufacturer reinstallation media, or other Microsoft program-specific media.

Still Having problems with your product key?

The way you can find your product key depends on how you got Office 365, Office 2016, or Office 2013. Select how you got Office from the options below.

Here are some FAQ’s that will help you to find and use your product key effectively:

I already installed Office and want to view my product key

For security reasons, the full product key isn’t displayed within Office or Windows.

Instead, you can do one of the following:

  • View the Microsoft account that’s associated with your Office install. You can do this by opening a document in Word 2016 (or any Office app) and going to File > Account.Look for the email address after Belongs to below the product name. This email address takes the place of your product key. You can use this account to reinstall Office from My Office Account and to reactivate Office without a product key.

    Subscription Product

    • View the last 5 characters of the product key. You can do this by using the command-line method described in Manage multiple one-time-purchase Office installs.
    • View the full product key for one-time purchases of Office. You can view the full product key for Office Home & Student, Office Home & Business, and Office Professional on the My Office Account page. Here’s how:
    1. Go to My Office Account and sign in, if prompted.
    2. Select your Office product.
    3. Select View your product key. Note that this product key will be different from the product key shown on an Office product key card for the same purchase.Office Home Screen ShotDo you manage several installations of Office that are all tied to one Microsoft account? Did you lose track of which product key was used to install Office on which PC? If you answered yes to these questions, see Manage multiple one-time-purchase Office installs that use the same Microsoft account to learn how to identify which Office product key was used to install Office on each PC.

      If you have already installed multiple one-time purchases of Office and activation is failing on subsequent installs, see Change your Office product key.

0 comments on Office for Home and Office for Business plans

Office for Home and Office for Business plans

Office for home

Office 365 subscriptions: These include the fully installed Office applications.

Office 365 Home
Office 365 Personal
Office 365 University

Office 2016 or Office 2013 versions available as one-time purchases: These include the fully installed Office applications.

Office Home & Student
Office Home & Business
Office Professional
Office Professional Plus*

Stand-alone Office 2016 or 2013 apps available as one-time purchases

Word
Excel
PowerPoint
OneNote
Outlook
Access
Publisher
Project
Visio

Office for business

Office 365 Subscriptions: These include the fully installed Office applications.

Office 365 Business
Office 365 Business Premium

Office 365 Education E5

Office 365 ProPlus
Office 365 Enterprise E3
Office 365 Enterprise E4
Office 365 Enterprise E5

Office 365 Nonprofit Business Premium
Office 365 Nonprofit E3
Office 365 Nonprofit E5

Office 365 U.S. Government Community G3
Office 365 U.S. Government Community G5

Project Online Professional
Project Online Premium

Visio Pro for Office 365

Office 365 Subscriptions without fully installed Office applications:

Office 365 Business Essentials

Office 365 Enterprise E1

Office 365 Education

Office 365 Nonprofit Business Essentials
Office 365 Nonprofit E1

Office 365 U.S. Government G1

Project Online Essentials

Volume license versions of Office 2016 or Office 2013

Office Professional Plus