LearnPro: Applying Excel 2000
Course description
Overview: Students will learn how to create spreadsheets and charts, and how to use Excel’s database features.
Prerequisites: Students should understand the basics of Microsoft Windows 95, 98 or 2000 and Excel.
Skills List
Students are introduced to the following essential and extended skills in this course:
Essential Skills
Add cell borders
Adjust column width and row height
Align cell contents
Apply character formats
Change the worksheet’s active cell
Clear the contents of a cell
Copy and paste data
Copy formulas using the Edit, Fill command
Create formulas using AutoSum tool or SUM function
Create new, blank workbook file
Define a cell
Define and describe a spreadsheet
Enter data into cell
Enter formulas
Enter labels and values
Familiarity with chart environment
Familiarity with database environment
Familiarity with spreadsheet environment
Insert and delete rows and columns
Modify numeric formats
Move around the worksheet
Open, save (update), and/or close file
Preview printout
Print a worksheet
Save file with new name
Select cell and range of cells
Use absolute cell references in formulas
Use Microsoft Help examples and demos
Use relative cell references in formulas
Use Undo and Redo
Extended Skills
Center text across columns
Create an Average function
Create spreadsheet without detailed guidance
Sort data
Use brackets to control order of operation in formula
Use File, Page Setup command to alter worksheet appearance
Use the Chart Wizard to create a chart
Use the Sum function
LearnPro: Applying Excel 2000 (continued)
Course content
Case 1: Initial Exploration
Group Session
Case 2: Marketing Analysis
Case 3: Office Expense Sheet
Case 4: Vehicle Mileage Log
Case 5: Assessing Average Sales
Case 6: Production Schedule
Case 7: Sales Analysis
Case 8: Weekly Income Schedule
Case 9: Feasibility Study
Case 10: Charting Budgets
Case 11: Creating and Sorting a Database
Case 12: Sorting Records
Case 13: What-If Analysis