Microsoft Excel 2003 Advanced

 Application Options and File Properties

·          View and change application options

·          View and change workbook properties

Using Named Ranges

·          Apply a name to a range of cells

·          Apply a name to a constant value

·          Modify and delete range names

·          Print a list of range names

·          Use a range names and labels in formulas

·          Define and modify a list range

Custom Number and Conditional Formatting

·          Use formatting options with Paste Special

·          Create a custom number or date format

·          Use scientific and fractional number formats

·          Use conditional formatting

Linking Worksheets and Workbooks

·          Create a formula to link worksheets and workbooks

·          Consolidate data using 3D references in common functions

·          Use Paste Special to link worksheets and workbooks

·          Use Paste Special to manipulate data

·          Manage and update linked workbooks

Consolidating Data

·          Use Consolidate to summarise data in multiple lists

Summarising a List

·          Extract data using advanced filters

·          Group and subtotal data using the outlining tools

·          Use D-functions to perform calculations on a data list

PivotTable and PivotChart Reports

·          Create a PivotTable Report

·          Modify PivotTable field layout

·          Modify field settings and grouping intervals

·          Use PivotTable AutoFormat

·          Create a PivotChart Report

Lookup Functions

·          Use VLOOKUP and HLOOKUP to get values from multi-column tables

·          Sort values in rows or from left-to-right

·          Use other lookup functions (LOOKUP, MATCH, INDEX, OFFSET)

·          Prevent lookup errors

Customising a Chart

·          Change the source data for a chart and modify data series

·          Explode segments of a pie chart

·          Insert an image into a chart

·          Add a text box to a chart

·          Store a custom chart as a chart template

Importing Text Data

·          Import data from a text file

Inserting Spreadsheets and Charts

·          Insert a worksheet from Microsoft Excel

·          Insert a chart from Microsoft Excel

Publishing to a Web Page

·          Save a worksheet or chart as a web page

·          Use Web Page Preview

Working with Objects

·          Select, position, and delete an object

·          Resize an object

·         Move or copy an object

If booking for more than one delegate, please contact us on 01189 778562 for discounted prices.