Excel Add-In: Internal Audit Tools

Custom Excel .xlam add-in designed to streamline internal audit fieldwork and documentation.

🔧 Features:

• One-click insertion of audit tickmarks (✔, Δ, ≠, etc.) — cell-based or floating
• Import templates directly from SharePoint (e.g., workpapers, checklists)
• Insert tickmark legends, notes blocks, and directional arrows
• Link to sampling guidance resources
• Custom ribbon UI for easy navigation

Power BI Dashboards

Vendor Payments Monitoring

Internal Audit Issue Tracker

Adventure Works Report

Property Management Dashboard

Sales Dashboard

Python Projects

Audit Sampling Tool

Internal audit sampling utility for filtering, random sampling, and file export.

Benford’s Law Audit Tool

Statistical fraud detection tool using Benford’s Law to flag anomalies in financial data.
GitHub Repo

Fair Lending Analysis

Fair Lending pricing and underwriting simulator using synthetic borrower data, statistical testing, and ipywidgets UI.

SQL Projects

Data Job Market Analysis

GitHub Repo
SQL analysis of job postings using PostgreSQL and Python to surface skill trends.

Sales ETL & Dashboard

GitHub Repo
SQL-based ETL pipeline to clean and aggregate sales data, paired with a Power BI dashboard for business insights.

Excel Templates

Risk Assessment Matrix

Download a customizable Excel-based risk matrix for internal audit and compliance teams.
📂 Download Template

---

More Coming Soon

• FP&A Model
• Audit Planning Template
• Risk & Control Matrix (RCM)
• Issue Tracking Log