Support

Thank you from doMore

I'd like to thank you for being involved in the doMore.com.au community and the team and I hope that you've received value from being a part of it.

doMore was our original passion project born out of the desire to help connect people wanting to learn something new with experts that could teach them over 10 years ago.

Over the years we have helped almost 70,000 learners connect with one of over 1,500 courses and providers, across the country. For that, we're very proud and grateful for your contribution.

doMore.com.au also served to teach us about how to help measure and improve business performance and inspired the launch and growth of two other companies as a result, one of which we've decided to dedicate our resources and energy to making great.

We'll be switching the site off on Tuesday 31st of July. If you have any questions or concerns, please contact us directly on [email protected].

Thanks again and good luck with your teaching endeavours in the future.

Warm regards,

The doMore team.

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

MYOB Course | End of Period Reconciliation
MYOB Course | End of Period Reconciliation
1 session available for $350.00
Dreamweaver CS4 Course - Introduction
Dreamweaver CS4 Course - Introduction
2 sessions available starting from $770.00
Crystal Reports 11 Introduction Course
Crystal Reports 11 Introduction Course
3 sessions available starting from $1,055.00

see all listings »


Found In