Excel 2007 training courses

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

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

Using Excel’s Print Preview And Quick Print Features

Excel’s Quick Print feature allows you to send a document to the default printer without the need of entering values in a dialog box. If the Quick Print button is not already visible on your Quick Access Toolbar, simply choose it from the Customise Quick Access Toolbar drop-down menu. You will notice that the tooltip which pops up when you position the mouse over the Quick Print button has the name of the default printer in brackets. If the printer shown is not the one you anticipated, you can simply use the regular Print command instead.

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

Leave a Comment