ECDL 95/97 Module 4

List of contents

 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  Unsuitable for financial amounts 111  The comma style 111  The currency style 112  The percent style 113  Changing from the general format 116  The number format 116  Toolbar buttons 117  Excel and dates 118  Entering dates 118  Formatting dates 119  Regional settings 120  Excel and text 120  Text across multiple columns 120  Entering numbers as text 121  Excel's autoFill feature 122  AutoFill and single numbers and text 124  AutoFill and number series 124  AutoFill and months, days, times and years 124  AutoFill and calculations 125  AutoFill and cell references 125  AutoFill keyboard shortcuts 127  Chapter summary: so now you know 128  chapter 6  Charting with Excel 129  In this chapter 129  New skills 129  New words 129  Charting: the two steps 131  The four dialog boxes to an Excel chart 131  Charts: two ideas you need to know 134  About data points 135  About data series 136  Single data series charts 136  Creating a multiple data series chart 137  Editing your chart 139  Changing chart data 139  Resizing the chart 139  Changing the chart title 140  Adding a chart title 140  Adding data labels 141  Formatting data labels 143  Changing the scale 143  Changing chart colours 145  Chart types 147  

About the author

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.

Summary

This title offers the basics, such as starting and closing Excel, creating Excel worksheets and editing cell contents. Written by experienced trainers Brendan Munnelly and Paul Holden, this book offers information in a clear and simple format.

Product details

• Authors: Paul Holden, Sharon Murphy
• Publisher: Pearson Academic
• Languages: English
• Product format: Paperback / Softback
• Released: 01.01.2001
• EAN: 9780130446381
• ISBN: 978-0-13-044638-1
• No. of pages: 178
• Weight: 540 g
• Series: Prentice Hall; Prentice Hall
• Subject: Natural sciences, medicine, IT, technology > IT, data processing > Hardware