MS-EXCEL
FOR
CHARTERED
ACCOUNTANTS
SUNIL B GABHAWALLA
CHARTERED ACCOUNTANT
WESTERN INDIA REGIONAL COUNCIL
OF THE INSTITUTE OF CHARTERED
ACCOUNTANTS OF INDIA
TABLE OF CONTENTS
1 Basics & Beyond......................................................................................................... 4
1.1
Introduction......................................................................................................... 4
1.2
The EXCEL Screen............................................................................................. 4
1.3
Moving Around................................................................................................... 5
2
Data Entry ................................................................................................................... 8
2.1
Text ..................................................................................................................... 8
2.2
Number (including date, time, percent) .............................................................. 8
2.3
Formulae ............................................................................................................. 8
2.4
Functions............................................................................................................. 9
2.5
AutoComplete ..................................................................................................... 9
2.6
AutoCorrect....................................................................................................... 10
2.7
AutoFill ............................................................................................................. 10
2.8
Data Validation ................................................................................................. 11
3
Totals & More........................................................................................................... 13
3.1
+ + + ,…. why not? ................................................................................