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.


Microsoft Excel Intermediate Course

2 sessions available starting from $445.00

Subject: Microsoft Excel

Ages: All ages

Skill level: All difficulty levels

BSBITU402 – Develop and use complex spreadsheets – Nationally Recognised & Accredited Training

General Information

Duration: 2 Half Days, 7 Hours

Prerequisite: Experience with Windows and Excel Introductory Functions.

Objectives: To provide a thorough understanding of the comprehensive concepts and skills that will enable the participant to effectively use Microsoft Excel.

Methodology: Group and individual instruction, hands on practical exercises, visual aids, comprehensive course documentation.

Competency Assessment: This will be issued to trainees upon completion of training session.

Expected Outcome: By the end of the course the participant should be able to use the following functions and features of Microsoft Excel.

Course Content

Working with Workbooks...

see more

BSBITU402 – Develop and use complex spreadsheets – Nationally Recognised & Accredited Training

General Information

Duration: 2 Half Days, 7 Hours

Prerequisite: Experience with Windows and Excel Introductory Functions.

Objectives: To provide a thorough understanding of the comprehensive concepts and skills that will enable the participant to effectively use Microsoft Excel.

Methodology: Group and individual instruction, hands on practical exercises, visual aids, comprehensive course documentation.

Competency Assessment: This will be issued to trainees upon completion of training session.

Expected Outcome: By the end of the course the participant should be able to use the following functions and features of Microsoft Excel.

Course Content

Working with Workbooks:
• Opening Workbooks
• Creating and Saving Workspaces
• Closing Workbooks

Formula Referencing:
• BODMAS Theory
• Relative Referencing
• Absolute Referencing
• Mixed Referencing

Linking Data:
• Linking across Spreadsheets
• Linking across Workbooks
• Updating Links

Other Formula Options:
• Range Names
• Creating Range Names
• Deleting Name Ranges
• Using Names for Constants
• Creating Names in External Workbooks
• Creating a List of Names

Functions:
• Insert Function Wizard
• Statistical Functions
• Financial Functions
• Lookup Functions

Managing Data:
• Outlining
• Sorting Data
• Auto Filtering

Creating and Using Macros:
• Exploring Macros
• Recording a Macro
• Running a Macro
• Assigning a Macro to a Button
• Deleting a Macro
• More Macros

Advanced Charting:
• Changing the Chart Type
• Adding Data to a Chart
• Formatting Charts

see less

Choose from 2 available sessions:

When

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

Where

  • Alice Springs, NT 0870

Price: $445.00

Notes:

Cost : $445 GST‐free Includes training manual

When

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

Where

  • Shepherd St, Darwin NT 0800, Australia
    Darwin, NT 0800

    Willing to travel

Price: $445.00

Notes:

Cost : $445 GST‐free Includes training manual

Type

  • Class / Group Sessions



My Other Listings

Excellence in Customer Service Course
Excellence in Customer Service Course
1 session available for $445.00
Diploma in Leadership & Management
Diploma in Leadership & Management
1 session available for $3,160.00
Microsoft Publisher Course
Microsoft Publisher Course
1 session available for $445.00

see all listings »


Found In