Would you like to be able to create spreadsheets that are both functional and interactive?

This 2-hour webcast will present students with specific situations requiring data collection via spreadsheets, and illustrates how to make reusable spreadsheets that are an interactive experience by integrating data parameters, validation, and feedback mechanisms that help both the data collector and the data reviewer complete their tasks more effectively.

Who Should Attend
Practitioners wanting a more powerful approach to using Excel.

Topics Covered

• The concept of interactivity in spreadsheets
• Why interactive spreadsheets are needed
• Excel functions such as SUMIF, VLOOKUP, etc.
• Conditional formatting in Excel
• How to leverage Excel’s functions and features to create a more powerful approach to data capture

Learning Objectives

• Explain the need for interactivity and discuss design considerations
• Create an interactive spreadsheet

Level
Intermediate

Format
Live webcast

Instructional Method
Group: Internet-based

NASBA Field of Study
Specialized Knowledge and Applications (2 hours)

Program Prerequisites
A basic knowledge of MS-Excel is recommended. Note: Focus will be on MS-Excel 2007 (although the ideas being discussed will translate to previous versions).

Advance Preparation
None