EXCE301

Intermediate Excel:
Level Two
22 May 2025
10am - 12pm AEST

Master formulas, pivot tables, and data visualisation techniques to unlock powerful insights.
Write your awesome label here.

Course contents

Course Overview

This course is designed to elevate your Excel proficiency. Delve into advanced techniques to streamline your data analysis and reporting processes. Master the art of creating dynamic pivot tables, automate repetitive tasks with VBA macros, and use Goal Seek to solve complex problems.

Leverage quick analysis tools to rapidly format data, generate charts, and apply conditional formatting. Understand and apply Boolean logic to create complex formulas and filter data effectively. Explore powerful functions like CHOOSE and LOOKUP to enhance your data manipulation and analysis capabilities.

By the end of this course, you'll be equipped to efficiently analyse data, create interactive reports, and automate tasks.

This program assumes knowledge of our EXCE201 – Excel Intermediate Level One program.


  • Create dynamic pivot tables to summarize and analyse large datasets.
  • Utilize quick analysis tools for fast data formatting, charting, and calculations.
  • Automate repetitive tasks with VBA macros.
  • Find optimal solutions to complex problems with Goal Seek.
  • Filter data based on multiple criteria and conditions with advanced filtering techniques.
  • Understand and apply Boolean operators (AND, OR, NOT) to create complex formulas.
  • Use the CHOOSE function to select values from a list based on an index number.
  • Use the LOOKUP function to search for a value in a range and return a corresponding value.
facilitated by

Joseph Dimarco

Joseph Dimarco is the Managing Director of Dimarcorp Group and the primary facilitator of our finance, governance and planning and software seminars.
Joseph is an experienced Accountant and has worked in Senior Executive roles within the Aged Care and Disability Sectors. He has been part of several large acquisitions within the aged care sector, as well as amalgamations, which as involved restructuring the business, including financial, marketing and human resources aspects.

He has managed and led finance, ICT, marketing, facilities and human resources teams for several large not-for-profit organisations and is passionate about enhancing leadership skills and making a positive cultural shift in the sectors workforce.

Joseph has facilitated training to over 3000 aged care and disability Board Members, Managers and staff. He is committed to supporting both “for-profit’ and “not-for-profit” aged care and disability providers to reach their financial and organizational goas and to ultimately fulfil their mission.

Frequently asked questions

What is the cancellation/rescheduling policy? 

Notice of cancellation where at least 14 days remain in advance of the seminar date, will be refunded in full. Notice of cancellation less than 14 days from the seminar date will not be refunded. In the event of a "no show", 1 substitute seminar is permitted for the next available seminar. A $50 change fee will apply to any additional changes.

Payment will still be required for registered delegates who fail to attend the seminar without cancellation within the 14 day time frame.

If the seminar does not have enough participants to adequately facilitate, Dimarcorp Academy at its discretion, may cancel the seminar; refund all fees paid to participants or transfer participants to the next session (if participant/s consent to the transfer).

I want to attend but I can no longer make this date?

Please contact us on 1300 85 00 77 or at academy@dimarcorp.com.au and we will be able to assist you. If there is another date available you will be able to transfer at no extra cost. Additional transfers incur a $50 admin fee. If there are no further dates scheduled, you can elect to attend a different course. 

Do I need to bring anything?

We have got you covered! All the necessary paperwork for your course, including a comprehensive workbook and supplementary handouts, will be provided by us. To ensure a smooth experience, make sure to arrange the technical aspects required if you are joining one of our webinars. Additionally, having a pen handy will be beneficial for any notes you may want to jot down during the session.

How do you provide your training courses?

Our training courses are facilitated both online via webinar, pre-recorded or via in-person at a venue or we can also arrange for inhouse training at your organisation.

Can you provide training on site at my place of work?

We LOVE travelling to organisations and delivering training face to face for them. If you have a group of 10 or more people and would like us to come to you for an Inhouse session please get in touch on 1300 85 00 77 or email us academy@dimarcorp.com.au

Can an Inhouse session be customised to my needs?

We would be delighted to offer the flexibility to customise any of our training courses to fit your organisation's needs. Prior to the session, we will engage in discussions to understand your focus areas, address any specific challenges and align the training with your company's Mission, Vision and Values. For more information or to discuss this further please email academy@dimarcorp.com.au or call us on 1300 85 00 77.