Back
Full Time
Duration 01 Year
Class 1 Hrs. Daily
Days Mon-Sat

MODULE 1 – M.I.S (Management Information System)

 Adv. MS WORD

Getting Started with Word

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

Formatting Text and Paragraphs

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

Working More Efficiently

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

Managing Lists

  • Sort a List
  • Format a List


Adding Tables

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

Inserting Graphic Objects

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

Controlling Page Appearance

  • Apply a Page Border and Color
  • Add Headers and Footers
  • Control Page Layout
  • Add a Watermark
  • Learn to set the page orientation as portrait or landscape.
  • Learn to set the print size of the paper.
  • Learn to split your text into multiple columns.
  • Learn to add page breaks.
  • Learn to add section breaks.

Advanced Mail Merge

  • Beginning a Mail Merge
  • Using Excel for Mail Merge Data
  • Previewing Merge Letters
  • Selective Merge Records
  • Filtering
  • IF Then Else Fields
  • Include Text Fields
  • Mail Merge to Email

Preparing to Publish a Document

  • Check Spelling, Grammar, and Readability
  • Use Research Tools
  • Check Accessibility
  • Save a Document to Other Formats
  • The Macro Recorder
  • Recording Macros
  • Testing Macros
  • Running Macros

Microsoft Word Keyboard Shortcuts

 

 Prof. MS POWERPOINT

Creating Presentation                    

  • Blank & Sample Templates 
  • Adding Text
  • Bullet & Numbered Lists 

Adding Graphics

  • Capture Images & Insert Pictures 
  • Photo Album 
  • Drawing Shapes 
  • Advanced Shapes 
  • Merge Shapes 
  • WordArt 
  • SmartArt Graphics 

Modify Objects

  • Crop, Resize & Style Objects 
  • Formatting Objects 
  • Grouping Objects 
  • Object Ordering & Layering 
  • Gridlines & Guides

Tables

  • Insert & Formatting Tables 
  • Insert Table from Word 
  • Manipulating PowerPoint Tables
  • Inserting a Word Table
  • Inserting an Excel Spreadsheet
  • Adjusting Rows, Columns, Cells
  • Table Styles and Borders

Create & Modify Charts 

  • Inserting a Chart
  • Working with Datasheets
  • Applying a Chart Type, Style and Layout
  • Displaying Chart Analysis
  • Picture Charts
  • Formatting Chart Background

Templates, Themes & Layouts

  • Creating a Custom Layout
  • Applying a Theme
  • Applying a Background Style
  • Saving a Custom Theme
  • Arranging and Printing Section

Custom Design Templates

  • Slide Master 
  • Background Graphics 
  • Custom Slide Layouts 
  • Advanced Custom Themes 
  • Add Headers & Footers 
  • Modify Notes Master 
  • Edit Handout Master 
  • Create Custom Template 

Editing Slide Masters

  • Slide Master, Title Master
  • Formatting the Masters
  • Adding Header and Footer Information
  • Notes and Handout Masters

Animations and Transitions

  • Animation Schemes
  • Animating Text and Objects
  • Custom Animations and timing
  • Inserting Sounds and Video
  • Editing Media Clips

Setting Up the Slide Show

  • Setting Automatic Slide Timings
  • Setting Up a Continuous Loop
  • Hiding a Slide
  • Rehearsing Slide Transition Timings

Custom Shows & Interlinked Shows

  • Creating a Custom Show
  • Setting Up a Custom Show as the Default
  • Creating a Hyperlink
  • Using a Hyperlink
  • Using an Action Buttons
  • Jumping to Another Presentation

Packaging Presentations

  • Embedding the Fonts in a Presentation
  • Using the PowerPoint Viewer
  • Formatting a Presentation for the Web
  • Inspecting the Document
  • Annotating a Presentation
  • Sending in PDF Format

Using SmartArt

  • Inserting a SmartArt Object
  • Formatting a SmartArt Object Color
  • Resizing/Repositioning a SmartArt Object
  • Inserting Text into a SmartArt Object
  • Formatting Text Within a SmartArt Object
  • Adding Shapes to a SmartArt Object
  • Grouping SmartArt Objects

Inserting a Photo Album

  • Inserting Pictures from a File
  • Adding Captions
  • Applying a Theme to your Album
  • Customizing the Album Layout

Special Effects

  • Insert, Trim, Fade & Bookmark Audio 
  • Insert, Trim, Fade & Bookmark Videos 
  • Advanced Animation 
  • Motion Paths 

Customizing Presentation

  • Custom Slide Shows 
  • Setup Slide Show & Presenter View 
  • Secure PowerPoint Show 
  • Hyperlinks 
  • Action Buttons & Link Actions 
  • Annotate 
  • Record Narration 
  • Rehearse Timings 

