Excel Intermediate

This course is run in conjunction with pass training, a Microsoft Certified Partner and Microsoft Office User Specialist (MOUS) Authorised Testing Centre. Pass training is a Numerica Group Plc Company.
Course Objectives

To give users an extended knowledge of the features and functions within Excel and realise the advantages of using a powerful electronic spreadsheet. Delegates will learn how to create and modify spreadsheets, enhancing them with charts and graphics and using more advanced formulae.


Delegates:
Maximum 8

This course is suitable for users with a basic understanding of Excel who want to consolidate and expand on their knowledge of the basic features in a short space of time. Familiarity with the basic features of Excel is required, gained either by previous experience or by attendance on an "Excel Introduction" course.

Delegate numbers are restricted to 8, to ensure personal attention from the trainer.

Structure:
PC for every delegate 		All pass training courses involve extensive hands-on activity including exercises that give participants practical experience of using Excel's tools.

Course details

Subject to change without notice.

Excel Intermediate
  • Intermediate Spreadsheet Functions and Features
  • Reviewing the Basic
Formatting the Worksheet
  • Adding Borders and Shading
  • AutoFormats
  • Copying Formats
  • Text Formatting
  • Indented List
Using Styles
  • Creating and Applying a New Style
  • Modifying Styles
Navigating Worksheets and Workbooks
  • Opening a Second Workbook
  • Working with Large Sheets
  • Using Zoom
  • Worksheet Linking
Using More Advanced Formulae
  • Preventing Rounding Errors
  • Conditional Formulae (IF, AND and OR)
  • The Formula Palette
  • Financial Functions (PMT, FV, PV)
Productivity Features
  • Protecting the Worksheet
  • Hiding Data
  • AutoCorrect
  • The Spelling Checker
Charts and Pictures
  • Creating Charts
  • Changing Chart Elements
  • Changing Chart Data
  • Printing Charts
  • Inserting Clip Art and Pictures
  • Drawing Objects
  • Manipulating Objects
Excel and the Internet
  • Creating Hyperlinks
  • Saving a Worksheet as a Web Page
  • Web Page Preview
  • Sending Worksheets and Workbooks Via E-mail
I want more information:
Phone Me

Duration:

1 day, 9.30am - 4.30pm

Booking

Title First name Last Name
Organisation
Address
Postcode
e-mail address
Phone number
fax number

Course dates 2004                                                                                                                       

 The above course costs £210.00 + VAT



Top of page | Home | Courses | Students

Contact details:

Roger Woolley FCIS
Woolley & Associates
PO Box 992
Blackheath,
London, SE3 9DQ

Fax: 020 8852 8255
Phone: 020 8852 8260

e-mail info@rogerwoolley.co.uk