Accounting Professional Program

·         Identifying the different Excel

·         Identifying new features of Excel

·         Working with the ribbon

·         Customizing the Excel program window

·         Zooming in on a worksheet

·         Arranging multiple workbook windows

·         Adding buttons to the Quick Access Toolbar

·         Customizing the ribbon

·         Maximizing usable space in the program window

·         Modifying workbooks

·         Modifying worksheets

·         Inserting rows, columns, and cells

·         Merging and unmerging cells           

·         Entering and revising data

·         Managing data by using Flash Fill

·         Moving data within a workbook

·         Finding and replacing data

·         Correcting and expanding upon worksheet data

·         Defining Excel tables

·         Naming groups of data

·         Creating formulas to calculate values

·         Summarizing data that meets specific conditions

·         Working with iterative calculation options and automatic workbook 

       calculation

·         Using array formulas

·         Finding and correcting errors in calculations        

·         Formatting cells

·         Defining styles

·         Applying workbook themes and Excel table styles

·         Making numbers easier to read

·         Changing the appearance of data based on its value

·         Adding images to worksheets          

·         Limiting data that appears on your screen

·         Filtering Excel table data by using slicers

·         Manipulating worksheet data

·         Selecting list rows at random

·         Summarizing worksheets by using hidden and filtered rows

·         Finding unique values within a data set

·         Defining valid sets of values for ranges of cells

·         Sorting worksheet data

·         Sorting data by using custom lists

·         Organizing data into levels

·         Looking up information in a worksheet

·         Using workbooks as templates for other workbooks

·         Linking to data in other worksheets and workbooks

·         Consolidating multiple sets of data into a single workbook         

·         Examining data by using the Quick Analysis Lens

·         Defining an alternative data set

·         Defining multiple alternative data sets

·         Analyzing data by using data tables

·         Varying your data to get a specific result by using Goal Seek

·         Finding optimal solutions by using Solver

·         Analyzing data by using descriptive statistics        

·         Creating charts

·         Customizing the appearance of charts

·         Finding trends in your data

·         Creating dual-axis charts

·         Summarizing your data by using sparklines

·         Creating diagrams by using SmartArt

·         Creating shapes and mathematical equations        

·         Analyzing data dynamically by using PivotTables

·         Filtering, showing, and hiding PivotTable data

·         Editing PivotTables

·         Formatting PivotTables

·         Creating PivotTables from external data

·         Creating dynamic charts by using Pivot Charts

·         Adding headers and footers to printed pages

·         Preparing worksheets for printing

·         Previewing worksheets before printing

·         Changing page breaks in a worksheet

·         Changing the page printing order for worksheets

·         Printing worksheets

·         Printing parts of worksheets

·         Printing charts

·         Linking to Office documents from workbooks

·         Embedding workbooks into other Office documents

·         Creating hyperlinks

·         Pasting charts into other Office documents           

·         Sharing workbooks

·         Saving workbooks for electronic distribution

·         Managing comments

·         Tracking and managing colleagues’ changes

·         Protecting workbooks and worksheets

·         Authenticating workbooks

·         Saving workbooks as web content

·         Importing and exporting XML data

·         Working with SkyDrive and Excel Web App          

·         Components of an Accounting Manual

·         Example of an Accounting Manual

·         What Is Accounting?

·         How Accounting Works

·         Types of Accounting

·         Requirements for Accounting

·         What is Commerce?

·         Why Accounting is needed?

·         Basic concept of accounting

·         Types of accounts

·         Golden Rules of Accounts

·         Introduction to Tally Prime

·         Top 10 Tally Prime Features

·         What’s New in Tally Prime

·         Comparison between Tally ERP 9 and Tally Prime

·         Gateway of Tally

·         Company Creation in Tally Prime

·         Alter/Delete Company Details

·         Introduction to Company Menu

·         Company Features

·         Tally Company Configuration

·         Create Account Groups Single/Multiple

·         Creating a Single/Multiple Ledger

·         Maintain Balances Bill-by-Bill & Default Credit Period

·         Ledgers with Opening Balances

·         Balance Sheet

·         Contra

·         Payment

·         Receipt

·         Journal

·         Sales

·         Purchase

·         Debit note

·         Credit note

·         Cost Centers Allocation

·         Cost categories for parallel allocation

·         Cost center class

·         Report related to cost center/category

·     Create/Alter a Budget

·     View Budget Variance

·     Delete a Budget

