Microsoft Excel for windows is a powerful spreadsheet application that can be used for managing, analyzing and presenting data in a graphical manner:
Excel has three component that perform in three different manner.
The Spreadsheet component. It displays, analyses text and numbers in rows and columns.
The Database component. It manipulates lists of information.
The Chart component. It produce charts which help to present data in graphical manner.
Applications:
•
Excel is used for preparing Company profiles in the form of Charts and Graphs
•
Excel stores the accounting spreadsheets in Electronic fo
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.
Applications:
•
Performing complex calculations more efficiently, using various
Excel functions.
•
Excel stores the accounting spreadsheets in Electronic form.
•
Creating MIS reports.
•
Consolidating
and managing data from multiple workbooks.
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.
This course will help to write macros in Excel using programming language Visual Basic Application (VBA). Recorded macro can edited to customize it to fulfill our requirement and one can directly go for coding to accomplish the required tasks. One can write his own functions and procedures, design forms and working with add-ins.
Applications:
•
Program is scheduled for Advanced Microsoft Excel users. VBA is a programming language, requires aptitude for programming.
Program Objectives
After completion of this program, the participants will be able to the following
It is the most famous and easy to use financial Program designed to suit Indian industry. It eradicates the maintenance of Account books, Balance sheets, journals, etc.
Applications:
•Tally is used by all type of business houses like Proprietor firm, Partnership firm, Non-profit making Organizations, MNC companies.
+91 9819006132 
