Jewellery Designing Interrior Designing Fashion Designing Aonline Training Franchise Scheme Send Free E-Greetings "Compufield -computer Institute specialized in fast track courses-multimedia,web designing,software engineering,certification courses,fashion,jewellery,interior designing courses. India,Bombay(Mumbai)."
Franchise Scheme Latest Courses At Compufield
Compufield now in Bandr
Franchise enquiry welcome It corporate Training World wide

OUR STUDENT'S ACHIEVEMENT VIDEO

  MS Office & Financial Accounting Courses :
   Certificate Course in Office Automation & Internet I Diploma In Office Automation & Internet I Computer Fundamentals + Windows O/S + Internet Technology
    Certificate course in Financial Accounting (Tally) + Advance Excel I Tally 9.2 (15)+ Advance Excel (30)
Search For Our Courses

ISO 9001:2000 Certified Computer Institute
Why do
Foreign/Indian Students prefer to study at COMPUFIELD?

Home
Join our Newsletter


Enter your E-Mail

ABout Us
Courses
Registration
Our Students
Business Offer


    Certificate course in Financial Application


Enquire About This Course
   
Name :
   
*Country Name
    e.g.India, UK, ....
Residence / Office Number :
Country Code City Code Number
    (Number-Coutry code & city code)
e.g. +91-22-23676218
     
Mobile Number :
     
*Email :
     
*Course Of Interest :
     
Enquiry :
    (*) Signed fields are mandatory.
   
   
Advance TALLY (Financial Accounting) 
  • Maintain Accounts using different Currencies other then the home currency.

  • Forecasting using Budgets feature of tally. You can make Departmental Budget, Financial Budget and Marketing Budget. Budget features are used to compare against actual to Display Variance.
  • How to handle and maintain Accounts of a manufacturing company.

    Cost Centers: - Allocating EXP and Income (Revenue) to the different branches of the company inside Bombay or all Over India. Maintaining Accounts related to Cost Centers

  • Using Tally’s Advance features of TDS (Tax Distributed at Source).

  • Using Tally’s Advance features of VAT (Value Added Tax)

  • How to Import and Export Tally Data

  • Ratio Analysis. (Explained in Detail):-  Reports showing you the state of the companies financial health and where it is going in short term. (Ratio Format).

  • Using E-capabilities. (Email) features of Tally.

  • Cash and Fund Flow statement:-          

    How to ascertain
    Cash Flow summary- Cash Movement- Inflow and Outflow of cash only.
    Fund Flow summary- Movement of entire Working Capital.

    Recall source of fund and how they are applied


  • Scenario Management:-  Useful in reports with provisional figures without actually putting the entries through the main books and for forecasting purposes, by passing necessary Vouchers

  • Exploring the QUERY features of Tally
SALIENT FEATURES
  • Saves time.
  • Accuracy.
  • Various accounting books are created within seconds i.e. cash book, ledger book, purchase book, sales purchase.
  • Financial statements within minutes i.e. Trading A/C, Profit and loss A/C, Balance sheet.

APPLICATIONS

  • Tally is used by all type of business houses like Proprietor firm, Partnership firm, Non-profit making Organizations, Mnc companies.
    Advance Excel (Financial Accounting) 

    Course Title: Microsoft Excel, Level 2 (2003, XP, 2003/2007)
    Duration : 30 hrs

    This program is designed for executives who are already familiar with the basics of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports, and automating various tasks.


    Program Objectives

    This Advanced Excel training program will empower the participants to be able to do the following:

    Performing complex calculations more efficiently, using various Excel functions.
    Organizing and analyzing large volumes of data.
    Creating MIS reports.
    Designing and using templates.
    Consolidating and managing data from multiple workbooks.


    Audience

    Executives and managers who have already been using Microsoft Excel, but now feel the need for learning more powerful features and options of Excel, to manage their worksheet-related tasks more efficiently.


    Prerequisites

    Participants attending this training should be familiar with the basic operations in Microsoft Excel, such as simple calculations, formatting and printing.


    Topics Coverd :

    Overview of the Basics
    Customizing common options in Excel
    Absolute and relative cells
    Protecting and un-protecting worksheets and cells

    Working with Functions

    Writing conditional expressions (using IF)
    Using logical functions (AND, OR, NOT)
    Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)


    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


    Working with Templates

    Designing the structure of a template
    Using templates for standardization of worksheets


    Sorting and Filtering Data

    Sorting tables
    Using multiple-level sorting
    Using custom sorting
    Filtering data for selected view (AutoFilter)
    Using advanced filter options


    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


    More Functions

    Date and time functions
    Text functions
    Database functions


    Formatting
    Using auto formatting option for worksheets
    Using conditional formatting option for rows, columns and cells

Course Duration Fees (Indian Rs.) Fees (US $)
45 sessions of 1 hr. each 9,500 270

 


 

Lodging, boarding and travelling not included in the fees.
The above mentioned fees is for one course.
   
COMPUFIELD offers a unique style of learning -

One computer : One student : One Instructor
Maximum Instructor to Student Ratio 1:4
Sessions : Each session will be of 1 hour.
The timing can be fixed based on our mutual convenience,between 9.00 a.m. to 7.00 p.m.
Overseas Students take 5 to 10 hours per day to complete their courses.
Course duration in days = total sessions divide by number of sessions per day.
The Above Mentioned Tuition Fees Includes Service Tax 12.36%
No extra charges/refund for more/less time taken to complete the course.


Top

Solve your Queries Online related to our Courses

Mobile Number
M.E. Khairaz (MD)
+91 - 9820134058

Gmail
 compufield@gmail.com
Yahoo Messenger
Yahoo Messenger
compufield@yahoo.com
ICQ
MSN Messenger
compufield@hotmail.co.uk
Skype
compufieldinfo@skype.com
Facebook
Facebook
Twitter
Twitter
Address-HO : Chinoy Mansion, 1st Flr, Block #2, Opp. St.Stephen's Church, Warden Road, Mumbai-400 036, India.+91-22-236762182