Aaaaaaaaaa Essay

16073 Words Mar 28th, 2013 65 Pages
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 2 Basics & Beyond......................................................................................................... 4 1.1 Introduction......................................................................................................... 4 1.2 The EXCEL Screen............................................................................................. 4 1.3 Moving Around................................................................................................... 5 Data Entry
…show more content…
13 3.2 SUM() Function ................................................................................................ 13 3.3 QuickSum ......................................................................................................... 13 3.4 SUBTOTAL() Function.................................................................................... 14 3.5 SUMIF() Function ............................................................................................ 14 3.6 Sorting Data ...................................................................................................... 14 3.7 Sub-Totals ......................................................................................................... 15 3.8 Conditional Sum Add-In................................................................................... 16 Queries in Lists ......................................................................................................... 17 4.1 AutoFilter.......................................................................................................... 17 4.2 Advanced Filter................................................................................................. 17 Functions................................................................................................................... 19 5.1 Lookup Functions ............................................................................................. 19 5.2 Date Functions

Related Documents