Course on Advanced Information Technology (ICITSS) 1. Auditing in an ERP Environment a. Auditing in ERP Environment‐Overview b. Information Technology General Controls (ITGCs) c. Automated Application Controls d. Segregation of Duties and Sensitive Accesses e. System Generated Reports f. System implementation and Data Migration Review g. Non Standard Journal Entries 2. Database Application sing MS ‐ Access a. Advanced SQL Queries b. Designing Forms and Reports c. Building Criteria Expressions d. Macros and Switchboards 3. Advance MS ‐ Excel a. Working With XML b. Advances In Macros c. Applied Financial Analysis and Forecasting Financial Statements d. Mathematical & Statistical Tools for Financial Analysis e. Application of Excel 4. MS ‐ Excel as an Audit Tool a. Introduction to MS‐Excel as an Audit Tool b. Useful Functions for Auditing c. Formula Auditing d. Analyzing Data with Pivot Tables 5. Enterprise Resource Planning a....
cpt, ipcc, final, atc, income tax, service tax, excise, sale tax, vat, audit, accounting, indirect tax law, direct tax laws, corporate law, merchantile law, quantitative aptitude related to ca & cs, foundation course, ictiss, aictiss, mcs, information technology, orientation course, foundation course, direct entry, gst, digital learning