Support

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

Diploma in Human Resources Management Course
Diploma in Human Resources Management Course
1 session available for $2,995.00
Microsoft Word Introduction Course
Microsoft Word Introduction Course
1 session available for $445.00
Diploma in Project Management Course
Diploma in Project Management Course
1 session available for $2,800.00

see all listings »


Found In