Introduction

Excel has built-in support for preparing a wide variety of charts , including custom charts, in your spreadsheet. You can even copy charts you create and embed them in Word documents. Charting is a handy data visualization technique that may provide valuable insight into the experimental or calculated data you may be trying to analyze. Excel makes charting quick and easy, and provides a great deal of flexibility in customizing your charts. Excel's charting capabilities are not as sophisticated as those of some specialized scientific data visualization applications, but in many cases Excel may be the fastest way to visualize data. This is especially true if you're generating your data in Excel via calculations or if you have already imported your data into Excel using techniques discussed in Chapter 3.

Using Excel

Getting Acquainted with Visual Basic for Applications

Collecting and Cleaning Up Data

Charting

Statistical Analysis

Time Series Analysis

Mathematical Functions

Curve Fitting and Regression

Solving Equations

Numerical Integration and Differentiation

Solving Ordinary Differential Equations

Solving Partial Differential Equations

Performing Optimization Analyses in Excel

Introduction to Financial Calculations

Index



Excel Scientific and Engineering Cookbook
Excel Scientific and Engineering Cookbook (Cookbooks (OReilly))
ISBN: 0596008791
EAN: 2147483647
Year: N/A
Pages: 206
Authors: David M Bourg

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net