Introduction to Excel
CIS 152B
2-day workshop, $215 +tax
9:00 am-4:00 pm
Utilizing
the LearnPro method of teaching, students will learn worksheet
basics as well as some use of three-dimensional workbooks (referencing
cells on multiple worksheets). After students complete this course, they
will understand the advantages of using an electronic spreadsheet over
a paper ledger, and create formulas with some of Excel's built-in functions.
Students will learn how to create and edit spreadsheets and charts and
use Excel's database functions. Students enrolling in this course should
understand the basic concepts involved in working with a personal computer.
Some of the skills developed in this course:
| Add cell borders | Familiarity with database environment |
| Adjust column width and row height | Familiarity with spreadsheet environment |
| Align cell contents | Insert and delete rows and columns |
| Apply character formats | Move around the worksheet |
| Center text across columns | Open, save (update), and/or close file |
| Change the worksheet's active cell | Preview printout |
| Clear the contents of a cell | Print a worksheet |
| Copy and paste data | Select cell and range of cells |
| Copy formulas using the Edit, Fill command | Sort data |
| Create an Average function | Use absolute cell references in formulas |
| Create formulas using AutoSum tool or SUM function | Use brackets to control order of operation in formula |
| Create new, blank workbook file | Use File, Page Setup command to alter worksheet appearance |
| Define and describe a spreadsheet | Use Microsoft Help examples and demos |
| Enter data into cell | Use relative cell references in formulas |
| Enter formulas | Use the Chart Wizard to create a chart |
| Enter labels and values | Use Undo and Redo Modify numeric formats |
| Familiarity with chart environment |
 |
|
 |
|
 |
|