Posts Tagged ‘formulas’

Navigating In Microsoft Excel 2007

In: computers

14 Jun 2009

Each Excel document is called a workbook and each workbook can contain up to 255 worksheets. To navigate to a particular worksheet, click on one of the tabs displayed at the bottom of your screen.

Multiple Document Windows In Microsoft Excel

In: computers

1 Jun 2009

When working in Microsoft Excel, it is probable that you will sometimes need to open more than one workbook at a time. Excel allows you to do this and to display and navigate between the workbooks.

Using COUNT, COUNTA And COUNTBLANK in Microsoft Excel 2007

In: computers

12 Mar 2009

Excel contains a huge range of functions which are conveniently arranged into categories. The COUNT function is found in the statistical category. There are five variations; COUNT, COUNTA, COUNTBLANK, COUNTIF and COUNTIFS. We will examine COUNTIF and COUNTIFS in another article. In this article, we will look at COUNT, COUNTA and COUNTBLANK.

Using The COUNTIF Function in Microsoft Excel 2007

In: computers

28 Feb 2009

The COUNTIF function is used to calculate the number of cells in a given range which satisfy a condition. COUNTIFS does pretty much the same. However, this time, we can specify multiple criteria. By way of illustration, 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 complaints.

Concatenating Data In Microsoft Excel

In: computers

25 Feb 2009

Concatenation is the simply the process of stringing together different pieces of information to form a new piece of data. For example, if say we have columns containing people’s title and first name and another containing their last name, we might use concatenation to create their full name. All we need to do is to string together the title, first name and last name, separated by spaces.

Microsoft Exel’s SUMIF function

In: computers

12 Feb 2009

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.


Categories

Archives

Copyright © 2010 - blabstr.com - is proudly powered by WordPress