Excel Tips and Tricks for Bank Audit | Bank Branch Audit | Bank Audit
Vložit
- čas přidán 3. 04. 2020
- #CASansaar #BankAudit #ExcelTips
Excel Tips and Tricks for Bank Audit
How Excel can helps you while conducting Bank Audit discussed by CA. Deepak Garg.
• Excel Tips and Tricks ...
About this Video -
In this Video, CA Deepak Garg Discussed about various excel tools which can be used while conducting Bank Audit.
DISCLAIMER :-
This Video is for the purposes of information / knowledge and shall not be treated as solicitation in any manner or of for any other purposes whatsoever.
It shall not to be used for any legal advice /opinion and shall not to be used to rendering any professional opinion. Viewers are advised to kindly go through to original Government publications / notifications and published case laws or judicial pronouncements.
The statements and opinions expressed in video are those of the speaker and do not necessarily reflect those of the CA Sansaar or any of its employees. CASansaar Team does not take any responsibility for the views of the Speaker..
#casansaar #excel #exceltips #exceltricks #learnexcel #excelforbankaudit #bankaudit #advanceexcel #excellearning #bankbranchaudit
Our Social Links - Follow CA Sansaar
CZcams / casansaarca
Twitter / casansaar
Facebook / casansaarca
Linkedin / casansaar
Watch Excel Tips and Tricks for Bank Audit - Part 2
czcams.com/video/gHGTRzaEhdM/video.html
Monotonous work done in miracles brings smile on ... face
Thank you sir for sharing your work knowledge...
Thank you :)
Vivek Khurana Ji, you have been rendering great and selfless service to the CA Profession in the time of Pandemic.
wonderfullpresentation good CA Suresh Bhandari
Thanks a lot for hosting and also to Dipakji. It was such a minute but worthy functions that has been touched upon.
Such a wonderfull presentation sir. I just love this. Thank you sir.
I just watched this video and found it very useful. Although we use many of these formulas but the way of presentation is really Good Deepak.
Nice presentation by using the formulas which everyone in our profession is used regularly in day to day work.
Thanks, Deepak Ji and Khurana Ji for such a Wonderful session.
Excellent presentation Deepak Ji. These tools will be beneficial not only in bank audits but in other professional work also. Some tools I was using earlier also, but only common features. Today came to known to more advanced another features that are very much useful and never used earlier by me. And also presentation is straight forward to the topic concerned and excel features. Thanks again to you and Mr. Vivek Sir.
Thank you sir .it is very useful. please keep on sharing this kind of tricks
Very helpful presentation Sirji Thanks Alot
Really nice presentation. Thanks
Very good presentation and use of formulas, I think myself as good at Excel, however, some of the use of formulas were also quite astonishing for me as well. Good Luck.
Great session many thanks
Thank You Deepak Ji and CA Sansaar for organising such a wonderful program on use of Excel effeciently in audit, Deepak ji has skillfully demonstrated the use of excel tools and techniques in different scenarios.
Thank you :)
Thanks for Very Valuable video Vivek Ji and Deepak Ji.- CA Atul Mittal
Very nice initiative by Vivek sir
Thanks Deepak Ji.
Very easily and comprehensibly explained. Thank u Sir
Good presentation Sir.
It may sound silly but please let me know while Cal. Interest for 1 day according to monthly spread.. whether interest on interest will be charged..or interest will be deducted from customer account on daily basis.
Sir,
You're requested to kindly share the sheet so we can able to practice.
Too too helpful.. keep making more such videos
very useful. well done sir
very helpful this excel tips
Very clearly ans easily explained. Thank you
This is excellent video sir..Please create one more with more formulas for auditing purposes
Thank You for this wonerful session...its really very helpful
Again thanks 🙏
Very Useful.. Thanks a lot.
Very beneficial
Very useful information it's definitely going to save time
Vivek sir, you are doing good for our profession
Nicely Presented and Explained
Nice presentation
Thank you sir for sharing the knowledge.
Sir, will you please let us know what type of reports, we should extract from Finacle etc. which can help us to carry out the audit more efficiently.
Very useful video.
Very nice session,Very good initiative
Very nice video thanks sir.
Very Smooth!!
Excel Sheet Download Link...
www.casansaar.com/files-Bank-Branch-Audit-Excel-Tips-and-Tricks-for-Bank-Audit/6298.html
Very useful
Excellant
Thanq so much sir
THANKYOU SIRRRRRR
Sir please upload the excel file which you have used in this video for practise purpose
Thanks fo sharing a wonderful session. However, I really don't know how do we download the files. It's a request please share the link so that we can doenlaod @CA SANSAAR
Many new tips learnt.
However, in the slide of the outcome of Cl Bal on each Date, say on 08.04.2019, Withdrawal of 1,00,000 only is reflected, but not Withdrawal of 32,800. So, the column of Withdrawals is incomplete or misleading.
Is it possible for you guys to attach the sheet also?
Please attach the sheet also as it will help us to learn better.
Thnx in advamce
Sir hw to download that sample bank statement from which site
Download the Excel Sheet. Here are the link,
www.casansaar.com/files-Bank-Branch-Audit-Excel-Tips-and-Tricks-for-Bank-Audit/6298.html
Sir pls share excel file..as u share the excel of part2
Download the file...
www.casansaar.com/files-Bank-Branch-Audit-Excel-Tips-and-Tricks-for-Bank-Audit/6298.html
plz how to audit in excel
plz example
plz give a sheet of this video for practice purpose
Would have been better if you could share the excel file you used for presentation.
Very good Presentation please share excel sheet khadaria@gmail.com
czcams.com/video/3Rctp7K4OcM/video.html
Sir Please share file for practice at officemjkadam@gmail.com
Sir please share file at indulgarg3@gmail.com
Not able to login
Sir pls share file at indulgarg3@gmail.con
Not able to download by login