public marks

PUBLIC MARKS from smartestbiz with tag "EXCEL 2007"

March 2009

Creating Split Worksheet Views In Microsoft Excel

by 1 other
The Split command can be found in the View Tab of the Excel Ribbon. It allows you to split an Excel spreadsheet window into either two or four individual panes and is particularly useful for comparing data in different parts of a large worksheet.

Excel 2007 COUNTIF AND COUNTIFS functions

by 1 other
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 fo...

Microsoft Excel 2007 Functions: COUNT, COUNTA And COUNTBLANK

by 1 other
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 a...

February 2009

Using Different Formatting In The Same Cell In Microsoft Excel

by 1 other
When changing the appearance of text within an Excel worksheet, you have the choice of working on the entire cell or at the text level. To work at the cell level you simply highlight one or more cells and choose your formats. The formats that you choos...

Customising Text Alignment Microsoft Excel 2007

by 1 other
The alignment section of the Home Tab of the Excel ribbon contains a number of options relating to the way in which your data is position within the cell. Perhaps the most familiar and the most frequently used buttons in this section are the three rela...

Microsoft Excel 2007 Text Alignment Options

by 1 other
The alignment section of the Home Tab of the Excel 2007 ribbon is home to a number of options relating to the way in which your data is position within the cell. The most familiar and most frequently used icons in this section are the three relating to...

Customising Text Alignment Microsoft Excel 2007

by 1 other
The alignment section of the Home Tab of the Excel ribbon contains a number of options relating to the way in which your data is position within the cell. Perhaps the most familiar and the most frequently used buttons in this section are the three rela...

Customising Text Alignment Microsoft Excel 2007

by 1 other
The alignment section of the Home Tab of the Excel 2007 ribbon is home to a number of options relating to the way in which your data is position within the cell. The most familiar and most frequently used icons in this section are the three relating to...

December 2008

Excel 2007 Number, Currency And Accounting Formats

Often, when you enter numbers into a spreadsheet, you need to ensure that the number format is consistent. For example, if these numbers are prices, you may want to display the currency symbol or you may simply want to specify that the number of decima...