Excel

 

The Mouse Training Company 
   

 

Excel 2007  Advanced 
Tel: +44 (0) 207 920 9500  http://www.mousetraining.co.uk  MS Office Training Specialists 
   

 
 

 

TABLE OF CONTENTS 
TABLE OF CONTENTS ...............................................................................................3
INTRODUCTION..........................................................................................................................7 How To Use This Guide .................................................................................................................. 7 Objectives....................................................................................................................................... 7 Instructions.................................................................................................................................... 7 Appendices..................................................................................................................................... 7

SECTION 1 ADVANCED WORKSHEET FUNCTIONS .....................................................9
NAMES.....................................................................................................................................10 Defining Names............................................................................................................................ 10 Creating Names Automatically..................................................................................................... 11 Managing Names......................................................................................................................... 12 USING NAMES ..........................................................................................................................14 Go To............................................................................................................................................ 14 Names In Formulae...................................................................................................................... 15 Applying Names ........................................................................................................................... 16 CONDITIONAL & LOGICAL FUNCTIONS.......................................................................................17If Statements................................................................................................................................ 17 Logical Test................................................................................................................................... 18 Value If True / False..................................................................................................................... 18 Nested If....................................................................................................................................... 19 Statistical If Statements ............................................................................................................... 21AND, OR, NOT...........................................................................................................................22 And ............................................................................................................................................... 22 Or ................................................................................................................................................. 23 Not............................................................................................................................................... 23 LOOKUP FUNCTIONS.................................................................................................................24 Lookup.......................................................................................................................................... 24 Vector Lookup...