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
Make Payment
What is the training cost?
Ensure you enter the right amount and choose the correct currency when making a payment.
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.
Read More
Patrick’s experience covers facilitating training in advanced data analytics using Excel and Power BI. He also has been involved in framework design and implementation of various management reporting projects that cover integrating Excel and/or Power BI with ERPs and other data sources for centralized reporting.
Patrick has facilitated training for corporates over the last 22 years covering various sectors including Banks, NGOs, Audit, Insurance, Oil Marketers, Beverage manufacturers. The participants trained cover various cadres including C-level, Middle Management, Operations and Trainees.
He has also been involved in implementation of reporting solutions that are consumed by various levels of staff including Board of Directors, Directors and Operations managers. Patrick holds a Bachelor of Science in Mathematics (Statistics Option), Microsoft Certified Professional in Power BI and is a Member of ISACA Kenya Chapter.
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.
Read More
Joan Wambui is a data analyst specializing in transforming raw data into clear, actionable insights using Excel, Python, and Power BI.
She is proficient in data cleaning, modelling, and visualization, with a strong focus on building efficient reports and dashboards that support decision-making.
Her expertise lies in simplifying complex datasets, uncovering trends, and delivering structured, reliable analysis for business performance tracking.
Beyond analysis, she is passionate about helping others work smarter. Joan actively supports teams in improving their day-to-day workflows by introducing practical automation techniques that reduce manual effort and increase accuracy.
By streamlining reporting processes and optimising data workflows, she has helped cut report generation time by up to 60%, enabling teams to focus more on insights and less on repetitive tasks.
