- Excel Scientific and Engineering Cookbook
- Excel Scientific and Engineering Cookbook
- Table of Contents
- Copyright
- Preface
- RecipeWho Should Read This Book
- RecipeWhat s in This Book
- RecipeConventions in This Book
- RecipeUsing Code Examples
- RecipeSafari Enabled
- RecipeWe d Like Your Feedback
- RecipeAcknowledgments
- Chapter 1. Using Excel
- Section 1.0. Introduction
- Recipe1.1.Navigating the Interface
- Recipe1.2.Entering Data
- Recipe1.3.Setting Cell Data Types
- Recipe1.4.Selecting More Than a Single Cell
- Recipe1.5.Entering Formulas
- Recipe1.6.Exploring the R1C1 Cell Reference Style
- Recipe1.7.Referring to More Than a Single Cell
- Recipe1.8.Understanding Operator Precedence
- Recipe1.9.Using Exponents in Formulas
- Recipe1.10.Exploring Functions
- Recipe1.11.Formatting Your Spreadsheets
- Recipe1.12.Defining Custom Format Styles
- Recipe1.13.Leveraging Copy, Cut, Paste, and Paste Special
- Recipe1.14.Using Cell Names (Like Programming Variables)
- Recipe1.15.Validating Data
- Recipe1.16.Taking Advantage of Macros
- Recipe1.17.Adding Comments and Equation Notes
- Recipe1.18.Getting Help
- Chapter 2. Getting Acquainted with Visual Basic for Applications
- Section 2.0. Introduction
- Recipe2.1.Navigating the VBA Editor
- Recipe2.2.Writing Functions and Subroutines
- Recipe2.3.Working with Data Types
- Recipe2.4.Defining Variables
- Recipe2.5.Defining Constants
- Recipe2.6.Using Arrays
- Recipe2.7.Commenting Code
- Recipe2.8.Spanning Long Statements over Multiple Lines
- Recipe2.9.Using Conditional Statements
- Recipe2.10.Using Loops
- Recipe2.11.Debugging VBA Code
- Recipe2.12.Exploring VBA s Built-in Functions
- Recipe2.13.Exploring Excel Objects
- Recipe2.14.Creating Your Own Objects in VBA
- Recipe2.15.VBA Help
- Chapter 3. Collecting and Cleaning Up Data
- Section 3.0. Introduction
- Recipe3.1.Importing Data from Text Files
- Recipe3.2.Importing Data from Delimited Text Files
- Recipe3.3.Importing Data Using Drag-and-Drop
- Recipe3.4.Importing Data from Access Databases
- Recipe3.5.Importing Data from Web Pages
- Recipe3.6.Parsing Data
- Recipe3.7.Removing Weird Characters from Imported Text
- Recipe3.8.Converting Units
- Recipe3.9.Sorting Data
- Recipe3.10.Filtering Data
- Recipe3.11.Looking Up Values in Tables
- Recipe3.12.Retrieving Data from XML Files
- Chapter 4. Charting
- Section 4.0. Introduction
- Recipe4.1.Creating Simple Charts
- Recipe4.2.Exploring Chart Styles
- Recipe4.3.Formatting Charts
- Recipe4.4.Customizing Chart Axes
- Recipe4.5.Setting Log or Semilog Scales
- Recipe4.6.Using Multiple Axes
- Recipe4.7.Changing the Type of an Existing Chart
- Recipe4.8.Combining Chart Types
- Recipe4.9.Building 3D Surface Plots
- Recipe4.10.Preparing Contour Plots
- Recipe4.11.Annotating Charts
- Recipe4.12.Saving Custom Chart Types
- Recipe4.13.Copying Charts to Word
- Recipe4-14.Displaying Error Bars
- Chapter 5. Statistical Analysis
