Accounting & Taxation Master's 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

·      Examples of Journal Entries

·      Contra

·      Payment

·      Receipt

·      Journal

·      Sales

·      Purchase

·      Debit note

·      Credit note

·      Accounting Problems for Practice

·      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

·      TallyVault 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 TallyPrime

·      Enable Payroll in TallyPrime

·      Payroll Transactions

·      Generate Pay Slips