Join Our Most Professional Telegram Group. Only Learning. No Nonsense. https://t.me/TheExcelism
|
Topic: 10 Magical Features of Ms-Excel
Speaker: CA Saran Kumar U (Founder, Excelism.in) Working Files: Download Key Take Aways: 1. Extract the Files Names from the Folder in Ms-Excel using Macro 4.0 2. How to Create Custom Templates in Ms-Excel (.XLTX File Type) 3. Usage of Name Box in Auditing in Case of BIG formula in Excel 4. Best Usage of Custom List in Ms-Excel 5. Consolidation of Data using Clipboard in Ms-Excel 6. Life Saver!! Clean Function in Ms-Excel 7. Magic of Auto Subtotal in Ms-Excel 8. Connect Live Google Spreadsheet data to Ms-Excel 9. Get the List of External Links in Ms-Excel (Macro 4.0) 10. Usage of Hidden Camera in Excel |
|
|
Topic: Art of Preparing Financial Statements with Ms-Excel
Speaker: CA Saran Kumar U (Founder, Excelism.in) Key Take Aways: 1. How to use the Tag System for BS and PL 2. Preparation of Master Data of Tags 3. Using VLOOKUP, SUMIF(S) Functions 4. Linking Excel Data to the Word Document for Annual Report 5. Conversion of Tally Trail Balance into Proper Format 6. Other Misc Features of Excel |
|
|
Topic: Spreadsheet and Forensic – A Relation
Speaker: CA Saran Kumar U (Founder, Excelism.in) Key Take Aways: 1. What you see in Ms-Excel is not always correct – Case Studies 2. Forensic Aspects in Spreadsheet – Case Studies 3. Errors in Excel reveal some story – Case Studies 4. Benford’s Law in Excel - NSE Stocks Case Study 5. Other Forensic Techniques in Ms-Excel |
|
|
Topic: Statutory Bank Branch Audit Using Excel (Part 2)
Speaker: CA Saran Kumar U (Founder, Excelism.in) Key Take Aways: 1. Conversion of Loan Balance File using Text to Columns 2. Analysis of Loan Balance File 3. Documentation of LFAR 4. Stratification of Data using Pivot Tables |
|
|
Topic: Statutory Bank Branch Audit Using Excel (Part 1)
Speaker: CA Saran Kumar U (Founder, Excelism.in) Key Take Aways: 1. How to Convert Text Files into Excel 2. CCDP Text File Conversion into Excel 3. Introduction to Core Banking Solution 4. Analysis of CCDP File 5. Documentation of Bank Audit |
|
