Wednesday February 15, 2012
When data is imported or copied into a spreadsheet unwanted characters or words can sometimes be included with the new data.
Excel has several text functions that can be used to remove these unwanted characters.
The LEFT function is one such example. It allows you to specify how many characters in a cell you wish to keep and the rest are removed.
To find out the details of using this function read the short tutorial on how to Truncate Text Strings in Excel with the LEFT Function.
Related Tutorials
Friday February 10, 2012
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 in an Excel database. Using the CONCATENATE function these can be combined into one cell when needed.
The data can be words, cell references, blank spaces, or numbers.
To find out all the details read this short tutorial on the Excel's CONCATENATE Function.
Related Tutorials
Sunday February 5, 2012
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 think I have a pretty good idea of where things will go.
Before long, however, I realize that I left out this data or forgot to leave room for that formula
So I often end up adjusting the layout by adding extra cells to the worksheet.
Fortunately, this isn't difficult to do since cells can be added in Excel with a couple clicks of the mouse.
To find out just how easy it is, read this short tutorial on how to Add Cells to an Excel Worksheet.
Related Tutorials
Thursday February 2, 2012
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 functions is the number of criteria that must be matched before a data record is included in the average.
AVERAGEIF looks to match a single criterion while AVERAGEIFS can be used to match from two to 127 criteria ranges.
AVERAGEIFS could be used to pick out data for specific years - allowing you, for example, to average only the profits for the years 2007 and 2009 from a worksheet containing data for the years 2006 to 2010.
To find out more, read the step by step tutorial on the Excel AVERAGEIFS Function.
Related Step by Step Tutorials
