9.1 Data Tables ....................................................................................................... 32
9.2 Scenarios ........................................................................................................... 33
9.3 Goal Seek .......................................................................................................... 33
9.4 Solver ................................................................................................................ 33
10 PivotTables ........................................................................................................... 35
10.1 Creating a Pivot Table ...................................................................................... 35
10.2 Layout of the PivotTable .................................................................................. 37
10.3 Some Examples:................................................................................................ 37
11 Auditing Tools ...................................................................................................... 41
11.1 Auditing Toolbar............................................................................................... 41
11.2 Documenting a Sheet ........................................................................................ 41
11.3 Migrating Data from Other Software................................................................ 43
11.4 Common Audit Techniques .............................................................................. 43
12 Automating MS-EXCEL ...................................................................................... 44
12.1 Open EXCEL each time computer starts .......................................................... 44
12.2 Open a particular file each time EXCEL starts................................................. 44
12.3 Create a new file based on a template each time computer starts..................... 44
12.4 Specifying the Defaults in EXCEL................................................................... 44
12.5 Customizing Menus & Toolbars....................................................................... 45
12.6 Customization Options...................................................................................... 46
12.7 Templates .......................................................................................................... 46
12.8 Workspaces.. ..................................................................................................... 47
12.9 Talking with Other Software ............................................................................ 47
13 Introduction to Macros.......................................................................................... 48
13.1 Global Macros vs. Individual Macros............................................................... 48
13.2 Use of Macro Recorder..................................................................................... 49
13.3 Running Macros................................................................................................ 49
13.4 Basics of VB Programming .............................................................................. 51
1 ANNEXURE A: KEYBOARD SHORTCUTS ........................................................ 53
2 ANNEXURE “B” IMPORTANT EXCEL FUNCTIONS........................................ 55
3 ANNEXURE “C”: COMMON ERROR CODES .................................................... 59
4 ANNEXURE “D” LIST OF ADD-INS PROVIDED WITH MS-EXCEL .............. 61
