ECDL 95/97 Module 4

Brendan Munnelly is an experienced IT trainer,consultant, journalist and author. Based in Dublin, Ireland, Brendan has developed user training materials for a range of corporate and government organisations throughout Europe. He is also a frequent contributor to computer publications.

 Contents  Introduction 1  Chapter 1  Your first steps in Excel 3  In this chapter 3  New skills 4  New words 4  Starting Excel 5  Worksheets and workbooks 5  Column letters: upper or lower case? 8  Entering numbers in cells 9  Why does Excel right-align numbers? 10  Entering text to a cell 11  Entering a cell reference in a cell 12  The ARROW keys 12  Editing the content of a cell 13  Dependent cells 13  F2: Excel’s EDIT key 14  Deleting the content of a cell 14  Deleting and the ENTER key 15  Deleting cell content – not the cell 15  Standard and formatting toolbars 15  Working with toolbars 16  Excel’s undo 16  Working with Excel workbooks 17  Saving your workbook 18  Creating a new workbook 19  Opening an existing workbook 19  Closing a workbook 19  Quitting Excel 20  Online help 20  Using help menu options 21  Using help from dialog boxes 22  Chapter summary: so now you know 23  chapter 2  Arithmetic with Excel 25  In this chapter 25  New skills 26  New words 26  Formulae in Excel 27  Formulae and arguments 28  Calculated cells 30  Adding down and across 31  Adding non-adjacent cells 32  Editing formulae 33  Combining operators 34  Formulae: using constants 35  Formulae: the rules of arithmetic 36  Fixed-factor calculations 37  Calculations and recalculations 40  Error Messages: when bad things happen 42  Excel’s zoom views 43  Zoom and printing 44  Saving to a diskette 44  Chapter summary: so now you know 45  chapter 3  Functions, formatting and printing 47  In this chapter 47  New skills 48  New words 48  Excel functions 49  The SUM function 49  Upper or lower case? 50  The AutoSum button 51  SUM tolerates text and spaces 52  The AVERAGE function 53  Formatting and aligning single cells 54  Formatting and aligning cell groups 55  Cancelling a selection 56  Cell ranges 56  Non-adjacent cell range 57  Selected cells and the active cell 59  F8: Excel’s SELECT key 59  Selecting columns and rows 60  Deleting rows and column contents 60  Selecting the entire worksheet 61  Adjusting column width and row height 61  Vertical alignment 63  Orientation 64  Fonts 65  Font sizes 66  Font colours 66  Cell borders 67  Cell colour backgrounds 68  Finding cell content 70  Find options 70  Replacing cell content 71  Spell-checking 72  Page setup 74  Paper size 74  Orientation 74  Scaling 74  Margins 75  Gridlines and headings 75  Headers and footers 76  Printing options 78  Print preview 78  Print range options 79  Chapter summary: so now you know 81  chapter 4  Inserting, sorting and moving cells 83  In this chapter 83  New skills 84  New words 84  Inserting and deleting rows 85  Deleting rows 87  Inserting and deleting columns 87  Deleting columns 88  Inserting and deleting cells 89  Copying and pasting cell contents 89  About the clipboard 91  The flashing marquee 92  Cutting and pasting cell contents 94  Copying between worksheets and workbooks 95  Moving calculations 95  Cell references: the two kinds 98  Sorting: reordering cells by content 100  Symbols and special characters 104  Chapter summary: so now you know 105  chapter 5  More about numbers, text and calculations 107  In this chapter 107  New skills 108  New words 108  Numbers: the different formats 109  The general format 110  Zeros after the decimal point 110  Trailing zeros 110  Thousands separators 111  Currency symbols 111  Unsu