Further with Excel
Intermediate Course

This course follows on from the Microsoft Excel 97 Beginners Course. As this is not a course for beginners, it is assumed that you have a basic working knowledge of Excel and can perform certain elementary tasks. It is designed to guide you through the most important features of the program, using language that is easy to understand and examples that are easy to follow.

Participants will need to prioritise which of the following topics they wish to cover:

• The Open & Save Dialogue Boxes
  storing workbooks
  sorting and opening the files
  the Save As Dialogue Box
  

  Working With Workbooks
  displaying a particular sheet
  moving and copying sheets within a workbook
  deleting and inserting sheets
  

  Absolute References
  using an absolute references
  testing the worksheet model
  

  Filling Cells & Number Series
  fill right/down/across
  autofill -values and series
  autofill - dates/text/numbers
  linear/growth/date series
  

  Custom Lists & AutoComplete
  entering the custom list in the worksheet
  setting up the custom list
  using the custom list
  
  Cell Names & Comments
  naming and defining names
  editing and deleting a comment

• Page Setup
  the page setup dialogue box
  headers and footers
  margins and inserting page breaks
  

• Creating Charts
  moving and re-sizing a chart
  using the chart toolbar
  charts with multiple data series
  
  

• Formatting Charts
  changing the chart type
  selecting chart objects
  combining chart types
  chart titles and axis titles
  
  

• Pictures, Text Boxes & Drawing tools
  inserting a picture
  using the drawing toolbar
  moving and re-sizing objects
  formatting text in a text box
  
  

• Sort, Find & Replace
  excel and databases
  fields and records
  sorting data
  

• An Introduction to Macros
  

• Start and exit Excel.
  
• Use the menus, toolbar buttons and shortcut key combinations.
  
• Change and zoom the view; show and hide toolbars.
  
• Hide and show the Office Assistant reset the Office Assistant tips.
  
• Navigate a worksheet using the mouse and keyboard.
  
• Create new workbooks; enter numbers, text and formulae.
  
• Open, close, save and print worksheets, use Print Preview to view a worksheet as it would be printed.
  
• Select cells and cell ranges; apply various fonts, font sizes and styles; align text within cells; use merge and center.
  
• Copy and move numbers, text and formulae within a worksheet and between worksheets in the same workbook.
  
  

"The sessions will be largely self directed using the latest commercial training manuals, thus allowing you to work at your own pace and cover the topics important to you. You will therefore need to prioritise from this information sheet, prior to the training day, to decide what you want to cover....."

The Trainer/Tutor
Our trainers are all "Quality Assured" and have a wealth of practical experience in the field of computer applications with qualifications to match. We are using the latest in purpose written Information Technology training courseware.


With so much to learn, it's time to get started! GOOD LUCK!