Microsoft Excel Advanced Course

Microsoft Excel Advanced Course

Course Overview

This Advanced Excel course will further enhance on your existing Excel skills.  Increasing your knowledge by understanding advanced functions and productivity tools. Following this course, you will work use a large range of functions.  Analyse data effectively and quickly using Pivot Tables and Charts.  You will gain a practical ability to use Excels productivity tools and Advanced Functions.  This is a hands-on course and includes plenty of chances to try out what you are being taught and ask questions.

Delivery Modes

MTA Training Facility in Osborne Park or on-site delivery with you

Requirements

  • A moderate English language, literacy and numeracy skill is required.
  • Participants must bring their own laptop for training days.
  • Lunch:  Subway Catering is provided, or you are welcome to bring your own (microwave and fridge available). Tea, Coffee and biscuits available.
  • Parking is available on site, or it is a short walk from Glendalough Train Station.

Duration

Two (2) Days

Content

  • Revision Exercise
  • Defined Names
  • Protecting Data, Worksheets and Workbooks
  • Logical Functions
  • Validating Data
  • Creating Drop Down boxes
  • Lookup Functions
  • Vlookup, Hlookup, Match
  • Summarising Data using Subtotals
  • Grouping and Outlining
  • Data Linking
  • Data Consolidation
  • Pivot Tables
  • Pivot Table Techniques
  • Macros
  • Attach Macros to buttons, Access Tootlbar and Worksheets

Learning Outcomes

At the completion of the program Excel Advanced participants should be able to:

  • Create If Functions to analyse data
  • use logical functions to test whether a statement is true or false
  • use a variety of data validation techniques
  • use a range of lookup and reference functions
  • create summaries in your spreadsheets using subtotals
  • understand and create simple PivotTables
  • construct and operate PivotTables using some of the more advanced techniques
  • create recorded macros in Excel

If you would like a proposal on how this training may benefit staff of your company, please contact us today.

bd@minetrainingaustralia.edu.au

(08) 9221 1803 OR 1300 354 309

  • Make an appointment to visit: Our administration offices (Level 1, 46 Edward Street, OSBORNE PARK WA 6017)

RIIHAN309F Conduct Telescopic Handler Operations

Secure goods and cargo

RIIHAN309F Conduct Telescopic Handler Operations

Course Overview

This unit describes the skills and knowledge required to conduct telescopic materials handler operations. This unit applies to those working in site-based roles.

NRT logo

Delivery Modes

On-site delivery

Entry Requirements

Above 18 years old. Must be currently working at mine site.

Learners should have sufficient language, literacy, and numeracy skills to participate in training.

Number of Participants

Minimum 8 participants.

Duration

One (1) Day

Assessment

Your assessment will be comprised of a number of tasks which will include some of the following.

  • Theory
  • Practical Demonstration

Outcome

Nationally Recognised Statement of Attainment.

If you would like a proposal on how this training may benefit staff of your company, please contact us today.

enquiries@pivot.edu.au

(08) 9221 1803 OR 1300 354 309

  • Make an appointment to visit: Our administration offices (Level 1, 46 Edward Street, OSBORNE PARK WA 6017)

DMIRS Exam Preparation Course

DMIRS Exam Preparation Course

Course Overview

DMIRS (Department of Mines, Industry Regulation and Safety) exam preparation course will assist you in gaining WA Certificate of Competency in one of the following appointments:

– Quarry Manager

– First class Mine Manager

– Restricted Quarry Manager

– Underground Supervisor

Delivery Modes

Face to face delivery: Face to face delivery will be held at our training room on Level 4/231 Adelaide Terrace, Perth WA 6000

Virtual Delivery: You can attend this course live virtually via Zoom from your home or your worksite.

Course Price

Mining Regulations (All Exams): $1050 (Days 1-3)

Practical Exam preparation (US and RQM): $350 (Day 4)

Duration

The total duration of DMIRS exam preparation course is 4 days.

Mining Regulations (All Exams): 3 days from 9 am to 4:30 pm

Practical Exam Preparation (US and RQM): 1 day from 9 am to 4:30 pm

Trainer

This course will be run by our mine specialist trainer Geoff Cozamanis who has possess over 26 years of experience in mining management, engineering, and quarry manager accountabilities.

Enrolment

