filed in behavior dog and training on Feb.08, 2010
The COUNTIF function enables us to count the number of cells in a given range which satisfy a condition. COUNTIFS does exactly the same. However, with COUNTIFS, we can specify multiple criteria. For instance, let’s say we have a worksheet containing four columns: the date, the number of phone calls received, the number of complaints and the percentage of calls which were actually complaints.
Tags: behavior dog and training, computer software, computers, Excel 2007, Excel 2007 training courses, formulas, FUNCTIONS, Microsoft Excel 2007, Microsoft Office 2007, software programs, Training, Tutorial
filed in behavior dog and training on Feb.03, 2010
Excel boasts a huge range of functions which are conveniently arranged into categories. The COUNT function is found under the statistical category. There are actually five COUNT functions; COUNT, COUNTA, COUNTBLANK, COUNTIF and COUNTIFS. We will look at COUNTIF and COUNTIFS in another article. In this article, we will examine COUNT, COUNTA and COUNTBLANK.
Tags: behavior dog and training, computer software, computers, Excel 2007, Excel 2007 training courses, formulas, FUNCTIONS, Microsoft Excel 2007, Microsoft Office 2007, software programs, Training, Tutorial
filed in behavior dog and training on Feb.01, 2010
Most Excel users have encountered the SUM function. It is one of the most widely used functions within the program. And most Excel users will also have used the IF function at some stage. The SUMIF function is really just a combination of SUM and If which allows us to calculate the total of all cells within a given range that match a certain condition.
Tags: behavior dog and training, computer software, computers, Excel 2007, Excel 2007 training courses, formulas, FUNCTIONS, IF, Microsoft Excel 2007, Microsoft Office 2007, software programs, SUM, SUMIF, Training, Tutorial
filed in behavior dog and training on Jan.31, 2010
As well as using and modifying Excel’s own built-in cell styles, you also have the option of creating your own. One convenient method of doing this is to select a range of cells and apply all the formatting attributes that you want to add to your style and then convert those attributes into a cell style. When you create a cell style, Excel will pick up all the attributes from the selected cells and include them in the style. Let’s say, by way of illustration, we want to create a cell style for headings with text angled at 45 degrees.
Tags: behavior dog and training, cell styles, computer software, computers, Excel 2007, Excel 2007 training courses, formulas, FUNCTIONS, Microsoft Excel 2007, Microsoft Office 2007, software programs, Training, Tutorial
filed in behavior dog and training on Jan.30, 2010
Excel offers a very wide variety of formats that you can apply to your cells. Naturally, as you build your worksheets you want your formatting to be consistent. Cell Styles provide an excellent way of achieving this.
Tags: behavior dog and training, cell styles, computer software, computers, Excel 2007, Excel 2007 training courses, formulas, FUNCTIONS, Microsoft Excel 2007, Microsoft Office 2007, software programs, Training, Tutorial
Powered by WordPress and BlackSplat.
:)