The site would be on maintenance from 8th Jul 2019 2.00pm to 8:00pm. You may experience some issue during this time.

loading

Advanced IT Course

By The Institute of Chartered Accountants of India

Course Study Materials

UNIT I: Auditing in ERP Environment

  • youtube

    1. Auditing in ERP Environment-Overview

    Duration: 31:53
  • ePub

    Study Materials

  • assessment

    Assessment

    10 Questions
  • youtube

    2. IT Governance Checklist

    Duration: 30:35
  • ePub

    Study Materials

  • assessment

    Assessment

    9 Questions
  • youtube

    3. Program Changes - Documentations

    Duration: 22:57
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    4. Access Security - Activities

    Duration: 20:44
  • ePub

    Study Materials

  • assessment

    Assessment

    9 Questions
  • youtube

    5. Access Security - File System Security

    Duration: 26:28
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    6. Access Security - Risks and Controls

    Duration: 25:30
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    7. IT Operations - Data Backup

    Duration: 24:09
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    8. IT Operations - Risks and Controls

    Duration: 21:04
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    9. Testing GITCs

    Duration: 22:45
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    10. What are automated controls

    Duration: 23:43
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    11. Types of Automated Controls

    Duration: 19:30
  • ePub

    Study Materials

  • assessment

    Assessment

    7 Questions
  • youtube

    12. Process of Identification of AAC's

    Duration: 24:28
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    13. Review of Design Effectiveness

    Duration: 30:29
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    14. Review of Operating Effectiveness

    Duration: 10:48
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    15. Timing of AAC's Testing and Sample Sizes

    Duration: 18:01
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    16. Segregation of Duties and Sensitive Accesses

    Duration: 28:29
  • ePub

    Study Materials

  • assessment

    Assessment

    21 Questions
  • youtube

    17. Validation of Reports

    Duration: 21:18
  • ePub

    Study Materials

  • assessment

    Assessment

    9 Questions
  • youtube

    18. Validate Reports - Example

    Duration: 19:39
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    19. Validation of reports - Cont...

    Duration: 18:28
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    20. System implementation and Data Migration Review

    Duration: 34:04
  • ePub

    Study Materials

  • assessment

    Assessment

    11 Questions
  • youtube

    21. Identify NSJE

    Duration: 20:09
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    22. Completeness of Data - Part A

    Duration: 20:32
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    23. Completeness of Data - Part B

    Duration: 18:29
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    24. Completeness of Data - Part C

    Duration: 18:09
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions

UNIT II: Database Application Using MS-Access

  • youtube

    25. Advanced SQL Queries -Advanced Queries

    Duration: 12:04
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    9 Questions
  • youtube

    26. Advanced SQL Queries - Joining Tables in Queries

    Duration: 10:20
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    5 Questions
  • youtube

    27. Designing Forms & Reports - Advanced Form Design

    Duration: 31:54
  • assessment

    Assessment

    10 Questions
  • ePub

    28. Designing Forms & Reports - Advanced Form Design - Cont..

  • ePub

    Exercise

  • assessment

    Assessment

    7 Questions
  • youtube

    29. Designing Forms & Reports - Advanced Reports

    Duration: 15:12
  • assessment

    Assessment

    7 Questions
  • ePub

    30. Designing Forms & Reports - Advanced Reports - cont….

  • ePub

    Exercise

  • assessment

    Assessment

    8 Questions
  • youtube

    31. Building Criteria Expressions - Using Operands in Criteria Expressions

    Duration: 7:38
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    24 Questions
  • youtube

    32. Building Criteria Expressions - Using built-in functions

    Duration: 14:05
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    10 Questions
  • youtube

    33. Macros & Switchboards- Simplifying Task Using a Macro

    Duration: 13:23
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    6 Questions
  • youtube

    34. Macros & Switchboards - Validating Data Using a Macro

    Duration: 9:04
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    5 Questions
  • youtube

    35. Macros & Switchboards- Managing Switchboards

    Duration: 22:22
  • assessment

    Assessment

    9 Questions
  • ePub

    36. Macros & Switchboards - Managing Switchboards - Cont…

  • ePub

    Exercise

  • assessment

    Assessment

    8 Questions

