Email Print Bookmark

Microsoft Excel 2003 Level 2


Who should do this course?

This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building simple workbooks. Participants should have already completed the Excel Level 1 course or have equivalent skills.

About the course:

This course covers how to work more efficiently with workbooks and worksheets, enhance the appearance of data and worksheets, perform analysis using functions and use the sorting and filtering features to manage and analyse data.

Learning outcomes:

Upon successful 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 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.
 

Quick Facts

Level: Intermediate Price: $385.00 incl GST You will receive:
Duration: 1 Days Discounts*: 2 Students - 10% - Certificate of completion
Size: 10   3 Students - 15% - Training Manual
Times: 9.00am - 5.00pm approx   4 Students - 20% - 12 months FREE email support*
Pre-requisites: Refer to course description Bonus: 2 FREE - FREE class re-sit (if necessary)*
      Movie Tickets Course Brochure:
        Excel_2003_L2.pdf
         
 * Conditions apply.
 

Upcoming Courses

Sydney

Level 11, 32 Walker Street
North Sydney
View map

Date:
18-18 Mar 10
30-30 Mar 10
13-13 Apr 10
29-29 Apr 10
11-11 May 10
27-27 May 10
08-08 Jun 10
24-24 Jun 10

Melbourne

Level 12, 379 Collins Street
Melbourne
View map

Date:
17-17 Mar 10
30-30 Mar 10
15-15 Apr 10
28-28 Apr 10
13-13 May 10
25-25 May 10
10-10 Jun 10
22-22 Jun 10

Brisbane

C/- Support Technology, Level 6, 371 Queen St
Brisbane
View map

Date:
08-08 Apr 10
05-05 May 10
03-03 Jun 10
29-29 Jun 10

Canberra

C/- Training Choice, Level 12, 15 London Circuit
Canberra
View map

Date:
16-16 Apr 10

Adelaide

C/- Mindfull Computer & Seminar, Level 4, 74 Pirie Street
Adelaide
View map

Date: upon demand

For more information on dates or locations, please call 1300 888 724 or enquire online.

Course Units

Unit 1: Working with Workbooks
- The Open Dialog Box
- Opening a Workbook
- Closing a Workbook
- Opening Multiple Workbooks
- Working with Multiple Workbooks
- Opening Recently Used Workbooks
Unit 2: Working with Worksheets
- Copying a Worksheet
- Renaming Worksheets
- Moving Worksheets
- Inserting And Deleting Worksheets
- Grouping Worksheets
Unit 3: Adjusting a Worksheet
- Inserting Cells
- Deleting Cells
- Inserting Columns
- Inserting Rows
- Deleting Rows And Columns
- Resizing Columns
- Resizing Rows
- Hiding Grid Lines
Unit 4: Viewing Worksheets
- Freezing Columns And Rows
- Splitting Windows
- Using Zoom
- Hiding Rows And Columns
Unit 5: Absolute Referencing
- Absolute And Relative Referencing
- Problems with Relative Formulas
- Tracing Precedents
- Creating Absolute References
- Creating Mixed References
- Circular References
Unit 6: 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
Unit 7: 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
Unit 8: 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
Unit 9: 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
Unit 10: Sorting
- Performing a Simple Sort
- Sorting on More Than One Column
- Sorting Numbers
- Sorting By Rows
Unit 11: AutoFilter
- Applying and Using AutoFilter
- Creating Compound Filters
- Creating Custom Filters
- Multiple Value Criteria
- Using Wildcards in Custom Criteria.
Man and woman sitting at a computer SEEK logo