Excel for Scientists & Engineers
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.
TABLE OF CONTENTS Excel for Scientists & Engineers
Chapter 1: General Techniques
Overview
There are some general techniques in Excel that every scientist should know about. These techniques will make your work easier and faster, and you will need them in all the chapters to come.
-
How do you copy information from your spreadsheets?
-
How do you refer to (the contents of) other cells?
-
How do you use Names in Excel spreadsheets?
-
What is behind your values: Appearance or Reality?
-
How do you manipulate dates?
-
How do you place functions inside functions?
For a more general coverage of these issues, consult the interactive CD called "Join the Excellers League" published by MrExcel. This CD is available through www.mrexcel.com or www.amazon.com.
Making Copies and Trends
You are probably familiar with the most common copy and paste routines in Excel. Select the cell(s) to copy from, and then choose one of the following options:
-
Hit the Copy button, select a new cell, and hit the Paste button.
-
Choose Edit / Copy, select a new cell, and choose Edit/Paste button.
-
Press Ctrl+C, select a new cell, and press Ctrl+V.
-
Right-Click (R-Click) on your selection, choose Copy, R-Click on a new cell, and choose Paste.
But there are also a few other, even fancier ways that we will discuss next.
Using Paste Special
Sometimes, you don't want an exact replica of the copied cells, but a modified version instead. That's when you need the Paste Special option from either the Edit menu or from the R-Click menu.
Say you have some values in your...
Copyright Dr. Gerard M. Verschuuren 2005 under license agreement with Books24x7
