Excel for Auditors and Fraud Examiners

Clean messy Excel data in one sheet by removing formatting with clear formats, trimming extra spaces with the trim function, and converting values to static percentages using paste special.

Learn to extract text or numerical values from mixed data in Excel using go to special and constants, and paste with skip blanks to combine dates into one column.

Learn to split a single-column sales dataset into multiple columns using Excel's text to column tool with ampersand delimiter, enabling pivot tables, charts, and formulas for analysis.

Split data across columns using the text to columns tool with forward slash delimiters in Excel. Handle consecutive delimiters as one to ensure accurate column alignment and enable subsequent analysis.

Learn to structure data into columns using text to columns, delimited settings, and auto-fit column width and row height for efficient analysis in Excel.

Learn to recognize and convert trailing negative values stored as text in Excel using the text to columns wizard, apostrophes, and the fixed length option, enabling proper numerical calculations.

Convert dates stored as text to Excel dates despite varying separators and patterns. Use text to columns with delimited format and set month day year to enable pivot tables.

Explore Flash Fill in Excel, a pattern-based tool that automatically completes data entry for text-based transformations like splitting, joining, and formatting, with data consistency considerations and static results.

Master flash fill in Excel to extract first names, last names, and emails from patterns. Learn to combine or reorder data, fix top-to-bottom errors, and distinguish non-dynamic from dynamic results.

Use flash fill to quickly extract numbers or letters from mixed data in Excel, create patterns like 4645, and reverse or reorder values with ctrl-e for accurate data analysis.

Learn to use flash fill to format numbers in patterns, extract numerical values, and combine text with data, then pull dates, units, and rates for auditors and fraud examiners.

Learn to derive years, months, and days from date ranges using Excel's flash fill with a pattern in cell A2 and Ctrl+E to fill.

Identify anomalies and outliers in erp data using excel tools like date checks, flash fill, and scatter charts; discuss root causes with management and generate reports with pivot tables.

Spot and remove duplicate invoices across two lists with Excel conditional formatting, dynamic highlighting, and a final cleanup; learn to concatenate name and department with ampersand to reveal cross-column duplicates.

Learn to detect anomalies in sales data by identifying figures rounded to hundreds or thousands using the mode function in Excel, revealing a red flag in large transactions.

Identify anomalies in transactions on weekends holidays and after hours using Excel functions such as text date time or if and apply conditional formatting for auditors and fraud examiners.

Learn to use Excel's quick analysis tool to format data, apply conditional formatting, create charts and sparklines, and generate dynamic insights on quarterly sales by representative.

Use Excel's consolidate tool to reconcile opening and closing balances for debtors and creditors, identify discrepancies, and report differences to management for clarification.

Explore Benford's law and leading-digit distributions to detect anomalies and fraud in numerical data, with practical Excel analysis and understanding of its limitations for artificial or small datasets.

Apply Benford's law in Excel to detect fraud by extracting first digits, computing actual vs expected frequencies, and flagging deviations for investigation.

Identify the relationship between vehicle expenditure and response time, and perform trend analysis in audits using Excel's trend and correlation functions.

Create and interpret heat maps in Excel to support risk-based audit planning by visualizing risk IDs with likelihood and impact scores, calculating risk ratings, and prioritizing high-risk areas.