Array Formula Sumif
Wednesday, April 13th, 2011The SUMIF() and COUNTIF() functions can only evaluate a single criterion.
Archive for the 'sub' Category
Excel Sorting features
Wednesday, April 13th, 2011Excel 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.
Using Customs Formats to Control Numbers
Wednesday, April 13th, 2011The number formats provided by Excel don’t meet your needs you can easily create your own custom formats.
Zeros Accounting Format dash rather than a zero
Tuesday, April 12th, 2011The accounting format has several advantages but one disadvantage is that it will yield a “–“ (dash) rather than a zero
Inserting Symbols in Excel
Tuesday, April 12th, 2011Microsoft 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?
Excel Easter Eggs Is it real?
Tuesday, April 12th, 2011In 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.
Sample Data for Subtotal in Excel 2007
Monday, April 11th, 2011When 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.
Formatting Hidden Format
Monday, April 11th, 2011You 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 ;;;
Auto Fill using the Fill Handle
Monday, April 11th, 2011You 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
Excel VBA and Access VBA
Monday, April 11th, 2011Similarities 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
Excel Advisor Increasing the size of task bar in separate
Monday, April 11th, 2011A 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
Publishing Your Worksheet To Internet
Monday, April 11th, 2011Publishing 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.
Routing Files with e-Mail
Sunday, April 10th, 2011You 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.
Default Date Settings
Thursday, April 15th, 2010The 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.