Learning Microsoft Excel 2000

Users' notes: Software requirements, Text, data and answers, Copying the Excel data files: Windows systems, Macintosh systems., Using the activities in schools, The chapter format, Reference index, Other Guided Computer Activities texts, Printing, Mouse conventions, Chapter 15, Sample projects; Chapter 1. Introduction to Microsoft Excel: The Microsoft Excel screen, Moving the cursor: Using the mouse, Using the arrow keys, Using the scroll bars., Moving to specific cells: The go to command, Entering the cell reference., Placing labels on the spreadsheet, Closing the spreadsheet: Using the Windows system, Using the Macintosh system., Entering values into the spreadsheet, Entering formulas into the spreadsheet, The value of a spreadsheet, Other types of formulas, Saving files: Saving the Windows system, Saving the Macintosh system., Loading files: For Windows users, For Macintosh users., Printing spreadsheets: Page set-up, Print preview, Printing., Erasing the contents of a cell, Finishing with Microsoft Excel; Chapter 2. Formatting spreadsheets: Formatting single cells, Formatting groups of cells, Formatting values to dollars, Formatting values to per cent, Changing column width: Using the format menu, Manually adjusting column widths, Automatic column widths., Approaches for entering spreadsheets: Column widths, Entering the body of the spreadsheet, Formatting, Formatting non-adjacent cells, Underlining, Entering the main headings, Adjusting the row height, Checking the spreadsheet, The page set-up, Saving and printing., Further formatting: Formatting the values, Formatting the sub-headings, Formatting the main headings, The format painter tool, Adding borders, The fill colour palette, Closing floating palettes, Saving and printing, Printing formulas; Chapter 3. The copy commands: Fill right, Fill down, AutoFill, Fill series, Clearing cells with AutoFill, Absolute reference cells, Absolute and relative references: Formatting the workbook, Entering the formulas., The grocery store template: Initial formats, Entering the labels and values, Formatting the labels, Formatting the values, Entering the month formulas, Copying the formulas, Adding borders, Entering the totals formula, Saving and printing, Making some changes; Chapter 4. Working with larger spreadsheets: Loading files using the Windows system, Loading files using the Macintosh system, Freezing titles, Saving the read-only file, Removing split bars, Inserting rows or columns, Turning the calculator off, Editing cell contents, Sorting: Sorting on labels, Sorting on values, Using worksheets: Loading a prepared file, Naming a worksheet, Copying data to a new worksheet, Changing the data in the new worksheet, Copying a worksheet, Moving a worksheet, Changing the sheet tabs displayed, Moving through worksheets, Deleting worksheets, Using the shortcut menu; Chapter 5. Making predictions and estimations: The motel template: Setting up the template, Calculating the income from rooms, Calculating the income from food, Calculating the total daily income, Using the spreadsheet to make predictions., Adjusting the motel template, The goal seek command, Practice exercise; Chapter 6. Using spreadsheets to make decisions: The IF command, Greater than or equal to, AND or OR, AND (a, b), OR (a, b); Chapter 7. Statistical functions and the LOOKUP command: Use of functions: Statistical functions, Using the functions box, The LOOKUP function; Chapter 8. Creating charts: Entering a spreadsheet, Creating a pie chart: Selecting the chart type, Setting the data range, The chart options, The chart location., Looking at the chart, Adjusting the size of the chart, The chart toolbar, Modifying the chart: Selecting chart objects, Modifying chart objects, Changing the chart type, Turning the legend off, Exploding a slice from the pie chart, Changing slice patterns, Looking at other pie charts,