The Mouse Training Company
http://www.mousetraining.co.uk
Excel 2010
Advanced
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
CONDITIONAL & LOGICAL FUNCTIONS................................................................................. 10
If Statements ............................................................................................................... 10
Logical Test .................................................................................................................. 11
Value If True / False ...................................................................................................... 11
Nested If...................................................................................................................... 12
COUNTING AND TOTALLING CELLS CONDITIONALLY ............................................................. 13
Statistical If Statements................................................................................................. 13
Sumif .......................................................................................................................... 15
Countif..................................................................