Microsoft Office Excel 2003

BELIEVE in YOURSELF and INVEST in YOUR FUTURE

Benefits

• Learn how to use this popular spreadsheet program to Microsoft Office Specialist level

• The flexibility and value of a self-study course designed to enable you to work at your own pace

• A personalised workbook to use as a reference guide on completion of the course

• The opportunity to gain the widely recognised Pitman Training Certificate

Course Content

• Lesson One – Including: The Excel 2003 screen, creating a worksheet, entering text and numeric data, navigation, saving, naming and closing, opening an existing spreadsheet, editing cell contents, accessing help

• Lesson Two – Including: Changing font type and size, text enhancement, selecting cells and ranges, text alignment, merging and splitting cells, modifying column width and row height, printing the active sheet, creating a folder, saving in a different format

• Lesson Three – Including: Inserting and deleting rows, switching between multiple workbooks, moving and copying cells, cut, copy and paste, AutoFill, Office clipboard

• Lesson Four – Including:  AutoComplete, Hide and unhide columns and rows, freezing and unfreezing panes, inserting columns, change text orientation, page break preview, changing to landscape orientation, adjusting margins and scaling, centring between margins, displaying gridlines, inserting headers and footers, setting a print area, selecting non-adjacent data, naming and deleting a worksheet, saving a workbook as a template, creating a workbook from a template

• Lesson Five – Including:  Applying borders, formatting numbers, defining and applying styles, Auto Calculate, complex formulas, absolute cell references

• Lesson Six – Including:  Inserting a new worksheet, formatting a worksheet tab, grouping and ungrouping worksheets, 3-D references, applying wrap text formatting, indenting text, printing row and column headings, centring text horizontally and vertically in a range, adding, viewing and editing comments

• Lesson Seven – Including:  Using the SUM and COUNT functions, AVERAGE, MAX and MIN functions, sorting columns, using NOW and IF functions, PMT and FV functions, AutoFilter, find and replace

• Lesson Eight – Including:  Using the Chart Wizard, creating a two series line chart, formatting the plot area, creating a pie chart, saving selected data and a workbook as a web page, inserting a picture, resizing and repositioning, inserting and modifying an object, inserting and using a hyperlink, creating, modifying and positioning a diagram

Duration       

Our Guarantee

Over 50,000 students per year take one of our courses.  Our unique training system has been proven to work with over 98% who complete achieving a pass.

To show how confident we are in our product we guarantee: 

1. To give you a no quibble, full refund should you not be 100% happy following your 1st session.

1. To allow you to re-sit the training and exam at no additional cost, should you not pass 1st time.

1. To allow you to come back at anytime after you’ve completed the course for a free refresher.  We understand that you frequently may learn a skill that you then find you don’t use for a while.