> 
> 
eBook edition

Excel 2007 for Scientists and Engineers (eBook)

Written for intermediate- to expert-level Microsoft Word users, this book demonstrates frequently missed tools and the proper way to use new and... more
Author:
Anne Troy
Format:
Adobe DRM PDF
Download Size:
16.27 MB
Not compatible with:
Kindle, Digibook, Verso, RK Book, Pocketbook 306

Delivery:
The eBook will be available to download in the LibraryBox as soon as payment has been processed.
Seller:
kalahari.com
Now:
R132.95
eBucks:
eB1 330
Discovery Miles:
1 330
  • Pintrest

Short description

Written for intermediate- to expert-level Microsoft Word users, this book demonstrates frequently missed tools and the proper way to use new and existing tools. Word's settings, toolbars, and menus are reviewed, as are topics such as the importance of installing safe fonts, setting tabs correctly, and using styles for maximum effect. Also offered is advice on topics pertaining to work groups, such as sharing templates, styles, and toolbars and creating paper and paperless forms. New concepts such as using tables to set up forms, recording macros to cut down on repetition, automatically updating cross-references, and minimizing file sizes are covered. Instructions on keeping a hard drive clean, which can minimize general PC problems, are also provided.

Long description

For scientists and engineers tired of trying to learn Excel with examples from accounting, this self-paced tutorial is loaded with informative samples from the world of science and engineering. Techniques covered include creating a multifactorial or polynomial trendline, generating random samples with various characteristics, and tips on when to use PEARSON instead of CORREL. Other science- and engineering-related Excel features such as making columns touch each other for a histogram, unlinking a chart from its data, and pivoting tables to create frequency distributions are also covered.

Product details

Publisher:
Holy Macro! Books
ISBN:
9781932802665
Edition:
Second Edition
Keywords:
Engineers,Excel 2007,Guide,Microsoft,Scientists,Techniques
Download Size:
16.27 MB
Copying:
20 selections to your clipboard every 14 days.
Printing:
20 pages every 14 days.
Content ID:
177589
Digital Rights:
41AD7B87-106D-474F-B8A7-57969EA3A3BC-50
Not compatible with:
Kindle, Digibook, Verso, RK Book, Pocketbook 306

Table of contents

PART 1: General Techniques Chapter 1 Navigation in Excel 2007 Chapter 2 The Fill Handle Chapter 3 Relative Vs. Absolute Cell References Chapter 4 Range Names Chapter 5 Nested Functions Excercises: Part-1 PART 2: Data Analysis Chapter 6 Auto-numbering Chapter 7 Subtotals Chapter 8 Summary Functions Chapter 9 Unique Lists Contents Chapter 10 Data Validation Chapter 11 Conditional Formatting Chapter 12 Filtering Tools Chapter 13 Lookups Chapter 14 Working with Trends Chapter 15 Fixing Numbers Chapter 16 Copying Formulas Chapter 17 Multi-cell Arrays Chapter 18 Single-cell Arrays Chapter 19 Date Manipulation Chapter 20 Time Manipulation Excercises: Part-2 76 PART 3: Plotting Data Chapter 21 Types of Graphs Chapter 22 A Graph’s Data Source Chapter 23 Combining Graph Types Chapter 24 Changing Graph Locations Chapter 25 Templates and Defaults Chapter 26 Axis Scales Chapter 27 More Axes Chapter 28 Error Bars Chapter 29 More Bars Chapter 30 Line Markers Chapter 31 Interpolation Chapter 32 Graph Formulas Excercises: Part-3 PART 4: Regression Analysis Chapter 33 Linear Regression Chapter 34 Nonlinear Regression Chapter 35 Curve Fitting Chapter 36 Sigmoid Curves Chapter 37 Predictability Chapter 38 Correlation Chapter 39 Multiple Regression: Linear Estimates Chapter 40 Reiterations and Matrixes Chapter 41 Solving Equations Chapter 42 What-If Controls Chapter 43 Syntax of Functions Chapter 44 Worksheet Functions Excercises: Part-4 PART 5: Statistical Analysis Chapter 45 Why Statistics? Chapter 46 Types of Distributions Chapter 47 Simulating Distributions Chapter 48 Sampling Techniques Chapter 49 Each Test Has Its Own Conditions Chapter 50 Estimating Means Chapter 51 Estimating Proportions Chapter 52 Significant Means Chapter 53 Significant Proportions Chapter 54 Significant Frequencies Chapter 55 More on the Chi-Squared Test Chapter 56 Analysis of Variance Chapter 57 Power Curves Excercises: Part-5 Index

excerpt

Excel 2007 for Scientists and Engineers

Excel 2007 has plenty of space for your scientific work. Each workbook (or .xlsx file) can hold an unlimited number of worksheets (provided that your computer memory permits), and each worksheet has a capacity of 1,048,576 rows by 16,384 columns. Hopefully, you won’t use all this space before retirement.

Scientific spreadsheets can be huge— filled with many numbers. So you need ways to quickly navigate around and to create formulas for giant ranges of cells in a swift and efficient way. That’s what this chapter is about.


Most sheets in this book have a modest size, so it is easy to practice with them. But in real life, you probably deal with much larger collections of data. The basic techniques discussed in this chapter will benefit you even more when your tables become larger and larger.


Navigation Shortcuts

The following keystrokes are some important navigation shortcuts: Ctrl+Home takes you to the origin of the sheet, which is cell A1. Ctrl+arrow key jumps between section borders. (A border is an empty row and/or column.) Ctrl+Shift+arrow key jumps and selects what is between the section borders. Shift+arrow key expands or reduces whatever has been selected.

Customer reviews & ratings

Be the first to write a review for this product.

Rate this product.