Excel for Accounting & Audit Trainees Course

Product Details

Trainees need to hit the ground running when they join a firm but one of the biggest things that slow trainees down is Microsoft Excel. Imagine what the wasteful labour cost must be from using it inefficiently?

Put your trainees in the lead by allowing ProBeta to help them be more efficient as we practically navigate the Excel functions / scenarios most often encountered in practice.

Course Content:

Introduction: Terminology / layout and interface / move or copy sheets / Status Bar / various ways to Paste data
Recovering Lost Documents: Finding lost documents / Attaching to emails
Built in Templates: Invoices / Loan amortisation schedule
Navigating Seamlessly: Freeze panes / Quick access toolbar / How to navigate without a mouse / Line breaks.
Data Editing: Sorting / filtering / Subtotal formula / conditional formatting.
Data Searching: VLookUps / Search and Replace text.
Data Extraction: Flash fill / Text-to-Columns / Concatenate.
If Statements: If and CountIf formulae.
Clean up GL: Various helpful tools to clean up general ledger accounts
Building Formulae: Cell referencing within formulae i.e. relative and absolute references.
Tables / Graphs: Create pivot tables.

All Included:

Video presented course
Downloadable course material
Certificate of training
SAICA, SAIBA, ACCA, IACSA, IRBA Accredited - 3 verifiable CPD hours

Hennie Fritz 19/11/2025

Email submission

Hello Ashton

We appreciate the excellent service in accommodating us in this way.

Best regards

Shivali Pema 10/11/2025

Good day,

Thank you for a very informative Financial Statements Webinar, truly beneficial on my end.

Thank you again for the course material and recordings

Have a lovely week!

Regards,

Hendri Fritz 30/10/2025

Good afternoon Ashton,

Thanks for the informative sessions on the Tax for Beginners Self-Study Package. It’s a great course that clearly explains how to perform the calculations. Some points are repeated throughout the sessions, but that actually helps reinforce the concepts and makes the content feel more complete especially when the speaker covers topics like Capital Gains Tax (CGT).

Thanks once again I enjoyed the course and would recommend it to anyone that has no tax experience or even wants to do their own tax.

Kind Regards

Belinda Viviers 31/10/2025

Facebook

Started with my course, big thumbs up

Thanks

Rodney Ndungase Chauke 17/08/2023

email submission

It's so professional and worth recognition.

100% Bizfacility.

I saw your course offered through Udemy, but I told myself, support local business direct, regardless of massive discount offered.

Thanks for your tireless attention to customer service.

All the best

Ushen 18/05/2023

One of the most insightful sessions I have been to and Ruzel I just wanted to say thank you for the video, material and content discussed as this was such a breath of fresh air to me. Looking forward to a few more in the coming weeks.

Much appreciated!

Zillah Abel 08/05/2023

Email Submission

Thank you so much for this course. It will be very valuable for me.

As a business owner it is overdue that I arm myself with bookkeepeing knowledge.

Kind Regards,

Barbara Theron 24/04/2023

The course was very informative and I enjoyed it, many thanks.

Kind Regards,

Melanie Thompson 13/04/2023

I was very impressed with the training. It answered real questions / issues that arise. Was really helpful.

Kind Regards,

Evette 05/04/2023

I just completed the full course.

Thank you for the amazing course, I learned so much from it!! Will definitely do more courses with Biz Facility!

Kind regards,

Bookings