Microsoft Excel 2003 Training - Level 2

Delegates attending the intermediate course are already proficient enough to use the basic elements of Excel, but are looking to improve their levels of efficiency and create spreadsheets which are more demanding in their design, and able to offer better solutions to more complex calculations.

The course will introduce the delegates to many of the time saving shortcuts and efficient functions available within Excel. On completion, amongst other skills, the delegate will be able to create links between workbooks, work within the view appropriate to the task in hand and protect worksheets against unwanted changes should a document be circulated for comment.

Course Outline: 

Viewing Worksheets

  • Freeze Columns And Rows
  • Split Windows
  • Hide Columns And Rows

Custom Views

  • Creating A Custom View
  • Use Custom Views
  • Delete Custom Views

Working With Worksheets

  • Copy A Worksheet
  • Rename A Worksheet
  • Move A Worksheet
  • Insert And Delete Worksheets
  • Group worksheets
  • Colour Code Worksheet Tabs

Linking Workbooks

  • Link Within A Workbook
  • Link Between Workbooks
  • Update Links Between Workbooks

Consolidation

  • Consolidate Data

Protecting Data

  • Lock And Unlock Cells
  • Protect A Worksheet

Data Form View

  • Display A Data Form
  • Search For Records By Criteria
  • Add A New Record In Form View
  • Deleting Records In Form View

Sorting Data

  • Perform A Simple Sort
  • Sort On More Than One Column
  • Sort By Rows

Autofilter

  • Use Autofilter
  • Create Custom Filters
  • Use Wildcards In Custom Criteria

Filling A Series

  • Filling A Series
  • Filling A Growth Series
  • Fill Options
  • Create A Custom Series
  • Modify And Delete Custom Series

Summarising Data

  • Create Subtotals

 

back to top ^