Tutorial

Microsoft Excel Navigation Techniques

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

Tags: , , , , , , , , , , , ,

Leave a Comment

Customising Your Excel 2007 Reports With Footers and Headers

Headers and footers are particularly useful for documents that need several pages to print. The header is information printed at the top of each page; the footer at the bottom of the page. There are two ways of working with headers and footers in Excel and both are found in the Page Layout Tab Of the Excel Ribbon. When working in Normal mode, you can access headers and footers by clicking on the Launch button in the Page Setup section. Here, in the Header/Footer tab, you gain access to all of Excel 2007 features relating to headers and footers.

Tags: , , , , , , , , , ,

Leave a Comment

Microsoft PowerPoint 2007 Slide Master Magic

Microsoft PowerPoint 2007’s slide master feature has been significantly enhanced. It now offers users very powerful and flexible control over the appearance of related slides within a presentation. To access the slide master, activate the View Tab of the PowerPoint Ribbon and click on the button marked “Slide Master”. There is also a nifty shortcut for switching between normal view and slide master view: hold down the shift key and click on the Normal View icon on the right of the status bar (next to the zoom icons). The slide master is displayed in the pane on the left of your screen along with the various master slide layouts.

Tags: , , , , , , , , ,

Leave a Comment

Mastering The Essentials Of XML Schema

XML schema definition languages are founded on recommendations laid down by the World Wide Web Consortium (W3C). They use XML 1.0 syntax and aim to explicit describe the structure of XML documents and constrain the data which they may contain. They offer a distinct improvement on the more limited schema features offered by the Document Type Definition (DTD) recommendation which formed part of the original XML specification released in 1998. The most widely used schema language is the one defined by the W3C in 2001: W3C XML Schema. However, there are alternatives, such as RELAX NG and Schematron.

Tags: , , , , , , , , , , ,

Leave a Comment

Using Embedded Charts in Microsoft Excel

Before you can 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.

Tags: , , , , , , , , , , ,

Leave a Comment