Excel Intermediate

Excel / Intermediate

Objective:

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.

Duration: 1 day 9.30 am – 4.30 pm

Further Training: Excel Advanced


Course Outline:

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
  
  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
  
  
  Price: £220 per delegate