Return to pass home page | About pass | Request A Brochure | Contact Us | Sitemap   

     

Excel Intermediate Course Details

Excel Intermediate

  • Intermediate Spreadsheet Functions and Features
  • Reviewing the Basics

Formatting the Worksheet

  • Adding Borders and Shading
  • AutoFormats
  • Copying Formats
  • Text Formatting
  • Indented Lists

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

BACK to Excel Intermediate

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

Regulatory & Legal Notices


Pass Training, London. Computer training, Accountancy training, Auditing and taxation courses, personal Development, and Business Development training courses in London UK
66 Wigmore Street, London, W1U 2SB (UK)
 Tel: 020 7284 4995   Fax: 020 7284 2966
 Email: info@pass.co.uk