Excel: Spreadsheet Design: Concepts, Formulas, & Formatting

During this three hour workshop the student will develop a more in-depth idea of how to design the spreadsheet and work with the common formulas and incorporate new formulas and values.

• Spreadsheet design concepts
• Common formulas
• Formatting techniques
• Incorporating other formulas and values
• Absolute/Relevant References
• Working with ranges

During this fast paced class, the student will begin by learning design components, progress to incorporating some of the common formulas, then other formulas and values will be experimented with. Learn how to work efficiently with large amounts of text and ranges of data by selecting and manipulating ranges. Change the appearance of your worksheet data by using a variety of formatting techniques.

Class targeted to:
Students needing the skills to design workable spreadsheets, use formulas, work with ranges, and important formatting techniques.

Prerequisites:
Windows: Introduction and a basic working knowledge of Excel.