Microsoft Office
®
Excel 2003
Guy Hart-Davis
McGraw-Hill/Osborne
New York Chicago San Francisco Lisbon London Madrid Mexico City Milan New Delhi San Juan Seoul Singapore Sydney Toronto
McGraw-Hill/Osborne 2100 Powell Street, 10th Floor Emeryville, California 94608 U.S.A.
To arrange bulk purchase discounts for sales promotions, premiums, or fund-raisers, please contact McGraw-Hill/Osborne at the above address. For information on translations or book distributors outside the U.S.A., please see the International Contact Information page immediately following the index of this book.
How to Do Everything with Microsoft Office Excel 2003
Copyright © 2003 by The McGraw-Hill Companies. All rights reserved. Printed in the United
…show more content…
. . . . . . . . . . . . . . . .
Improve Your View with Splits, Extra Windows, Hiding, Zooming, and Freezing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Split the Excel Window to Show Separate Parts at Once . . . . . . . . Open Extra Windows to Work in Different Areas of a Worksheet . . Arrange Open Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Hide a Window . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Zoom In and Out . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
25
26 26 27 28 30 30
iii
iv
How to Do Everything with Microsoft Office Excel 2003
Use Freezing to Keep Key Rows and Columns Visible . . . . . . . . . Set Options to Make Excel Easier to Use . . . . . . . . . . . . . . . . . . . . . . . . . Choose View Options to Customize Excel’s Visual Appearance . . Understand (and Maybe Choose) Calculation Options . . . . . . . . . Set Edit Options to Fine-Tune Editing Maneuvers . . . . . . . . . . . . . Choose General Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Choose Suitable Save Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . Choose Transition Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Set Spelling Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . .
What we need to do is walk you through the steps to be able to freeze, or lock rows and columns, which will allow you to keep track of your placement when you scroll through your dataset. To do this we need to use the Freeze Pane option provided with your
To do this, use the Week 4 Course Project Assignment Template (PROJ420_W4_PIMatrixTemplate.xlsx) in Doc Sharing.
- - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
You cannot analyze data until you have brought the relevant data that will answer the question you are asking. A new feature of Excel 2016 is the built-in function which makes getting and transforming your data much faster and easier and allows you to find and gather all your data into one place. These new capabilities were only available previously as a separate add-in called Power Query. Now they can be found built into Excel 2016. They can be accessed from the Get & Transform group located on the Data tab.
You must complete this assignment without the assistance of persons other than the members of
e. Click to select the Table tab in the dialog box. If your settings do not match those shown below, make the necessary changes.
- - - - - - - - - - - - - - - - -
There are many ways to present the collected data. The information should be presented in a way that is visual to the user of analytical software. This can be done using spreadsheets, charts or graphs.
In the Spreadsheet Stephen is sending – the cells in BLUE HAVE to remain the same. The DID needs to stay. These are outward facing numbers.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
9. Use Excel to calculate averages for data analysing. Also, use Excel to calculate the standard deviation to show variances in data