uLektz logo
login images close

Verify Account

A Verification Code has been sent to you registered email address shown below. Please enter the code to verify your account. You may edit the email address, if it is incorrect

Resend Code

Note: Please check your Spam or Junk folder, in case you didn't receive the email with verification code.

Learning Path

Linear: Sequential Order

About the Course

AICITSS

.

Course Study Materials
UNIT I: Auditing in ERP Environment
  • 1. Auditing in ERP Environment-Overview Duration: 31:53
  • Study Materials
  • Assessment 10 Questions
  • 2. IT Governance Checklist Duration: 30:35
  • Study Materials
  • Assessment 9 Questions
  • 3. Program Changes - Documentations Duration: 22:57
  • Study Materials
  • Assessment 5 Questions
  • 4. Access Security - Activities Duration: 20:44
  • Study Materials
  • Assessment 9 Questions
  • 5. Access Security - File System Security Duration: 26:28
  • Study Materials
  • Assessment 5 Questions
  • 6. Access Security - Risks and Controls Duration: 25:30
  • Study Materials
  • Assessment 5 Questions
  • 7. IT Operations - Data Backup Duration: 24:09
  • Study Materials
  • Assessment 5 Questions
  • 8. IT Operations - Risks and Controls Duration: 21:04
  • Study Materials
  • Assessment 5 Questions
  • 9. Testing GITCs Duration: 22:45
  • Study Materials
  • Assessment 5 Questions
  • 10. What are automated controls Duration: 23:43
  • Study Materials
  • Assessment 5 Questions
  • 11. Types of Automated Controls Duration: 19:30
  • Study Materials
  • Assessment 7 Questions
  • 12. Process of Identification of AAC's Duration: 24:28
  • Study Materials
  • Assessment 5 Questions
  • 13. Review of Design Effectiveness Duration: 30:29
  • Study Materials
  • Assessment 5 Questions
  • 14. Review of Operating Effectiveness Duration: 10:48
  • Study Materials
  • Assessment 5 Questions
  • 15. Timing of AAC's Testing and Sample Sizes Duration: 18:01
  • Study Materials
  • Assessment 5 Questions
  • 16. Segregation of Duties and Sensitive Accesses Duration: 28:29
  • Study Materials
  • Assessment 21 Questions
  • 17. Validation of Reports Duration: 21:18
  • Study Materials
  • Assessment 9 Questions
  • 18. Validate Reports - Example Duration: 19:39
  • Study Materials
  • Assessment 5 Questions
  • 19. Validation of reports - Cont... Duration: 18:28
  • Study Materials
  • Assessment 5 Questions
  • 20. System implementation and Data Migration Review Duration: 34:04
  • Study Materials
  • Assessment 11 Questions
  • 21. Identify NSJE Duration: 20:09
  • Study Materials
  • Assessment 5 Questions
  • 22. Completeness of Data - Part A Duration: 20:32
  • Study Materials
  • Assessment 5 Questions
  • 23. Completeness of Data - Part B Duration: 18:29
  • Study Materials
  • Assessment 5 Questions
  • 24. Completeness of Data - Part C Duration: 18:09
  • Study Materials
  • Assessment 5 Questions
UNIT II: Database Application Using MS-Access
  • 25. Advanced SQL Queries -Advanced Queries Duration: 12:04
  • Study Materials
  • Exercise
  • Assessment 9 Questions
  • 26. Advanced SQL Queries - Joining Tables in Queries Duration: 10:20
  • Study Materials
  • Exercise
  • Assessment 5 Questions
  • 27. Designing Forms & Reports - Advanced Form Design Duration: 31:54
  • Assessment 10 Questions
  • 28. Designing Forms & Reports - Advanced Form Design - Cont..
  • Exercise
  • Assessment 7 Questions
  • 29. Designing Forms & Reports - Advanced Reports Duration: 15:12
  • Assessment 7 Questions
  • 30. Designing Forms & Reports - Advanced Reports - cont….
  • Exercise
  • Assessment 8 Questions
  • 31. Building Criteria Expressions - Using Operands in Criteria Expressions Duration: 7:38
  • Study Materials
  • Exercise
  • Assessment 24 Questions
  • 32. Building Criteria Expressions - Using built-in functions Duration: 14:05
  • Study Materials
  • Exercise
  • Assessment 10 Questions
  • 33. Macros & Switchboards- Simplifying Task Using a Macro Duration: 13:23
  • Study Materials
  • Exercise
  • Assessment 6 Questions
  • 34. Macros & Switchboards - Validating Data Using a Macro Duration: 9:04
  • Study Materials
  • Exercise
  • Assessment 5 Questions
  • 35. Macros & Switchboards- Managing Switchboards Duration: 22:22
  • Assessment 9 Questions
  • 36. Macros & Switchboards - Managing Switchboards - Cont…
  • Exercise
  • Assessment 8 Questions
