Excel 2003 Bible
by John Walkenbach (J-Walk and Associates, Inc., San Diego, CA )Format: eBook
Pub. Date: 2008-12-01
Publisher(s): Wiley
Availability: This title is currently not available.
Other versions by this Author
List Price: $43.21
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
Summary
The most comprehensive guidebook available on the most popular spreadsheet program, fully updated to include all-new "X" features Written by the leading Excel guru known as "Mr. Spreadsheet," John Walkenbach, who has written more than thirty books and 300 articles on related topics and maintains the popular Spreadsheet Page at www.j-walk.com/ss The definitive reference book for beginning to advanced users, featuring expert advice and hundreds of examples, tips, techniques, shortcuts, work-arounds, and more Covers expanded use of XML and Web services to facilitate data reporting, analysis, importing, and exporting information Explores Excel programming for those who want advanced information CD-ROM includes all templates and worksheets used in the book, as well as sample chapters from all Wiley Office "X" related Bibles and useful third party software, including John Walkenbach's Power Utility Pak
Table of Contents
| Preface | |
| Getting Started with Excel | |
| Introducing Excel | |
| Entering and Editing Worksheet Data | |
| Essential Worksheet Operations | |
| Working with Cells and Ranges | |
| Worksheet Formatting | |
| Understanding Files and Templates | |
| Printing Your Work | |
| Working with Formulas and Functions | |
| Introducing Formulas and Functions | |
| Creating Formulas That Manipulate Text | |
| Working with Dates and Times | |
| Creating Formulas That Count and Sum | |
| Creating Formulas That Look Up Values | |
| Creating Formulas for Financial Applications | |
| Introducing Array Formulas | |
| Performing Magic with Array Formulas | |
| Creating Charts and Graphics | |
| Getting Started Making Charts | |
| Learning Advanced Charting | |
| Enhancing Your Work with Pictures and Drawings | |
| Analyzing Data with Excel | |
| Working with Lists | |
| Using External Database Files | |
| Analyzing Data with Pivot Tables | |
| Performing Spreadsheet What-If Analysis | |
| Analyzing Data Using Goal Seek and Solver | |
| Analyzing Data with the Analysis ToolPak | |
| Using Advanced Excel Features | |
| Using Custom Number Formats | |
| Customizing Toolbars and Menus | |
| Using Conditional Formatting and Data Validation | |
| Creating and Using Worksheet Outlines | |
| Linking and Consolidating Worksheets | |
| Excel and the Internet | |
| Sharing Data with Other Applications | |
| Using Excel in a Workgroup | |
| Making Your Worksheets Error-Free | |
| Programming Excel with VBA | |
| Introducing Visual Basic for Applications | |
| Creating Custom Worksheet Functions | |
| Creating UserForms | |
| Using UserForm Controls in a Worksheet | |
| Working with Excel Events | |
| VBA Examples | |
| Creating Custom Excel Add-Ins | |
| Appendixes | |
| Worksheet Function Reference | |
| What's on the CD-ROM | |
| Just for Fun | |
| Additional Excel Resources | |
| Excel Shortcut Keys | |
| Index | |
| End-User License Agreement | |
| Table of Contents provided by Publisher. 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.