CEC Teachers

Editor Log-in

C E C Middle College
2650 Eliot St.
Denver CO 80211
Ph: 720 - 423 - 6600
Fax: 720 - 423 - 6604
TTY: 720 - 423 - 6643

Microsoft Excel Syllabus

LEARNING MICROSOFT EXCEL XP

Table of Contents

EX 1.01

EX 1.02

EX 1.03

EX 1.04

Ex 1.05

EX 1.06

EX 1.01  Introduction to Spreadsheets

You will be able to:

1. Identify and describe an electronic spreadsheet.

2. Understand the purpose of an electronic spreadsheet.

3. Provide an overview of Excel's capabilities.

4. Explore the worksheet using the mouse and keyboard.

5. Enter labels and make corrections.

6. Save and close a workbook.

What you will use:

"Learning Microsoft Office XP"

What you will do:

1. Obtain "Learning Microsoft Office XP" workbook and read pages 175-178,

practicing as requested. Complete the Exercise on page 179.

2. Obtain "Learning Microsoft Office XP" workbook and read pages 181-184. Create

the spreadsheet on page 185. Show the spreadsheet to your instructor when you

are finished.

3. Obtain "Learning Microsoft Office XP" workbook and read pages 187-189.

Complete the exercise on page 190. Show the spreadsheet to your instructor when

you are finished.

4. Obtain "Learning Microsoft Office XP" workbook and read pages 192-195.

Complete the exercise on page 196. Show the spreadsheet to your instructor when

you are finished.

EX 1.02 Entering Formulas and Formatting a Worksheet

You will be able to:

1. Create a worksheet by entering labels, numeric labels, and values.

2. Make worksheet corrections.

3. Enter formulas.

4. Format data.

5. Print a worksheet.

6. Use worksheet ranges.

What you will use:

"Learning Microsoft Office XP"

What you will do:

1. Obtain "Learning Microsoft Office XP" workbook and read pages 198-199.

Complete the Exercise on page 199.

2. Obtain "Learning Microsoft Office XP" workbook and read pages 203-204. Create

the spreadsheet on page 205. Show the spreadsheet to your instructor when you

are finished.

3. Obtain "Learning Microsoft Office XP" workbook and read pages 206-208.

Complete the exercise on page 209. Show the spreadsheet to your instructor when

you are finished.

4. Obtain "Learning Microsoft Office XP" workbook and read pages 211-212.

Complete the exercise on page 213. Print the worksheet

EX 1.03 Using Functions and Formulas

You will be able to:

1.         Copy a formula using an absolute reference.

2.         Use functions.

3.         Use page setup to control the print output.

4.         Insert automatic page breaks into a worksheet.

5.         Insert page breaks, headers, and footers.

What you will use:

"Learning Microsoft Office XP"

What you will do:

1.         Obtain "Learning Microsoft Office XP" workbook and read pages

215-216. Complete the exercise on page 217. Print the worksheet.

2. Obtain "Learning Microsoft Office XP" workbook and read pages 219-220.

Complete the exercise on page 221. Print the worksheet.

3. Obtain "Learning Microsoft Office XP" workbook and read pages 225-228.

Complete the exercise on page 229. Print the worksheet.

4. Obtain "Learning Microsoft Office XP" workbook and read pages 231-232.

Complete the exercise on page 233. Print the worksheet.

5. Obtain "Learning Microsoft Office XP" workbook and read pages 235-236.

Complete the exercise on page 237. Print the worksheet.

EX 1.04 Creating Charts

You will be able to:

1.         Create column, line, pie, and combination charts.

2.         Change a chart type and subtype.

3.         Select and size embedded charts.

4.         Delete an embedded chart.

5.         Enable chart editing.

6.         Edit chart text.

7.         Change legend position.

What you will use:

"Learning Microsoft Office XP"

What you will do:

1. Obtain "Learning Microsoft Office XP" and read pages 245-248.  Complete the

exercise on page 249.

2. Read pages 251-253. Complete Exercise on page 254.

EX1.05 Advanced Formatting

You will be able to:

1.         Create a series.

2.         Insert and delete columns and rows.

3.         Move and copy data.

4.         Transpose data.

5.         Freeze a worksheet.

What you will use:

"Learning Microsoft Office XP"

What you will do:

1.         Obtain "Learning Microsoft Office XP" workbook and read pages

258-260. Complete the exercise on page 261. Print the worksheet.

2. Obtain "Learning Microsoft Office XP" workbook and read pages 264-265.

Complete the exercise on page 266. Print the worksheet.

3. Obtain "Learning Microsoft Office XP" workbook and read pages 268-269.

Complete the exercise on page 270. Print the worksheet.

4. Obtain "Learning Microsoft Office XP" workbook and read pages 273-274.

Complete the exercise on page 274. Print the worksheet.

5. Obtain "Learning Microsoft Office XP" workbook and read pages 276-277.

Complete the exercise on page 278. Print the worksheet.

EX 1.06 Advanced Formatting

You will be able to:

1.         Use workbook sheets.

2.         Use named ranges.

3.         Extract and combine data.

What you will use:

“Learning Microsoft Office XP”

What you will do:

1. Obtain "Learning Microsoft Office XP" workbook and read pages 280-281.

Complete the exercise on page 282. Print the worksheet.

2. Obtain "Learning Microsoft Office XP" workbook and read pages 284-285.

Complete the exercise on page 286. Print the worksheet

Congratulations! You've completed Microsoft Excel.

Lorraine Smith