CONVERT NEGATIVE VALUES TO POSITIVE VALUES USING EXCEL

A worksheet contains negative values. To convert all of the negative values to positive values, perform the following steps.

To convert negative values to positive values:

1. Enter a series of negative values in cells B1:B10.
2. Select cell C1 and type -1.
3. Copy this cell.
4. Select cells B1:B10.
5. From the Edit menu, select Paste Special.
6. Select Multiply under Operation.
7. Click OK.

Note: After this, C1 can be cleared.


Watch the Video Tutorial

Microsoft Excel Tutorials,  Convert negative values to positive values using Microsoft Excel,  Microsoft Excel Video Tutorials,  Macros to perform tasks

INCREMENTING ROW NUMBERS USING MICROSOFT EXCEL

Standard row numbering in Excel is often used, but you can also create your own numbering system in a table, such as incrementing by 10 as described below.

To increment row numbers by 10:

1. Select cell A2 and type 0.
2. Select cell A3 and type the following formula: =A2+10.
3. Select cells A3:A12.
4. From the Edit menu, select Fill and Down.

INCREMENTING ROW NUMBERS USING EXCEL

Note: If the value of cell A2 is changed, the values in all other cells change too.


Watch the Video Tutorial


Incrementing Row Numbers Using Excel, Microsoft Excel Tutorials, Microsoft Excel Video Tutorials, Pivot Table Usage In Microsoft Excel

CREATE YOUR OWN TO-DO LIST USING MICROSOFT EXCEL

Generate your own to-do list by entering the hours of the day in column A and your daily tasks in column B.

To generate your own to-to list:

1. Select cell B1 and type =TODAY().
2. Select cell A3 and type 7:00.
3. Select cell A4 and type the following formula: =A3+(1/24).
4. Select cells A4:A14.
5. From the Edit menu, select Fill and Down.

CREATE YOUR OWN TO-DO LIST USING MICROSOFT EXCEL

Note: To get increments of half an hour, use the formula =A3+(1/48). To display column A as shown in Figure 1-9, select Cells from the Format menu, click the Number tab, select Time from the Category list, select 1:30 PM, and click OK.

Watch the Video Tutorial

Formulas in Excel, Microsoft Excel Tutorials, Today Formula in Microsoft Excel, Excel Video Tutorials, Macros Usages

CREATE A QUICK CALENDAR USING MICROSOFT EXCEL

To create a simple calendar, use the Fill command in combination with a formula.

To create a quick calendar:

1. Select cell A1 and type the following formula: =TODAY().
2. Select cell B1 and type the following formula: =A1+1.
3. Select cells B1:G1.
4. From the Edit menu, select Fill and Right.
5. In cell A2, type =A1.
6. Drag the bottom-right corner of cell A2 with the mouse cursor rightward through cell E2.
7. From the Format menu, select Cells.
8. Select Custom under Category.
9. Enter the custom format ddd and press OK.

CREATE A QUICK CALENDAR USING MICROSOFT EXCEL

Watch the Video Tutorial


Formulas in Excel, Microsoft Excel Tutorials, Microsoft Excel Video Tutorials, Macro Lessons In Excel, Macro Tutorials, Create a quick calendar using Microsoft Excel

CALCULATE YOUR IDEAL AND RECOMMENDED WEIGHT USING MICROSOFT EXCEL

Formulas for calculating ideal body weight first came into existence in 1871 when a French surgeon, Dr. P.P. Broca, created this formula (known as Broca’s index): 

Weight (in kg) should equal height (in cm) – 100, 

plus or minus 15% for women or 10% for men 

In recent years, the body mass index (BMI) has become the standard for calculating ideal weight.

To determine ideal and recommended weights:

1. In a worksheet, enter your own data or the data shown in Figure 1-7.
2. Select cell B6 and type the following formula to determine your ideal weight (BMI=body mass index): =(B4-100)*0.9.
3. Select cell B7 and type the following formula to calculate your recommended weight: =B4-100.
4. Calculate the total difference in cells D6 and D7 by simple subtraction.
5. Calculate the difference in percentage in cells E6 (=1-B5/B6) and E7 (=1-B5/B7).
6. From the Format menu, select Cells.
7. Select the Number tab and then select Percentage from the Category list.
8. Set Decimal places to 2 and click OK.