UNIT III: Advance Excel

  • youtube

    37. Working with XML-Understanding of XML

    Duration: 22:49
  • ePub

    Study Materials

  • ePub

    Study Materials

  • assessment

    Assessment

    14 Questions
  • youtube

    38. Working with XML- Understanding of XML in Excel

    Duration: 1:59
  • assessment

    Assessment

    3 Questions
  • youtube

    39. Working with XML- XML Maps

    Duration: 15:05
  • assessment

    Assessment

    5 Questions
  • ePub

    40. Working with XML-XML Maps-Cont...

  • ePub

    Exercise

  • assessment

    Assessment

    4 Questions
  • youtube

    41. Advances In Macros

    Duration: 14:30
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    8 Questions
  • youtube

    42. Applied Financial Analysis - Financial Analysis

    Duration: 10:03
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    8 Questions
  • youtube

    43. Applied Financial Analysis - Financial Ratios

    Duration: 21:02
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    22 Questions
  • youtube

    44. Applied Financial Analysis - DuPoint Analysis & Leasing

    Duration: 8:01
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    9 Questions
  • youtube

    45. Applied Financial Analysis - Financial Sheningans

    Duration: 9:13
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    5 Questions
  • youtube

    46. Applied Financial Analysis - Equity Reasearch

    Duration: 8:37
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    5 Questions
  • youtube

    47. Mathematical & Statistical Tools for Financial Analysis - Testing of Hypothesis

    Duration: 12:18
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    14 Questions
  • youtube

    48. Mathematical & Statistical Tools for Financial Analysis - Anova Analysis & Regression

    Duration: 11:07
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    6 Questions
  • youtube

    49. Applications of MS Excel -Depreciation Accounting

    Duration: 24:13
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    9 Questions
  • youtube

    50. Applications of MS Excel -Marginal Costing & Cash Budgeting

    Duration: 11:07
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    11 Questions
  • youtube

    51. Applications of MS Excel -Discounting & Tax Calculation

    Duration: 16:52
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    5 Questions
  • youtube

    52. Applications of MS Excel -EMI Calculations

    Duration: 17:41
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    13 Questions
  • youtube

    53. Applications of MS Excel -Risk Analysis & Investment

    Duration: 7:50
  • assessment

    Assessment

    10 Questions
  • ePub

    54. Applications of MS Excel - Risk Analysis & Investment - Cont… (Study Materials)

  • ePub

    Exercise

  • assessment

    Assessment

    6 Questions

UNIT IV: MS-Excel as Audit Tool

  • youtube

    55. Introduction to MS Excel as an Audit Tool

    Duration: 9:56
  • ePub

    Study Materials

  • assessment

    Assessment

    6 Questions
  • youtube

    56. Useful Functions For Auditing - Depreciation

    Duration: 23:19
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    5 Questions
  • youtube

    57. Useful Functions For Auditing - Date & Time Functions

    Duration: 9:32
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    9 Questions
  • youtube

    58. Useful Functions For Auditing - Maths- Trig & Text Functions

    Duration: 9:23
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    59. Useful Functions For Auditing - Lookup & Reference Functions

    Duration: 15:45
  • ePub

    Study Materials

  • assessment

    Assessment

    7 Questions
  • youtube

    60. Useful Functions For Auditing - Lookup & Reference Functions - Cont…

    Duration: 22:15
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    61. Useful Functions For Auditing - Logical Functions

    Duration: 19:45
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    62. Useful Functions For Auditing - Statistical Functions

    Duration: 6:32
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    63. Formula Group Auditing - Concepts & Features of Formula Auditing group

    Duration: 12:15
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    6 Questions
  • youtube

    64. Formula Group Auditing - Error Checking, Evaluate Formula & Tips

    Duration: 15:31
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    5 Questions
  • youtube

    65. Data Analysis using MS Excel - Duplicates & Sorting

    Duration: 14:42
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    66. Data Analysis using MS Excel - Filters

    Duration: 21:50
  • ePub

    Study Materials

  • assessment

    Assessment

    6 Questions
  • youtube

    67. Data Analysis using MS Excel -Consolidation of Data

    Duration: 6:31
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    68. Data Analysis using MS Excel - Pivot Tables

    Duration: 19:42
  • youtube

    Data Analysis using MS Excel - Pivot Tables - Part B

    Duration: 32:10
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    5 Questions
  • youtube

    69. Data Analysis using MS Excel - Gap Detection

    Duration: 9:30
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    70. Data Analysis Using Ms Excel - Benford's Law

    Duration: 12:17
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    71. Data Analysis using MS Excel - Aging Analysis

    Duration: 11:57
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    72. Data Analysis using MS Excel - Statistical Analysis

    Duration: 22:04
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions

