A Guide to Microsoft Excel 2013 for Scientists and Engineers

✍ Scribed by Bernard Liengme

• Publisher: Academic Press
• Year: 2015
• Tongue: English
• Leaves: 363
• Edition: 1
• Category: Library

✦ Synopsis

Completely updated guide for students, scientists and engineers who want to use Microsoft Excel 2013 to its full potential. 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.

• Content written specifically for the requirements of science and engineering students and professionals working with Microsoft Excel, brought fully up to date with the new Microsoft Office release of Excel 2013.
• Features of Excel 2013 are illustrated through a wide variety of examples based in technical contexts, demonstrating the use of the program for analysis and presentation of experimental results.

New to this edition:

• The Backstage is introduced (a new Office 2013 feature); all the ‘external’ operations like Save, Print etc. are now in one place
• The chapter on charting is totally revised and updated – Excel 2013 differs greatly from earlier versions
• Includes many new end-of-chapter problems
• Most chapters have been edited to improve readability

✦ Table of Contents

Content:
Front Matter, Pages i-ii
Copyright, Page iv
Preface, Pages xi-xii
Chapter 1 - Welcome to Microsoft® Excel 2013, Pages 1-10
Chapter 2 - Basic Operations, Pages 11-39
Chapter 3 - Printing in Excel, Pages 41-48
Chapter 4 - Using Functions, Pages 49-74
Chapter 5 - Conditional Functions, Pages 75-102
Chapter 6 - Data Mining, Pages 103-116
Chapter 7 - Charts, Pages 117-155
Chapter 8 - Regression Analysis, Pages 157-179
Chapter 9 - VBA User-Defined Functions, Pages 181-206
Chapter 10 - VBA Subroutines, Pages 207-227
Chapter 11 - Modeling I, Pages 229-246
Chapter 12 - Using Solver, Pages 247-271
Chapter 13 - Numerical Integration, Pages 273-290
Chapter 14 - Differential Equations, Pages 291-306
Chapter 15 - Modeling II, Pages 307-319
Chapter 16 - Statistics for Experimenters, Pages 321-345
Appendix - Answers, Pages 347-360
Index, Pages 361-365