Open Learning Guide for Excel 2003 Introductory
This A4 spiral bound manual has been specifically designed to provide the necessary knowledge and techniques for the successful creation and manipulation of an Excel spreadsheet. The accompanying data files on disk are designed to help demonstrate the features you are learning as you work through the manual using a step-by-step approach.
- Mixed media product | 172 pages
- 150 x 300 x 16mm | 520g
- 26 May 2004
- CiA Training Ltd
- Sunderland, United Kingdom
Table of contents
Section 1: Fundamentals - Includes spreadsheet principles, menus and toolbars. Section 2: Opening and Closing Workbooks - Includes moving around using keyboard and mouse, opening multiple workbooks. Section 3: Creating and Saving Workbooks - Includes spreadsheet structure, entering labels and numbers. Section 4: Formulas - Includes using operators, brackets and ranges. Section 5: Editing Cells - Includes using the formula bar and in-cell editing. Section 6: Copying and Moving - Includes using the fill handle and copying to a range of cells. Section 7: Printing - Includes page setup and printing formulas. Section 8: Formatting Cells - Includes adding appearance attributes, changing font, font size and colour. Section 9: Formatting Worksheets - Includes changing row height & column width and inserting & deleting rows and columns. Section 10: Workbooks - Includes using multiple worksheets, renaming and grouping sheets. Section 11: Cell Referencing - Includes relative & absolute addressing. Section 12: Functions - Includes using simple in built functions such as Average, Maximum, & If. Section 13: Charts - Includes creating & manipulating charts in a variety of ways.