UNIT V: Enterprise Resource Planning

  • youtube

    73. ERP Overview

    Duration: 14:21
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    74. Business Processes Example

    Duration: 14:39
  • ePub

    Study Materials

  • assessment

    Assessment

    6 Questions
  • youtube

    75. Business Intelligence

    Duration: 13:12
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    76. Data Mining

    Duration: 14:12
  • ePub

    Study Materials

  • assessment

    Assessment

    9 Questions
  • youtube

    77. ERP Implementation

    Duration: 20:06
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    78. Flexible & Rigid and Tools

    Duration: 18:51
  • ePub

    Study Materials

  • assessment

    Assessment

    12 Questions
  • youtube

    79. Tally Installation and Security Control

    Duration: 16:04
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    5 Questions
  • youtube

    80. Ledger Cretion and Entries

    Duration: 14:53
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    5 Questions
  • youtube

    81. Synchronization

    Duration: 13:27
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    82. Data Backup and Restore

    Duration: 14:20
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    5 Questions
  • youtube

    83. ERP Control And Audit

    Duration: 19:20
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    5 Questions
  • youtube

    84. Verification of Stock Items

    Duration: 19:03
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    85. Audit and Verification

    Duration: 19:00
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    86. Cash Flow/Fund Flow

    Duration: 17:56
  • ePub

    Study Materials

  • assessment

    Assessment

    5 Questions
  • youtube

    87. Password Policy

    Duration: 18:38
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    10 Questions
  • youtube

    88. VAT

    Duration: 18:19
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    5 Questions
  • youtube

    89. TDS

    Duration: 17:22
  • ePub

    Study Materials

  • ePub

    Exercise

  • assessment

    Assessment

    6 Questions
  • youtube

    90. Service tax

    Duration: 14:31
  • ePub

    Exercise

  • assessment

    Assessment

    4 Questions


Upload Profile Photo

upload only (JPG and JPEG ) images

Please upload profile picture which will be printed on your certificate.

Please ensure your face is properly visible at the centre of this window.

Please ensure your face is properly visible at the centre of this window.

Virtual Advanced IT Course

Registration opens on 04-02-2019

Virtual Advanced IT Course

Your registration details are under review. It should take about 1 to 2 working days. Once approved you will be notified by email and then you should be able to access the course.

Virtual Advanced IT Course

Your Expired date : 31-01-1970

Maximum time allowed to the candidate for completing the course is exceeded. Incase the candidate is not able to complete the course during the aforestated period and need to extend the days please contact virtual.mcs@icai.in

For any Queries Write: virtual.mcs@icai.in

Virtual Advanced IT Course

Approved On : 01-01-1970

Maximum time allowed to the candidate for completing the course is 180 days. Incase the candidate is not able to complete the course during the aforestated period; extension of 90 days shall be given to the candidate. The candidate has to pay 50% of the course fee for revalidation of the registration in the aforestated course.

For any Queries Write: virtual.mcs@icai.in

Virtual Advanced IT Course

Course starts on 04-05-2020

Virtual Advanced IT Course

You have completed 6 hours (i.e., 6 sections with assessments) of learning for 07-08-2020. You can continue learning starting 08-08-2020.

Virtual Advanced IT Course

This course can only be taken in sequential order.

Virtual Advanced IT Course

It will take a maximum of 2 weeks time to generate the certificate from the date of course completion. Once the certificate is generated, you'll be informed via email.

Virtual Advanced IT Course

Reason :

Virtual Advanced IT Course

Result Summary

logo

Login

Forgot your password?

loading