Microsoft Excel 97
Subtitle: complete concepts and techniques
By: Gary B. Shelly, Thomas J. Cashman, James S. Quasney
Contributors: Cashman, Thomas J.; Quasney, James S.
Series: Shelly Cashman series
Publisher: Course Technology
Published: 1997
Place of publication: Cambridge, Mass
Language: eng
ISBN-13: 9780789513410
Subjects: Microsoft Excel (Computer file); Electronic spreadsheets; Business; Computer programs
Description: [This book] is intended for a two-unit course that presentsMicrosoft Excel 97. No experience with a computer is assumed, and no mathematics beyond the high school freshman level is required. The objectives of this book are: To teach the fundamentals of Microsoft Excel 97; to help students demonstrate their proficiency in Microsoft Excel 97 and prepare them to pass the Proficient level Certified Microsoft Office User (CMOU) examination for Microsoft Excel 97; To foster appreciation of worksheets as a useful tool in the workplace [and] to give students an in-depth understanding of worksheet design, charting, what-if anlysis, Web queries, adding hyperlinks to a worksheet, saving worksheets as HTML files, worksheet database creation and manipulation, and object linking and embedding (OLE) -Pref.
Table of contents: title: Creating a worksheet and embedded chart; title: Forumlas, formatting, charts, and Web queries; title: What-if analysis and working with large worksheets; title: Creating templates, workbooks with multiple worksheets, and Web pages; title: Data tables, Visual Basic for applications, hyperlinks, and scenario manager; title: Sorting and filtering a worksheet database, pivot tables, and creating a data map.