Archive for the 'sub' Category

Array Formula Sumif

Wednesday, April 13th, 2011

The SUMIF() and COUNTIF() functions can only evaluate a single criterion.

Read more..

Excel Sorting features

Wednesday, April 13th, 2011

Excel 2003 has a built-in feature that enables data in a worksheet to be sorted. Sorting data in Excel 2003 can bring important data together, organise its appearance within the document, and allow the user to spot data that are incorrectly formatted or incomplete.

Read more..

Using Customs Formats to Control Numbers

Wednesday, April 13th, 2011

The number formats provided by Excel don’t meet your needs you can easily create your own custom formats.

Read more..

Zeros Accounting Format dash rather than a zero

Tuesday, April 12th, 2011

The accounting format has several advantages but one disadvantage is that it will yield a “–“ (dash) rather than a zero

Read more..

Inserting Symbols in Excel

Tuesday, April 12th, 2011

Microsoft Excel is a fantastic tool for analyzing scientific data. Microsoft Word is a fantastic tool for writing up scientific research. So surely Microsoft Office is the only software a scientist would ever require beyond that associated with specialist scientific apparatus?

Read more..

Excel Easter Eggs Is it real?

Tuesday, April 12th, 2011

In the past the developers of Excel (and most of the other Microsoft Office applications) built in little hidden programs that would run inside the application if you knew the secret sequence of keys. These secret routines were generally humorous and entertaining.

Read more..

Sample Data for Subtotal in Excel 2007

Monday, April 11th, 2011

When you have a massive amount of data, you can let excel calculate the subtotals in your worksheets. All you need to do is group the data by the items to be subtotaled and then tell excel to outline.

Read more..

Formatting Hidden Format

Monday, April 11th, 2011

You can format anything in Excel so it will not appear on the worksheet but still be present in the worksheet. This works for both screen and printing. The custom format characters are three semicolons or ;;;

Read more..

Auto Fill using the Fill Handle

Monday, April 11th, 2011

You can fill in several types of series by selecting cells and dragging the “fill handle” or by using the Series command (point to Fill on the Edit menu, and then click Series). By dragging the fill handle of a cell, you can copy the contents of a cell to other cells in the same row or column

Read more..

Excel VBA and Access VBA

Monday, April 11th, 2011

Similarities between Excel VBA and Access VBA

In theory it should be easy to switch from one MS Office VBA programming language to another, since all the underlying principles are the same

Read more..

Excel Advisor Increasing the size of task bar in separate

Monday, April 11th, 2011

A vertical lookup is an extremely useful – but little-used – feature of Excel. It allows you to link data arranged in a table to data in your spreadsheet by matching a field contained in both the table and the spreadsheet

Read more..

Publishing Your Worksheet To Internet

Monday, April 11th, 2011

Publishing your worksheet on the Internet makes it readily available to anyone who has Internet access. By publishing it on a password protected Web site the Internet becomes a secure and timely method to distribute information.

Read more..

Routing Files with e-Mail

Sunday, April 10th, 2011

You may have noticed that Excel has the ability to send a file as an e-mail or as an e-mail attachment directly from inside of the Excel worksheet.

Read more..

Default Date Settings

Thursday, April 15th, 2010

The default setting for dates (in both cell and in headers and footers) is a format that drops the zeros and gives the shortest date possible.

Read more..