Spreadsheet Fundamentals

Course description:
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 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 calculation with formulas and functions. In a final lesson, students create hyperlinks in a worksheet, save worksheets and workbooks as a Web pages, send workbooks via e-mail, and add comments to workbook sheets.
Course duration: 12 Hours

Course Details:

Preface
LESSON 1	Learning Worksheet Fundamentals
LESSON 2	Editing and Formatting Worksheets
LESSON 3	Formatting Cells
LESSON 4	Changing Print Options
LESSON 5	Working with Rows, Columns, Worksheets, and Workbooks
LESSON 6	Working with Charts
LESSON 7	Performing Basic Calculations
LESSON 8	Using Basic Financial and Logical Functions
LESSON 9	Using Spreadsheets with the Internet
Appendix	Excel 2002 Core Microsoft Office Specialist Exam Objectives

back