FINANCIAL & ACCOUNTING ANALYST TRAINING

FINANCIAL & ACCOUNTING ANALYST 

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

  • 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

  • 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

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

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

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
  • Advanced Excel Course – Working with Templates
  • Designing the structure of a template
  • Using templates for standardization of worksheets

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

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 ( Version 2010 & Above)

Advanced Excel Course – More Functions

  • Date and time functions
  • Text functions
  • Database functions
  • Power Functions (CountIf, CountIFS, SumIF, SumIfS)

Advanced Excel Course – Formatting

  • Using auto formatting option for worksheets
  • Using conditional formatting option for rows, columns and cells
  • Advanced Excel Course – Macros
  • Relative & Absolute Macros
  • Editing Macro’s

Advanced Excel Course – WhatIf Analysis

  • Goal Seek
  • Data Tables
  • Scenario Manager

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)

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

Enquiry

Give us a call or fill in the form below and we will contact you. We endeavor to answer all inquiries within 24 hours on business days.