Course Title:              Beginning Microsoft Excel (201.000)

Course Length:         8 hrs

Prerequisites:            

Basic knowledge of keyboard or Computer Literacy

Objective:

Participants will be able to demonstrate the basic skills and commands needed to set up a spreadsheet.

Course Content:

Lesson 1:

• Creating, Saving, and exiting a Worksheet
• Using Mouse & Keyboard
• Enter Labels
• Simple Corrections
• Save & Close a Workbook
• Numeric Labels & Values
• Alignment
• Merging Cells
• Formatting, number, colors, borders
• Indenting within a cell
• #### - What do I do?

Lesson 2:

• Using Formulas: Formatting: Copying Formulas
• Using a Formula
• File Functions
• Formatting Data
• Using Ranges
• Copying Data
• Quick Sorts
• Copying a Formula
• Absolute Reference
• Series
• Insert & Delete Columns & Rows

Lesson 3

• Copying & Pasting, Paste Special, Pasting Links, Printing Options
• Moving
• Copy
• Copy & Paste Special
• Transposing Data
• Freeze Titles
• Split Workbook
• Multiple Worksheets
• Printing Options
• Comments

 Lesson 4:

• Charting
• Create & Edit Charts
• Mail Merge & Using Excel as a database

Equipment Needed:

Microsoft Office software, Lap Top Computers