EXCE201

Excel Beginners
29 May 2025
10am - 12pm AEDT

Build on your skills to become and Excel master user!
Write your awesome label here.

Course Contents

Course Overview

Become a Microsoft Excel master with our Excel Intermediate program. Building upon the basics, this program delves into the more complex functionalities of Excel. Pivot tables, quick analysis, intricate formulas, and functions are just part of the key learning outcomes of this program.

This program assumes knowledge of our EXCE101 - Microsoft Excel Beginners program.

  • Use common worksheet functions
  • Use filling techniques
  • Apply a variety of page setup techniques
  • Apply borders to cells and ranges in a worksheet
  • Create and use defined names in a workbook
  • Apply conditional formatting in ranges in a worksheet
  • Create and work with tables
  • Use a variety of financial functions
  • Select and change the format of object in a chart
  • Use a range of elements and features to enhance charts
  • Create more complex formulas and functions
  • Apply a range of number formatting techniques to sheet cells
  • Understand and use Excel's Quick Analysis tools
  • Understand and create basic pivot tables
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 organisational goals 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.