Table of Contents
: Get Going with Excel 2000
Table of Contents: Is This Booklet for You? ........... 4 Technical Language Only for Nerds?................... 4 The structure .......................... 4 Excel the first impression....... 5 General concepts .................. 5 What is a spreadsheet? ........... 5 Inserting text and numbers..... 5 Data types .............................. 6 Creating formulas................. 6 Menus and How You Use Them........................... 8 Editing .................................. 9 Changing the contents of a cell....................................... 9 Deleting the contents of a cell....................................... 9 Undo ...................................... 9 Column width ........................ 9 Data Entry in Columns....... 11 Simple number formatting ........................ 11 Selecting cells ...................... 12 Copying cells ............................ 13 Summing data..................... 14 Saving a file........................ 15 Help........................................... 16 Household budget .................... 17 Permanent preferences ......... 17 The Household budget ....... 18 Insert rows............................ 19 Inserting and deleting columns............................. 19 Font and font size................. 20 Fill (series) ................................ 21 Creating your own lists ........ 22 Numbers and formulas in our budget ................................ 23 Selecting formulas ............... 23 Saving the budget................. 24 Absolute cell references ..... 24 Annual total.......................... 25 Checking your formulas....... 25 Navigation ................................ 27 Formatting ............................... 28 Excel and Windows ................. 29 Toggling formats.................. 29 Viewing the spreadsheet.......... 30 Zoom.................................... 30 Freeze panes......................... 30 The Last Formulas .......... 30 Saving .................................. 30 Summary.................................. 31 Save As ................................ 32 Formatting the household budget ....................................... 32 AutoFormat.........................32 Manual formatting ..............33 Moving data using the mouse ................................ 33 Moving data using the keyboard............................ 33 Updating Formulas............... 34 Borders................................34 Changing a border................ 35 Removing a border............... 35 Removing gridlines.............. 35 Shading and color ...............35 Copying formats................... 36 Printing the budget..............36 Data layout..........................37 Centering headings............... 37 Vertical layout...................... 37 Naming cells ............................. 38 Other advantages of using names......................38 Entering formulas................. 38 Jumping to named cells........ 39 Names in the Household budget .............................39 Printing..................................... 40 Margins ................................ 40 Headers and footers.............. 40 Scaling the printout .............. 41 Manual page breaks ............. 41 Repeating headings .............. 42 Print area .............................. 43 Fixed print area .................... 43 Printing named areas............ 43 Toolbars.................................... 44 Customizing toolbars ........... 44 Charts ....................................... 45 The Chart Wizard ...............45 A chart on a new page.......... 45 Updating a chart................... 46 Adjusting the format in a chart................................... 46 Chart types ........................... 47 3-D perspective .................... 47 Save chart............................. 48 A chart on this sheet............. 48 Printing charts.....................48 Household Budget................ 49 Working with worksheet tabs............................................ 50 Naming tabs ......................... 50 Deleting a sheet.................... 50 Inserting a sheet ................... 50 Copying sheets..................... 50 Functions .................................. 51 Average................................ 51 Other functions..................... 51 Calculating loan payments.......................... 51 Naming cells in functions. ... 53 Links ......................................... 54 Sorting & filtering data........... 55 Sorting................................ 55 Filtering.............................. 55 User defined filters............... 56 Where do you want to go tomorrow? ............................... 57 Read this while the cat plays with the mouse......... 58 Index: Absolute cell references, 24 AutoFilter, 55 Autoformat, 32 AutoSum, 14 Borders, 34 Calculating loan payments, 51 Cells, definition, 5 Changing the contents of a cell, 9 Charts, 45 3-D perspective, 47 adjusting appearance, 46 on a new page, 45 on this sheet, 48 Printing, 49 Save, 48 Selecting data, 48 Types, 47 Column width, 10 Columns, definition, 5 Copying Cells, 13 Copying using the keyboard, 13 Copying using the mouse, 14 Formats, 36 Relative references, 13 Sheets, 50 Creating formulas, 6 Creating formulas Brackets, 7 Formula bar, 7 Formulas, principles, 8 Operators, 6 Order of operations, 6 Customising Excel Default File Locations, 18 Customizing Excel Options, 17 Data layout, 37 Data types, 6 Decimals, 11 Deleting a sheet, 50 Deleting rows, 19 Deleting the contents of a cell, 9 Editing, 9 Changing the contents of a cell, 9 Column width, 10 Columns, 19 Deleting rows, 19 Deleting the contents of a cell, 9 Insert rows, 19 Undo, 9 Excel and Windows, 29 File location, 18 Fill (series), 21 Creating your own lists, 22 Fill handle, 14 Filtering, 55 User defined filters, 56 Font, 20 Font size, 20 Format Painter, 36 Formatting, 28 Autoformat, 32 Borders, 34 Centering headings, 37 Copying formats, 36 Data layout, 37 Format Painter, 36 Manual formatting, 33 Shading and color, 35 Toggling formats, 29 Vertical layout, 37 Formula Absolute cell references, 24 Check your formulas, 25 Linked spreadsheets, 54 Formula bar, 5; 7 Formulas, principles, 8 Functions, 51 Average, 51 FunctionWizard, 51 Loan payment calculations, 51 Naming cells in functions., 53 Graphs (charts), 45 Headers and footers, 40 Help, 16 TipWizard, 16 Household budget, 17 Insert rows, 19 Insert sheet, 50 Inserting text and numbers, 5 Formula bar, 5 Links, 54 Manual formatting, 33 Margins, 40 Moving around in a spreadsheet, 27 Moving data using the keyboard, 33 Moving data using the mouse, 33 Naming cells, 38 Apply name, 39 Entering formulas, 38 Jumping to, 39 Naming tabs, 50 Navigation, 27 New Workbook, 18 Operators, 6 Options, 17 Order of operations, 6 Page breaks, 41 Print Print Preview, 36 Print area, 43 Print Preview, 36 Printing, 40 Headers and footers, 40 Manual page breaks, 41 Margins, 40 Print area, 43 Repeating headings, 42 Scaling the printout, 41 Relative references, 13 Repeating headings, 42 Rows, definition, 5 Save a file Save, 15 Save as, 15 Saving a file, 15 Selecting, 12 Selecting formulas, 23 Shading and color, 35 Shortcut keys, summary, 58 Simple number formatting Decimals, 11 Sorting, 55 Spreadsheets - naming (tabs), 50 Summing data, 14 AutoSum, 14 Undo, 9 Updating formulas, 34 Viewing the spreadsheet, 30 Freeze panes, 30 Zoom, 30 Workbook, 5