Liengme’s Guide to Excel 2016 for Scientists and Engineers is a completely updated guide for students, scientists, and engineers who want to use Microsoft Excel 2016 to its full potential, whether you’re using a PC or a Mac. Electronic spreadsheet analysis has become part of the everyday work of researchers in all areas of engineering and science. Microsoft Excel, as the industry standard spreadsheet, has a range of scientific functions that can be utilized for the modeling, analysis, and presentation of quantitative data. This text provides a straightforward guide to using these functions of Microsoft Excel, guiding the reader from basic principles through to more complicated areas such as formulae, charts, curve-fitting, equation solving, integration, macros, statistical functions, and presenting quantitative data.
1. Cover image - p. iv 2. Title page - p. iv 3. Table of Contents - p. iv 4. Copyright - p. iv 5. Preface - p. xi 6. Chapter 1: Welcome to Microsoft Excel 2016 - p. xii 7. Chapter 2: Basic Operations - p. 13 8. Chapter 3: Printing in Excel - p. 46 9. Chapter 4: Using Functions - p. 56 10. Chapter 5: Conditional Functions - p. 84 11. Chapter 6: Data Mining - p. 116 12. Chapter 7: Charts - p. 132 13. Chapter 8: Regression Analysis - p. 186 14. Chapter 9: VBA User Defined Functions - p. 216 15. Chapter 10: VBA Subroutines - p. 243 16. Chapter 11: Modeling I - p. 268 17. Chapter 12: Using Solver - p. 289 18. Chapter 13: Numerical Integration - p. 316 19. Chapter 14: Differential Equations - p. 336 20. Chapter 15: Modeling II - p. 353 21. Chapter 16: Statistics for Experimenters - p. 369 22. Index - p. 397
Liengme’s Guide to Excel 2016 for Scientists and Engineers is a completely updated guide for students, scientists, and engineers who want to use Microsoft Excel 2016 to its full potential, whether you’re using a PC or a Mac. Electronic spreadsheet analysis has become part of the everyday work of researchers in all areas of engineering and science. Microsoft Excel, as the industry standard spreadsheet, has a range of scientific functions that can be utilized for the modeling, analysis, and presentation of quantitative data. This text provides a straightforward guide to using these functions of Microsoft Excel, guiding the reader from basic principles through to more complicated areas such as formulae, charts, curve-fitting, equation solving, integration, macros, statistical functions, and presenting quantitative data.
1. Cover image - p. iv 2. Title page - p. iv 3. Table of Contents - p. iv 4. Copyright - p. iv 5. Preface - p. xi 6. Chapter 1: Welcome to Microsoft Excel 2016 - p. xii 7. Chapter 2: Basic Operations - p. 13 8. Chapter 3: Printing in Excel - p. 46 9. Chapter 4: Using Functions - p. 56 10. Chapter 5: Conditional Functions - p. 84 11. Chapter 6: Data Mining - p. 116 12. Chapter 7: Charts - p. 132 13. Chapter 8: Regression Analysis - p. 186 14. Chapter 9: VBA User Defined Functions - p. 216 15. Chapter 10: VBA Subroutines - p. 243 16. Chapter 11: Modeling I - p. 268 17. Chapter 12: Using Solver - p. 289 18. Chapter 13: Numerical Integration - p. 316 19. Chapter 14: Differential Equations - p. 336 20. Chapter 15: Modeling II - p. 353 21. Chapter 16: Statistics for Experimenters - p. 369 22. Index - p. 397
