TY - BOOK AU - Shelly,Gary B. AU - Cashman, Thomas J. AU - Pratt, Philip J. AU - Last, Mary Z. TI - Microsoft excel 2002: comprehensive concepts and techniques T2 - 10 minute guide SN - 0789562790 [hardbound] PY - 2002/// CY - Australia PB - Thomson/Course Technology KW - Microsoft Excel (Computer file) KW - Business KW - Computer programs KW - Electronic spreadsheets N1 - Includes appendices and index; Contents: Project One Creating a worksheet and embedded chart -- Project Two Formulas, functions, formatting, and web queries -- Project Three What-if analysis, charting, and working with large worksheets -- Web feature -- Project Four Financial functions, data tables, amortization schedules, and hyperlinks -- Project Five Creating, sorting, and querying a worksheet database -- Project Six Creating templates and working with multiple worksheets and workbooks -- Integration feature -- Project Seven Using macros and visual basic for application (VBA) with excel -- Project Eight Formula auditing, data validation, and complex problem solving -- Project Nine Importing data, routing changes, pivotcharts, pivottables, and trendlines -- Web feature ER -