Information Technology
 
Excel Intermediate

>>DESIGNED FOR
This one day course is for people who are familiar with Windows, have become confident in the essentials of Excel and want to move on to use it in greater depth.

>>AIM
By the end of the course, delegates will be confident in using multiple sheets, linking them to create formulae across sheets, using common functions such as Average and If statements and manage data in an Excel database.

>>OBJECTIVES
By the end of the course, delegates will be able to:

  • Use Absolute Cell References to copy formulae while keeping elements constant.
  • Protect spreadsheets to prevent other users making changes.
  • Create Range Names to speed up movement and printing.
  • Use the Function Wizard to explore the full range of functions available in Excel.
  • Use the IF function to create a conditional result.
  • Create a three dimensional workbook, linking formulas across several sheets.
  • Group sheets together to make the same change to several sheets at once.
  • Export spreadsheet information & charts from Excel to Word, with and without an automatic link.
  • Sort sections of a spreadsheet, according to any column with that spreadsheet.
  • Set up a spreadsheet as an Excel database.
  • Use Auto-Filter to extract all entries that meet a particular criteria.

>>PARTICIPANT NUMBERS

This course is run for a maximum of six delegates.

>>TIME TABLE SESSIONS

  1. Recap; Formulas & Absolute Cell References, Design Principles. Range names,
    Protecting Worksheets
  2. Using the Function Wizard; Common functions - AVERAGE, MIN, MAX, COUNT:
    Basic IF Function, Using COUNTIF
  3. Using multiple worksheets & OLE: Grouping & Linking formula across sheets,
    Pasting to Word -with or without links
  4. Sorting within a database; Using Auto-Filter
>>REQUIREMENTS
Delegates must be confident in the basics of Excel.

Delegates must be confident in entering numbers, text and simple formula into work-sheets and also be familiar with Absolute Cell References (putting $ in formula).
Back to courses  
Excel Intermediate