Module-1 MS Office

Lecture-1 Fundamentals of Computer 
·         Introduction of Computer

·         Introduction to paint

·         Introduction of Notepad

·         Introduction of WordPad

Lecture 2-9 Microsoft Word 
·         Introduction to MS Office            

·         Selecting & Editing Data             

·         Modifying Pictures          

·         Getting Help from Office

·         Typing Text in Word

·         Formatting Text

·         Designing your Pages

·         Inserting TOC,

·         Footnote & End Note,

·         Linking Documents

·         Mail Merge

Lecture 10-17 Microsoft Excel 
·         The Basics of spread sheets

·         Playing with formulas

·         Charting and Analysing Data

Lecture 18-22 Microsoft PowerPoint 
·         Creating PowerPoint Presentation

·         Adding Color and Pictures

·         Showing off a presentation

Lecture 23-27 Microsoft Outlook & Internet 
·         Managing E-Mail with Outlook

·         Calendar, Contacts and Tasks

·         Internet Concepts

  Module-2 Advance Excel
Lecture 1: Getting started with Excel 
·         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           

Lecture 2: Working with data and Excel tables 
·         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

Lecture 3: Performing calculations on data 
·         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        

Lecture 4: Changing workbook appearance 
·         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          

Lecture 5: Focusing on specific data by using filters 
·         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

Lecture 6: Reordering and summarizing data 
·         Sorting worksheet data

·         Sorting data by using custom lists

·         Organizing data into levels

·         Looking up information in a worksheet

Lecture 7: Combining data from multiple sources 
·         Using workbooks as templates for other workbooks

·         Linking to data in other worksheets and workbooks

·         Consolidating multiple sets of data into a single workbook         

Lecture 8: Analyzing data and alternative data set 
·         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        

Lecture 9: Creating charts and graphics 
·         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        

Lecture 10: Using PivotTables and Pivot Charts 
·         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

Lecture 11: Printing worksheets and 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

Lecture 12: Working with other Office programs 
·         Linking to Office documents from workbooks

·         Embedding workbooks into other Office documents

·         Creating hyperlinks

·         Pasting charts into other Office documents           

Lecture 13: Collaborating with colleagues 
·         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

  Module - 3 Manual accounting
Lecture - 1 Understanding an Accounting Manual 
·         Components of an Accounting Manual

·         Example of an Accounting Manual

·         What Is Accounting?

·         How Accounting Works

·         Types of Accounting

·         Requirements for Accounting

  Module - 4 TallyPrime
Lecture-2 Accounting Concepts 
·         What is Commerce?

·         Why Accounting is needed?

·         Basic concept of accounting

·         Types of accounts

·         Golden Rules of Accounts

Lecture - 3 Introduction to Tally Prime & Company Creation 
·         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

Lecture - 4 Chart of Accounts, Groups & Ledgers in Tally Prime 
·         Create Account Groups Single/Multiple

·         Creating a Single/Multiple Ledger

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

·         Ledgers with Opening Balances

·         Balance Sheet

Lecture-5Introduction to Vouchers 
·         Contra

·         Payment

·         Receipt

·         Journal

·         Sales

·         Purchase

·         Debit note

·         Credit note

Lecture-6 Cost Center & Cost Category 
·         Cost Centers Allocation

·         Cost categories for parallel allocation

·         Cost center class

·         Report related to cost center/category

Lecture -7 Budget & Scenario 
·     Create/Alter a Budget

·     View Budget Variance

·     Delete a Budget

·     Create/Alter a Scenario

·     Use Optional Vouchers in Scenarios

·     Use Scenarios in Reports

Lecture -8 Interest Calculation 
·     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

Lecture -9 Accounting Reports 
·     Balance Sheet

·     Profit & Loss

·     Cash Flow

·     Funds Flow

·     Receivables

·     Payables

·     Trial Balance

·     Day Book

·     Cash Book

·     Bank Book
	
Lecture -10 Inventory Creation in Tally Prime 
·     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

Lecture -11 Bill of Materials 
·     Setup Bill of Materials (BOM)

·     Creating a Manufacturing Journal

Lecture -12 Batches and Expiry date 
·     Set Up Batches for Stock Items

·     Sell Stock Items from Batches

·     Batches for Purchased Stock Items

·     Batch Summary

·     Batch Vouchers

Lecture -13 Inventory Vouchers and Order Processing 
·     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

Lecture -14 Job order processing- Material in/Material out 
·     Job Work

·     Job Work Masters

·     Principal Manufacturer (Job Work Out)

·     Job Work In

·     Material In/ Material Out Voucher

Lecture -15 Advance features in Tally 
·     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

Lecture - 16 Price Levels and Price List in Tally Prime 
·     Price Levels

·     Create Price Levels

·     Assign Price Levels to Ledger Accounts

·     Price List

·     Use Price Levels & Price List during Voucher Entry

Lecture -17 Pre closure of Orders 
·     Complete cancellation of order

·     Partial cancellation of order

·     Record Quotation
Lecture -18 POS-Point of Sale 
·     Record a POS Invoice

·     POS Invoice with Multiple Modes of Payment

·     Faster Data Entry for POS Invoice

·     POS Register

Lecture -19 Inventory Reports 
·     Track Your Inventory | Stock Summary

·     Location/Godown Summary

·     Movement Analysis

·     Stock Ageing Analysis

·     Stock Query

·     Physical Stock Register

·     Stock Cost Estimation

Lecture - 20 Other Utilities 
·     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

Lecture – 21 Tally Prime with Banking 
·     Cheque printing

·     Cheque Register

·     Banking Transaction Types

·     Post Dated Cheque

·     Deposit Slip

·     Payment Advice

·     Bank Reconciliation

Lecture – 22 Payroll Processing 
·     Introduction to Payroll

·     Payroll in Tally Prime

·     Enable Payroll in Tally Prime

·     Payroll Transactions

·     Generate Pay Slips
Module - 5 TallyPrime with GST
Lecture – 23 GST in Tally Prime 
·     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

Lecture – 24 Introduction to GST Returns 
·     GSTR-1 Filing

·     GSTR-3B Filing

Lecture – 25 GST Report 
·     GSTR-1

·     GSTR-2

·     GSTR-3B

·     GST Annual Computation Report

Lecture – 26 E-Way Bill 
·     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

Lecture – 27 TDS- Tax Deducted at Source 
·     Enable TDS

·     TDS Nature of Payment

·     TDS Ledger- Expenses Ledger, Party Ledger

·     Record TDS Transactions

·     Generate TDS Reports

Lecture – 28 TCS- Tax Collected at Source 
·     Set Up Your Books For Tax Collected at Source

·     Record TCS Transactions

·     Generate TCS Reports