Special Edition Using Microsoft Office Excel 2003

by Blattner, Patrick

• ISBN13: 9780789729538
• ISBN10: 0789729539
• Edition: 1st
• Format: Paperback
• Copyright: 2003-09-11
• Publisher: Que Publishing

Summary

bull; Geared for the power Excel user or the wannabe - a must have for users who live and die by the integrity of spreadsheet data. bull; See how it's done in real life - don't settle for lame pivot table and chart examples. bull; Provides more down and dirty help with formulas and functions than can be found in any other book!

Author Biography

Patrick Blattner is the author of three Que Excel books: Special Edition Using Excel 2000, Special Edition Using Excel 2002 and Microsoft Excel 2000 Functions in Practice. His articles have appeared in PC Computing and he has been a guest on TechTV's Call for Help. An Excel evangelist, he deals with real-world information problems daily. He has worked for some of America's most respected companies, including Disney and AOL Time Warner's CompuServe brand.

Table of Contents

Introduction	p. 1
Getting Started with Excel 2003
Getting Around Excel	p. 9
Spreadsheet Basics	p. 49
Editing Spreadsheets	p. 63
Formatting and Printing Excel Worksheets
Applying Number and Data Formats	p. 91
Formatting and Printing	p. 107
Using Formulas and Functions
Function Fundamentals	p. 159
Database Functions	p. 189
Date and Time Functions	p. 201
Engineering Functions	p. 215
Financial Functions	p. 233
Information Functions	p. 265
Logical Functions	p. 277
Lookup and Reference Functions	p. 285
Math and Trigonometry Functions	p. 303
Text Functions	p. 325
Statistical Functions	p. 343
Using Excel's Analysis Tools
Setting Up a List or Database in Excel	p. 385
Using Excel's Data-Management Features	p. 407
Outlining, Subtotaling, and Auditing Worksheet Data	p. 439
Creating and Modifying Charts
Building Charts with Excel	p. 465
Modifying Excel Charts	p. 505
Formatting Charts	p. 533
Professional Charting Techniques	p. 563
Using Excel in Business
Using PivotTables and PivotCharts	p. 607
Using Analysis Tools: Goal Seek, Solver, and Data Tables	p. 645
Using Excel in Business	p. 675
Customizing Excel to Fit Your Working Style	p. 703
Integrating Excel with Other Applications
Building Presentations with Excel	p. 733
Using Excel with Access and Other Databases	p. 755
Retrieving Data from OLAP Servers	p. 789
Recording and Editing a Macro	p. 809
Creating Interactive Excel Applications with VBA	p. 837
Appendix
What's on the CD	p. 879
Index	p. 887
Table of Contents provided by Blackwell. All Rights Reserved.