Support

Excel 2003 Advanced Course

3 sessions available starting from $770.00

Subject: Microsoft Excel

Ages: All ages

Skill level: All difficulty levels

This course is designed for people who have a good working knowledge of Excel, and who want to wish to use the advanced features of Excel 2003. By the completion of this course, participants will have a broad knowledge of Excel

Duration:

2 Days

Audience:

The course has been designed for experienced users of Excel who wish to used the advanced features of Excel 2003.

Prerequisites:

Participants must be confident users of Excel who are able to create and manage multiple sheet workbooks.

Course Content:

Auditing Tools

• Overview of Auditing Tools
• Tracer Arrows, Dependent and Precedent Arrows
• Removing Tracer Arrows
• Tracing Cells Causing Errors
• Understanding Error Messages
• Overcoming Error Messages

Advanced Functions

• Nested IF Functions
• AND...

see more

This course is designed for people who have a good working knowledge of Excel, and who want to wish to use the advanced features of Excel 2003. By the completion of this course, participants will have a broad knowledge of Excel

Duration:

2 Days

Audience:

The course has been designed for experienced users of Excel who wish to used the advanced features of Excel 2003.

Prerequisites:

Participants must be confident users of Excel who are able to create and manage multiple sheet workbooks.

Course Content:

Auditing Tools

• Overview of Auditing Tools
• Tracer Arrows, Dependent and Precedent Arrows
• Removing Tracer Arrows
• Tracing Cells Causing Errors
• Understanding Error Messages
• Overcoming Error Messages

Advanced Functions

• Nested IF Functions
• AND, OR functions
• Using an AND Condition with IF
• Lookup Functions
• VLOOKUP, HLOOKUP, Match and Index
• String Functions
• Round Function
• Array formulas

Database/Lists

• Creating a Database List
• Adding/Removing Records
• Adding / Removing Fields
• Sorting Records by Multiple Fields
• Performing a Custom Sorts
• Sorting from Left to Right
• Using a Data Form to find and edit data
• Creating Subtotals in a List
• Removing Subtotals from a List

Advanced Filters

• Creating a Criteria
• Using a Criteria
• Showing All Records
• Using Comparison Criteria
• Using an Advanced AND or OR Conditions
• Extracting Filtered Records
• Using Database Functions

Scenario & GoalSeek

• Using the Scenario Manager
• Creating, Displaying and Editing a Scenario
• Creating a Scenario Summary Report
• Using Goal Seek

Problem Solving

• Using Solver to find solutions to spreadsheet problems
• Savings a Solver Solution as a Scenario
• Restoring the Original Values
• Changing a Constraint
• Creating a Solver Report
• Using Scenarios to View Solutions

Consolidating Worksheets

• Overview of Consolidating data
• Consolidating by Position or by Category

Working with Views

• Using Views
• Creating a Custom View
• Displaying a View
• Editing a View
• Deleting a View

Report Manager

• Working with the Report Manager
• Using Sheets in a Report
• Printing a Report
• Using Scenarios and Views in a Report

Creating Pivot Table Reports

• Creating a PivotTable
• Adding PivotTable Report Fields
• Editing and Refreshing a PivotTable Report
• Changing The Summary Function
• Moving Pivot table Report Fields
• Hiding And Unhiding Items
• Pivot Table Options
• Adding Multiple Data Fields
• Custom Calculations In Pivot Tables
• Creating Calculated Fields and Calculated Item
• Grouping/Ungrouping Items
• Sorting A Pivot Table
• Creating Pivot Charts
• Creating Interactive PivotTables • Web
• Adding Fields To A PivotTable • Browser

Macros

• Defining Macros
• Recording and running a Macro
• Personal Workbook
• Visual Basic Editor Understanding Your Code
• Running Code In VBA Environment
• Recording a Relative Record
• Debugging a Macro
• Correcting Errors
• Assigning A Macro To A Menu
• Deleting A Macro From A Menu
• Assigning A Macro To a Button

Creating an Online Form

• Creating A Form
• Adding Controls
• Selecting Controls
• Moving A Control
• Adding Data To Controls
• Setting Up For On-Line Use

see less

Choose from 3 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: $770.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: $770.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: $770.00

Type

  • Class / Group Sessions



My Other Listings

Writing Reports and Proposals  Course
Writing Reports and Proposals Course
2 sessions available starting from $870.00
Microsoft Outlook 2003 Course | Advanced
Microsoft Outlook 2003 Course | Advanced
1 session available for $350.00
Microsoft Outlook 2007 Course | Advanced
Microsoft Outlook 2007 Course | Advanced
2 sessions available starting from $350.00

see all listings »


Found In