On This Table Of Contents Page

Use the Skills and Tutorials contents below to find keywords from the questions to look up for your answers.   Use the "Edit>Find (on This Page)...  Ctrl+F" feature   in your web browser to help you find keyword links on this Table  of Contents page that will then take you to particular tutorials for your answer. This will work on any Internet Explorer (IE) browser page to look for a word or phrase!  (Most other browsers have something similar)

Occasionally, there may be a hint attached.  It may be a hyperlink that looks like this.

Hint: Right-Click a link and then click "Open in New Window" (as in this image )
It will help you keep your answers' page safe from disappearing on you!

Use the Office Assistant (Help) to help find many answers. It's an extensive feature you need to get used to using,  because you will never know it all, your teacher will not always be there to answer a question, and you may be the most expert user in a room at any time!

Work through the examples and exercises in the tutorials. They will give you the experience you need.  If computers aren't "hands-on" what is?

Begin Here, reading through the tutorials, and doing the tasks in them:

Tutorials

1. Starting Excel
2. Entering Data & Doing Simple Calculations
3. Formatting Your Data
4. Using Numbers, Formulas and Functions
   • More on Formulas
5. Using Proofing Tools
6. Emphasizing Your Point with Charts
7. Advanced Excel Skills

Basic EXCEL Skills

1. Working With Cells
2. Working With Files
3. Formatting Worksheets
4. Page Setup and Printing
5. Working with Worksheets
6. Working with Formulas
7. Using Charts and Objects

• Skills "Check Sheet"

Other pages to Go to -

	Computer Applications Home
	Introduction to Windows 2000
	Some Helpful Links
	PowerPoint Tutorials
	Word Tutorials

Class Syllabus/Point Sheet

• Windows 2000 Intro (You should have done this before you got here!)

TESTS...

1. XLTest 1
2. XLTest 2
3. XLTest 3
4. XLTest 4
5. XLTest 5
6. XLTest 6
7. XLTest 7
8. XLTest 8

• Using the workbook window.
• Moving Between Worksheets in a Workbook.
• Insert, Delete and Copy Worksheets.
• Move Worksheets
• Change the Zoom Setting.
• Basic Excel Toolbar Buttons
  • The Standard Toolbar
  • The Formatting Toolbar
  • The Formula Toolbar
  • The Drawing Toolbar
• Moving through a worksheet.
• Using Find and Replace.

• Using Office Assistant. (You will be sent to Starting Word, click the back button to get back here)
• Creating a workbook.
• Using a template.
• Opening an existing workbook.
• Saving your workbook to a file.
  • Saving your workbook as another file type.
  • Saving your workbook in another location.
  • Save as Web Page
• Closing a document and quitting Excel.

Entering Data and Doing Simple Calculations

• How to select cells; things in cells; cells, rows, or columns in different places...

• Entering Text.
• AutoComplete.
• Create Hyperlinks.
• Entering titles.
• Modifying text style and font size.
• The Formula Toolbar.
• Entering column headings and adjusting column widths and row heights.
• Insert/Delete Rows and Columns.
• Hide/Unhide Rows and Columns.
• Freeze/Unfreeze Rows and Columns.
• Arranging text with the Copy, Paste, and Cut commands.
• Entering data.
• Using AutoFill.
• Calculating simple formulas, sums, and percentages.
• The AutoSum button.
• Customizing the Enter key.

• Using Number formats.
• Formatting numbers within cells with Increase/Decrease Decimal.
• Entering Dates.
• Merge & Center - Formatting with the Formatting toolbar.
  • Use the Format Painter
  • Apply Cell Borders and Shading
• Apply an AutoFormat
• Resizing columns and rows.
• Formatting rows and columns.
• Clear Cell Contents
• Clear Cell Formats
• Insert and Delete Selected Cells
• Define, Apply, and Remove a Style

• Use the Office Clipboard
  • View the Contents
  • Paste Specific Items from the Clipboard
  • Collect and Paste Multiple Items from the Clipboard
  • Clear all items from the Clipboard
• Changing Column alignment
• Rotating text on your worksheet.
• Add ClipArt.
• WordArt.
• Inserting maps into your worksheets.
• Creating do-it-yourself graphics.