Collaborating

  • Merge & Compare 
  • Insert Comments 
  • Slide Library 
  • OneDrive & Coauthoring 

Secure & Distribute

  • Present Online 
  • Create Video Files 
  • Package Presentation 
  • Publish to PDF or XPS 
  • Document Properties 
  • Document Inspector 
  • Password Protect 
  • Digital Signature 
  • Mark as Final 
  • Screen Recording 
  • Closed Caption 
  • Equations & Ink

 MICROSOFT EXCEL

Mathematical & Statical Functionโ€™s

  • Sum
  • Product
  • Average
  • Ceiling
  • Floor
  • Round
  • Round Up
  • Round Down
  • Power
  • Count
  • Counta
  • Maximum
  • Minimum
  • Mode
  • Median
  • Log
  • Dollar
  • Average A
  • Mina
  • Maxa
  • Large
  • Sqrt
  • Mod
  • Roman
  • Rank
  • Rank Average
  • Rand
  • Rand Between

Logical Function

  • If
  • Nested if
  • SumIf
  • Sumifs
  • Averageif
  • Averageifs
  • Countif
  • Countifs
  • Or
  • Not
  • And
  • If error
  • If Function & Nested If Statements And & Or Functions
  • Maxifs
  • Minifs
  •  

Text Functionโ€™s

  • Upper
  • Lower
  • Left
  • Right
  • Exact
  • Len
  • Mid
  • Concatenate
  • Proper
  • Trim
  • Substitute
  • Search
  • Find

Date & Time Functionโ€™s

  • Days360
  • Date
  • Network days
  • Now
  • Today
  • Weekday
  • Effect
  • Eomonth
  • Edate
  • Workdays
  • Datedif

Lookup &Reference Functionโ€™s

  • Index
  • Match
  • Lookup
  • Choose
  • Offset
  • Offset with Match
  • Xlookup
  • Transpose
  • Hlookup For Single Worksheet
  • Vlookup For Single Worksheet
  • Hlookup & Vlookup For Multiple Sheet
  • Match and Find Record by Vlookup And Hlookup
  • Approximate Match with Vlookup
  • Exact Match with Vlookup
  • Nesting Lookup Function
  • Show Formula
  • Choose Function with Vlookup
  • Indirect

Financial Functionโ€™s

  • Pmt
  • Rate
  • Ppmt
  • Ipmt
  • Fv
  • Pv
  • Coupdays
  • Coupnum
  • Ispmt
  • Sln
  • Cumprinc
  • Cumipmt
  • Ddb
  • Db
  • Received

Database Functionโ€™s

  • Daverage
  • Dproduct
  • Dmin
  • Dmax
  • Dcount
  • Dsum
  • Dget

Working with Charts

  • 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
  •  

Format Cells

  • Cell Format.
  • Data Bars, Color Scales & Icon Sets.
  • Sorting basic.
  • Sorting based on Customized List.
  • Customized Sorting (Advanced).
  •  

Conditional Formatting with Rules & Color Scale 

  • Using Conditional Formatting
  • Removing Conditional Formatting
  • Format As table
  • Create our Styles
  • Conditional formatting with formulas
  • Conditional formatting with Form Controls.
  •  

Data Management with Data Validation

  • Data Validation and dealing with Invalid Data.
  • Group and Outline Data
  • Data Consolidation.
  • Data text to column.
  • Custom Views
  •  

Data Analysis

  • Tracing Formula Precedents
  • Tracing Cell Dependents
  • Error Checking
  •  

Summarizing Data by Subtotal With grouping

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

What โ€“If Data Analysis

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

Sorting & Filtering

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

Protecting Excel Workbook & Sheet

  • 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
  •  

Workgroup Collaboration

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

Customizing Macro by Action Button

  • 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
  •  

Working with Pivot Table & Pivot Chart

  • Creating a Pivot Table
  • Rearranging a Pivot Table
  • Filtering Pivot Table Data
  • Creating a Pivot Chart
  •  

Reporting with Payroll Statement

  • MIS Report
  • Profit & Loss a/c statement
  • Balance sheet
  • Worker contribution statement
  • Cash flow statement
  • Debtorโ€™s & Creditors statement
  • Inventory statement
  • BRS Statement
  • Fixed Assets & fund statement
  • Payroll Report
  • P.F & E.S.I Report
  •  

Advance Paste Special Techniques

  • Paste Formulaโ€™s, Paste Formats
  • Paste Validations
  • Transpose Tables
  • Paste data
  •  

Special Operation

  • Find record by drop down list according To condition
  • Dash Board
  • Working with the Web and External Data
  • 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
  • Speed o Meter
  •  

Print Settings

  • Page Break
  • Print Area
  • Print Titles
  • Background

Module 2

 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

 

Module 3

 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

 

Module 4

 BUSY

