Sale!

Excel Scientific and Engineering Cookbook 1st Edition by David M Bourg ISBN 0596008791 9780596008796

Original price was: $50.00.Current price is: $35.00.

Excel Scientific and Engineering Cookbook 1st Edition David M. Bourg Digital Instant Download

Author(s): David M. Bourg
ISBN(s): 9780596008796, 0596008791
Edition: 1
File Details: PDF, 17.32 MB
Year: 2006
Language: english
SKU: EB-2508960 Category: Tag:

Excel Scientific and Engineering Cookbook 1st Edition by David M Bourg – Ebook PDF Instant Download/Delivery: 0596008791, 9780596008796
Full download Excel Scientific and Engineering Cookbook 1st Edition after payment

Product details:

ISBN 10: 0596008791 
ISBN 13: 9780596008796
Author: David M Bourg

Given the improved analytical capabilities of Excel, scientists and engineers everywhere are using it–instead of FORTRAN–to solve problems. And why not? Excel is installed on millions of computers, features a rich set of built-in analyses tools, and includes an integrated Visual Basic for Applications (VBA) programming language. No wonder it’s today’s computing tool of choice. Chances are you already use Excel to perform some fairly routine calculations. Now the Excel Scientific and Engineering Cookbook shows you how to leverage Excel to perform more complex calculations, too, calculations that once fell in the domain of specialized tools. It does so by putting a smorgasbord of data analysis techniques right at your fingertips. The book shows how to perform these useful tasks and others: Use Excel and VBA in general Import data from a variety of sources Analyze data Perform calculations Visualize the results for interpretation and presentation Use Excel to solve specific science and engineering problems Wherever possible, the Excel Scientific and Engineering Cookbook draws on real-world examples from a range of scientific disciplines such as biology, chemistry, and physics. This way, you’ll be better prepared to solve the problems you face in your everyday scientific or engineering tasks. High on practicality and low on theory, this quick, look-up reference provides instant solutions, or “recipes,” to problems both basic and advanced. And like other books in O’Reilly’s popular Cookbook format, each recipe also includes a discussion on how and why it works. As a result, you can take comfort in knowing that complete, practical answers are a mere page-flip away.

Excel Scientific and Engineering Cookbook 1st Table of contents:

  • Chapter 1: Getting Started with Excel for Science and Engineering

    • Overview of Excel’s Interface
    • Customizing the Ribbon and Quick Access Toolbar
    • Key Excel Functions for Science and Engineering
    • Navigating the Excel Workspace

  • Chapter 2: Data Entry and Organization

    • Entering and Formatting Data
    • Organizing Data with Tables and Named Ranges
    • Using Data Validation for Error-Free Data Entry
    • Sorting and Filtering Data
    • Using Excel for Managing Large Datasets

  • Chapter 3: Mathematical Functions and Formulas

    • Basic Math Functions: SUM, AVERAGE, etc.
    • Trigonometric and Statistical Functions
    • Engineering-Specific Functions (e.g., IM, BESSEL)
    • Using Array Formulas for Complex Calculations
    • Solving Equations with Excel

  • Chapter 4: Data Analysis and Manipulation

    • Working with PivotTables for Summarizing Data
    • Analyzing Trends and Patterns with Excel’s Data Analysis ToolPak
    • Using Solver for Optimization Problems
    • Regression Analysis and Curve Fitting
    • Statistical Analysis Techniques (e.g., ANOVA, T-tests)

  • Chapter 5: Engineering Calculations and Simulations

    • Performing Unit Conversions with Excel
    • Using Excel for Numerical Methods (e.g., integration, differentiation)
    • Simulating Physical Systems with Monte Carlo Methods
    • Using Excel for Electrical Circuit Calculations
    • Solving Differential Equations Using Excel

  • Chapter 6: Data Visualization and Charting

    • Creating Basic Charts (Line, Bar, Scatter, etc.)
    • Customizing Charts for Scientific Presentations
    • Creating Engineering Diagrams (e.g., Bode Plots, Nyquist Diagrams)
    • Visualizing 3D Data and Surface Plots
    • Creating Dashboards and Interactive Charts

  • Chapter 7: Advanced Excel Functions for Scientists and Engineers

    • Using Lookup Functions: VLOOKUP, HLOOKUP, INDEX, MATCH
    • Working with Financial Functions for Cost Analysis
    • Using Logical Functions (IF, AND, OR) for Complex Conditions
    • Dynamic Arrays and New Excel Features
    • Automating Tasks with Excel Macros

  • Chapter 8: Automating Tasks with VBA (Visual Basic for Applications)

    • Introduction to VBA Programming
    • Writing Simple VBA Scripts for Repetitive Tasks
    • Building Custom Functions and Procedures
    • Automating Data Analysis Workflows
    • Debugging and Error Handling in VBA

  • Chapter 9: Scientific and Engineering Applications

    • Using Excel for Chemistry Calculations
    • Structural Engineering: Load Calculations and Stress Analysis
    • Electrical Engineering: Circuit Design and Analysis
    • Mechanical Engineering: Motion, Force, and Kinematics
    • Environmental Science and Statistical Modeling in Excel

  • Chapter 10: Working with External Data

    • Importing Data from External Sources (e.g., CSV, databases)
    • Working with Web Queries and APIs
    • Linking Excel to External Software (e.g., MATLAB, Python)
    • Handling and Cleaning Raw Data
    • Exporting Excel Data for Use in Scientific Reports

  • Chapter 11: Scientific and Engineering Reporting

    • Creating Professional Reports in Excel
    • Using Excel for Documentation and Presentation
    • Collaborating on Excel Documents with Teams
    • Printing and Publishing Excel Workbooks

  • Chapter 12: Tips, Tricks, and Troubleshooting

    • Common Excel Errors and How to Avoid Them
    • Efficiency Tips for Working with Large Datasets
    • Keyboard Shortcuts and Time-Saving Techniques
    • Troubleshooting Formulas and VBA Code

People also search for Excel Scientific and Engineering Cookbook 1st:

excel scientific and engineering
    
excel scientific and engineering cookbook
    
engineering calculations in excel
    
xcel engineering jobs
    
do engineers use excel

Tags:

David M Bourg,Excel Scientific,Engineering