left
left left
PTR

People, Training, Results
Independent Technical IT Computer Training Courses

Call: 0118 979 4000 | Contact us

left
  Home | Schedule | Classroom Courses | Closed Courses | Onsite Courses | One-to-one Training | SaveIT Passport |
spacer
spacer
spacer

Microsoft Courses > Microsoft Excel 2000 Worksheets Training Course


Course Fee = £410   (excl.VAT)


Microsoft Excel 2000 Worksheets Course Outline


Course Description
Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities. Students will learn how to use an electronic spreadsheet to create basic data reports.

Course pre-requisites:
Students enrolling in this course should understand how to use Windows 98/2000/XP. Excel 2000: Worksheets is designed for the student who has had no previous spreadsheet experience. Students who are not familiar with the Windows environment will probably want to first take the following PTR Content course:
  • Windows 98/2000: Introduction


  • Topics covered on the 2 day Microsoft Excel 2000 Worksheets course


    Excel Basics

  • The Paper Spreadsheet
  • The Excel Program
  • The Workbook Environment


  • Entering Data and Navigating in a Worksheet

  • Entering and Correcting Data
  • Saving a File
  • Using Formulas
  • Opening a Second File
  • Navigation and Movement Techniques


  • Modifying a Workbook

  • Working with Ranges
  • Working with Functions
  • Editing Cell Contents


  • Moving and Copying Data

  • Inserting Rows and Ranges
  • Moving Data
  • Copying Data
  • Absolute References
  • Using the Fill Series Feature


  • Formatting a Worksheet

  • Formatting a Worksheet
  • Number Formats and Text Alignment
  • Copying and Pasting Formats
  • Special and Custom Formatting


  • Printing a Worksheet

  • Checking Spelling
  • Using the Print Preview Command
  • Printing a Large Worksheet
  • Additional Print Options


  • Introduction to the Workbook Environment

  • Using a Multiple-sheet Workbook
  • Creating a Chart
  • Outlining
  • Spreadsheet Solutions


  • Creating Excel Web Pages

  • Using Excel as a Web Tool
  • Other Web Options
  • This is an instructor led training course taught in a classroom based environment.

    Course Classification: 

    Course Fee = £410
       (excl.VAT)


    Scheduled course dates
    July 2009 August 2009 September 2009 October 2009 November 2009



    If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite Microsoft Excel Training and bespoke Microsoft Excel courses


    If you want to attend the course but can't make the dates published, then please get in touch as we may well be able to add additional dates to those published or to re-arrange the course. Additionally, you could take advantage of one-to-one training with our SoloIT Training packages that also enables you to attend this course on dates that suit.






    Microsoft Course Index & Training Schedule
    More Microsoft Courses

    Analyzing Requirements and Defining Microsoft .NET Solution Architectures Course

    Implementing Security For Applications Course

    Microsoft Solutions Framework Essentials Course

    Microsoft Excel Macros Course

    Deploying & Managing Microsoft Commerce Server 2000 Course

    Fundamentals of Developing a Business-to-Consumer Solution with Microsoft Commerce Server 2000 Course

    Deploying and Managing E-Business Solutions using Microsoft BizTalk Server 2004 Course

    Building e-Business Solutions with Microsoft BizTalk Server 2004 Course

    Microsoft® Windows® SharePoint® Services 2003 Level 1 Course

    Microsoft® Windows® SharePoint® Services 2003 Level 2 Course

    Microsoft® SharePoint® Designer 2007 Level 1 Course

    Microsoft® SharePoint® Designer 2007 Level 2 Course

    Customizing Microsoft SharePoint Products and Technologies 2003 Course

    Applications Courses
    C Programming Courses
    Cisco Courses
    Citrix Courses
    CIW Courses
    CompTia Courses
    Database Courses
    Exchange Server Courses
    Fortran Courses
    Internet Courses
    ITIL Service Management Courses
    Java Courses
    JSP Courses
    Linux Courses
    MCSD Courses
    MCSE Courses
    Microsoft Courses
    Microsoft .NET Courses
    Microsoft Access Courses
    Microsoft Excel Courses
    Microsoft Outlook Courses
    Microsoft Powerpoint & Visio Courses
    Microsoft Project Courses
    Microsoft Server Products Courses
    Microsoft Word Courses
    Networking Courses
    Oracle Courses
    Perl Courses
    Programming Courses
    Security Courses
    SQL Courses
    Unix Courses
    VBA Courses
    Visual Basic Courses
    Visual Basic 2008 Courses
    Windows 2000 Courses
    Windows Server 2003 Courses
    Windows Server 2008 Courses
    Windows Vista Courses
    Windows XP Courses
    XML Courses
    PTR

    PTR Associates Limited 21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
    Tel: 0118 979 4000 Fax: 0118 979 4035 Email: training@ptr.co.uk

    Privacy Policy | © PTR Associates Ltd

    PTR Associates Ltd is a company registered in England and Wales. Company number 2442290.
    Registered Office: Grenville Court, Britwell Road, Burnham SL1 8DF. VAT Registration Number: GB 532 1929 56

    left