General Features

  • Completely Codeless
  • Multi-Company Accounting
  • Context-Sensitive On-Line Help
  • Flexible Voucher Numbering
  • Multiple Voucher Series for each Voucher Type
  • Voucher entry while viewing reports and Vice-versa
  • User-definable Optional Fields in Masters and Vouchers
  • Unlimited level of Grouping of Accounts, Items, Material Centers and Cost Centers
  • Option for adding Images & Notes in Account & Item Masters
  • Draft Mode Printing for every Report and Document
  • Voucher Cancellation
  • Powerful Query System
  • SQL Query Executor
  • Print Preview
  • Landscape Mode Printing
  • Bird’s Eye View of Account
  • ENTERPRISE FEATURES
  • Voucher / Master Approval
  • Message centre
  •  

Financial Accounting

  • All books of Accounts & Final Results
  • Balance Sheet with various Schedules
  • Columnar Account Registers (Configurable)
  • Daily / Monthly Summaries of Accounts, Account Groups and Cost Centers
  • Bill-wise Outstanding with Ageing Analysis
  • Payment Reminder Letters (Configurable)
  • Statement of Account (Configurable)
  • Handling of Post-dated Cheques
  • Broker-wise Reporting
  • Royalty Calculation
  • Interest Calculation (Multiple Slabs based on Amt. & Days)
  • Bank Interest Calculation
  • Bank Re-conciliation
  • Depreciation Chart (As per Companies Act / IT Act)
  • Multi-Currency Accounting
  • Cost Centre-wise Reporting
  •  

Multi-Location Inventory

  • All books of Inventory
  • Stock Status (Multi-location)
  • Sales / Purchase Challans
  • Columnar Inventory Registers (Configurable)
  • Stock Valuation on Multiple Methods
  • Separate Stock Valuation Method for each Item
  • Item Serial No. Tracking
  • Stock Ageing Analysis
  • Allocation of Expenses to Items
  • Daily / Monthly Summaries of Items and Item Groups
  • Automatic Round-off in Vouchers
  • Primary and Alternate Unit for each Item
  • Batch-wise Inventory with Expiry Date
  • Provision for Free Qty in Inventory Vouchers
  • Provision for entering Sales / Purchase Return in Sales / Purchase Vouchers
  • Production / Un-assemble
  • BOM / Production Planning
  • Critical Level Reporting
  • Multiple Price-list for Items
  • Multiple Price Structures (Party / Qty / Category-wise)
  • Provision to update Item Prices on various Criterion
  •  

Sales / Purchase Order Processing

  • Pending Sales Orders (Party / Item-wise)
  • Pending Purchase Orders (Party / Item-wise)
  • Order Cancellation
  • Invoice / Challan Generation from Orders
  • USER-CONFIGURABLE INVOICING
  •  

Fully User-Configurable

  • Use Plain / Pre-printed Stationery
  • Option for Fonts, Colors& Logos
  • Option to Print Outer Box, Horizontal & Vertical Lines
  • Multiple-taxes in Single Invoice
  • Tax Inclusive / MRP Billing
  • Point-of-Sale (POS) Billing
  • Mfg. Excise Invoicing
  • Trading Excise Invoicing
  •  

User-Configurable Documents

  • Accounting Vouchers
  • Purchase Invoice
  • Sales Return / Purchase Return Invoice
  • Receipt / Payment Advice
  • Debit / Credit Note
  • Sales / Purchase Order
  • Delivery Note / Goods Receipt Note
  • Stock Transfer Memo
  •  

Sales Tax Reports

  • Sales Tax Forms Receivables / Issuable
  • Sales Tax Forms Reminder Letters
  • Forms Received / Issued Register
  • Sales Tax / Purchase Tax Summary
  • Sales Tax Surcharge
  • Sales Tax Registers
  •  

GST Reports

  • GST Computation / Summary
  • GST Invoicing (Tax / Retail)
  • GST Returns (State-wise)
  • GST Registers (State-wise)
  • Columnar GST Registers (Configurable)
  • Party-wise / Item-wise GST Summary
  • Party-wise / Item-wise GST Summary
  • Sales Re-conciliation as per Accounts and GST
  • GST R1
  • GST R2
  • GST 3B
  •  

Service Tax

  • Input Service Tax Register
  • Output Service Tax Register
  • Service Tax Summary
  • ST-3 (Service Tax Return)
  •  

TDS Reports

  • TDS Calculation
  • TDS Warning Alarms
  • TDS Challans
  • TDS Certificate (Form 16-A)
  • TDS Return (Form 26-Q)
  • Annexures to Form 26-Q
  • e-TDS with TDS 27-A
  • TDS Audit Report
  • TDS Deduction Details Report
  •  

Fringe Benefit Tax

  • Mark Expenses as FBT
  • Expense-wise Taxable Value
  • Option to charge FBT on Account Groups
  • Fringe Benefit Tax Report
  •  

