Taking a thematic approach to the use of Excel spreadsheets in introductory business data analysis, this text has been designed to explain the overall nature of what is to be achieved and also instruction in how it is to be done.
The learning approach is highly interactive and enables students to develop an understanding of the power of Excel in allowing both analysis of business data sets and in the flexible preparation of graphs, charts and tables for inclusion in reports and essays.
1. Introduction to Excel (1) ; 2. Understanding Data ; 3. Data Handling ; 4. Charting Data ; 5. Elementary Modelling (1) ; 6. Elementary Modelling (2) ; 7. Collating and Categorising Data ; 8. Data Description - Central Tendency ; 9. Data Description - Dispersion ; 10. Data Description - Further Methods ; 11. Data Description - Association ; 12. Regression Analysis ; 13. Financial Arithmetic ; 14. Investment Appraisal
