Excel 2007 for Scientists and Engineers
With examples from the world of science and engineering, this reference shows scientists the tips and techniques of Excel and how to tailor them specifically to their experiments, designs, and research.
TABLE OF CONTENTS Excel 2007 for Scientists and Engineers
Part 1: General Techniques
Chapter List
- 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
Overview
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.
Let's use Figure 1.1 to see how these shortcuts work. Based on Figure 1.1, the following would happen:
| Note | All files used in this book... |
Copyright Dr. Gerard Verschuuren 2008 under license agreement with Books24x7
