Learn to Use Microsoft Excel 2003

Learn to USE Range - The 'Learn to Use' series of IT training discs have been developed specifically for helping PC users to become more proficient with key applications without needing to wade through complex books.

The approach is a show and do method, which has proven to deliver outstanding retention of skills, required to become a competent computer user.

From here you can learn the many uses of Excel, beyond the more obvious ability as a spreadsheet

 


Learn to Use Excel 2003

 

Formulas and functions

  • Generate formulas using cell references
  • Recognise and understand errors associated with formulas
  • Understand and use relative, mixed and absolute cell referencing
  • Generate formulas using basic functions
  • Generate formulas using the 'IF' function

Formatting part Two

  • Display cells with specified number of decimal places
  • Format cells to display date style
  • Format cells to display currency symbol
  • Format cells to display numbers as percentages
  • Change cell contents appearance
  • Apply formatting to cell contents
  • Apply colours to cell contents
  • Copy formatting from on cell to another
  • Apply text wrapping within a cell

Formatting part Three

  • Align the contents of a cell
  • Centre a title over a range of cells
  • Adjust cell content orientation
  • Add border effects to a cell or range

Charts and graphics

  • Produce different types of charts and graphs
  • Label an existing chart
  • Change the background colour of a chart or graph
  • Modify the appearance of a chart or graph
  • Change the chart type
  • Move charts or gaphs within a worksheet or between open spreadsheets
  • Resize or delete charts or graphs

Prepare outputs

  • Change worksheet margins
  • Change worksheet orientation
  • Adjust worksheet to fit on page
  • Add or modify text in headers and footers
  • Insert fields such as page numbering
  • Understand the importance of checking spreadsheets prior to distribution
  • Preview a worksheet
  • Switch gridlines on and off
  • Apply automatic titling
  • Controlling printing

Using the application

  • Opening and closing Microsoft Word
  • Introduction to Microsoft Word
  • Opening existing document
  • Opening a new document (Default template)
  • Saving
  • Save as other formats
  • Switch between open documents
  • Using help
  • Closing a document
  • Viewing documents
  • Modify toolbars
  • Display and hide 'non-printing' characters
  • Modify basic options

Main operations

  • Inserting text
  • Inserting special characters and symbols
  • Selecting text
  • Editing text
  • Using undo and redo
  • Duplicating text
  • Moving text
  • Deleting text
  • Using find (Search)
  • Using replace

Formatting part One

  • Change font size and type
  • Apply Bold, Italic and underline formatting
  • Apply subscript and superscript
  • Apply 'Case Changes'
  • Apply colour to text
  • Copy text formatting
  • Apply styles to text
  • Use hyphenation
  • Insert and remove paragraph marks
  • Insert and remove 'Soft carriage return' marks 
     

 


Learn to use Excel 2003

Bulk Buying

If you are interested in buying multiple copies, please contact our Corporate Sales Team. 

 

DescriptionPrice Inc VATPrice Ex VATQty
Learn to use Excel 2003 - CD£10.00£8.51
Learn to use Excel 2003 - Web Delivery£10.00£8.51
 
Home
Products
Support & Training
News & Events
Partners
Contact Us
Shop online
   

Copyright © 2010 ISV Software | Site Map | Contact

thomas ASP TEAM Logo Rev   Career Coaching  rec  british  FirstResponse cash

www.intergage.co.uk