FINANCIAL & ACCOUNTING

FINANCIAL & ACCOUNTING

Financial accounting is a specialized branch of accounting that keeps track of a company’s financial transactions. Using standardized guidelines, the transactions are recorded, summarized, and presented in a financial report or financial statement such as an income statement or a balance sheet and also accounting related services such as auditing, bookkeeping, payroll processing, taxation, management and business consultancy or risk assessment and control.

TALLY WITH GST

Tally. Erp 9 Taxation | ABC Trainings
• User Interface and Company Management
• Masters – Ledgers
• Masters – Groups
• Masters – Bill wise Debtors and Creditors Ledger
• Payment Voucher
• Day Book in Tally
• Pre-Allocation of Bills
• Receipt Voucher
• Contra and Journal Voucher
• Cheque Printing in Tally ERP
• Masters: Inventory
• Goods and Services Tax (GST)
• Purchase Voucher with GST
• Sales Voucher with GST
• GST Returns and Payment
• Billing Features in Tally
• Purchase Order Processing
• Sales Order Processing
• Debit and Credit Notes
• Bank Reconciliation in Tally
• Price List in Tally
• Credit Limit
• Stock Transfers
• Manufacturing Vouchers
• Batch Wise Details
• Re-Order Level in Tally
• Interest Calculations (Auto Mode)
• Voucher Types and Class
• Point of Sales
• Scenarios and Optional Vouchers
• Budgets and Controls in Tally
• Cost Centers and Cost Categories
• Party Ledger Analysis
• Purchase and Sales Reporting
• Stock Analysis and Reports
• Cash and Bank Reports
• Search, Filter and Sorting
• Financial Reports
• Multi Language
• Export, Import, Backup and Restore
• Tax Deducted at Source (TDS) in Tally
• Payroll Accounting in Tally
• Finalization Entries
• Data Security
• Tally Audit
• Data Synchronization
• Multi-Currency
• Printing Reports
• Miscellaneous
• Shortcut Keys

FINANCIAL ACCOUNTING

Financial Accounting: Meaning and Objectives - Shiksha Online
 Introduction to Accounting
• Accounting Process
• Finalization of Accounts
• Financial Statement Analysis
• Reconciliation of Books
• Petty Cash Accounting
• Inventory Accounting
• Depreciation Accounting
• Analysis of Financing Liabilities
• Leases and Off-Balance-Sheet Debt
• Analysis of Income Taxes
• Financial Reporting Standards
• International Standards Convergence

ADVANCED EXCEL

Best advanced excel training institute

Advanced Excel
Unit – 1: Advanced Excel Course – Overview of the Basics of Excel
• Customizing common options in Excel
• Absolute and relative cells
• Protecting and un-protecting worksheets and cells

Unit – 2: Advanced Excel Course – Working with Functions
• Writing conditional expressions (using IF)
• Using logical functions (AND, OR, NOT)
• Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
• VlookUP with Exact Match, Approximate Match
• Nested VlookUP with Exact Match
• VlookUP with Tables, Dynamic Ranges
• Nested VlookUP with Exact Match
• Using VLookUP to consolidate Data from Multiple Sheets

Unit – 3: Advanced Excel Course – Data Validations
• Specifying a valid range of values for a cell
• Specifying a list of valid values for a cell
• Specifying custom validations based on formula for a cell

Unit – 4: Advanced Excel Course – Working with Templates
• Designing the structure of a template
• Using templates for standardization of worksheets

Unit – 5: Advanced Excel Course – Sorting and Filtering Data
• Sorting tables
• Using multiple-level sorting
• Using custom sorting
• Filtering data for selected view (AutoFilter)
• Using advanced filter options

Unit –6: Advanced Excel Course – Working with Reports
• Creating subtotals
• Multiple-level subtotals
• Creating Pivot tables
• Formatting and customizing Pivot tables
• Using advanced options of Pivot tables
• Pivot charts
• Consolidating data from multiple sheets and files using Pivot tables
• Using external data sources
• Using data consolidation feature to consolidate data
• Show Value as (% of Row, % of Column, Running Total, Compare with Specific Field)
• Viewing Subtotal under Pivot
• Creating Slicers

Unit – 7: Advanced Excel Course – More Functions
• Date and time functions
• Text functions
• Database functions
• Power Functions (CountIf, CountIFS, SumIF, SumIfS)

Unit – 8: Advanced Excel Course – Formatting
• Using auto formatting option for worksheets
• Using conditional formatting option for rows, columns and cells

Unit – 9: Advanced Excel Course – Macros
• Relative & Absolute Macros
• Editing Macro’s

Unit – 10: Advanced Excel Course – WhatIf Analysis
• Goal Seek
• Data Tables
• Scenario Manager

Unit – 11: Advanced Excel Course – Charts
• Using Charts
• Formatting Charts
• Using 3D Graphs
• Using Bar and Line Chart together
• Using Secondary Axis in Graphs
• Sharing Charts with PowerPoint / MS Word, Dynamically
• (Data Modified in Excel, Chart would automatically get updated)

Market Analysis

Risk Management

Technology Advising

Financial Consultation

Planning & Conductiong

Bonds & Commodities

Business Strategy