Spreadsheet Fundamentals

Spreadsheet Fundamentals teaches the basics of spreadsheet concepts, which includes creating worksheets, editing data, building charts, and publishing a spreadsheet to the Web. In early lessons, students create, edit, and print worksheets, soon learning to format rows, columns, and cells. They gain expertise with margins, page breaks, and various print options. They learn to hide and unhide data, add and delete worksheets in a workbook, create a three-dimensional formula, and link workbooks. Students then create, edit, format, revise, and print charts. In later lessons, they perform basic Excel calculations with formulas and functions. In a final lesson, students create hyperlinks in a worksheet, save worksheets and workbooks as Web pages, send workbooks via e-mail, and add comments to workbook sheets.

Student Learning Material

• Learning Worksheet Fundamentals (430KB)
• Editing and Formatting Worksheets (277KB)
• Formatting Cells (245KB)
• Changing Print Options (166KB)
• Working with Rows, Columns (887KB)
• Working with Charts (455KB)
• Performing Basic Calculations (215KB)
• Using Basic Financial and Logical Functions (138KB)
• Using Spreadsheets with the Internet (344KB)

Instructor Teaching Material

• Learning Worksheet Fundamentals (84.8KB)
• Editing and Formatting Worksheets (101KB)
• Formatting Cells (100KB)
• Changing Print Options (75.2KB)
• Working with Rows, Columns (78.7KB)
• Working with Charts (91.5KB)
• Performing Basic Calculations (86.8KB)
• Using Basic Financial and Logical Functions (69.4KB)
• Using Spreadsheets with the Internet (82.2KB)

Source: MSUP