MANAGEMENT PACKAGES

  • Eligibility
    1. candidate should have 60% through out his/her academics
    2. should have good communication skills
  • TOPICS

    1. Tally ERP 9 syllabus
      • Basic of Accounting
        1. Types of Accounts
        2. Golden Rules of Accounting
        3. Accounting Principles
        4. Concept and Convections
        5. Double Entry System of Book Keeping
        6. Mode of Accountings
        7. Financial Statements
        8. Transaction
        9. Recording Transactions
      • 2. Fundamentals of Tally ERP 9
        1. Getting Functional With Tally ERP 9
        2. Creation / Setting Up Of Company In Tally ERP 9
      • Accounting Masters in Tally ERP 9
        1. List the different Types of Identifiers in a PL/SQL subprogram
        2. F11 : Features
        3. F12 : Configurations
        4. Setting Account Heads
      • Inventory in Tally ERP 9
        1. Stock Groups
        2. Stock Categories
        3. Go downs / Locations
        4. Unit Of Measures
        5. Stock Items
        6. Creating Inventory Masters Of National Traders
      • Voucher Entry in Tally ERP 9
        1. Accounting Vouchers
        2. Inventory Vouchers
        3. Invoicing
      • Advanced Accounting in Tally ERP 9
        1. Bill Wise Details
        2. Cost Centers And Cost Category
        3. Voucher Class And Cost Center Class
        4. Multiple Currencies
        5. Bank Reconciliation
        6. Interest Calculations
        7. Budget And Controls
        8. Scenario Management
      • Advanced Inventory in Tally ERP 9
        1. Order Processing
        2. Reorder Levels
        3. Tracking Numbers
        4. Batch-Wise Details
        5. Additional Cost Details
        6. Bill Of Materials (BOM)
        7. Price Levels And Price Lists
        8. Stock Valuation
        9. Zero Valued Entries
        10. Inventory Aging Analysis
        11. Different Actual And Billed Quantities
      • Value Added Tax (VAT)
        1. Configuring VAT In Tally ERP 9
        2. Creating Masters
        3. Entering Transactions
        4. Accounting For Return Of Goods
        5. Rate Difference In Purchase / Sales
        6. Accounting For Interstate Transactions
        7. Exempt Transaction Under VAT
        8. Purchase From Unregistered Dealers
        9. Claiming ITC On Capital Goods
        10. Inter State Branch Transfers
        11. VAT Reports
        12. VAT For Composite Dealers
      • Central Sales Tax
        1. Basics Of Central Sales Tax
        2. Enabling CST In Tally ERP 9
        3. Recording Interstate Transactions In Tally ERP 9
        4. Payment Of CST
        5. CST Reports
      • Point Of Sale (pos)
        1. Features Of Point of Sale(Pos) In Tally ERP 9
        2. Configuring Point Of Sale In Tally ERP 9
        3. Entering POS Transactions
        4. POS Reports
      • Job Costing
        1. Configuring Job Costing In Tally ERP 9
        2. Creating Masters For Job Costing
        3. Recording Transactions
        4. Job Costing Reports
      • Multilingual Capabilities
        1. Configuring Tally ERP 9 For Multilingual Capabilities
        2. Creating Masters
        3. Entering Transaction In Multiple Languages
        4. Transliteration
        5. Generating Reports
      • Technological Advantages of Tally ERP 9
        1. Tally Vault
        2. Security Control
        3. Tally Audit
        4. Backup And Restore
        5. Split Company Data
        6. Export And Import Of Data
        7. ODBC Connectivity
        8. Web Enabled, Print Preview And Online Help
        9. Printing Of Reports And cheques
      • Tally Net and Remote Capabilities
        1. Over View of Tally. NET
        2. Configure. NET Features
        3. Connect Company On Tally. NET
        4. Create Remote Users
        5. Remote Access
      • Application Management and Controls
        1. What are Oracle-Supplied Packages?
        2. Examples of some of the Oracle-Supplied Packages
        3. How does the DBMS_OUTPUT Package work?
        4. Use the UTL_FILE Package to Interact with Operating System Files
        5. Invoke the UTL_MAIL Package
        6. Write UTL_MAIL Subprograms
      • Application Management and Controls
        1. Concept Of Control Center
        2. Installing And Activating Tally ERP 9
        3. Logging To Control Center
        4. Managing Accounts Using Control Center
      • On Line Help and Support
        1. Features Of Support Center
        2. Accessing The Support Center
        3. Using Support Center
      • Service Tax
        1. Basis Of Service Tally ERP 9 For Service Tax
        2. Basis Of Service Tally ERP 9 For Service Tax
        3. Entering Transactions
        4. Accounting For Advance Receipts
        5. Accounting For Opening Service Tax Credit
        6. Payment Of Service Tax
        7. Service Tax Reports
      • 1Tax Deducted At Source
        1. Basic Concepts Of TDS
        2. Configuring TDS In Tally ERP 9
        3. Creation Of Masters
        4. Processing Transactions
        5. TDS Reports
      • Tax Collected At Source
        1. Basic Concept Of TCS
        2. Configuring TCS In Tally ERP 9
        3. Creating Masters
        4. Entering Transactions
        5. TCS Reports
      • Excise for Dealers
        1. Basic Concepts
        2. Silent Features Of Dealer Excise
        3. Enabling Dealer Excise
        4. Enabling Dealer Excise In Tally ERP 9
        5. Creating Masters
        6. Entering Transaction
        7. Excise Reports
        8. Sales And Purchase Extract
      • Excise for Manufactures
        1. Basic Concept Of Excise Duty
        2. Configuring Excise In Tally ERP 9
        3. Creation Of Masters
        4. Processing Transaction
      • Payroll Accounting Compliances
        1. Configuring Payroll In Tally ERP 9
        2. Creating Payroll Masters
        3. Processing Payroll In Tally ERP 9
        4. Accounting For Employer PF Contributions
        5. Accounting For Employer ESI Contributions
        6. Payment For Professional Tax
        7. Generating Payroll Reports
    1. ADVANCE EXCEL AND VBA

        Advanced Worksheet Functions

      • Names
        1. Defining Names
        2. Creating Names Automatically
        3. Managing Names
      • Using Names
        1. Go To
        2. Names In Formulae
        3. Applying Names
      • Conditional & Logical Functions

        1. If Statements
        2. Logical Test
        3. Value If True/False
        4. Nested If
        5. Statistical If Statements
      • AND,OR,NOT
        1. And
        2. Or
        3. Not
      • Lookup Functions
        1. Lookup
        2. Vector Lookup
        3. Hlookup
        4. Vlookup
        5. Nested Lookups
      • Other Useful Functions
        1. ISERROR
        2. IFERROR
        3. COUNTIF
        4. AVERAGEIF
        5. AVERAGEIFS
        6. SUMIFS
        7. COUNTIFS
      • Data Consolidation
      • Views, Scenarios, Goalseek And Solver

      • Goal Seeking And Solving
        1. Goal Seek
        2. Solver
        3. Solver Parameters
        4. Constraints
        5. Solver and Scenario Manager
        6. Opening Scenario Manager
        7. Saving Solver Solutions
        8. Reports
      • Views & Scenarios
        1. Custom Views
        2. Typical Custom View Model
        3. Defining A View
        4. Showing A View
        5. Scenario Manager
        6. Load The Scenario Manager
        7. Showing A Scenario
        8. Editing A Scenario
        9. Deleting A Scenario
      • Using Excel To Manage Lists

      • Excel Lists And List Terminology
        1. Row And Column Content
        2. Column Labels
        3. List Size And Location
        4. Miscellaneous
      • Sorting data
        1. Custom Sorting Options
        2. Creating A Custom Sort Order
      • Adding subtotals to a list
        1. Examining Subtotals
      • Filtering A List
        1. Custom Criteria
        2. Wildcards
        3. Turning Off Auto filter
        4. Advanced Filtering
        5. Set Criteria
        6. Entering Search Criteria
        7. Wildcards With Text Criteria
        8. Multiple Criteria
        9. Checking The Criteria Range
        10. Calculated Criteria
        11. Calculated Criteria Using Functions
        12. Copying Filtered Data
        13. Unique Records
      • List Statistics
        1. Database Functions
      • Pivot Tables
        1. To Create A PivotChart Report From An Existing PivotTable Report
        2. Create A Static Chart From The Data In A Pivot Table Report
        3. Delete A PivotTable Or PivotChart Report
        4. Create Layout For PivotTables
        5. Modifying A PivotTable
      • Managing Pivot Tables
        1. Using Another PivotTable Report
        2. Changing An Existing Report's Source Data
        3. Automatically Refresh Data When A Workbook Is Opened
        4. Automatically Refresh Data At Regular Time Intervals
        5. Require A Password To Refresh An External Data Range
        6. Grouping PivotTable Items
        7. Formatting A PivotTable
      • Charts

      • Introduction To Charting
        1. Terminology
        2. Embedded Charts
        3. Separate Chart Pages
        4. Three Methods To Create Charts Moving And Resizing Embedded Charts
        5. Data Layout
        6. Chart Types
        7. Shortcut Menu (Right Click)
        8. Default Chart Type
      • Formatting Charts
        1. Design Ribbon
        2. Switch Rows And Columns
        3. Changing The Chart Layout
        4. Chart Styles
        5. Moving Chart Location
        6. Layout Ribbon
        7. Formatting Chart Elements
        8. Resetting Custom Formats Adding Removing And Formatting Labels
        9. Axes
        10. Gridlines
        11. Unattached Text
        12. Format Dialog
        13. Add A Series Manually
        14. The Series Function
        15. Charting With Blocks Of Data
      • Templates

      • Introduction To Templates
        1. Standard Templates
        2. Custom Templates
        3. AutoTemplates
        4. Opening And Editing Templates
        5. Template Properties
      • Auditing

      • Auditing Features
        1. Tracers
        2. Comments
      • Other Formatting

      • Formatting cells
        1. Themes
        2. Customizing A Theme
        3. Styles
        4. Conditional Formatting
      • Other Excel Features

      • Inserting, Formatting And Deleting Objects
        1. Inserting A Drawing Object
        2. Smart Art
        3. WordArt
        4. Formatting Shapes
        5. Quick Styles
        6. Manual Formatting
      • Reviewing
        1. Protecting
        2. Use A Shared Workbook To Collaborate
        3. Share A Workbook
      • Proofing Tools
        1. Spelling And Grammar
        2. Thesaurus
        3. Translation
        4. Show Or Hide Screen Tips
      • VBA

      • Introducing VBA
        1. What Is VBA?
        2. Introduction to Macro Recordings, IDÉ
      • How VBA Works with Excel
        1. Working In the Visual Basic Editor
        2. Introducing the Excel Object Model
        3. VBA Sub and Function Procedures
        4. Using the Excel Macro Recorder
      • Programming Concepts
        1. Essential VBA Language Elements
        2. Working with Range Objects
        3. Using VBA and Worksheet Functions
        4. Controlling Program Flow and Making Decisions
        5. Automatic Procedures and Events
        6. Error-Handling Techniques
        7. Bug Extermination Techniques
        8. VBA Programming Examples
      • Communicating with Your Users
        1. Simple Dialog Boxes
        2. UserForm Basics
        3. Using UserForm Controls
        4. UserForm Techniques and Tricks
        5. Accessing Your Macros through the User Interface
      • Putting It All Together
        1. Creating Worksheet Functions and Living to Tell about It
        2. Creating Excel Add-Ins
      • The Part of Tens
        1. Ten VBA Questions (And Answers)
        2. (Almost) Ten Excel Resources.
    1. Ms SQL Syllabus
      • SQL Server 2008

          Overview of SQL Server 2008

        1. Introduction to SQL Server 2005
          1. Role of a Database Server
          2. SQL Server 2008Components
          3. The .NET Framework
          4. Features of SQL Server 2005
          5. SQL
        2. Identifying SQL Server 2008Tools
          1. SQL Server Management Studio
          2. SQL Server Business Intelligence Development Studio
          3. Database Engine Tuning Advisor
          4. SQL Server Configuration Manager
          5. SQL

        3. Querying Data

        4. Retrieving Data
          1. Identifying Data types
          2. Retrieving Specific Attributes
          3. Retrieving Selected Rows
        5. Using Functions to Customize the Result Set
          1. Using String Functions
          2. Using Date Functions
          3. Using Mathematical
          4. Using System Functions
        6. Summarizing and Grouping Data
          1. Summarizing Data by Using Aggregate Functions
          2. Grouping Data

        7. Querying Data Using Joins and Sub Queries

        8. Querying Data By Using Joins
          1. Using an Inner Join
          2. Using an Outer Join
          3. Using a Cross Join
          4. Using a Self Join
          5. SQL

        9. Managing Databases and Tables

        10. Managing Databases
          1. Identifying the System Databases in SQL Server 2005
          2. Identifying the Database Files
          3. Creating a User-Defined Databases
          4. Renaming a User-Defined Databases
          5. Dropping a User-Defined Databases
        11. Managing Tables
          1. Creating a Table
          2. Implementing Data Integrity
          3. Creating a Partitioned Table
          4. Modifying a Table
          5. Renaming a Table
          6. Dropping a Table

        12. Manipulating Data in Tables

        13. Manipulating Data by Using DML Statements
          1. Storing Data in a Table
          2. Updating Data in a Table
          3. Deleting Data from a Table
        14. Manipulating the XML Data
          1. oStoring XML Data in a Table
          2. Retrieving the XML Data from the Table
          3. Modifying the XML Data

        15. Implementing Indexes, Views and Full Text Search

        16. Creating and Managing Indexes
          1. Identifying the Types of Indexes
          2. Creating Indexes
          3. Creating XML Indexes
          4. Managing Indexes
        17. Creating and Managing Views
          1. Creating Views
          2. Indexing Views
          3. Managing Views
        18. Implementing Full-Text Search
          1. Configuring Full-Text Search
          2. Searching Data by Using a Full-Text Search

        19. Implementing Stored Procedures and Functions

        20. Implementing Batches
          1. Creating Batches
          2. Using Constructs
          3. Handling Errors and Exceptions
        21. Implementing Stored Procedures
          1. Creating Stored Procedures
          2. Creating Parameterized Stored Procedures
          3. Returning Values from Stored Procedures
          4. Calling a Procedure from Another Procedure
        22. Implementing Functions
          1. o Creating UDFs

        23. Working with Triggers and Transactions

        24. Implementing Triggers
          1. o Identifying Types of Triggers
          2. Creating Triggers
          3. Managing Triggers

        25. Implementing Managed Code

        26. Understanding Managed Code
          1. Understanding Managed Code
          2. Identifying the need for managed code
        27. Creating Managed Database Objects
          1. Importing and Configuring Assemblies
          2. Creating Managed Database Objects

        28. Implementing HTTP Endpoints

        29. Introduction to HTTP Endpoints
          1. Introduction to SOA
          2. Introduction to Web Services
          3. Identifying the role of HTTP Endpoints in a Native Web Service Architecture
        30. Implementing the HTTP Endpoints
          1. Creating HTTP Endpoints
          2. Securing HTTP Endpoints

        31. Implementing Services for Message-Based Communications

        32. Message Based Communication
          1. Introduction to Service Broker
          2. Introduction to Service Broker
        33. Implementing Service Broker
          1. Creating Messages
          2. Creating Queues
          3. Creating Contracts
          4. Creating Services

    Benefits Of Management Course

      1. students will be getting government authorized certificate and will be valid worldwide
      2. Sharp Mind Info Train provides excellent coaching for the students who are looking to build high career goals.

      3. Sharp Mind not only provides professional teachers but also the necessary material required for the students and takes them to the next level of knowledge.

      4. The institute helps to gain fresh perspectives on your personal challenges and opportunities.

      5. In the era of cut-throat competition, there is huge competition in all the fields. Our institute makes the way for you easy by teaching all the new technologies to be a good competitor and ease your way to reach your goals.

      6. We provide competitive environment to you to make you more and more stable technically with all the best skills.

      7. We have company environment.

      8. All the courses available here are cost effective. The institute also provides 100% career assistance.

  • <