Archive for August, 2007

How to Hide the Worksheet ?

Making a worksheet very hidden
You can use Excel’s Format, Sheet, Hide to hide an entire worksheet. But unless you password-protect the workbook structure, anyone can select Format, Sheet, Unhide to see the hidden sheet.
There is another option:

Press Alt-F11 to display the Visual Basic Editor

in the Project window, double-click Microsoft Excel Objects [...]

Combining Text and Values in one cell

Text and values in one cell
How can you combine text and values in a single cell?
For example, lets say cell A1 contains the value 1977.
Enter the following formula into another cell:
=”Total: “&A1

The formula cell will display: “Total: 1977.”
The ampersand is a concatenation operator that joins the text with the contents of [...]

Copying Excel into Powerpoint

Copying Excel into Powerpoint
How to include an Excel spreadsheet into one of your Powerpoint presentations? It seems to be very difficult. The cells never seem to line up properly or not all of the spreadsheet seems to copy across.

Try with the Copy Picture function in Excel?
Hold down the Ctrl and Shift keys. [...]

Copy Page Setup Settings to other sheets

Copy Page Setup settings to other sheets
Excel sheet has its own print setup options (orientation, margins, headers and footers, and so on). These options are specified in the
Page Setup dialog box, which you access using the Fil > Page Setup command.

When you add a new sheet to a workbook, it contains the [...]

Converting Time Zone Values

Converting Time Values from One Time Zone to Another

Problem:
Listed in B1:E2 are several destinations and their hourly time difference with New York.We want to convert the time value in B3 (New York local time) to the equivalent local time in each destination city.
Solution:With destinations in C1:E1 and time differences in C2:E2, enter the following formula [...]

Conditional Formatting in Excel

Conditional Formatting:

You can format your cells appearance based on up to three different criteria. This can be used to help color code a gradesheet, expense sheets or other data. You can also use it to create simulations. To access this feature, select a group of cells and choose Format > Conditional Formatting from the [...]

Calculate Years, Months, Days elapsed

Calculate Years, Months, Days elapsed from a certain date in Microsoft Excel

In order to calculate the time elapsed from a certain date, we will use a any date as an example
Enter date in cell A1: 01/01/1980
To calculate the number of years from the date, enter the following formula in cell B1: =YEAR(TODAY())-YEAR(A1)
The result (rounded): [...]

Calculate number of Minutes between Dates

Calculate number of minutes between dates - time in Microsoft Excel

Data in cell A1:B2

A

B

1

End Date/Time

05/11/2003 15:33

<– =NOW()

2

Start Date/Time

10/01/2002 9:33

<– =NOW()-222.25

Formula in cell E2: =(B1-B2)*1440 ( 24 hours*60 minutes=1440 )
Format in cell E2: regular number format
Result: 320,040 minutes