Microsoft Excel Intermediate

Investment

$840

Delivery

Mine Training Australia
Osborne Park or On-siteMine Training Australia Trainers will come directly to your company’s location

Duration

Two (2) Days

The Microsoft Excel Intermediate course will focus on expanding your existing Excel skills.

Following this course, you will work more effectively in Excel, supporting you to professionally present data.

Find Out More:

l l
Course Overview
Investment
Delivery
h h
Units
Entry Requirements
Funding
FAQ's
Course Dates
Course Dates

Microsoft Excel Intermediate Course

This intermediate-level Excel course is designed to enhance your existing skills, enabling you to work more efficiently and present your data effectively.

Through hands-on learning, you’ll explore powerful Excel functions, advanced data organisation techniques, and improved charting capabilities. The course offers ample opportunities to practice new skills and ask questions, ensuring a comprehensive understanding.

After the Microsoft Excel Intermediate course, check out the final course, the Microsoft Excel Advanced course.

Who Should Enrol?

This course is ideal for:

  • Individuals with basic Excel proficiency aiming to advance their skills.
  • Professionals seeking to improve data management and presentation capabilities.
  • Anyone looking to utilise Excel’s advanced features for more efficient workflow.

What You Will Learn

Participants will gain practical experience in:

  • Advanced Functions: Utilising logical functions like IF statements to perform conditional calculations.
  • Data Management: Sorting and filtering data to organise information effectively.
  • Conditional Formatting: Applying formatting rules to highlight key data points dynamically.
  • Enhanced Charting: Creating and modifying charts for clear and impactful data visualisation.

About the Instructor

Naomi is a Microsoft Office Master Instructor with extensive experience in computer training. Her passion for facilitating learning and helping participants achieve their goals is reflected in outstanding evaluations.

Naomi has delivered training across various industry sectors and developed specialised materials tailored to different clients. She is enthusiastic about teaching efficient and effective use of Microsoft products, ensuring participants leave the course excited to apply their new skills.

Enrol Today!

Enhance your Excel proficiency and boost your productivity with our Microsoft Excel Intermediate Course. Contact us today for more information on course availability and enrolment options.

$840

Mine Training Australia
Osborne Park or On-siteMine Training Australia Trainers will come directly to your company’s location

✅ Revision Exercise

✅ Complex Formulas

✅ Scoping Formulas

✅ Logical Functions

✅ IF, AND, OR, NOT

✅ Number Formatting

✅ Conditional Formatting

✅ Data Bars, Icon Sets, Colour Scales

✅ Applying Borders

✅ Working with a Worksheet

✅ Adv Find and Replace

✅ Page Setup

✅ Print Titles

✅ Creating Sparklines

✅ Sorting Data

✅ Filtering Data

✅ Understanding Chart Elements

✅ Chart Object Formatting

 

A moderate English language, literacy and numeracy skill is required.

Important: Participants are required to bring their own laptop for training days.

Lunch: Please feel free to bring your own as we have lunchroom facilities available i.e. microwave, fridge.

Parking: Available on-site or alternatively a short walk from Glendalough Train Station.

Microsoft Excel Intermediate Course – FAQ’s

General Information

What is the Microsoft Excel Intermediate course?
The Microsoft Excel Intermediate course is designed for individuals who have basic Excel skills and want to enhance their proficiency in data management, analysis, and automation. It covers advanced formulas, functions, data manipulation, and productivity-enhancing features.

Who is this course suitable for?
This course is ideal for:

  • Professionals looking to improve their Excel efficiency.
  • Business owners and managers who work with financial and operational data.
  • Office workers, analysts, and administrators who need to manage and report data.
  • Individuals who have completed the Microsoft Excel Essentials course or have equivalent knowledge.

Is this course nationally recognised?
No, this is a professional development course and not a nationally recognised qualification. However, it provides valuable skills applicable in various industries.


Course Details

What does the course cover?
The program covers key topics, including:

  • Advanced formulas and functions (IF, VLOOKUP, HLOOKUP, INDEX, MATCH).
  • Conditional formatting and data validation.
  • Working with tables and structured references.
  • PivotTables and PivotCharts for data analysis.
  • Using named ranges and absolute/relative references.
  • Introduction to Macros for process automation.
  • Advanced sorting, filtering, and data organisation techniques.

How long does the course take to complete?
The course is typically one day long, including hands-on exercises and guided learning.

What are the delivery methods for the course?
We offer flexible delivery options, including:

  • Face-to-face training sessions at our training facility.
  • On-site training for corporate groups.
  • Online interactive sessions for remote learning.

Are there any prerequisites for enrolment?
Yes, participants should have:

  • A basic understanding of Microsoft Excel (such as completion of the Microsoft Excel Essentials course).
  • Basic knowledge of formulas, formatting, and navigation within Excel.
  • Access to a computer with Microsoft Excel installed (for online learners).

Assessment and Outcomes

How is the course assessed?
There is no formal assessment. However, participants will complete practical exercises throughout the training to apply their knowledge.

What will I achieve upon completion?
Upon completing the course, participants will receive a Certificate of Completion from Mine Training Australia, confirming their attendance and participation in the course.

Will this course help me advance my career?
Yes, improving your Excel skills can enhance job opportunities and efficiency in roles that involve data management, financial analysis, and reporting.


Cost

How much does the course cost?
Please view our website for information on fees for this course.

Are there any additional fees?
No additional fees apply. The course fee includes all training materials and access to training exercises.


Additional Support

What support is available during the course?
We provide comprehensive support, including:

  • Access to an experienced trainer for guidance and feedback.
  • Hands-on exercises with real-world examples.
  • Post-course support for follow-up questions.

Can I get credit for prior learning?
No, this course does not offer Recognition of Prior Learning (RPL), as it is a professional development course rather than a formal qualification.

What if I need to withdraw from the course?
If you need to withdraw, please notify us as soon as possible. Refunds or rescheduling options may be available depending on the circumstances and timing of your withdrawal.


Enrolment

How do I enrol in the course?
You can enrol online via our website or contact us directly for assistance. Our team will guide you through the process and provide all necessary information.

What documents do I need to enrol?
There are no mandatory documents required, but you may need to provide basic personal details for registration.


Further Information

For further details, please contact us or call our friendly team on (08) 9221 1803.

Enrol Today

RTO: 51586
N

Mine Training Australia will provide you with all the skills and knowledge you need for working in Mines in Australia

You can get in touch with us on our contact form, by email, or by phone. The Mine Training Australia team are always available to discuss your training requirements in Perth, regional WA or throughout Australia.

Family Owned & Run Business in WA

Z

Nationally Recognised Certifications

Industry Specialists

w

Easy Help & Support

Easy & Flexible Payment Options

h

Specialised Trainers & Assessors