Microsoft
Excel 2007
Introduction

Looking for Excel 2007 training in a friendly, non-threatening atmosphere?

Then come along to our full day Microsoft Excel introduction course. Small class size for greater attention.

Date: Friday 5 November 2010
Venue: Sun House, 23 Queen Edith's Way, Cambridge CB1 7PH
Start Time: 9.30pm
End Time: 4.30pm
Price: £197 (+VAT)

How to book:

• Email karen@roem.co.uk OR
• Call Karen on 01223 214177

Unless otherwise agreed to, payment is due before the training event. Roem Limited reserves the right to refuse entry to any attendee should payment not have been received.

The price includes a Microsoft Office Specialist (MOS) approved seminar handout with a CD packed with exercise files for you to work through and take away, as well as one month post course advice.

The maximum class size is four, providing computer training in a friendly, non-threatening atmosphere. You will be led through each topic and there will be plenty of opportunity for hands-on exercises, questions and individual support. The practical work will be done on laptops using Excel v2007.

Course outline:

Getting Started

• what is Excel?, starting Excel, the Excel application window
• using the Excel menu system, using the Microsoft Office Button
• using the Quick Access Toolbar
• displaying help information
• exiting from Excel

Modifying an existing worksheet

• resetting the working folder
• moving the cell pointer, changing data in a worksheet
• reversing an edit operation, saving a workbook
• adding data to a worksheet
• entering a formula into a worksheet
• adjusting column width in a worksheet
• adjusting row height in a worksheet
• printing a worksheet

Building a new worksheet

• opening a new workbook
• using the spelling checker

Editing a worksheet

• working in edit mode
• selecting ranges in a worksheet
• using autofill
• copying cells, moving cells, clearing cells
• using autosum
• inserting and deleting rows and columns
• inserting and deleting a range of cells

Formatting a worksheet

• resetting the alignment of cell entries
• resetting font options for cell entries
• resetting the number format of cell entries
• adding borders and shading to a worksheet
• using autoformat

Enhancing a worksheet printout

• changing the page setup for a worksheet
• previewing a worksheet
• inserting a manual page break into a worksheet/including print titles in a printout
• printing selected worksheet entries

Using Excel functions

• what is a function? using the SUM function
• using the AVERAGE function, using the MAX and MIN functions
• using the COUNT function, using the insert function button

Final case study

Home   Courses   Word   Excel   PowerPoint   Access   Outlook   Windows   Disclaimer