Excel 2007

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

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

Report Setup In Microsoft Excel

Excel’s page formatting features are accessed by clicking on the page layout tab of the Excel ribbon. When working with page formatting, you may also find it useful to enter page layout mode by clicking on the page layout button in the status bar. Adjust the zoom as required and you now have a constantly updated preview of how your document will look when it prints out.

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

Leave a Comment

Tips And Techniques For Making Selections In Microsoft Excel 2007

In this article, we will look at Excel selection techniques which involve using the mouse in conjunction with the keyboard. One of the most useful is click followed by Shift-click. This is particularly useful for selecting large ranges of data since it allows you to simply click on two opposite corners of the rectangular range of cells which you want to highlight. To use this technique, first click in the top left cell of the range you want to highlight. Next, scroll to make the bottom right cell of the proposed range visible. Finally, hold down the Shift key and click on the bottom right cell. All the cells between the two cells that you have clicked on will now be highlighted.

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

Leave a Comment