Excel 2003

Sponsored links

Our Microsoft Excel course is very flexible – you will have the freedom to take the Excel lessons at your own pace, based at one of our handy town or city centre locations, with support on hand should you need it. And a workbook will be yours to take away as a handy reference guide.

This Excel course comprises several lessons, which provide a detailed but manageable study programme, so you can be confident about your new skills in the workplace. Just some of the areas covered include creating worksheets, formatting text, simple and complex formulas; handling rows and columns, autocomplete, using styles, headers and footers, average, max and min functions and using charts.

Delivery:
  • Other
Regions:
  • South East England
Category:

Further Details

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

This Training Course is available at the following locations:
Brighton

Guide Price: POA