| About Spreadsheets |
| Put this feed on your website |
| Description: |
Spreadsheets |
| Format: |
RSS 1.0 |
| Url: |
http://z.about.com/6/g/spreadsheets/b/index.rdf |
| |
| Latest headlines |
About Spreadsheets
|
Combine Text Entries in Excel
Fri, 10 Feb 2012 09:01:00 +0200
Excel CONCATENATE Function© Ted French
Excel's CONCATENATE function can be used to combine data from multiple cells in a spreadsheet.
Names and addresses are often split between two or more cells...
|
Add Cells to an Excel Worksheet
Sun, 05 Feb 2012 01:55:00 +0200
Add Cells in Excel © Ted French
When creating a spreadsheet, the layout I start with is usually not the layout I finish with. Having planned my spreadsheet, I always...
|
Excel AVERAGEIFS Function
Thu, 02 Feb 2012 07:00:00 +0200
Like the SUMIF and SUMIFS functions below, there is also an AVERAGEIF and AVERAGEIFS functions in Excel.
The difference between these two functions that combine the AVERAGE and IF...
|
Excel COUNTIF Function
Sat, 28 Jan 2012 05:41:00 +0200
Excel COUNTIF Function © Ted French
Excel's COUNTIF function combines two other commonly used functions - the COUNT function and the IF function.
The result is that COUNTIF will only...
|
Excel SUMIFS Function
Tue, 24 Jan 2012 06:29:00 +0200
Excel's SUMIFS function is similar to the SUMIF function except that it is used to add up data only if specific criteria are met in two or more ranges of...
|
Excel SUMIF Function
Thu, 19 Jan 2012 07:43:00 +0200
Two of the most useful functions available in Excel are the IF Function and the SUM Function:
The IF function introduces decision making which adds flexibility to your...
|
Excel TRUNC Function
Mon, 16 Jan 2012 01:31:00 +0200
The TRUNC function in Excel is similar to the INT function in that they both remove all decimal places from a number leaving only the whole number.
How they differs...
|
Excel IF Function Step by Step Tutorial
Thu, 12 Jan 2012 06:10:00 +0200
The Excel IF function adds flexibility to your spreadsheets by introducing decision making. It does this by testing a specified condition in your spreadsheet to see if it is true...
|
Rounding Numbers with the CEILING Function
Fri, 06 Jan 2012 09:12:00 +0200
The CEILING function in Excel is similar to the ROUNDUP Function in that they both round the last digit upwards.
How they differs is that while the ROUNDUP function only...
|
Keeping Headings and Titles on Screen in Excel
Mon, 02 Jan 2012 03:35:00 +0200
When working with large spreadsheets, it gets a bit frustrating, when you go to read the data in a distant row or column and the headings at the top of...
|