Special Edition Using Microsoft Office Excel 2003
by Blattner, PatrickEdition: 1st
Format: Paperback
Pub. Date: 2003-09-11
Publisher(s): Que Publishing
Other versions by this Author
List Price: $48.62
Rent Book
Select for Price
New Book
We're Sorry
Sold Out
Used Book
We're Sorry
Sold Out
eBook
We're Sorry
Not Available
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
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. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.