Support

Excel 2003 Course - Intermediate

6 sessions available starting from $700.00

Subject: Microsoft Excel

Ages: All ages

Skill level: All difficulty levels

This course is designed for people who have a basic knowledge of Excel, and who want to increase their knowledge of the practical uses of Excel 2003. By the completion of this course, participants will have a thorough knowledge of Excel.

Duration:

2 Days

Audience:

The course has been designed for users of Excel 2003 who have a basic knowledge of Excel.

Prerequisites:

Participants must have basic knowledge of entering data, formatting and simple formulas.

Course Content:

Absolute References

• Relative & Absolute Cell Referencing
• Absolute Formulas

Charting

• Creating a Chart
• Chart Types and Components
• Modifying a Chart
• Adding / Deleting a Chart Sheet
• Editing Chart
• Changing the Data Source
• Formatting Chart Objects
• Labels, Titles and Legends...

see more

This course is designed for people who have a basic knowledge of Excel, and who want to increase their knowledge of the practical uses of Excel 2003. By the completion of this course, participants will have a thorough knowledge of Excel.

Duration:

2 Days

Audience:

The course has been designed for users of Excel 2003 who have a basic knowledge of Excel.

Prerequisites:

Participants must have basic knowledge of entering data, formatting and simple formulas.

Course Content:

Absolute References

• Relative & Absolute Cell Referencing
• Absolute Formulas

Charting

• Creating a Chart
• Chart Types and Components
• Modifying a Chart
• Adding / Deleting a Chart Sheet
• Editing Chart
• Changing the Data Source
• Formatting Chart Objects
• Labels, Titles and Legends
• Printing Charts

Working with large worksheets

• Changing the Magnification
• Full Screen View
• Splitting the Window
• Freeze/Unfreeze Panes

Range Names

• Creating with Range Names
• Navigating Named Ranges
• Assigning Names
• Range Names in Formulas
• Applying / Deleting Range Names
• Display a List of Names

Working with Outline

• Expand and Collapse an Outline
• Ungroup rows/columns in an outline
• Clearing an Outline

Paste Special

• Working with Paste Special
• Copy Formats between Worksheets
• Copy Formulas / Values between Worksheets
• Mathematical Operations
• Transposing Data
• Copy Ranges with Hidden Data
• Copy Visible Cells only

Working with Multiple Worksheets

• Navigating between Worksheets
• Insert and deleting Worksheets
• Select Multiple Worksheets
• Grouping and Ungrouping Sheets
• Move & Copy Worksheets
• Print Selected Worksheets
• 3-D Formulas

Adding Drawing Objects

• Drawing and formatting Lines, Arrows and Objects
• Adding Text to an Object
• 3-D Effect and Shadow Effects
• Adding Pictures to a worksheet

Functions

• Mathematical Functions:
- Pi, TRUNC, INT, RAND, SQRT functions
• Date and Time Functions
• Statistical Functions: Count and CountA functions
• Financial Functions
• Logical Functions: IF, CountIF, SumIf Functions

Creating and Working with Links

• Linking Data with Linking Formulas
• Managing Links
• Creating Hyperlinks

Enhanced Formatting

• Conditional formatting
• Background formatting
• Using Styles

Working with Lists

• Data Lists
• Using an AutoFilter to filter list data
• Clearing AutoFilter Criteria
• Creating a Custom AutoFilter
• Sorting Data with single or multiple Sort Keys

Data Validation

• Data Validation
• Restrict Cell Entries to Data List

Worksheet Protection

• Cell Protection
• Using Passwords
• Unprotecting a Worksheet

Comments

• Creating Comments
• Viewing /Editing a Comment
• Printing Comments

Sharing Workbooks

• Shared Workbooks
• Tips on Shared Files and Resolving Conflicts

Templates

• Creating and Working with Templates

Online Forms

• Worksheet Forms
• Creating a Form
• Adding Controls
• Selecting and moving Controls
• Adding Data to Controls
• Setting up for on-line use

see less

Choose from 6 available sessions:

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $700.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $700.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $700.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $700.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $700.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $700.00

Type

  • Class / Group Sessions



My Other Listings

Word 2007 Advanced Course
Word 2007 Advanced Course
8 sessions available starting from $770.00
Photoshop CS5 Introduction Course
Photoshop CS5 Introduction Course
1 session available for $770.00
Access 2003 Course - Intermediate
Access 2003 Course - Intermediate
1 session available for $700.00

see all listings »


Found In