Send to a Colleague Print Bookmark

Microsoft Excel 2003 Level 2

Regular Excel 2003 users can take their spreadsheet skills to the next level with advanced techniques including multiple workbooks, lookup functions, fill techniques and more.

Quick Facts

 

$385 incl GST

Duration: 1 Days

Class Size: 10

Level: Intermediate

Times: 9.00am - 5.00pm approx

 
 

About the Course

During this 1 day course, instructors show participants how to work more effectively with Excel 2003 workbooks and worksheets. Students will undertake hands-on exercises in advanced formatting, absolute referencing, Lookup functions and using complex sorting and filtering features to manage and analyse data.

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. Upon completion of the course, students should be able to use advanced techniques to manage, manipulate and analyse complex data.

Prerequisites

Participants should have already completed the Excel 2003 Level 1 course or have equivalent skills.

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.

Upcoming Courses

Sydney

Level 11, 32 Walker Street
North Sydney
View map

Date:
15 Mar 12
15 Mar 12
08 May 12

Melbourne

Level 12, 379 Collins Street
Melbourne
View map

Date:
15 Feb 12
22 Mar 12
15 May 12

Brisbane

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

Date:
07 Feb 12

Canberra

C/O Atlas Business Services, 21 Barry Drive
Turner
View map

Date: upon demand

Adelaide

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

Date: upon demand

Perth

C/- Lansen Consulting Pty Ltd, Level 1, 484 Albany Highway
Victoria Park
View map

Date: upon demand
 

$385 incl GST

Duration: 1 Days

Class Size: 10

Level: Intermediate

Times: 9.00am - 5.00pm approx

 
Man and woman sitting at a computer SEEK logo