Tutor-led Word Excel Powerpoint Outlook Course Dates Other

EXCEL 2003: LEVEL1

Click here for Excel Level 2


Course Objectives:
You will create and edit basic Microsoft Office Excel 2003 worksheets and workbooks

Target Students:
This course is designed for persons preparing for certification as a Microsoft Office Specialist in Excel, who already have knowledge of the Microsoft Office Windows 98 (or above) operating system, and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Excel 2003 worksheets.

Pre-requisites:
To ensure your success, we recommend you first take the following Element K course or have equivalent knowledge: Windows: Introduction
 

   Course Content:

 

  • Getting Started with Excel

    An Overview of Excel

    Navigate in Excel

    Select Data

    Enter Data

    Save a Workbook

    Obtain Help
     

  • Modifying a Worksheet

    Move and Copy Data Between Cells

    Fill Cells with Series of Data

    Edit Cell Data

    Insert and Delete Cells, Columns, and Rows

    Find, Replace, and Go To Cell Data

    Spell Check a Worksheet
     

  • Performing Calculations
    Create Basic Formulas
    Calculate with Functions
    Copy Formulas and Functions
    Create an Absolute Reference

  • Formatting a Worksheet

    Change Font Size and Type

    Add Borders and Colour to Cells

    Change Column Width and Row Height

    Merge Cells

 

  • Apply Number Formats

    Create a Custom Number Format

    Align Cell Contents

    Find and Replace Formats

    Apply an AutoFormat

    Apply Styles
     

  • Developing a Workbook

    Format Worksheet Tabs

    Reposition Worksheets in a Workbook

    Insert and Delete Worksheets

    Copy and Paste Worksheets

    Copy a Workbook
     

  • Printing Workbook Contents

    Set a Print Title

    Create a Header and a Footer

    Set Page Margins

    Change Page Orientation

    Insert and Remove Page Breaks

    Print a Range
     

  • Customizing Layout

    Split a Worksheet

    Arrange Worksheets

    Freeze and Unfreeze Rows and Columns

    Hide and Unhide Worksheets
     

 


Benefits

  • A personal workbook to use as a reference guide on completion of the course

  • The opportunity to gain the widely recognised Pitman Training Certificate

Duration: 1 Day


Click here for Excel Level 2










 



( 020 7256 6668

     



  HOME   INVEST IN YOUR TEAM   INVEST IN YOUR CAREER   ABOUT US   COURSES   CONTACT US  

MICROSOFT   SHORTHAND   KEYBOARD SKILLS   DIPLOMAS   BOOKKEEPING   SEMINARS   QUALIFICATIONS   COURSE DATES  

PITMAN TRAINING LONDON
CITY WEST END BANK OXFORD CIRCUS
MICROSOFT OFFICE SKILLS KEYBOARD TYPING IT SHORTHAND ACCOUNTS BOOKKEEPING SECRETARIAL DIPLOMAS
ECDL MOS EXAMS MICROSOFT WORD EXCEL POWERPOINT ACCESS OUTLOOK FRONTPAGE 2003 2007
WARNFORD COURT 29 THROGMORTON STREET LONDON EC2N 2LT
WALMAR HOUSE 288 REGENT STREET LONDON W1B 3AL