Page 1

• The Order of Calculations in Excel.
• Sorting your data.
• Creating a simple data table: Calculating Car Payments.
• Average function
• Copying formulas.
• Writing your Own Formula
• Creating a budget.
• Converting Arabic numerals to Roman numerals.

More on Formulas

• Mean, median, and standard deviation functions.
• How Excel refers to Cells & Ranges of Cells
• Enter a Range within a Formula.
• Use 3D References.
• Revise Formulas.
• Use References (Absolute and Relative).
• Use Paste Function to insert a Function.
• Use Basic Functions.
• Enter Functions with the Formula Palette.
• Use Date Functions (NOW and DATE).
• Use Financial Functions (FV and PMT).
• Use Logical Functions (IF).

• Use the built-in spelling checker.
• Adding words to the computer dictionary.
• Proofing formulas.
• AutoCorrect fixes errors as you type.
• Print a Worksheet
  • Print a Selection
  • Set Margins
  • Insert Headers and Footers
  • Set Print Area
  • Print Gridlines
• Print row numbers and column letters on every page
• Page Setup
• Page Break Preview
• Repeat Print Titles
• Print preview
• Web Page Preview

• Creating charts with the Chart Wizard with worksheet data.
  Modifying standard graphs:
  • Adding Titles to charts.
  • Rotating and enlarging titles.
  • Changing backgrounds in charts.
  • Changing colors of data bars.
  • Rotating 3-D charts.
  • Adding depth to charts.
  • Using pie charts with your data.
• Manipulating Graphics...
  • Insert, Move, and Delete an Object.
  • Create and Modify Lines and Objects.
  • AutoShapes.

• Linking Excel charts and graphs from in a Word document.

• Recording A Macro.

• Running a Macro.

• Subtotals

  • Summary functions for Subtotaled Lists.

Working With Files

• Save
• Save As... (You will be sent to a Word Intro page, click the back button to get back here)
• Locate and Open an Existing Workbook
• Create a Folder
• Use Templates to Create a New Workbook
• Save a Workbook as a Webpage
• Use the Office Assistant (You will be sent to a Word Intro page, click the back button to get back here)

• Use Undo and Redo (You will be sent to Working with your Word Document, click the back button to get back here)
• Clear Cell Contents
• Enter Text, Dates, & Numbers
• Edit Cell Content
• Go To a Specific Cell
• Insert and Delete Selected Cells
• Use the Office Clipboard
• Use Find and Replace
• Clear Cell Formats
• AutoFill (Work With Series)
• Create Hyperlinks

• Apply Font Styles
• Apply Number Formats
• Modify Row and Column Size
• Modify Alignment of Cell Content
• Adjust the Decimal Place
• Use the Format Painter
• Apply AutoFormat
• Apply Cell Borders and Shading
• Merging Cells
• Rotate Text and Change Indents
• Define, Apply, and Remove a Style

• Preview Worksheets
• Print Worksheets
• Use Web page Preview
• Print a Selection
• Change Page Orientation and Scaling
• Set Page Margins and Centering
• Insert and Remove a Page Break
• Set and Clear a Print Area
• Set up Headers and Footers
• Set Print Titles and Options

• Insert and Delete Rows and Columns
• Hide/Unhide Rows and Columns
• Freeze/Unfreeze Rows and Columns
• Change the Zoom Setting
• Move Between Worksheets in a Workbook
• Check Spelling
• Rename a Workbook
• Insert and Delete Worksheets
• Move and Copy Worksheets
• Use 3D References

• Enter a Range within a Formula
• Enter Formulas
• Revise Formulas
• Use References (Absolute and Relative)
• Use AutoSum
• Use Paste Function to insert a Function
• Use Basic Functions
• Enter Functions with the Formula Palette
• Use Date Functions (NOW and DATE)
• Use Financial Functions (FV and PMT)
• Use Logical Functions (IF)

• Preview and Print Charts
• Use Chart Wizard to Create a Chart
• Modify Charts
• Insert, Move, and Delete an Object
• Create and Modify Lines and Objects