MS Excel 2002: Next Step with Excel

This course extends the learner’s basic knowledge of Excel 2002. You will learn additional skills to produce more effective and productive workbooks. It covers formula and function techniques, more intricate formatting, PivotTables, using intricate charting features, and working more effectively with existing worksheets and workbooks.

On the following page you’ll find a detailed breakdown of the topics covered in this course. If you wish to incorporate topics from one of our other Excel courses, contact us and we’ll be able to customise this courseware so that the additional material is included.

Learning outcomes

At the completion of this course participants will 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 the various logical functions in Excel
  • use the various Lookup functions
  • sort data in lists in a workbook
  • use autofilter to display data in lists selectively.

The training room and facilities

When training on-site at your premises, we require only that each participant has access to their own computer or laptop, with Microsoft Excel 2002 installed. Internet and networking facilities are not required. A data projector is required, and if your training room or board room is not equipped with one, we’re able to provide one at no extra cost.

Working With Workbooks

  • The Open Dialog Box
  • Opening A Workbook
  • Closing A Workbook
  • Opening Multiple Workbooks
  • Working With Multiple Workbooks
  • Opening Recently Used Workbooks

Working With Worksheets

  • Copying A Worksheet
  • Renaming Worksheets
  • Moving Worksheets
  • Inserting And Deleting Worksheets
  • Grouping Worksheets

Adjusting A Worksheet

  • Inserting Cells
  • Deleting Cells
  • Inserting Columns
  • Inserting Rows
  • Deleting Rows And Columns
  • Resizing Columns
  • Resizing Rows
  • Hiding Grid Lines

Viewing Worksheets

  • Freezing Columns And Rows
  • Splitting Windows
  • Using Zoom
  • Hiding Rows And Columns

Formatting Cells

  • Using The Font Tools
  • Using The Alignment Tools
  • Using The Number Tools
  • The Format Cells Dialog Box
  • Formatting Fonts Using The Menu
  • Superscript Subscript
  • Strikethrough
  • Changing Horizontal Alignment
  • Centering Across A Selection
  • Wrapping Text
  • Changing Text Orientation
  • Changing Vertical Alignment
  • Formatting Dates
  • Formatting Numbers
  • Formatting Currency
  • Creating Custom Formats
  • Borders And Shading
  • Clearing Cell Formats

Absolute Referencing

  • Absolute And Relative Referencing
  • Problems With Relative Formulas
  • Tracing Precedents
  • Creating Absolute References
  • Creating Mixed References
  • Circular References

Filling Series

  • Filling A Series
  • Filling A Growth Series
  • Filling A Series Backwards
  • Filling Using Options
  • Creating A Custom Series
  • Modifying And Deleting Custom Series

Labels And Names

  • Labels and Names Explained
  • Accepting Labels In Formulas
  • Using Text Labels
  • Creating Labels
  • Creating Names Using The Name 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 For 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 VLOOKUP Function
  • Testing Lookup Functions
  • Using VLOOKUP For Exact Matches
  • The INDEX Function

Sorting

  • Performing A Simple Sort
  • Sorting On More Than One Column
  • Sorting Numbers
  • Sorting By Rows

AutoFilter

  • Applying & Using AutoFilter
  • Creating Compound Filters
  • Creating Custom Filters
  • Multiple Value Criteria
  • Using Wildcards In Custom Criteria.

Need more information?

Contact us:

1300 730 922
www.exceldimensions.com.au
enquiries@exceldimensions.com.au