UNIT III: Advance Excel
  • 37. Working with XML-Understanding of XML Duration: 22:49
  • Study Materials
  • Study Materials
  • Assessment 14 Questions
  • 38. Working with XML- Understanding of XML in Excel Duration: 1:59
  • Assessment 3 Questions
  • 39. Working with XML- XML Maps Duration: 15:05
  • Assessment 5 Questions
  • 40. Working with XML-XML Maps-Cont...
  • Exercise
  • Assessment 4 Questions
  • 41. Advances In Macros Duration: 14:30
  • Study Materials
  • Exercise
  • Assessment 8 Questions
  • 42. Applied Financial Analysis - Financial Analysis Duration: 10:03
  • Study Materials
  • Exercise
  • Assessment 8 Questions
  • 43. Applied Financial Analysis - Financial Ratios Duration: 21:02
  • Study Materials
  • Exercise
  • Assessment 22 Questions
  • 44. Applied Financial Analysis - DuPoint Analysis & Leasing Duration: 8:01
  • Study Materials
  • Exercise
  • Assessment 9 Questions
  • 45. Applied Financial Analysis - Financial Sheningans Duration: 9:13
  • Study Materials
  • Exercise
  • Assessment 5 Questions
  • 46. Applied Financial Analysis - Equity Reasearch Duration: 8:37
  • Study Materials
  • Exercise
  • Assessment 5 Questions
  • 47. Mathematical & Statistical Tools for Financial Analysis - Testing of Hypothesis Duration: 12:18
  • Study Materials
  • Exercise
  • Assessment 14 Questions
  • 48. Mathematical & Statistical Tools for Financial Analysis - Anova Analysis & Regression Duration: 11:07
  • Study Materials
  • Exercise
  • Assessment 6 Questions
  • 49. Applications of MS Excel -Depreciation Accounting Duration: 24:13
  • Study Materials
  • Exercise
  • Assessment 9 Questions
  • 50. Applications of MS Excel -Marginal Costing & Cash Budgeting Duration: 11:07
  • Study Materials
  • Exercise
  • Assessment 11 Questions
  • 51. Applications of MS Excel -Discounting & Tax Calculation Duration: 16:52
  • Study Materials
  • Exercise
  • Assessment 5 Questions
  • 52. Applications of MS Excel -EMI Calculations Duration: 17:41
  • Study Materials
  • Exercise
  • Assessment 13 Questions
  • 53. Applications of MS Excel -Risk Analysis & Investment Duration: 7:50
  • Assessment 10 Questions
  • 54. Applications of MS Excel - Risk Analysis & Investment - Cont… (Study Materials)
  • Exercise
  • Assessment 6 Questions
UNIT IV: MS-Excel as Audit Tool
  • 55. Introduction to MS Excel as an Audit Tool Duration: 9:56
  • Study Materials
  • Assessment 6 Questions
  • 56. Useful Functions For Auditing - Depreciation Duration: 23:19
  • Study Materials
  • Exercise
  • Assessment 5 Questions
  • 57. Useful Functions For Auditing - Date & Time Functions Duration: 9:32
  • Study Materials
  • Exercise
  • Assessment 9 Questions
  • 58. Useful Functions For Auditing - Maths- Trig & Text Functions Duration: 9:23
  • Study Materials
  • Exercise
  • Assessment 5 Questions
  • 59. Useful Functions For Auditing - Lookup & Reference Functions Duration: 15:45
  • Study Materials
  • Exercise
  • Assessment 7 Questions
  • 60. Useful Functions For Auditing - Lookup & Reference Functions - Cont… Duration: 22:15
  • Study Materials
  • Exercise
  • Assessment 5 Questions
  • 61. Useful Functions For Auditing - Logical Functions Duration: 19:45
  • Study Materials
  • Exercise
  • Assessment 5 Questions
  • 62. Useful Functions For Auditing - Statistical Functions Duration: 6:32
  • Study Materials
  • Exercise
  • Assessment 5 Questions
  • 63. Formula Group Auditing - Concepts & Features of Formula Auditing group Duration: 12:15
  • Study Materials
  • Exercise
  • Assessment 6 Questions
  • 64. Formula Group Auditing - Error Checking, Evaluate Formula & Tips Duration: 15:31
  • Study Materials
  • Exercise
  • Assessment 5 Questions
  • 65. Data Analysis using MS Excel - Duplicates & Sorting Duration: 14:42
  • Study Materials
  • Exercise
  • Assessment 5 Questions
  • 66. Data Analysis using MS Excel - Filters Duration: 21:50
  • Study Materials
  • Exercise
  • Assessment 6 Questions
  • 67. Data Analysis using MS Excel -Consolidation of Data Duration: 6:31
  • Study Materials
  • Exercise
  • Assessment 5 Questions
  • 68. Data Analysis using MS Excel - Pivot Tables Duration: 19:42
  • Data Analysis using MS Excel - Pivot Tables - Part B Duration: 32:10
  • Study Materials
  • Exercise
  • Assessment 5 Questions
  • 69. Data Analysis using MS Excel - Gap Detection Duration: 9:30
  • Study Materials
  • Exercise
  • Assessment 5 Questions
  • 70. Data Analysis Using Ms Excel - Benford's Law Duration: 12:17
  • Study Materials
  • Exercise
  • Assessment 5 Questions
  • 71. Data Analysis using MS Excel - Aging Analysis Duration: 11:57
  • Study Materials
  • Exercise
  • Assessment 5 Questions
  • 72. Data Analysis using MS Excel - Statistical Analysis Duration: 22:04
  • Study Materials
  • Exercise
  • Assessment 5 Questions