Email hello@minetrainingaustralia.edu.au to register your interest to attend this course on the dates you are available. Our friendly team will contact you to enrol.

After enrolment, you will be provided access to all the preparation materials on POLS (Pivot Online learning system). If you would like to discuss this course further, please call John on 0427 086 606.

If you would like a proposal on how this training may benefit staff of your company, please contact us today.

johns@minetrainingaustralia.edu.au

John 0427 086 606 or Geoff 0448 891 016

Make an appointment to visit: Our administration offices (Level 1, 46 Edward Street, OSBORNE PARK WA 6017)

RII50120 – Diploma of Surface Operations Management

Secure goods and cargo

RII50120 - Diploma of Surface Operations Management

RPL (Recognition of prior learning) for set 1-4

Face to face / virtual / self-paced for only Set 4 (Minining Management)

Units Overview

This qualification provides you the skills and knowledge to work in management roles within the resources sector, such as quarry or open cut coal or metalliferous mine. It requires the application of significant judgement in planning and determining the selection of equipment, roles and techniques for yourself and others. It covers a broad range of skills such as Compliance, Risk and Safety in the workplace, pit planning and managing teams.

NRT logo

Course Price

$6,799

Entry Requirements

Above 18 years old. Must be currently working at mine site and have minimum 6 months supervisory experience in surface mining operations . Learners should have sufficient language, literacy, and numeracy skills to participate in training.

Number of Participants

Minimum 8 participants.

Duration

The duration of RII50120 Diploma of Surface Operations Management is 12-18 months.

Units

Total number of units = 13

3 core units plus

10 elective units

SetUnitUnit Name
Compliance, Risk and SafetyBSBWHS521Ensure a Safe Workplace for a Work Area
RIIGOV501EIdentify, Implement, and Maintain Legal Compliance Requirements
RIIRIS501EImplement and Maintain Management Systems to Control Risk
Pit PlanningRIISRM501Implement Stockpile Management Plans
RIIMPO502DManage the Interaction of Heavy and Light Vehicles and Mining Equipment
RIIMEX501DImplement Pit Plans
Health, Safety and EnvironmentRIIRIS402ECarry Out the Risk Management Process
RIIWHS301EConduct Safety and Health Investigations
RIIENV501EImplement and Maintain Environmental Management Plans
Mining ManagementBSBPEF501Manage Personal and Professional Development
BSBSTR502Facilitate Continuous Improvement
BSBTWK502Manage Team Effectiveness
BSBWHS411Implement and Monitor WHS Policies, Procedures and Programs

 

Delivery Modes

RPL (Recognition of prior learning) for set 1-4

  • Recognition of Prior Learning (RPL) is an assessment process that assesses candidates non-formal and formal learning to determine how their current skills and knowledge match the competency outcomes for a unit.
  • Students completing part or all of this qualification through Recognition of Prior Learning (RPL) will be required to:

o           Complete a RPL document where they provide documents evidencing their formal and non-formal skills and knowledge,

o           Undergo two site visits by our Mining Specialist and

o           Have their supervisor verify their abilities.

Training and Assessment for Set 4 (Mining Management)

  • Candidates who do not have much experience or evidence of the skills and knowledge covered in a unit will complete the units through a Training and Assessment pathway which will involve working through the course content and submitting assessments.
  • Students can complete the unit by attending our facilitated workshops, either in person or virtually, or working through the content online at their own pace. Our first in class Hybrid delivery technology allows both our virtual and face to face students to attend the same facilitated workshops.
  • Face to Face Attendance: Training will be held 9am – 4pm at our RiverView training room on Level 4, 231 Adelaide terrace, Perth.
  • Virtual Attendance: Attend this training from any location by clicking a link.
  • Online, Self-paced

Assessment

Your assessment will be comprised of a number of tasks which will include some of the following.

  • Theory
  • Practical Demonstration

Outcome

Nationally Recognised Qualification

If you would like a proposal on how this training may benefit staff of your company, please contact us today.

johns@minetrainingaustralia.edu.au

John Soubotian 0427086606 OR 1300 354 309

BSB40120 Certificate IV in Business Traineeship

ew age managers in western australia

BSB40120 Certificate IV in Business Traineeship

Significant government incentives for employers!

