Industrial Management Account Courses
Professional Training &
100% Projects Based Training

Be Professionals From Professionals               Only Professionals can Make u Professional

Industrial Management Account Training courses in West Delhi offers below course content


MASTER DIPLOMA IN CERTIFIED INDUSTRIAL MANAGEMENT ACCOUNTANT


Part Time
Duration 15 Months
Class 1.5Hrs. Daily
Days Mon-Fri
Half Time
Duration 8 Months
Class 3 Hrs. Daily
Days Mon-Fri
Full Time
Duration 5 Months
Class 4.5 Hrs. Daily
Days Mon-Fri

 MICROSOFT WORD

  •   Navigate in Microsoft Word.
  •   Create and Save Word Documents
  •   Manage Your Workspace
  •   Edit Documents
  •   Preview and Print Documents
  •   Customize the Word Environment

    Apply Character Formatting
  •   Control Paragraph Layout
  •   Align Text Using Tabs
  •    Display Text in Bulleted or Numbered Lists
  •    Apply Borders and Shading

  •   Make Repetitive Edits
  •   Apply Repetitive Formatting
  •   Use Styles to Streamline Repetitive
  •   Formatting Tasks

  •   Sort a List
  •   Format a List

  •   Insert a Table
  •    Modify a Table
  •   Format a Table
  •   Convert Text to a Table

  •   Insert Symbols and Special Characters
  •   Add Images to a Document

  •   Apply a Page Border and Color
  •    Add Headers and Footers
  •    Control Page Layout
  •   Add a Watermark

  •   Check Spelling, Grammar, and Readability
  •   Use Research Tools
  •   Check Accessibility
  •    Save a Document to Other Formats

 MICROSOFT POWERPOINT

  •   Navigate the PowerPoint Environment
  •   Create and Save a PowerPoint Presentation
  •   Use PowerPoint Help

  •   Select a Presentation Type
  •   View and Navigate a Presentation
  •   Edit Text
  •   Build a Presentation

  •   Format Characters
  •   Format Paragraphs
  •   Format Text Boxes

  •   Insert Images
  •   Insert Shapes

  •   Edit Objects
  •   Format Objects
  •   Group Objects
  •   Arrange Objects
  •   Animate Objects

  •   Create a Table
  •   Format a Table
  •   Insert a Table from Other Microsoft Office Applications

  •   Create a Chart
  •   Format a Chart

 MICROSOFT EXCEL

  •   Sum
  •   Product
  •   Average
  •   IF
  •   Days360
  •   Date
  •   Ceiling
  •   Floor
  •   Round
  •   Round up
  •   Round down
  •   Power
  •   Count
  •   CountA
  •   Count
  •   Sum if
  •   Maximum
  •   Minimum
  •   Hlookup for single worksheet
  •   Vlookup for single worksheet
  •   Hlookup & Vlookup for multiple Sheet
  •   Index
  •   Show formula
  •   Or
  •   Not
  •   Iferror
  •   Lookup
  •   Rate
  •   Ppmt
  •   Ipmt
  •   Networkdays
  •   Roundup
  •   Rounddown
  •   Mode
  •   Median
  •   Received
  •   Log
  •   Dollar
  •   AverageA
  •   Averageif
  •   Averageifs
  •   Mina
  •   Maxa
  •   Sumifs
  •   Large
  •   Pv
  •   Fv
  •   Coupdays
  •   Coupnum
  •   Datedif
  •   Daverage
  •   Dproduct
  •   Dmin
  •   Dmax
  •   Dcount
  •   Dsum
  •   Dget
  •   Now
  •   Today
  •   Weekday
  •   SQRT
  •   Mod
  •   Upper
  •   Lower
  •   Left
  •   Right
  •   Exact
  •   Len
  •   Match
  •   Roman
  •   Proper
  •   Pmt
  •   Concatenate
  •   IF Function & Nested IF Statements And & Or Functions
  •   Match and find record by VLOOKUP And HLOOKUP
  •   ISPMT
  •   SLN
  •   Effect
  •   CUMPRINC
  •   CUMIPMT
  •   EoMonth
  •   EDATE
  •   WORKDAYS
  •   DDB
  •   DB
  •   Approximate Match with Vlookup
  •   Exact match with Vlookup
  •   Nesting Lookup Function
  •   Choose Function
  •   Rank & Rank Average
  •   Rand & Rand Between
  •   Mod with Conditional Formatting
  •   Transpose
  •   Find & mid
  •   ISERR,ISERROR,IFERROR
  •   OFFSET
  •   IIR
  •   NPV
  •   MONTH
  •   HOURS
  •   MINUTE
  •   NETWORKDAYS.INSTL
  •   Transpose with Vlookup
  •   ISNUM
  •   ISERROR
  •   IFERROR
  •   SUBSTITUTE
  •   INDIRECT
  •   SEARCH
  •   TRIM
  •   INDEX WITH SUM,COUNT,AVERAGE
    •   Profit & Loss a/c statement
    •   Balance sheet
    •   Worker contribution statement
    •   Cash flow statement
    •   Debtor’s & Creditors statement

    •   Inserting a Hyperlink
    •   Importing Data from an Access Database or Text File
    •   Importing Data from the Web and Other Sources
    •   Working with Existing Data Connections

    •   Creating a Chart with the 2D or 3D
    •   Create Column Chart, Pie Chart
    •   Create Pateros Charts
    •   Create Speed- O-Meter Chart
    •   Moving a Chart One to another Sheet
    •   Resizing a Chart, Changing a Chart Type
    •   Editing Chart Text, Modifying Chart Options
    •   Formatting Category & Value Axis Data
    •   Formatting a Data Series
    •   Changing a Chart’s Source Data

    •   Cell Format.
    •    Data Bars, Color Scales & Icon Sets.
    •   Conditional formatting with formulas
    •   Conditional formatting with Form Controls.
    •   Sorting basic.
    •   Sorting based on Customized List.
    •   Customized Sorting (Advanced).

    •    Using Conditional Formatting
    •    Removing Conditional Formatting
    •    Format As table
    •    Create our Styles

    •   Data Validation and dealing with Invalid Data.
    •   Group and Outline Data
    •    Data Filter
    •   Data Consolidation.
    •   Data text to column.
    •   Custom Views
    •   Inventory statement
    •   BRS Statement
    •   Fixed Assets & fund statement
    •   Payroll Report
    •   P.F & E.S.I Report

    •   Tracing Formula Precedents
    •   Tracing Cell Dependents
    •   Error Checking
    •   Creating a Pivot Table
    •   Rearranging a Pivot Table
    •   Filtering Pivot Table Data
    •   Creating a Pivot Chart

    •   Adding Subtotals to a List
    •   Nesting Subtotals
    •    Applying Advance Filters
    •    Adding Group & Outline Criteria to Ranges
    •   Using Data Validation
    •   Text to Column

    •   Using Goal Seek
    •   Using Data Table
    •   Creating & Displaying Scenarios

    •   Sorting Records in a List
    •   Using AutoFilter in a List
    •   Filter & Advance Filter

    •   Locking/Unlocking Cells in a worksheet
    •   Protecting a Worksheet
    •   Protecting a Workbook
    •   Creating a Shared Workbook
    •   Tracking Changes to a Workbook
    •   Accepting & Rejecting Changes to a Workbook
    •   Password Protecting a Workbook
    •   Merging Workbooks

      Web Page Preview    Converting Worksheets into Web Pages
    •    Inserting Hyperlinks
    •    Viewing & Editing Comments

    •   Creating a Macro with Condition
    •   Running a Macro, Editing a Macro
    •   Adding a menu to the Menu Bar
    •   Adding a Commands to a Menu
    •   Adding Buttons to a Toolbar

    •   Page Break
    •   Print Area
    •   Print Titles
    •   Background

    •   Link with One sheet,Another Worksheet , One Workbooks,Multiple Workbooks
    •   Find record by drop down list according To condition
    •   Dash Board

     ADVANCE MS ACCESS (RDBMS)

    •   Starting and Opening an Existing Database
    •   Moving Around in Access
    •   Understanding Datasheet View & Design View
    •   Using the Mouse Pointer to Navigate

     SQL (DBMS)

    •   Relational database concepts, specific products
    •   SQL syntax rules
    •   Data definition, data manipulation, and data control statements
    •   Getting acquainted with the course database and editor

     EXCEL VBA MACROS

    •   Quick Review of Macros
    •   Introducing the Visual Basic Editor
    •   Uses of record Macros
    •   Understanding and creating modules

     ADVANCED ACCOUNTING

    •   Accounting terminology
    •   Activities and user of Accounting Information
    •   Assumption of Accounting
    •   Principal of Accounting
    •   Accounting cycle and source/Accounting document
    •   Accounting equation Classification of Account
    •   Types of Expenditure
    •   Compound Entry
    •   Subsidiary book and types of book
    •   Trial balance & Objectives
    •   Rectification of Error
    •   Provision & Reserve
    •   Inventory & cost for Inventory Valuation
    •   Suspense Account
    •   Share capital of company
    •   Kind of Share, forfeiture of share
    •   Over Subscription & Pro-rata allotment
    •    Accounting voucher
    •   Journal, cash book, ledger and trial balance
    •   Bills of exchange
    •   Depreciation
    •   Bank Reconciliation Statement
    •   Financial Statements
    •   Ratio Analysis
    •   Cash Flow Statement
    •   MIS Report
    •   Budget & Types of Budget
    •   Accounting Standard

     TAXATION

    •   Residential Status & Slab rate of Taxes
    •   Certain Incomes Exempt From Tax
    •   Income under Head Salary
    •   Income under the Head House Property
    •   Profit & Gains from Business & Profession
    •   Income under the Head Capital Gains
    •   Income under the head Other Sources
    •   Clubbing of Income, set off & Carry Forward of losses, Deduction from Gross Total Income.
    •   Agricultural Income, Illustration on Computation of Total Income & Liability
    •   Assessment of Firms, Return of Income & Assessment of individual
    •   TDS/TCS-Types of Forms, return filing
    •   Tax Deduction of Source, Advance Tax,
    •     Interest, Refund, Penalty,
    •     Income Tax-Preparation of Income Tax Return Filing (Manually and E-filling) allotment of PAN, TAN, Advance tax, penalties, complete documentation
    •   Legal Documentation
    •   GST (GOODS AND SERVICE TAX)
    •   Legal Documentation For GST

     BUSY

    •   Completely Codeless
    •    Multi-Company Accounting
    •   Context-Sensitive On-Line Help
    •    Flexible Voucher Numbering
    •   Multiple Voucher Series for each Voucher Type

     TALLY ERP 9

    •   Company information
    •   Create a new company
    •   Current period, current date
    •   Company ceation (accounts maintain, financial year,security control,tally vault)
    •   Accounts info
    •   Group ledger
    •   Ledger
    •   Entries with dr. And cr.
    •   Using cash account in journal
    •   Voucher types

     SAP FICO

    •   Introduction to SAP R/3
    •    Introduction to ERP, Advantages of SAP over other ERP Packages
    •    Introduction to SAP R/3 FICO
    •    Financial Accounting Basic Settings

     E-FILING

     GST FORM

    •   GSTR-1
    •   GSTR-2
    •   GSTR-3
    •   GSTR-4
    •   GSTR-5
    •   GSTR-6
    •   GSTR-7
    •   GSTR-8

     TDS FORM

    •    TDS/TCS Challan
    •   TDS 24Q
    •   TDS 26Q

     INCOME TAX RETURN FORM

    •   ITR-1 , ITR-2 , ITR-3 , ITR-4 , ITR-5

    Copyright © Computec Professionals Group