Excel Quick , 3rd Edition

Front Cover......Page 1
Title Page......Page 2
Copyright......Page 3
Contents......Page 4
INTRODUCTION......Page 6
FINAL COMMENT......Page 7
COMPUTER SPREADSHEETS......Page 8
STARTING MICROSOFT® EXCEL......Page 9
THE WORKSHEET......Page 10
MOVING AROUND THE WORKSHEET......Page 11
ENTERING TEXT ON THE WORKSHEET......Page 13
CHANGING COLUMN WIDTH AND ROW HEIGHT......Page 16
ENTERING NUMBERS ON THE WORKSHEET......Page 17
USING TOOLBAR BUTTONS......Page 19
FUNCTIONS AND FORMULAS......Page 21
PRINTING A WORKSHEET......Page 22
FINISHING THE LESSON......Page 23
FINAL COMMENT......Page 24
THE IMPORTANCE OF FORMULAS IN EXCEL......Page 25
MATH......Page 26
FORMULAS......Page 27
NUMBER FORMATS......Page 29
SAVE YOUR WORK......Page 32
PRINT YOUR FILE......Page 33
FINAL COMMENT......Page 35
EXPANDING THE FINANCIAL PLANNING MODEL......Page 36
COPYING DATA......Page 37
MOVING DATA......Page 43
DELETING AND INSERTING COLUMNS, ROWS, AND SHEETS......Page 45
WHAT-IF ANALYSIS......Page 47
FINAL COMMENT......Page 48
1. GLOBAL SETTINGS......Page 49
2. ENTERING DATES......Page 50
3. AUTOFILL (THE FILL HANDLE)......Page 51
5. ACCOUNTING UNDERLINES......Page 52
6. CELL AND WORKSHEET PROTECTION......Page 53
7. CREATING NAMES FOR CELLS AND RANGES......Page 54
8. KEEPING CERTAIN COLUMNS AND ROWS ALWAYS ON THE SCREEN......Page 55
9. WORKING WITH SHEETS......Page 56
10. ARTWORK......Page 58
Lesson 5 Charts......Page 61
COMPUTER SPREADSHEETS......Page 73
STARTING MICROSOFT® EXCEL......Page 74
HOW EXCEL WORKS......Page 75
THE WORKSHEET......Page 76
MOVING AROUND THE WORKSHEET......Page 77
ENTERING TEXT ON THE WORKSHEET......Page 79
TYPEFACE STYLES (FONTS)......Page 82
ENTERING NUMBERS ON THE WORKSHEET......Page 83
SAVE YOUR WORK......Page 85
IMPROVING APPEARANCES......Page 86
FUNCTIONS AND FORMULAS......Page 87
PRINTING A WORKSHEET......Page 88
WHAT-IF ANALYSIS......Page 90
FINAL COMMENT......Page 91
THE IMPORTANCE OF FORMULAS IN EXCEL......Page 92
MATH......Page 93
FORMULAS......Page 94
NUMBER FORMATS......Page 97
SAVE YOUR WORK......Page 100
WHAT-IF ANALYSIS AGAIN......Page 101
USING FUNCTIONS......Page 102
FINAL COMMENT......Page 104
EXPANDING THE FINANCIAL PLANNING MODEL......Page 105
COPYING DATA......Page 106
SAVE YOUR MODEL......Page 111
MOVING DATA......Page 112
DELETING AND INSERTING COLUMNS, ROWS, AND SHEETS......Page 113
WHAT-IF ANALYSIS......Page 116
FINAL COMMENT......Page 117
1. GLOBAL EXCEL OPTIONS......Page 118
2. ENTERING DATES......Page 120
4. UNIFORM COLUMN WIDTHS......Page 121
5. ACCOUNTING UNDERLINES......Page 122
6. CELL AND WORKSHEET PROTECTION......Page 123
7. CREATING NAMES FOR CELLS AND RANGES......Page 124
8. KEEPING CERTAIN COLUMNS AND ROWS ALWAYS ON THE SCREEN......Page 125
9. WORKING WITH SHEETS......Page 126
10. ARTWORK AND COLOR......Page 128
ABOUT CHARTS IN EXCEL......Page 131
CREATING CHARTS......Page 132
COPYING A CHART......Page 133
CHART TOOLS – DESIGN TAB......Page 134
SAVING A CHART......Page 137
CHART TOOLS - LAYOUT TAB......Page 138
CHART TOOLS – FORMAT TAB......Page 139
INSTANT CHARTS......Page 141
FINAL COMMENT......Page 142
Appendix A: Functions for Business......Page 143
Appendix B: Data Commands......Page 153
Appendix C: Pivot Tables......Page 158