investors in people REC member one group many options
 

Microsoft Excel 2003 Intermediate

Details

Time: 09:00 to 16:00
Venue: AP Training Room
Cost: £295
Included in the price: Learning manual for the course; lunch, refreshments and post-course support.

Course Description

Microsoft Excel 2003 Intermediate is designed for users who are keen to extend their understanding and knowledge of the software.  The skills and knowledge acquired in Microsoft Excel 2003 Intermediate are sufficient to be able to use and operate the software at an efficient level.

Course Design

The course is a full-day tutor-led course that combines tutoring and practical work.

Target Audience

Microsoft Excel 2003 Intermediate assumes little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers, the Windows operating system environment and to have used a mouse and keyboard.  This course is intended for persons pursuing a Microsoft Office specialist certification in Microsoft Excel 2003 or for those in employment that involves using Microsoft Excel to create spreadsheets, maintain and format worksheets and workbooks, sort and filter data and understand the concept and to create formulas and functions within spreadsheets.

Learning Objectives

On completion of Microsoft Excel 2003 Intermediate, you should be able to:

  • Work with one or more workbooks at once
  • Use a range of techniques to work with worksheets
  • Adjust the sizing of columns and rows in a workbook
  • Use a variety of viewing techniques to view worksheets
  • Format cells in a workbook
  • Understand and use absolute referencing in a workbook
  • Use the fill technique to enter data into cells
  • Use names and labels
  • Use a range of logical functions
  • Use the various Lookup functions
  • Sort data in lists in a workbook
  • Use Autofilter to display data in lists selectively

 
Course Content

Working with Workbooks

The open dialogue box
  • Opening and closing a workbook
  • Opening multiple workbooks
  • Working with multiple workbooks
  • Opening recently used workbooks
  • Compare workbooks side by side
  • Saving under a different name
  • Saving to a text file
  • Saving as a template
  • Saving to earlier Excel versions
  • Saving an a XML file
  • Saving to Lotus 123

    Working with Worksheets

    • Switching between worksheets
    • Copying a worksheet
    • Renaming a worksheet
    • Moving a worksheet
    • Inserting and deleting a worksheet
    • Grouping worksheets
    • Colour-coded worksheet tabs
    • Inserting a new worksheet
    • Deleting a worksheet
    • Copying a worksheet to another workbook
    • Moving a worksheet to another workbook
    • Hiding and unhiding worksheets

    Adjusting a Worksheet

    • Inserting and deleting cells
    • Inserting and deleting columns
    • Inserting and deleting rows
    • Resizing columns and rows
    • Hiding gridlines

    Viewing Worksheets

    • Freezing columns and rows
    • Splitting windows
    • Using zoom
    • Hiding rows and columns

    Formatting Cells

    • Using the font tools
    • Using the alignment
    • Using the number tools
    • The format cells dialogue box
    • Formatting fonts using the menu
    • Superscript and subscript
    • Strikethrough
    • Changing horizontal alignment using the menu
    • Merging cells
    • Changing text orientation
    • Changing vertical alignment
    • Text wrapping
    • Formatting dates, numbers and currency
    • Custom formats
    • Borders and shading
    • Clearing cell formatting
    • Absolute Referencing
    • The concept of absolute and relative referencing
    • Problems with relative formulas
    • Tracing precedents
    • Creating absolute references
    • Creating mixed references
    • Circular referencing
    • Tracing dependent cells

    Filling Series

    • Filling a series
    • Filling a growth series
    • Filling a series backwards
    • Filling using options
    • Creating a custom series
    • Modifying and deleting a custom series

    Labels and Names

    • Labels and names explained
    • Accepting labels in formulas
    • Using text labels
    • Creating labels
    • Creating names using the names box
    • Using names to select cells
    • Using names in formulas
    • Creating names between workbooks
    • Creating names for constants
    • Creating a list of names
    • Changing the range of names
    • Deleting names

    Logical Functions

    • Logical function concepts
    • Displaying information using IF
    • Displaying values using IF
    • Nesting an IF function
    • Using the AND function
    • Using the OR function
    • Using the NOT function

    Lookup Functions

    • Requirements of lookup functions
    • The CHOOSE function
    • The ISERROR function
    • The VLOOPUP function
    • Testing lookup functions
    • Using VLOOKUP for exact matches
    • Using the HLOOKUP function
    • The INDEX function

    Sorting

    • Performing a simple sort
    • Sorting on more than one column
    • Sorting numbers
    • Sorting by rows
    • Sorting in ascending and descending alphabetical order
    • Sorting in ascending and descending numerical order
    • Creating a custom sort list
    • Performing a custom sort

    Auto Filter

    • Applying and using Auto filter
    • Creating compound filters
    • Creating custom filters
    • Multiple value criteria
    • Using wildcards in custom criteria