Advanced Excel Training for Auditors

Why this Training ?

Modern auditors are expected to analyse large volumes of data, identify risks faster, and deliver audit insights efficiently. This practical training equips auditors with Advanced Excel techniques for audit planning, testing, data analysis, exception reporting, and working paper automation.

What You Will Learn

• Advanced formulas for audit analysis
• Data cleansing and audit data preparation
• Pivot Tables for audit testing and reporting
• Risk-based sampling techniques
• Detection of anomalies and exceptions
• Audit dashboard creation
• Automation of audit working papers and reports
• Excel best practices for audit efficiency

Course Prerequisites

Participants should have a good working knowledge of Excel and be comfortable using formulas, functions, and Pivot Tables.

Who Should Attend?

• Internal Auditors
• External Auditors
• Risk & Compliance Professionals
• Finance Managers
• Audit Supervisors and Managers
• Professionals involved in assurance and governance

What Makes This Training Different?

Audit-focused case studies
Real-world audit datasets
Practical hands-on exercises
Templates that can be applied immediately at work
Led by experienced Excel and Audit Analytics trainers

When will the training take place?

Date: 13th – 15th October 2026
Time: 8:00 PM – 10:00 PM (EAT)
Mode: Virtual

Will I receive a certificate after the training?

We will offer a certificate of achievement and a link for you to add to your LinkedIn profile.

Trainers

	Patrick Ngotho Lead Trainer Sunesis Consulting Limited Patrick Ngotho is the Lead Trainer at Sunesis Consulting, with over 27 years of experience training Excel and Power BI to more than 1,000 participants across various industries.
	Joan Wambui Advanced Excel Expert Trainer Sunesis Consulting Limited Joan Wambui is an Advanced Excel Expert Trainer at Sunesis Consulting and a data analyst who transforms raw data into clear, actionable insights using Excel, Python, and Power BI.