MIS Reports

  • Cash Flow / Funds Flow
  • Budgets / Targets / Credit Limits
  • Ratio Analysis
  • Sales / Purchase Analysis on various combinations
  • Issue / Receipt Analysis
  • Consumption Analysis
  • Data Check List
  • Profitability Reports (Item / Bill / Party / Batch / MC wise)
  • Multi-Company Final Results / Reports
  •  

Utilities

  • Data Freezing
  • Pop-up Calculator
  • Notes / Task Manager
  • User-definable Access Rights

Module 5

 TALLY

Introduction of Tally

  • Company information
  • Create a new company
  • Current period, current date
  • Company creation (accounts maintain, financial year, security control, tally vault)
  • Accounts info
  • Group ledger
  • Ledger

Book Keeping

  • Entries with dr. And cr.
  • Using cash account in journal
  • Debit & Credit note
  • Voucher types
  • Select company
  • Shut company
  • Alter company
  • Delete company
  • Group company
  • Change tally vault

Financial Reports & Consolidate Ledger Accounts

  • Balance sheet
  • Profit & loss a/c
  • Ratio analysis

Fund management with list of account

  • Trial balance
  • Accounts book
  • Statement of account
  • Cash/fund flow
  • Day book
  • List of account
  •  

Mode of Invoice Punching/billing

  • Bill wise detail with (new reference, against ref, advance, on account)
  • Display (statement of a/c
  • Bills payable, Receivables
  • outstanding ledger, group)

Inventory Management

  • Stock group
  • Stock item
  • Unit of measure
  • Voucher entries โ€“goods in, goods out
  • Alternate unit and standard rate
  • Opening balance, stock summary

Purchase & Sales Order Processing

  • Purchase and sale order
  • Create purchase order
  • Alter purchase order
  • Delete purchase order
  • Create sale order
  • Alter sale order
  • Delete sale order
  • How can we do reject in reject our entry & use option
  • Delivery note & Receipt note
  • Give challan number in item
  • How can we do reject in reject our entry & use option
  • Delivery note & Receipt note
  • Give challan number in item
  •  

Internal Report of Finance

  • Display (inventory books, day book, list of account)
  • Accounts with inventory (balance sheet. P&l a/c, stock summary, ratio display)

Controlling (Cost Center & Cost Categories)

  • Cost centre
  • Creation of cost centre
  • Alteration of cost centre
  • Cost categories
  • Create cost categories
  • Alter cost categories

 

Multi godown creation

  • Godown/location
  • Create godown
  • Alter godown
  • Removing companies
  • Copy company
  •  

Tax Deducted at Source (TDS)

  • Tds
  • Transaction of tds
  • Ledger for tds
  • Payment voucher
  • Preparing tds challan
  • Deposit of tds to govt
  •  

Tax Collected at Source (TCS)

  • Understanding TCS
  • Creating TCS Masters & Practical Examples
  • TCS Payment, Reports, & Forms
  •  

Goods and Services Tax (GST)

  • GST
  • Ledger for GST
  • Transaction of GST
  • Adjustment of GST
  • Payment of GST

Budgets and Controls in Tally

  • Budget
  • Types of budget
  •  

Scenarios and Optional Vouchers

  • Creation of scenario
  • Alter or display scenario information
  •  

Export, Backup and Splitting company data

  • Splitting company data
  • Steps of splitting
  • From tally to excel
  • Importing into MS-excel
  • Removing companies
  • Copy companies

Printing Reports

  • Printout of balance sheet, p&l a/c, ledger
  • Printing Different Reports
  • Sales Invoice
  •  

Multi-Currency

  • Currency creation (How to create
  • New currency & how to set the price Lists.

Point of Sales

  • POS (Point of Sale)

Payroll Accounting Functions

  • Payroll (payroll info)
  • Employees and salary detail
  • Maintain attendance register of employees
  • Employees group
  • Create attendance type
  • Unit of leave (payroll)

Manufacturing Vouchers

  • BOM (bill of material)
  • Create Item of BOM
  • How to create voucher after
  • Ledger of BOM
  • Transaction of BOM
  • Alter of BOM
  • After ledger for excise duty

Batch wise Details

  • Batchwise Inventory
  •  

Interest Calculations

  • Interest Calculations

Credit Limit Price List

  • Creation of Price level
  • Create of Price group
  • Maintain Price list on items
  •  

Voucher Types and Class

  • Voucher Type
  • Voucher Class-Sales
  • Inclusive Tax Class
  • Customer pay their payment
  • How to create voucher with discount & freight charg

Module 6 – E-Filing

 GST Forms

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

 

 Income Tax Return Forms

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

 

 TDS/TCS Forms

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

Eligibility 10+2 and Above

error: Content is protected !!