Udemy - Excel For Auditors And Fraud Examiners

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Mastering Essential Excel Skills for Audit and Fraud Examination
• 1 - Introduction to Excel for Auditors A MustWatch Session.mp4 (54.3 MB)
• 2 - Boosting Efficiency and Effectiveness in Excel.mp4 (109.4 MB)
• 2 - Section-1-Lecture-1-5-Practice-Workbook.xlsx (56.1 KB)
• 3 - Understanding and Using Wildcards in Excel.mp4 (68.2 MB)
• 4 - Do This Instead of Merge Cells in Excel.mp4 (24.4 MB)
• 5 - Quickly Removing Blank Rows and Cleaning Data.mp4 (19.9 MB)
2 - Extracting Cleaning and Structuring Audit Data
• 10 - Structuring Data into Tables for Better Analysis.mp4 (23.0 MB)
• 11 - Managing Trailing Negative Values.mp4 (49.6 MB)
• 12 - Handling Common Date Issues in Excel.mp4 (43.8 MB)
• 13 - Using AIPowered Features in Excel for Auditors.mp4 (47.2 MB)
• 14 - Distributing Data as per Requirement.mp4 (48.7 MB)
• 15 - Reversing Order and Getting Specific Data from Complex Data.mp4 (19.5 MB)
• 16 - Combining and Extracting Data Effectively.mp4 (91.8 MB)
• 17 - Deriving Dates Months and Years from Data Sets.mp4 (5.2 MB)
• 6 - Section-2-Lecture-6-17-Practice-Workbook.xlsx (31.9 KB)
• 6 - Smart Formatting Techniques for Clean and Reliable Data.mp4 (26.1 MB)
• 7 - Extracting Data and Skipping Blank Cells.mp4 (37.9 MB)
• 8 - Splitting and Converting Data Across Columns 1.mp4 (55.4 MB)
• 9 - Splitting and Converting Data Across Columns 2.mp4 (62.9 MB)
3 - Detecting Anomalies Risky Transactions and Irregularities
• 18 - How to Identify Outliers in Data.mp4 (68.5 MB)
• 18 - Section-3-Lecture-18-21-Practice-Workbook.xlsx (56.9 KB)
• 19 - Spotting and Removing Duplicate Transactions and Entries.mp4 (45.0 MB)
• 20 - Detecting Anomalies or Suspected Figures in Data.mp4 (32.6 MB)
• 21 - Identifying Transactions on Weekends Holidays and AfterHours.mp4 (313.4 MB)
4 - Data Analysis Techniques for Auditors Fraud Examiners
• 22 - Leveraging the Quick Analysis Tool for Instant Insights.mp4 (50.6 MB)
• 22 - Section-4-Lecture-22-Practice-Workbook.xlsx (32.9 KB)
• 23 - Reconciling Balances and Validating Data Integrity.mp4 (73.8 MB)
• 23 - Section-4-Lecture-23-Practice-Workbook.xlsx (13.3 KB)
5 - Fraud Detection Using Benfords Law
• 24 - Section-5-Lecture-24-Benfords-Law-Theory.pdf (379.6 KB)
• 24 - Understanding the Theory Behind Benfords Law.mp4 (68.0 MB)
• 25 - Applying Benfords Law for Fraud Detection in Excel.mp4 (95.4 MB)
• 25 - Section-5-Lecture-25-Practice-Workbook.xlsx (44.2 KB)
6 - Special Tools and Techniques for Auditors Fraud Examiners
• 26 - Performing Correlation and Trend Analysis in Audit.mp4 (151.1 MB)
• 26 - Section-6-Lecture-26-Practice-Workbook.xlsx (42.2 KB)
• 27 - Creating and Understanding Heat Maps for RiskBased Audit Planning.mp4 (81.5 MB)
• 27 - Section-6-Lecture-27-Practice-Workbook.xlsx (21.4 KB)
• Bonus Resources.txt (0.1 KB)