Normal view MARC view

## Business data analysis using excel

Author: Whigham, David Publisher: Oxford University Press (OUP) 2007.Language: EnglishDescription: 293 p. : Ill. ; 25 cm.ISBN: 9780199296286Type of document: BookBibliography/Index: Includes index
Tags: No tags from this library for this title.
Item type Current location Collection Call number Status Date due Barcode Item holds
Europe Campus
Main Collection
Print QA76.73 .Z2 EXC 2007
(Browse shelf)
001217763
Available 001217763
Total holds: 0

Includes index

Digitized

Business Data Analysis Using Excel Contents GUIDE TO THE ONLINE RESOURCE CENTRE xv 1 Introduction to Excel 1.1 Terminology and navigation 1.2 Entering data 1.3 Selecting an area of the worksheet 1.4 Saving, closing and opening files 1.5 Copying data 1.6 Creating and using named cells 1.7 Inserting or deleting rows or columns 1.8 Working with multiple sheets 1.9 Avoiding errors and mistakes 1.10 Exercises 1.11 Solutions to the exercises 1 1 5 12 13 14 22 23 25 27 28 32 2 Understanding data 2.1 What are data? 2.2 Quantitative data 2.2.1 Discrete data 2.2.2 Continuous data 2.3 Qualitative data 2.3.1 Categorical data 2.3.2 Ordinal data 2.4 Exercises 2.5 Solutions to the exercises 39 39 40 41 41 42 42 44 45 46 3 Data handling 3.1 Sorting data 3.2 Filtering data 3.3 Parsing data 3.4 Exercises 3.5 Solutions to the exercises 48 48 52 56 58 60 4 Charting data 4.1 Principles of charting 4.2 XY scatter graphs 4.3 Column and bar charts 4.4 Pie charts 4.5 Some practicalities in preparing graphs 65 65 66 68 72 73 13.5 Variations in the compounding period 13.6 Continuous compounding 13.7 The equivalent annual rate 13.8 Growth rate calculations 13.9 Annuities 13.10 Sinking funds 13.11 Debt repayments 13.12 Exercises 13.13 Solutions to the exercises 231 235 237 239 241 246 247 249 252 14 Investment Appraisal 14.1 Present value 14.2 Discounting multiple amounts 14.3 Variations in the discounting period 14.4 Net present value 14.5 The internal rate of return 14.6 The annual percentage rate 14.7 Exercises 14.8 Solutions to the exercises 258 258 261 264 268 273 275 278 281 INDEX 291

There are no comments for this item.