Using The Countif AND Countifs Functions In Excel 2007
The COUNTIF function is used to count the number of cells in a given range which satisfy a condition. COUNTIFS does the same. However, here, we can specify multiple criteria. For example, 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.
We would now like to create a summary worksheet…
Understanding The For-each Element In XSLT
Extensible Stylesheet Language (XSL) is a technology closely related to XML which is used to transform XML data. XML file are used to set out the ground-rules for a given body of data and to describe the data itself. XSL allows us to take the original XML data and convert it into information which can be displayed in a web browser window or opened with a text editor. XSL can…
Overview of XML Technologies
Core XML
XML can be found in a growing number of applications nowadays; but what exactly is it? Extensible Markup Language (XML) is a specification by the Worldwide Web Consortium (W3C) for creating markup languages such as XHTML. The XML specification is being used in an increasingly wide range of applications for exchanging data between different environments, platforms and media. One of the main reasons for its rapidly growing…
Developing Spreadsheets Gadgets
code.google.com Justin Kosslyn goes over what spreadsheets gadgets are, and how to develop them.
Using Embedded Chart in Excel 2007
In order to create a chart in Microsoft Excel, you must highlight the data that you want to plot. Your selection should also include any relevant headings. Excel allows you to create charts on chart sheets independent of the worksheet containing the data or to embed the chart on the worksheet alongside the data.
To create a chart which is embedded in the worksheet itself, having selected the range…
XML, SGML and HTML
Extensible Mark-up Language (XML) has very quickly established itself as a viable technology with a huge range of real-world applications. One of the main reasons for its importance and wide acceptance is the fact that it offers a working solution to one of the key problems faced by software developers and computer users alike: the exchange of incompatible data. Each software environment creates its own unique type of…
