Regional Training Centre, Delhi

Course contents (Information Technology Courses)


1.Level-II (Database concepts, system concepts and Introduction to MS-Access)


  • •Database basics, Concept of RDBMS and Overview of MS-Access
  • •Creating database with elaborate data structure
  • •Analysis of data using of find/replace, Sort and filter
  • •Designing Simple and complex queries
  • •Designing Forms
  • •Designing Report
  • •Creating Switchboards and finalization of application

2.Level-II (IT audit advanced) - Auditing in IT Environment


  • •IT Audit awareness
  • •General controls & Application controls
  • •Network communication basics and Security controls
  • •Database basis and User Level Security
  • •Computer Aided Audit Techniques (CAATs)
  • •Using MS Access as CAAT
  • •Using MS Excel as CAAT
  • •Using SQL DML queries as CAAT
  • •Working on Interactive Data Extraction and Analysis (IDEA) to import, link, sample, summarise, analyse and present data from diverse platforms.

  • 3.Level-I (Ms-Word Advanced)


  • •Using and Creating Style sheet
  • •References – Table of contents
  • •Review – Track changes
  • •Inserting and formatting tables
  • •Using Mail-Merge
  • •Understanding MS Word Themes
  • •Advanced Features for data conversion and presentation

  • 4.MS-Excel


  • •Getting acquainted with anatomy of MS Excel workbook
  • •Understanding data types and entering data into worksheet
  • •Preparing Formulas
  • •Using functions
  • •Formatting worksheet
  • •Preparing charts and Graphs
  • •Analysing data using Sorting, Data filter and Pivot tables

  • 5. Interactive Data Extraction and Analysis (IDEA)


  • •Introduction to IDEA
  • •Importing various types of data
  • •Data extraction
  • •Grouping, indices and Summarization of data using different tools
  • •Analysis of data using various tools and functions
  • •Joining two data files and appending data in the existing file
  • •Sampling (Systematic, Random, Stratified and MUS)

  • 6. Tableau


  • •Introduction to Tableau Software
  • •Data import into Tableau
  • •Understanding dimensions and values
  • •Understanding data labels
  • •Working with charts
  • •Tableau Dashboard

  • 7. Public Financial Management System (PFMS) and important features of E-lekha data software


  • •Brief history, background and Mandate of PFMS
  • •Various Modules under PFMS
  • •Fund Flow Monitoring under PFMS
  • •Direct Benefit Transfer Modules
  • •PAO Computerization-Online payments, receipts and accounting of Govt. of India
  • •Non – Tax Receipt Portal
  • •CBDT PAN Validation and GSTN bank account validation
  • •Implementation Strategy and Status of Implementation
  • •Introduction to E-lekha data software
  • •Framework and available reports.
  • Feedback        Sitemap         FAQ        Disclaimers        Contact Us        Visitor Count:         Best Viewed: 1024 X 768