CALCULATE YOUR IDEAL AND RECOMMENDED WEIGHT USING MICROSOFT EXCEL

Watch the Video Tutorial


Microsoft Excel Tutorials, Microsoft Excel Video Tutorials, Calculate Your Ideal and Recommended Weight Using Microsoft Excel, Macros Usage, VB Scripts in Excel

DETERMINE FUEL CONSUMPTION USING MICROSOFT EXCEL

In a worksheet, fuel consumption data is recorded. Each time you refill your gas tank, record the following data: date, miles traveled, and gallons purchased. Then reset the mileage counter. To calculate the fuel consumption of your vehicle, perform the following steps:

To determine fuel consumption:

1. In a worksheet, enter your own data or the data shown in Figure 1-6.
2. Select cells D5:D10.
3. Enter the following formula: =B5/C5.
4. Press <-Ctrl+Enter->.

DETERMINE FUEL CONSUMPTION USING MICROSOFT EXCEL

Watch the Video Tutorial


Microsoft Excel Tutorials, Determine Fuel Consumption Using Microsoft Excel, Microsoft Excel Video Tutorials, Macros, VB Scripts

CONVERT FROM HOURS TO MINUTES USING EXCEL FORMULAS

As a task, time in a timesheet has to be converted from hours to minutes.

To convert time to minutes:

1. In a worksheet, enter your own data or the data shown in Figure 1-5.
2. Select cells B4:B8.
3. Enter the following formula: =A4*24*60.
4. Press <-Ctrl+Enter->.

5. Format cells B4:B8 as general by selecting the Format menu and choosing Cells and General then clicking OK.

CONVERT FROM HOURS TO MINUTES USING EXCEL FORMULAS

Note: To convert minutes to hours and minutes format, use the formula =A4/24/60. Remember to format the cells with a time format, as shown in cell C4 in Figure 1-5.

Watch the Video Tutorial

Microsoft Excel Tutorials, Convert From Hours To Minutes Using Excel Formulas, Microsoft Excel Video Tutorials, How to use Macros in Excel

CONVERT CURRENCY USING MICROSOFT EXCEL

In a worksheet, currency has to be converted from dollars (Column B) to euros (Column C). The rate of exchange from dollars to euros is placed in cell C1; here we use 0.8021.

To convert currency:

1. In a worksheet, enter your own data or the data shown in Figure 1-4.
2. Select cells C4:C8.
3. Enter the following formula: =B4*$C$1.
4. Press <-Ctrl+Enter->.
5. From the Format menu, select Cells.
6. Select the Number tab and then select Currency from the Category list.
7. Choose € Euro.
8. Click OK.

CONVERT CURRENCY USING MICROSOFT EXCEL

Note: To convert euros back to dollars, use the following formula: =C4/$C$1.


Watch the Video Tutorial


Microsoft Excel Tutorials, Convert Currency Using Microsoft Excel, Excel Macro Tutorials, Microsoft Excel Video Tutorials

CALCULATE A PRICE REDUCTION USING MICROSOFT EXCEL

All prices in a price list have to be reduced by a certain percentage. The amount of the price reduction is 15% and is entered in cell C1.

To reduce all prices by a certain percentage:

1. In a worksheet, enter your own data or the data shown in Figure 1-3.
2. Select cell C1 and type -15%.
3. Select cells C4:C8.
4. Enter the following formula: =B4+(B4*$C$1).
5. Press <-Ctrl+Enter->.

CALCULATE A PRICE REDUCTION USING MICROSOFT EXCEL

Note: Please note that the formula must have an absolute reference to cell C1. Also, columns B and C are formatted with the Currency style, which is available by clicking on the $ button on the Formatting toolbar.

Watch the Video Tutorial

Microsoft Excel Tutorials, Microsoft Excel Video Tutorials, Excel Tutorials using Macro, Formulas in Excel, Calculate A Price Reduction Using Microsoft Excel, General Formulas In Excel