Table of Contents

OVERVIEW... 9

REVIEW QUESTIONS –SECTION 1. 16

CREATING A CHART.. 17

CHANGE CHART TYPE.. 21

EDITING AND UPDATING CHARTS. 26

FORMATTING AND GRAPHICS. 35

REVIEW EXERCISE.. 38

REVIEW QUESTIONS-SECTION 2. 39

CREATING A DEFAULT CHART.. 40

CUSTOM CHART TYPES. 41

CUSTOM CHART TYPES. 42

REVIEW QUESTIONS-SECTION 3. 45

DIFFERENT CHART TYPES. 46

PIE CHARTS. 46

COMBINATION CHARTS. 55

REVIEW EXERCISE.. 64

STOCK CHARTS. 65

WATERFALL CHARTS. 70

TREEMAP CHARTS. 73

SCALING.. 75

PRINTING CHARTS. 80

REVIEW QUESTIONS -SECTION 4. 81

LINK EXCEL DATA INTO POWERPOINT PRESENTATIONS. 82

REVIEW EXERCISE.. 88

REVIEW QUESTIONS -SECTION 5. 89

FINER POINTS OF PRESENTATIONS. 90

GUIDELINES FOR MAKING BETTER PRESENTATIONS. 92

MISUSE OF GRAPHICS. 94

REVIEW QUESTIONS- SECTION 6. 95

GLOSSARY.. 96

INDEX.. 97

ANSWERS TO REVIEW QUESTIONS. 98

CPE EXAM... 105