HJDS Computer Services Computer Systems Support and Installation.

PowerPoint audience handouts offer a way of giving the attendees of your presentations something to remember you by. They normally consist of printouts of the presentation; one, two, three, four six or nine slides to a page. Naturally, however, whether or not the essence of your presentation can be captured by this kind of printout depends on the nature of the presentation.

To customize the appearance of handouts, click on the View tab of the PowerPoint ribbon and then click on the Handout Master button. In PowerPoint, masters allow you to determine the format of the three main elements within a presentation; slides, speaker notes and handouts. When you are in handout master mode, the Handout Master contextual tab appears. It contains a Page Setup section which allows you to choose the orientation of both the page as a whole and of the individual slide miniatures. It also contains buttons for activating or deactivating the header, footer, date and page number as well as for formatting the background of the slide.

Given that Microsoft PowerPoint allows you to produce three separate elements (slides, speaker notes and handouts), when the print command is used, you need to specify which of these elements you wish to print. This is done by choosing an option from the Print What drop-down menu. In addition to the three elements mentioned above, you can also print the outline of the presentation.

For presentations containing a fair amount of important detail, it may be more useful to print out the slide outline and distribute it to the audience in place of PowerPoint’s usual handouts. Better still, you can export your presentation into Microsoft Word and then customise it for your audience. To export an outline, from the Office button, choose Publish and then Create Handouts in Microsoft Word.

When exporting to Word in this way, you will be presented with a dialogue box which allows you to choose one of five page layout options. Firstly, you can have speaker notes next to slides. This will create a two column layout with a slide miniature in column one and speaker notes next to it in column two. If you have used the speaker notes feature in your presentation, this may be a useful solution. The second option is Blank Lines Next to Slides: this produces the same two column layout as the first option but the right hand column is blank, so that you can enter notes next to each slide.

The first two options don’t offer you much room for text. If you have made or wish to make extensive notes on each slide, options three and four (Notes below Slides and Blank lines below Slides) provide a layout with the text below the slide miniature and leaves approximately 60 percent of the page free for notes.

If you simply wish your audience to have a summary of the content of the presentation, you can choose the final option: Outline Only. This simply exports the text on each slide into Microsoft Word.

When exporting to Microsoft Word in this way, you have the option of activating Paste Link. This will create a link between the exported file and the original PowerPoint presentation, such that, if the presentation is modified, the exported Word file will also be updated.

Posted under Software

Before you can edit or format your text, you need to highlight it. Highlighting your text is a way of telling Microsoft Word that you want to work with a certain piece of text. (Highlighting is also referred to as selecting.)

The easiest way of selecting text is to position the cursor where you want your selection to start, click and hold the mouse button down and drag to the position where you want to end the selection. It is not necessary to drag across every single line that you want to select. It is sufficient to move in a straight line from start to the finish.

To deselect your text and remove the highlight, simply click anywhere in your text. The flashing text cursor will then reappear.

Another easy way of highlighting text is to select the whole document. This is done using the “Select All” command. In Microsoft Word 2007, the “Select All” command can be found in the “Editing” group of the “Home” Tab. Click to display the “Select” drop-down menu then choose “Select All”.

The “Select All” command can be found in lots of programs and lots of different environments. It can also be done via the keyboard using Control-A: that is to say, keep the Control key held down while typing “A”.

As well as highlighting character by character, Word also allows you to select complete lines. To do this, move the cursor into the left margin and you’ll notice that it changes to an arrow pointing to the right. When the cursor changes, simply click to highlight a single line or click and drag to highlight several lines.

Another way of highlighting text is to click multiple times. To highlight a word, double click on the word; to highlight an entire paragraph, click three times on the paragraph.

It is also possible to select text using the mouse and keyboard. This normally involves using the Shift key. One such technique is click then Shift-click. First, you click to position the cursor at the start of the text to be highlighted; next hold down the Shift key and click to mark the point where you want the highlighting to end. All the text between the two clicks will now be selected.

To highlight text without the mouse, use the cursor keys on your keyboard to position the cursor where you want your highlight to begin. Next, press Shift in conjunction with one of the cursor keys. To highlight character by character, press the right or left cursor key depending on the required direction. To highlight line by line press the down or up cursor key.

The Shift key can also be used in conjunction with Control. For example, if you hold down the Control and Shift keys and press the right arrow, you will select word by word instead of character by character. In a similar way, if you hold down Shift and Control and press the down arrow, you will select paragraph by paragraph.

The Home and End keys can also be utilised in this context. For example, if the cursor is in the middle of a line, pressing Shift and Home will select from the cursor position to the start of the line while pressing Shift and End will select from the cursor position to the end of the current line. Holding down Control and Shift and pressing the right cursor key will select from the cursor position to the start of the document. Control, Shift and End will select from the current position to the end of the document.

Posted under Software

One of the pivotal components of the Microsoft Office 2007, Excel is a uniquely powerful spreadsheet. If you bought this sophisticated piece of software, it makes sense to ensure that your staff members know how to use it effectively. Having allowed them a week or two to get used to the new environment and go through some online tutorials, you will probably want to get them properly trained. Tutor-led software training has the benefit that delegates are able to ask questions as they learn and have complex concepts explained and demonstrated to them until they fully understand them.

Sending your people on a public Excel course is one possibility. However, increasingly companies are demanding to have this training customised to meet their specific demands. Microsoft Excel can be used for a variety of data analysis and storage tasks: not everyone uses it in the same way. Perhaps you will be using it for complex business modelling. Or, you may be using it to create interactive forms and reports complete with complex calculations. Maybe your staff will be using the program in a database role recording information under column headings. Booking a customised course will ensure that you only pay for instruction which is relevant to your requirements and reflects the way in which you will be using Microsoft Excel.

Before you start contacting Excel training companies, it would be a good idea to ensure that you have a clear idea of what you want to achieve by using Excel and that your expectations are realistic. When you approach training companies, you should make it clear that you do not simply want them to deliver their standard Excel courses but that you require a customised programme of training. Between you, a schedule of topics to be covered should then be drawn up and the duration of the program decided.

The customisation process may also involve identifying different requirements within your own organisation. Different people may need to do different tasks with the program and therefore need different skills. For example, some of your users will be primarily interested in using Excel for business analysis and projection. Their primary areas of interest will be the “What if” analysis tool like goal seek, scenarios and pivot tables. On the other hand, you may have people who are interested in create charts and reports either for printing or for use in PowerPoint presentations.

Most training companies offering customised Excel courses should be willing to accommodate the specific needs of your organisation and the different profiles of the staff members: accounts, sales and marketing, etc. Between you, you can then create a program of study which satisfies the needs of all users. Perhaps this may mean, having different courses for users with different profiles or perhaps the best approach will be a modular one whereby some modules are taken by everyone while others are only attended by certain user groups.

Posted under Software