Tally with Professional Excel & E-filing - Contents
Tally with Professional Excel & E-filing training in west delhi
Introduction of TALLY
Tally with Professional Excel & E-filling course in west delhi
- 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 Accounts
- 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 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
- Cost centre
- 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 (TDS)
- Understanding TCS
- Creating TCS Masters & Practical Examples
- TCS Payment, Reports, & Forms
Goods & Services Tax (GST)
- GST
- Ledger for GST
- Transaction of GST
- Adjustment of GST
- Payment of GST
Export , Backup & 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
- Printout of balance
- Currency creation (How to create
- New currency & how to set the price Lists.
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
Credit Limit Price List
- Creation of Price level
- Create of Price group
- Maintain Price list on items
Vouchers Types & Class
- Voucher Type
- Voucher Class-Sales
- Inclusive Tax Class
- Customer pay their payment
- How to create voucher with discount & freight charge
Module 2 - E-FILLING
Tally with Professional Excel & E-filling course
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
Module 3 - PROFESSIONAL EXCEL
Tally with Professional Excel & E-filling training in west delhi
Formulas
- Sum
- Product
- Average
- IF
- Days360
- Date
- Ceiling
- Sum
- Product
- Average
- IF
- Days360
- Date
- Ceiling
- Floor
- Round
- Round up
- Round down
- Power
- Count
- CountA
- Count
- Sum if
- Maximum
- Minimum
- Hlookup for single worksheet
- Vlookup for single worksheet
- Hlookup & Vlookup for multiple Sheet
- Index
- Show formula
- Or
- Not
- Iferror
- Lookup
- Rate
- Ppmt
- Ipmt
- Networkdays
- Roundup
- Rounddown
- Mode
- Median
- Received
- Log
- Dollar
- AverageA
- Averageif
- Averageifs
- Mina
- Maxa
- Sumifs
- Large
- Pv
- Fv
- Coupdays
- Coupnum
- Datedif
- Daverage
- Dproduct
- Dmin
- Dmax
- Dcount
- Dsum
- Dget
- Now
- Today
- Weekday
- SQRT
- Mod
- Upper
- Lower
- Left
- Right
- Exact
- Len
- Match
- Roman
- Proper
- Pmt
- Concatenate
- IF Function & Nested IF Statements And & Or Functions
- Match and find record by VLOOKUP And HLOOKUP
- ISPMT
- SLN
- Effect
- CUMPRINC
- CUMIPMT
- EoMonth
- EDATE
- WORKDAYS
- DDB
- DB
- Approximate Match with Vlookup
- Exact match with Vlookup
- Nesting Lookup Function
- Choose Function
- Rank & Rank Average
- Rand & Rand Between
- Mod with Conditional Formatting
- Transpose
- Find & mid
- ISERR,
- OFFSET
- IIR
- NPV
- MONTH
- HOURS
- MINUTE
- NETWORKDAYS.INSTL
- Transpose with Vlookup
- ISNUM
- ISERROR
- IFERROR
- SUBSTITUTE
- INDIRECT
- SEARCH
- TRIM
- INDEX WITH SUM,COUNT,AVERAGE
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
Create Statements According to Function
- Inserting a Hyperlink
- 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
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
FORMATS , CONDITIONAL FORMATTING & SORTING
- Cell Format.
- Data Bars, Color Scales & Icon Sets.
- Conditional formatting with formulas
- Conditional formatting with Form Controls.
- Sorting basic.
- Sorting based on Customized List.
- Customized Sorting (Advanced).
FORMATTING NUMBERS
- Using Conditional Formatting
- Removing Conditional Formatting
- Format As table
- Create our Styles
DATA MANAGEMENT
- Data Validation and dealing with Invalid Data.
- Group and Outline Data
- Data
- Data Consolidation.
- Data text to column.
- Custom Views
DATA ANALYSIS TOOLS
- Tracing Formula Precedents
- Tracing Cell Dependents
- Error Checking
- Creating a Pivot Table
- Rearranging a Pivot Table
- Filtering Pivot Table Data
- Creating a Pivot Chart
SUMMARIZING DATA
- Adding Subtotals to a List
- Nesting Subtotals
- Applying Advance Filters
- 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
WORKING WITH LISTS
- Sorting Records in a List
- Using AutoFilter in a List
- Filter & Advance Filter
WORKGROUP COLLABORATION
- 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
- Web Page Preview
- Converting Worksheets into Web Pages
- Inserting Hyperlinks
- Viewing & Editing Comments
CUSTOMIZING EXCEL
- 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
PRINT SETTINGS
- Page Break
- Print Area
- Print Titles
- Background
SPECIAL OPERATIONS
- Link with One sheet,Another Worksheet , One Workbooks,Multiple Workbooks
- Find record by drop down list according To condition
- Dash Board
