THE INSTITUTE OF
CHARTED ACCOUNTANT OF
INDIA
INFORMATION TECHNOLOGY TRAINING
PROJECT REPORT
1
DETAILS
SUBMITTED BY : AVIN ASHOK
SHETTY
SRO0732602
BATCH :
SUBMITTED TO : UDUPI BRANCH
OF SIRC OF ICAI
UDUPI
COMMENTS BY REVIEWER :
ACKNOWLEDGEMENT
First of all, I would like to thank ICAI and SIRC for
organizing this course, which helps us to know the dynamic area
of computer in professional course like CA
Next up, I would like to thank all the CAs who despite their
2
busy schedule and due dates, conducted this course and I
also would like to thank all other faculties for making us
understand different concepts
Lastly, I would like to thank some of my friends, who
helped me in making this project
DECLARATION
I hereby declare that all the fact, information, figures and
other details provided by me in this project report are
purely imaginary, any resemblance is coincidence. The
report is original and has not been submitted for any other
reason
3
TOPICS COVERED
MS WORD
MS EXCEL
MS POWERPOINT
MS ACCESS
4
MS WORD
Microsoft word is a word processor software developed by Microsoft in
1983. It is the most commonly used word processor software. It is used
to create professional quality documents, letters, reports, resumes, etc
and also allows you to edit or modify your new or existing document.
The file saved in MS Word has .docx extension. It is a component of
the Microsoft Office suite, but you can buy it separately and is available
for both Windows and macOS.
5
Features of MS WORD used in this project
Format painter
Tables
Grouping
Clip arts
Smart art
Pictures
Boarders
Headers and footers
Page number
Bullets
Different styles
Indents
Hyphenation
Alignments
Bold, italic, underline
FEATURES OF MS WORDS :
6
QUICK ACCESS MENU BAR TITLE BAR MINIMIZE MAXIMIZE
CLOSE
RIBBONS
STATUS BAR TEXT AREA VIEW OPTION
1. FILE
It contains options related to the file, like New (used to create a new document),
Open (used to open an existing document), Save (used to save document), Save As
(used to save documents), History, Print, Share, Export, Info, etc.
7
2. HOME
It is the default tab of Ms Word and it is generally divided into five groups, i.e.,
Clipboard, Font, Paragraph, Style and Editing. It allows you to select the color, font,
emphasis, bullets, position of your text. It also contains options like cut, copy, and
paste. After selecting the home tab, you will get below options:
3. INSERT
It is the second tab present on the menu bar or ribbon. It contains various items that
you may want to insert into a Microsoft word. It includes options like tables, word
art, hyperlinks, symbols, charts, signature line, date and time, shapes, header, footer,
text boxes, links, boxes, equations, etc., as shown in the below image:
8
4. LAYOUT
It is the fifth tab present on the menu bar or ribbon. It holds all the options that allow
you to arrange your Microsoft Word document pages just the way you want them. It
includes options like set margins, display line numbers, set paragraph indentation,
and lines apply themes, control page orientation and size, line breaks, etc., as shown
in the below image:
5. REFERENCES
It is the sixth tab present in the menu bar or ribbon. The references tab lets you add
references to a document, then create a bibliography at the end of the text. The
references are generally stored in a master list, which is used to add references to
further documents. It includes options like, Table of Contents, Footnotes, Citations &
Bibliography, Captions, Index, Table of Authorities, smart look, etc. After selecting
References tab, you will get the below options:
9
6. MAILING
It is the seventh tab present in the menu bar or ribbon. It is a least used tab in the
menu bar. This tab is where you would create labels, print them on envelopes, do
mail merge, etc. After selecting mailing, you will get the below options:
7. REVIEW
The review tab contains, commenting, language, translation, spell check, word count
tools. It is good for quickly locating and editing comments. After selecting a review
tab, you will get the options below:
8. VIEW
View tab allows you to switch between single page or double page and also allows
you to control the layout tools It includes print layout, outline, web layout, task pane,
toolbars, ruler, header and footer, footnotes, full-screen view, zoom, etc. as shown in
the below image
10
MS EXCEL
11
MS-EXCEL is a part of Microsoft Office suite software. It is an electronic
spreadsheet with numerous rows and columns, used for organizing data,
graphically represent data(s), and performing different calculations. It
consists of 1048576 rows and 16384 columns; a row and column
together make a cell. Each cell has an address defined by column name
and row number example A1, D2, etc. this is also known as a cell
reference.
Cell references: The address or name of a cell or a range of cells
is known as Cell reference. It helps the software to identify the cell
from where the data/value is to be used in the formula. We can
reference the cell of other worksheets and also of other programs.
Referencing the cell of other worksheets is known as External
referencing.
Referencing the cell of other programs is known as Remote
referencing.
There are three types of cell references in Excel:
1. Relative reference.
2. Absolute reference.
3. Mixed reference.
12
FEATURES OF MS EXCEL USED IN THIS PROJECT
Formulas
Charts
Screenshots
Custom list
Sorting
Filter
Advance filter
Subtotal
Pivot Table
Dynamic Range name
Data Validation
Blocking cells
Data table
Scenario Management
Goal Seek
Lookup
Consolidate
Formatting
13
SALARY REPORT
CRITIRIA :
DA : 40% OF BASIC
HRA : 10% OF BASIC
GROSS : BASIC + DA + HRA
PF : GROSS * 4%
NET : GROSS + PF
14
SALES REPORT
SALE COMISSION
<1000 0
1000 - 5000 2% OF SALE
> 5000 5% OF SALE
CRITRIA:
COMISSION:
REMARKS:
SALES
< 1000 POOR
1000 – 4550 GOOD
> 4550 EXCELLENT
15
16
FORM CONTROLS
LIST BOX:
GROUP BOX:
17
COMBO BOX:
CHECK BOX:
18
SUBTOTAL:
19
LOAN SHEET:
LOAN 50000
INSTALLMENT 15
RATE 11.50%
EMI: =PMT(B3/B12,B2,B1)
20
PIVOT TABLE ;
21
CHARTS:
PIE CHART:
COLUMN CHART:
22
WHAT IF ANALYSIS:
What if analysis consists of 3 types’ data table, scenario manager, and
goal seek. These three are used in order to get a view at potential
instances that could have happened and that could happen
1.DATA TABLE:
DIALOGUE BOX
DATA
FORMULA USED
RESULTS
23
2.GOAL SEEKS:
DIALOGUE BOX
BEFORE AFTER
3.SCENARIO ANALYSIS:
24
4.CUSTOM LISTS
5.SORTING
25
26
5.FILTER
DIALOGUE BOX
27
6.ADVANCE FILTER
DIALOGUE BOX
LIST RANGE
CRITERIA
RESULTS
28
7.DYNAMIC RANGE NAME
The formula of offset is used to create dynamic range name for e.g.:
=OFFSET (database!$A$1,0,0,COUNT(database!$A$1:$A$1000),6)
The uses of dynamic range name are that it changes over time meaning if adjustments
are made to the range there will be no mistakes in the results as adjustments will be
made accordingly.
8.DATA VALIDATION
DIALOGUE BOX
It is used to check whether data is acceptable or not. And when the data
is invalid, the following is displayed .
29
9.PASSWORD
Password can be changed by going to files and then save as
and general options where password can be given to both
access and modify the excel workbook
PROTECTION
Protection of both the sheets and workbook can be given in order to
prevent unauthorized access by accessing the options in review tab.
Additionally access to only few cells may be given by first unlocking the
cells through formatting and then protecting the worksheets. In order to
unlock the sheet, the option to unlock it would appear were prior option
to lock it was present
30
10.LOOKUP FORMULAS
DATA
1. LOOKUP
RESULTS
FORMULA
2. VLOOKUP
RESULTS
FORMULA
31
3. HLOOKUP
RESULTS
FORMULA
32
MS POWERPOINT
It is a presentation-based program that uses graphics, videos, etc. to
make a presentation more interactive and interesting.
The file extension of a saved
PowerPoint presentation is “.ppt”. A PowerPoint presentation comprising
slides and other features is also known as PPT.
It enables users to build visual presentations composed of individual
slides. PowerPoint is generally used by business people and students
to design slide show presentations.
33
TYPES OF SLIDES :
34
TYPES OF TRANSITIONS :
35
TYPRES OF ANIMATIONS :
36
MS ACCESS
In simple terms, Microsoft Access is a popular information
management tool, which helps you store all kinds of
information for reporting, analysis, and reference. With Microsoft
Access, you can manage data more efficiently and analyse large
amounts of information.
Microsoft Access is software you can use to store, edit, and organize
large pools of data. Unlike Excel, Access has more safeguards in
place to prevent human error. You'll also be able to manage more
data for your
37
DESIGN VIEW OF TABLE:
DEFAULT VALUE FOR STATE =”KARNATAKA”
DATE OF BIRTH FORMAT: DATE / TIME SHORT
DATE
38
FEES TYPE
CASH
CHEQUE
39
STEPS TO CREATE MACROS
CREATING QUERY DESIGN TO MAKE A COMBINATION TABLE:
1.CHOOSE THE TABLE:
40
2.SELECT FIELDS:
3.SAVE AND RUN THE ACTION:
4.RESULT
41
5.CREATING FORMS:
STEP 1 STEP 2 STEP 3
42
7.CREATING REPORT:
STEP 1 STEP 2 STEP 3
STEP 4 STEP 5
43
APPEND:
CALCULATION OF TAX USING QUERY DESIGN:
TAX: Sum([STUDENT FEES]!FEESAMT*0.5)
44
TALLY ERP 9
TALLY.ERP 9 is one of the most popular accounting
software used in India. It is complete enterprise software
for small & medium enterprises. Tally. ERP 9 is a perfect
business management solution and GST software with an ideal
combination of function, control, and in-built customizability.
Tally. ERP 9 permits business owners and their
associates to interact more in accounts related discussions and is
a complete product that retains its original simplicity yet offers
comprehensive business functionalities such as Accounting,
Finance, Inventory, Sales, Purchase, Manufacturing, Costing,
Job Costing, Payroll , TDS, TCS, and now GST too.
FEATURES OF TALLY ERP 9 USED
IN THIS PROJECT
45
CREATING A COMPANY
EDITING ITS FEATURES
LEDGERS
VOUCHERS
STOCK ITEMS
STOCK UNITS
TRIAL BALANCE
BALANCE SHEET
PROFIT AND LOSS
DAY BOOK
STOCK SUMMARY
RATIOS
STATEMENT OF ACCOUNTS
STATISTICS
GSTR 1 & 2
CASH FLOW
LIST OF ACCOUNTS
46
CREATION OF COMPANY:-
FEATURES:-
47
LEDGER CREATION:-
VOUCHER ENTRIES:
48
TRIAL BALANCE
B
ALANCE SHEET
DA
Y BOOK
STOCK ITEMS
UNIT OF MEASURES
49
PROFIT AND LOSS:-
LISTS OF ACCOUNTS:-
50
RATIO ANALYSIS:-
STOCK SUMMARY:-
51
THANK YOU
52
