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.


Advanced Excel 2002 / 2003

3 sessions available starting from $780.00

Subject: Microsoft Excel

Ages: All ages

Skill level: All difficulty levels

TARGET AUDIENCE & PURPOSE

Advanced Excel Training is for people who can already create moderately complex spreadsheets, and want to add more sophistication and automation.

OBJECTIVES

By the end of this course participants should be able to:

* Use outlines, range names, databases & the data form
* Use AutoFilter & advanced filters
* Work with Data Series
* Use advanced functions
* Modify charts
* Use Scenarios & Goal Seek
* Use templates, data tables & solve problems
* Use automatic formatting & styles
* Work with views, consolidate worksheets
* Create & revise PivotTables
* Use, record & edit macros

PREREQUISITES

Participants should already be using Excel on a regular basis and / or have a good Knowledge of Excel Introduction topics.

COURSE CONTENT

* Using...

see more

TARGET AUDIENCE & PURPOSE

Advanced Excel Training is for people who can already create moderately complex spreadsheets, and want to add more sophistication and automation.

OBJECTIVES

By the end of this course participants should be able to:

* Use outlines, range names, databases & the data form
* Use AutoFilter & advanced filters
* Work with Data Series
* Use advanced functions
* Modify charts
* Use Scenarios & Goal Seek
* Use templates, data tables & solve problems
* Use automatic formatting & styles
* Work with views, consolidate worksheets
* Create & revise PivotTables
* Use, record & edit macros

PREREQUISITES

Participants should already be using Excel on a regular basis and / or have a good Knowledge of Excel Introduction topics.

COURSE CONTENT

* Using Outline View
Applying an Outline, Collapsing / Expanding an Outline, Modifying Outline Settings, Clearing an Outline, Using Auto Outline

* Using Multiple Workbooks
Open & Arrange Multiple Workbooks, Save a Workspace, Create & Maintain Links

* Using Range Names
Jumping to a Named Range, Assigning Names, Using Range Names in Formulas, Creating Range Names from Headings, Using Range Names in 3-D Formulas, Using 3-D Range Names & Labels in Formulas, Using Labels to Define a Range, Using Multiple Stacked Headings

* Working with Databases
Creating & Modifying a Database, Sorting Records by Multiple Fields, Using Data Validation, Creating Subtotals in a List

* Working with the Data Form
Editing Data Form Records, Adding Data Form Records, Defining Criteria, Clearing Data Form Criteria, Deleting Data Form Records

* Using AutoFilter & Advanced Filters
Enabling AutoFilter, Using AutoFilter to Filter a List, Creating a Custom AutoFilter, Disabling AutoFilter, Creating a Criteria Range, Using Comparison Criteria, Using an Advanced 'AND' Condition, Using an Advanced 'OR' Condition, Using Database Functions

* Using Advanced Functions
Using the VLOOKUP & HLOOKUP Function, Using the IF Function& Nested IF Function, Using the ISERROR Function, Using an 'AND' Condition with IF, Using an 'OR' Condition with IF

* Advanced Charting
Adding, Removing & Formatting Gridlines, Formatting an Axis, Changing the Axis Scaling, Formatting the Data Series, Adding Data - Different Worksheets, Using a Secondary Axis, Changing Data Series Chart Types, Adding a Trendline, Creating User-defined Charts

* Using Templates
Saving a Workbook as a Template, Using a Template, Editing a Template, Deleting a Template, Creating Default Templates

* Using Auditing Tools
Displaying the Formula Auditing Toolbar, Displaying/Removing Dependent & Precedent Arrows, Removing All Tracer Arrows, Using the Auditing Tools Buttons

* Using Scenarios & Goal Seeking
Using the Scenario Manager, Creating, Displaying & Editing a Scenario, Creating a Scenario Summary Report

* Solving Problems
Using Solver, Saving a Solution as a Scenario, Changing a Constraint, Creating a Solver Report, Viewing Solutions using Scenarios

* Using Automatic Formatting & Styles
Applying an AutoFormat, Changing AutoFormat Options, Extending List Formats & Formulas, Creating a Style by Example, Creating a New Style, Editing an Existing Style, Merging Styles

* Working with Views
Creating, Displaying & Deleting a Custom View

* Consolidating Worksheets
Consolidating Worksheets by Category or by Position

* Sharing Workbooks
Saving a Shared Workbook, Viewing Users Sharing a Workbook, Viewing Shared Workbook Changes, Highlighting Changes, Resolving Conflicting Changes, Adding a History Worksheet, Reviewing Tracked Changes, Merging Shared Workbook Files

* Creating/Revising PivotTables
Creating a PivotTable Report, Adding Fields, Selecting a Page Field Item, Refreshing a PivotTable Report, Changing the Summary Function, Adding New Fields, Moving Fields, Hiding/Unhiding PivotTable Report Items, Deleting PivotTable Report Fields, Creating a Page Field Report, Formatting a PivotTable Report, Creating a PivotChart Report

* Using, Recording, Editing Macros
Opening a Workbook Containing Macros, Running a Macro, Using the Visual Basic Toolbar, Using the Visual Basic Editor Window, Recording a Macro, Using Relative References, Assigning a Macro to a Menu, Removing a Custom Menu Item, Deleting a Macro, Writing a New Macro, Entering Macro Comments, Copying, Editing & Typing Macro Commands, Running a Macro from the Code Window

* Using Custom Toolbars & Menus
Creating a Custom Toolbar, Adding/Removing Toolbar Buttons, Assigning a Macro to a Button, Attaching a Custom Toolbar, Deleting a Custom Toolbar, Creating a Custom Menu

* Creating a Macro Button
Using a Macro Button, Creating a Macro Button, Formatting a Macro Button, Moving/Sizing a Macro Button, Deleting a Macro Button

Duration: Two Days

see less

Choose from 3 available sessions:

When

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

Where

  • 83 York St
    Sydney, NSW 2000

Price: $780.00

Notes: Course Inclusions * Comprehensive learning materials incl. exercise... see more

Notes:

Course Inclusions

* Comprehensive learning materials incl. exercise files
* 12 months post course telephone support
* 'Certificate of Attendance'
on completion of course
* Light lunch plus morning & afternoon tea

see less

Type

  • Class / Group Sessions

When

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

Where

  • 83 York St
    Sydney, NSW 2000

Price: $780.00

Notes: Course Inclusions * Comprehensive learning materials incl. exercise... see more

Notes:

Course Inclusions

* Comprehensive learning materials incl. exercise files
* 12 months post course telephone support
* 'Certificate of Attendance'
on completion of course
* Light lunch plus morning & afternoon tea

see less

Type

  • Class / Group Sessions

When

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

Where

  • 83 York St
    Sydney, NSW 2000

Price: $780.00

Notes: Course Inclusions * Comprehensive learning materials incl. exercise... see more

Notes:

Course Inclusions

* Comprehensive learning materials incl. exercise files
* 12 months post course telephone support
* 'Certificate of Attendance'
on completion of course
* Light lunch plus morning & afternoon tea

see less

Type

  • Class / Group Sessions



My Other Listings

Advanced Dreamweaver & CSS Training
Advanced Dreamweaver & CSS Training
1 session available for $995.00
Presentation Skills Training
Presentation Skills Training
2 sessions available starting from $500.00
Microsoft PowerPoint 2010 Advanced
Microsoft PowerPoint 2010 Advanced
3 sessions available starting from $390.00

see all listings ยป


Found In