UNIT V: Enterprise Resource Planning
  • 73. ERP Overview Duration: 14:21
  • Study Materials
  • Assessment 5 Questions
  • 74. Business Processes Example Duration: 14:39
  • Study Materials
  • Assessment 6 Questions
  • 75. Business Intelligence Duration: 13:12
  • Study Materials
  • Assessment 5 Questions
  • 76. Data Mining Duration: 14:12
  • Study Materials
  • Assessment 9 Questions
  • 77. ERP Implementation Duration: 20:06
  • Study Materials
  • Assessment 5 Questions
  • 78. Flexible & Rigid and Tools Duration: 18:51
  • Study Materials
  • Assessment 12 Questions
  • 79. Tally Installation and Security Control Duration: 16:04
  • Study Materials
  • Exercise
  • Assessment 5 Questions
  • 80. Ledger Cretion and Entries Duration: 14:53
  • Study Materials
  • Exercise
  • Assessment 5 Questions
  • 81. Synchronization Duration: 13:27
  • Study Materials
  • Assessment 5 Questions
  • 82. Data Backup and Restore Duration: 14:20
  • Study Materials
  • Exercise
  • Assessment 5 Questions
  • 83. ERP Control And Audit Duration: 19:20
  • Study Materials
  • Exercise
  • Assessment 5 Questions
  • 84. Verification of Stock Items Duration: 19:03
  • Study Materials
  • Assessment 5 Questions
  • 85. Audit and Verification Duration: 19:00
  • Study Materials
  • Assessment 5 Questions
  • 86. Cash Flow/Fund Flow Duration: 17:56
  • Study Materials
  • Assessment 5 Questions
  • 87. Password Policy Duration: 18:38
  • Study Materials
  • Exercise
  • Assessment 10 Questions
  • 88. VAT Duration: 18:19
  • Study Materials
  • Exercise
  • Assessment 5 Questions
  • 89. TDS Duration: 17:22
  • Study Materials
  • Exercise
  • Assessment 6 Questions
  • 90. Service tax Duration: 14:31
  • Exercise
  • Assessment 4 Questions

The certificate issued for the Course will have

  • Student's Name
  • Photograph
  • Course Title
  • Certificate Number
  • Date of Course Completion
  • Name(s) and Logo(s) of the Certifying Bodies
    • .

    Only the e-certificate will be made available. No Hard copies. The certificates issued by ICAI. can be e-verifiable at www.ulektzskills.com/verify.

    • Students are required to take online assessments with e-Proctoring.
    • Students will be assessed both at the end of each module and at the end of the Course.
    • Students scoring a minimum of 50% in the assessments are considered for Certifications
    certificate
...
₹5500
Features:
  • 90 hours Learning Content
  • 100% online Courses
  • English Language
  • Certifications

Recommended Courses

See more
Total Quality Management
LordsBot

40 hours of Learning Content
Enroll Now
₹2360 ₹826
Internship & Job Openings
Theory of Computation
LordsBot

50 hours of Learning Content
Enroll Now
₹2360 ₹826
Internship & Job Openings
Software Project Management
LordsBot

1 to 2 weeks hours of Learning Content
Enroll Now
₹2360 ₹826
Internship & Job Openings
Software Engineering
LordsBot

1 to 2 weeks hours of Learning Content
Enroll Now
₹2360 ₹826
Internship & Job Openings
Software Architectures
LordsBot

1 to 2 weeks hours of Learning Content
Enroll Now
₹2360 ₹826
Internship & Job Openings
Resource Management Techniques
LordsBot

1 to 2 weeks hours of Learning Content
Enroll Now
₹2360 ₹826
Internship & Job Openings
Python Programming
LordsBot

1 to 2 Weeks hours of Learning Content
Enroll Now
₹2360 ₹826
Internship & Job Openings
Programming with C 2nd edition
LordsBot

1 to 2 weeks hours of Learning Content
Enroll Now
₹2360 ₹826
Internship & Job Openings
Explore all Skill Courses

Course

Registration opens on 04-02-2019

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.

Course Approved

Approval Pending - In-Progress

Course access details will be shared within 24 hours.
For help contact: support@ulektz.com

Course Enrollment

Course

Course starts on 04-05-2020

Course

You have completed 6 hours of learning for 24-04-2025. You can continue learning starting 25-04-2025.

Course

This course can only be taken in sequential order.

Course

You have completed the course. You will be notified by email once the certificate is generated.

Course

Are you sure want to enroll this course?.

Course

Course

S.no Date Title Reason

Result Summary

Advanced IT Course