Here at The Pivot Institute, we are leaders in the field with our own Pivot Online Learning System (POLS). Virtual face-to-face participants will be set up on our leading online learning platform; the Pivot Online Learning System (POLS). This platform provides students with the content, resources and assessment documentation necessary to complete the course. Participants will attend virtual classrooms with industry leading facilitators. Participants can start the course anytime and will be required to book in and attend sessions via Zoom. Printed workbooks, assessment documentation and all resources are provided and posted to students.

Recognition of Prior Learning (RPL) at The Pivot Institute is an assessment only pathway. The RPL process assesses your non-formal and formal learning to determine how your current skills and knowledge match the competency outcomes for partial or full qualification. RPL assessment at The Pivot Institute allows you to evidence your skills and knowledge through the completion of an RPL kit.

Traineeship cost: Indicative Fees

To apply for BSB40215 Certificate IV in Business, please download and fill the application form below and submit to enquiries@pivot.edu.au

Course Overview

The Pivot Institute is offering BSB40120 Certificate IV in Business traineeship for your company employees in Perth and Broome. The federal government is boosting wage subsidy to employers enrolling new workers and existing workers (see eligibility requirements*) to undertake traineeship in BSB40120 Certificate IV in Business.

Graduates of BSB40120 Certificate IV in Business will be ready to use their skills and knowledge to provide leadership to their teams and perform complex administrative and operational tasks within the workplace.

NRT logo

Eligibility Requirements*

Funding Eligibility

  • Persons must be an Australian Citizen, Permanent Resident or holders of approved Visa subclasses 309,444,785,790,820;
    • Secondary holders of a temporary visa of sub class 457; and
    • Holders of a Bridging Visa E (Subclass 050 and 051) where the visa holder has made a valid application for a visa of subclass 785 or 790.
  • Persons primary place of residence is in Western Australia
  • Persons under 18 years of age in the year of enrolment must be under a DoE Notice of

Arrangement (NoA)2 (Full Time) or exempted from the School Education Act 1999.

This does not include Students undertaking a school based program such as an

Apprenticeship, Traineeship, Pre-apprenticeship, or Aboriginal School Based Training

(ASBT) Program.

  • Persons must have a valid Unique Student Identifier (USI)

 

Concession Eligibility

  • Persons aged 15—24 years at the time of enrolment (excluding students enrolled at school)
  • Persons and dependents of persons in receipt of services from one of the following Commonwealth support or employment services programs:
    • Jobactive
    • Online Employment Services
    • ParentsNext

(a letter from the Commonwealth services provider confirming the student’s participation in the program is required)

  • Persons and dependents of persons receiving the Youth Allowance, AUSTUDY or ABSTUDY
  • Persons and dependents of persons holding:
    • a pensioner concession card or  Health Care Card; or
    • a Repatriation Health Benefits Card issued by the Department of Veterans’ Affairs
  • Dependents of persons who are inmates of a custodial institution

 

Traineeship Eligibility

Trainees must meet the requirements for funding eligibility and meet the new worker definition (i.e. have been employed for less than 3 months full time or less than 12 months part-time or casual prior to commencing the qualification) Trainees will be employed in an appropriate role that reflects the requirements of the qualification.

Traineeship Duration

The duration of BSB40120 Certificate IV in Business traineeship is 12 months

Employer Benefits

– Your team members become qualified with new and relevant skills and knowledge

– Up to $24,000 annual wage subsidy for NEW trainees* (Paid by Apprenticeship Office)

– Wage subsidy for existing workers (criteria apply) * (Paid by Apprenticeship Office)

– Trainees develop new skills and learn processes suited to your organization.

Trainee Benefits

Trainees will develop skills and abilities to:

– conduct business meetings

– Communicate effectively

– Build workplace relationships

– Develop emotionally intelligent teams

– apply business risks

– Manage risks

Modes of Delivery

Facilitated Virtual Delivery

You will be required to attend sessions on Zoom using Pivot Online Learning System (POLS). You will also be provided access to Pivot Online Learning System (POLS) that includes all the learning material, assessment, and resources to complete the course.  

There will be workplace visits by facilitator to observe and assess your skills in the workplace.

Recognition of Prior Learning (RPL)

