Class Agenda – 10/30/2012

• Learning objectives and methods for Excel part of class.

• Demonstrate using Lynda.com for extra help with Excel.

• Describe worksheet structure.• Start design for Excel #1.

Learning Objectives Methods How

Understand when to use a spreadsheet

Class discussion and lecture In class

Be able to design a workbook

Practice designing individual worksheets & whole workbooks

In class & tutorials

Learn how to navigate through worksheets

Practice creating worksheets in tutorials & assignments.

Tutorials

Make functional and correct worksheets

Practice creating worksheets in tutorials & assignments.

Tutorials

Make pretty worksheets

Practice creating worksheets in tutorials & assignments

Tutorials & In class

Learn advanced Excel functions

Practice creating worksheets in assignments & in class

In class

All about spreadsheets

• What is a spreadsheet?

• What are the core competencies of spreadsheet products?

• Why are spreadsheets frequently used for “what-if” questions and what are “what-if” questions?

• What are three examples of personal and organizational applications that are appropriate for a spreadsheet?

• What is a “workbook” vs. a “worksheet” in Excel?

• What is the general structure of a worksheet?

The “Power” of a spreadsheet

• Formulas and functions.

• Copying, dragging. A powerful spreadsheet is designed to have draggable formulas and functions!

• Cell references Relative Absolute Mixed Named

Spreadsheet Design

• Input data; “What-if” scenario input.

• Calculation areas.

• Total areas.

• Charts.

Spreadsheet focus

• Spreadsheets are often a key tool in business decision making.

• Should help the person using the spreadsheet focus on what is important. Structure of sheet. Lines. Colors. Formatting. Conditional formatting.