·     Create/Alter a Scenario

·     Use Optional Vouchers in Scenarios

·     Use Scenarios in Reports

·     Calculate Interest Using Simple Parameters

·     Calculate Interest Transaction-by-Transaction

·     Calculate Interest Using Advanced Parameters

·     Calculate Interest on Group

·     Calculate Interest on Ledger Balances

·     View Interest Amount on Invoices

·     Record Transaction for Interest Calculation

·     Balance Sheet

·     Profit & Loss

·     Cash Flow

·     Funds Flow

·     Receivables

·     Payables

·     Trial Balance

·     Day Book

·     Cash Book

·     Bank Book

·     Creating a Single Stock Group

·     Modifying / Deleting a Single Stock Group

·     Creating a Multiple Stock Group

·     Creating Single/multiple Stock category

·     Creation of Units of Measure

·     Simple Units of Measure

·     Compound Units of Measure

·     Alternation / Deletion of Stock Units

·     Creation of Single Stock Items

·     Inventory storage using godown

·     Setup Bill of Materials (BOM)

·     Creating a Manufacturing Journal

·     Set Up Batches for Stock Items

·     Sell Stock Items from Batches

·     Batches for Purchased Stock Items

·     Batch Summary

·     Batch Vouchers

·     Purchase Order Processing in Tally.ERP9

·     Receipt Note Voucher (GRN) against Purchase Order

·     Rejection Out Voucher against Purchase Order

·     Purchase Voucher against Receipt Note Voucher (GRN)

·     Sales Order Processing

·     Delivery Note Against Sales Order

·     Rejection In Against Sales order

·     Sale Invoice Against Delivery Note

·     Job Work

·     Job Work Masters

·     Principal Manufacturer (Job Work Out)

·     Job Work In

·     Material In/ Material Out Voucher

·     Track Additional Cost of Purchase

·     Zero valued Transactions

·     Use Different Actual & Billed Quantity

·     Transaction using Stock journal with purchase/sales:

·     Separate Discount Column in Invoices

·     Price Levels

·     Create Price Levels

·     Assign Price Levels to Ledger Accounts

·     Price List

·     Use Price Levels & Price List during Voucher Entry

·     Complete cancellation of order

·     Partial cancellation of order

·     Record Quotation

·     Record a POS Invoice

·     POS Invoice with Multiple Modes of Payment

·     Faster Data Entry for POS Invoice

·     POS Register

·     Track Your Inventory | Stock Summary

·     Location/Godown Summary

·     Movement Analysis

·     Stock Ageing Analysis

·     Stock Query

·     Physical Stock Register

·     Stock Cost Estimation

·     Group Company

·     Multi-Currency

·     Multiple Addresses for Ledger

·     Specify Credit limit

·     Use Security Control

·     Creating Users and Passwords

·     Tally Vault Password

·     Backup/ Restore Company data

·     Splitting Company Data

·     Import/Export data

·     Cheque printing

·     Cheque Register

·     Banking Transaction Types

·     Post Dated Cheque

·     Deposit Slip

·     Payment Advice

·     Bank Reconciliation

·     Introduction to Payroll

·     Payroll in Tally Prime

·     Enable Payroll in Tally Prime

·     Payroll Transactions

·     Generate Pay Slips

·     GST Introduction

·     SGST, CGST and IGST Terms

·     GST – What is HSN and SAC

·     GST Classifications

·     Enable & Recording GST Transactions

·     Recording GST Transactions - Multi Tax Rates

·     GST Payment

·     Recording GST on Item Rate

·     Recording GST Services

·     Recording GST Expenses

·     Recording GST Assets

·     GST on Reverse Charge Mechanism (RCM)

·     GST Advance Receipts

·     GSTR-1 Filing

·     GSTR-3B Filing

·     GSTR-1

·     GSTR-2

·     GSTR-3B

·     GST Annual Computation Report

·     Setup e-Way Bill

·     Generate JSON of E-Way Bill

·     Record invoice with details required for e-Way Bill, and create JSON

·     Step to generate e-Way Bill on the e-Way Bill Portal

·     Print the invoice with e-Way Bill number

·     Enable TDS

·     TDS Nature of Payment

·     TDS Ledger- Expenses Ledger, Party Ledger

·     Record TDS Transactions

·     Generate TDS Reports

·     Set Up Your Books For Tax Collected at Source

·     Record TCS Transactions

·     Generate TCS Reports