Recognition of Prior Learning (RPL) at The Pivot Institute is an assessment only pathway. The RPL process assesses your non-formal and formal learning to determine how your current skills and knowledge match the competency outcomes for partial or full qualification. RPL assessment at The Pivot Institute allows you to evidence your skills and knowledge through the completion of an RPL kit.

Course Structure

There are six (6) core unit and six (6) elective units for this Qualification. This Qualification is presented as a series of blocks for both facilitated virtual delivery and supported distance learning students. You can start the course any time.

BLOCK 1: MANAGING YOURSELF & OTHERS

  • BSBPEF402 Develop personal work priorities
  • BSBLDR522 Manage people performance
  • BSBOPS405 Organise business meeting

#Post workshop study required.

BLOCK 2: WORK HEALTH AND SAFETY, WRITING COMPLEX DOCUMENTS AND USING DIGITAL TECHNOLOGY

  • BSBWHS411 Implement and monitor WHS policies, procedures and programs
  • BSBWRT411 Write complex documents
  • BSBTEC404 Use digital technologies to collaborate in a work environment

#Post workshop study required.

 BLOCK 3: COMMUNICATION, PLANNING AND CRITICAL THINKING

  • BSBXCM401 – Apply communication strategies in the workplace
  • BSBOPS402 – Coordinate business operational plans
  • BSBCRT411 Apply critical thinking to work practices

#Post workshop study required.

BLOCK 4:  MANAGING RISK, WORKPLACE RELATIONSHIPS AND DEMONSTRATING EMOTIONAL INTELLIGENCE 

  • BSBOPS403 – Apply business risk management processes
  • BSBPEF502 Develop and use emotional intelligence
  • BSBTWK401 Build and maintain business relationships#Post workshop study required.

Course Calendar

This course calendar is  for students participating in facilitated virtual delivery. Following dates have been scheduled for virtual units delivery via zoom from 9:00 am to 4:30 pm. There are four clusters of workshops which can be attended in any order.

Block 1: MANAING YOURSELF & OTHERS

Block 2: WORK HEALTH AND SAFETY, WRITING COMPLEX DOCUMENTS AND USING DIGITAL TECHNOLOGY

Block 3: COMMUNICATION, PLANNING AND CRITICAL THINKING

Block 4: MANAGING RISK, WORKPLACE RELATIONSHIPS AND DEMONSTRATING EMOTIONAL INTELLIGENCE

Assessments

Candidate Assignment Booklet

For each unit, you will be provided with a Candidate Assignment Booklet.  In each booklet there are a series of tasks relevant to each unit.  We work to ensure that the tasks are clear and that you have the right support and resources to undertake your assessment.   This qualification requires that a number of activities are undertaken to prove competency so please consider these requirements prior to committing to the program. You will need to complete all tasks in order to be assessed for competency. Your assessment will be comprised of a number of tasks which will include some of the following:

– Complete a range of activities related to effective communication in the workplace.

– Design, develop and deliver a series of presentations in the workplace.

– Brainstorm an innovation.

– Use tools of continuous improvement to identify an opportunity to improve service excellence within your organisation.

– Develop a project plan and undertake a small project (or contribute to a larger project).

– Implement and monitor WHS activities in the workplace.

– Undertake research to identify potential business risks and develop a risk matrix and action plan.

– Analyse your current emotional strengths and weaknesses and develop resources to support the development of EI in the workplace.

– Create an induction pack for a workplace which establishes the foundation for a smooth start for new employees.

Assessment Process

During the assessment process your assessor will:

– Answer any questions or concerns you may have about the assessment process or tasks

– Assess your competency as required by the unit of competency, by making judgments about the evidence presented in line with the rules of evidence: validity, authenticity, currency and sufficiency

– Give you feedback on the outcomes of the assessment process

– Provide your results, either competent or not yet competent

– Advise you on the outcomes of the assessment including the appeals process you can follow if you disagree with the assessment decision

Enrolment Form

Trainees need to fill the enrolment form and submit to enquiries@pivot.edu.au

Click here to download the enrolment form.  

Get a USI (Unique Student Identifier)

A USI is your lifelong education number – you only need to create it once. If you have undertaken any VET training since 2015, you may already have a USI. You can find it here.

If you don’t have USI, you can Apply for USI

enquiries@pivot.edu.au

  • Make an appointment to visit: Our administration offices (Level 1, 46 Edward Street, OSBORNE PARK WA 6017)