Simple Guide To Creating Web Page

Contents Introduction x Icons xi 1 Spreadsheet design 1 The 'so that' question 2 Checking validity 4 Data 6 Discrete or continuous? 7 Time series 8 Consistency 9 Presentation 9 Secrecy 10 Design rules 11 2 Built-in functions 15 The order of precedence 16 Intermediate cells 20 Relative and absolute cell addressing 21 The pocket calculator 23 Formatting 25 Percentage 26 Number 26 Functions 27 IF 30 NOW 33 Templates 36 3 Lookup tables and databases 39 Lookup tables 40 Naming cells 42 Case sensitive 44 Spreadsheet practice 45 Databases 54 Boolean logic 55 Terminology 56 Database design 58 Lotus 123 databases 63 Microsoft Excel databases 66 Data sources 72 4 Charts 75 Creating a chart 77 Histograms 79 Concatenate 84 XY graph 84 Creating an XY graph 87 The trend line 90 Area graph 91 Hi-lo graph 91 Radar graph 92 Z graph 93 Log graph 98 5 What if 101 Data tables 102 Two-way data tables 108 Differences 109 Scenario manager 109 In Excel 111 In Lotus 111 Goal seeking 112 Excel goal seeking 113 Lotus goal seeking 114 6 Forecasting 117 Previous week actual 118 N week moving average 118 Exponential smoothing 119 Regression analysis 121 Seasonal variations 121 Multiple regression 131 Applied regression analysis 134 Strength of relationship 138 7 Regression analysis 141 A brief overview 142 8 Simulation 145 State the requirements 148 Analyse the system 148 Formulate the mathematical model 150 Create the simulation 150 Verify the simulation 150 Carry out the simulation 151 The working part of the simulation 155 The assembly backlog 160 9 Beyond competence 165 Pivot tables 166 Arrays 171 Macros 173 Running a macro 175 Script editor in Excel 176 Script editor in Lotus 178 Conclusion 179 Index 181