## EXCEL TIPS & TRICKS – ANALYTICAL PROCEDURES USING EXCEL

In this video on Excel Tips & Tricks, we discuss Analytical Procedures using Excel and Beneish Model
Analytical procedures in Audit are an essential part of Audit Procedures. Excel is a wonderful Tool for performing analytical procedures.

This is extracted from a webinar “Analytical procedures using Forensic Models and Excel” hosted by Sansaar on 19-06-2021.

The complete webinar is hosted on the YouTube channel of CA Sansaar

– Sample data to follow along: https://www.msmehta.com/analytical-procedures/

SA 520 – Analytical Procedures are Evaluations of financial information through analysis of plausible relationships among both financial and non-financial data.
Excel and Forensic models like Beneish Model can be used to perform Analytical Procedures.
Analytical Procedures are about relationships and are required at the Initial Stage, during the audit, and end of the audit
Analytical Procedures are also required for risk Assessment as specified in SA 315.
This video discusses how Excel can be used for such Analytical review i.e Trend Analysis and Ratio Analysis.
My other videos on Using Excel 👇

TOP 10 EXCEL TIPS in Hindi/English Series
#2 Keyboard Shortcuts https://youtu.be/tu52UdJR5MM
#3 Custom Sort https://youtu.be/sThclPC2AIU
#4 Horizontal Sort https://youtu.be/DHKrDDYq_1o
#5 Go to Special https://youtu.be/SofqWqJu27E
#7 Table https://youtu.be/IVGIBq7tY6I
#8 Subtotal https://youtu.be/AnEfgHP4g90
#9 Consolidate https://youtu.be/WERAbDJ3ga8
#10 Flash Fill https://youtu.be/PpDr4JPdT5U
Excel Tips & Tricks- Hindi
#Pivot Table https://youtu.be/KFJJIRPytPg

Excel Productivity Hacks
◾Autofilter, Flash Fill https://youtu.be/IGjw-YFHvLU
◾Using Tables https://youtu.be/nKJdgFtjZ_E
◾Consolidate https://youtu.be/7AwJLMJ6OeE
◾TEXTJOIN https://youtu.be/o-7uLzl7J6k
◾SUBTOTAL https://youtu.be/01rrV7_fw64
◾SUBTOTAL Outline https://youtu.be/tVhdN9orSQ8
◾Evaluate Formula https://youtu.be/-6iSLH-x8b0
◾ANALYZE DATA https://youtu.be/KnkkVStpr_Q

3 Simple Powerful Tools for Tax Audit 🎯
#1 Excel https://youtu.be/bGzoTGtdNb4​
#2 eCAAT https://youtu.be/3vl4KXyuO44​
#3 MDA Audit Tool https://youtu.be/V_alqesIUhI

Excel as an Audit Tool https://youtu.be/Ne3w6Jj2ZSU
The Data Analysis Story with Excel https://youtu.be/0ZUxLCDUNsc
Analytical procedures using Excel https://youtu.be/Nd2OnCrl34M

Bank Audit Series
Part 1: How to convert bank reports to Excel

Part 2: How to use Filter in Excel to analyse Loan Balance Report. https://youtu.be/4Z6W40gSWOA
Part 3: How to use the Power of Pivots to analyse Loan Balance Report. https://youtu.be/whdEZDSdoIM
Bank Audit in Computerised Environment

1. Thumbs up, if you learned something new today. 👍