2001ExcelEfficienciesMono

2001ExcelEfficienciesMono - Efficiency Techniques in Excel...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
Efficiency Techniques in Excel E XCEL R EVIEW 2001-2002
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This handout is meant to serve as a quick review of some of the principal features of Excel. It’s not meant to cover all Excel’s features or to treat them in any depth. This guide may jog your memory about a feature or two you might have used and then forgotten or introduce you to something new in Excel that you’d like to explore further. If you’re not already familiar with a feature described here and you think it might be useful to you, I hope you’ll consult Excel’s online help or a good reference guide for a complete description. Examples and illustrations are drawn from Excel 2000. Paula Ecklund Spring 2001
Background image of page 2
Contents Page I. Workbook Organization The workspace. ................................................................................................................ 1 The document window. ................................................................................................. 2 Toolbars. ........................................................................................................................... 3 Worksheet tabs: adding, deleting, naming, reordering. ............................................ 5 Copying and moving worksheets . ............................................................................... 6 Configuring the Excel environment to suit you. ........................................................ 7 II. Data Entry & Edit Determining the Enter key order of movement . ........................................................ 8 The formula bar. .............................................................................................................. 9 Formats and when to apply them . ............................................................................... 10 Fill and Extend . ............................................................................................................... 11 Why name cells & ranges?. ............................................................................................ 13 Validation. ........................................................................................................................ 16 Special copying . .............................................................................................................. 17 Transposition. .................................................................................................................. 18 Text to Columns. ............................................................................................................. 19 III. Getting Basic Information The status bar . ................................................................................................................. 21 The title bar. ..................................................................................................................... 22 Online help . ..................................................................................................................... 23 Go to particular objects or types. .................................................................................. 26 IV. Arranging & Viewing the Worksheet Adding & deleting rows & columns. ........................................................................... 27 One- and two-way splits. ............................................................................................... 28 Viewing multiple windows (& moving between them) . .......................................... 29 Moving & selecting: power keyboard techniques. ..................................................... 30 Zoom. ................................................................................................................................ 31 Custom views. ................................................................................................................. 32 Combining views & scenarios: the Report Manager . ................................................ 33
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
V. Calculations Recommendations . ......................................................................................................... 34 Copying formulas: Relative & absolute addressing . ................................................. 35 Using built-in functions . ................................................................................................ 38 Analysis Toolbox . ........................................................................................................... 40 Referencing across sheets or books . ............................................................................. 42 IF and the Logical Functions. ........................................................................................ 44 VI. Debugging Testing your model (with small numbers). ................................................................. 46 Audit features. ................................................................................................................. 47 Handling error values. ................................................................................................... 48 VII. Data Management Essentials Sort. ................................................................................................................................... 49 Subtotal. ............................................................................................................................ 50 Outline. ............................................................................................................................. 51 AutoFilter. ........................................................................................................................ 52 Data Table. ....................................................................................................................... 53 Pivot Table. ...................................................................................................................... 55 VIII. Documenting Adding comments to cells . ............................................................................................ 58 IX. Format Tips Row & Column Autofit. ................................................................................................. 60 Autoformat . ..................................................................................................................... 61 The Formatting Toolbar: Highlights. ........................................................................... 63 Conditional Formatting . ................................................................................................ 65 The Drawing Toolbar. .................................................................................................... 66 Styles: Changing & Creating (within a workbook). ................................................... 67 X. Charting Basics ...................................................................................................................... 68
Background image of page 4
XI. Printing Basics Fit to page. ........................................................................................................................ 72 Headers & footers. .......................................................................................................... 73 Printing part of a worksheet. ......................................................................................... 74 XII. Other Resources ................................................................................................................ 75
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Workbook Organization 1 I. Workbook Organization The Workspace Excel’s workspace is the window that holds the Excel menus, toolbars, status area, and workbook documents. You can have more than one workbook open at the same time. You can have more than one view of the same worksheet document visible at the same time. Use Window, New Window to get a second worksheet view. Use Window, Arrange, Tile to see multiple sheets or books at the same time.
Background image of page 6
Workbook Organization 2 The Document Window A workbook may be displayed in a document window within the Excel workspace. A document window is distinct from the workspace window, as in the illustration below. Here, both the workspace window and the document window have their own title bar.
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 80

2001ExcelEfficienciesMono - Efficiency Techniques in Excel...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online