Microsoft Excel 97 : Power Toolkit
by Tucker, ScottFormat: Paperback
Pub. Date: 2000-04-01
Publisher(s): Iuniverse Inc
Other versions by this Author
List Price: $49.95
Buy New
Usually Ships in 2-3 Business Days
$49.90
Rent Textbook
Select for Price
Used Textbook
We're Sorry
Sold Out
eTextbook
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.
Author Biography
Lisa A. Bucki, a freelance author and publishing consultant, also developed an interactive CD series on Office products. Among her many computer book credits is Managing with Microsoft Project. Jim Kinlan is president of KMT Software, Inc., and coauthor of the Winning Forms series. Scott Tucker, vice president of KMT's product development, is coauthor of numerous spreadsheet titles, including Inside Lotus 1-2-3 Macros.
Table of Contents
| Introduction | p. xxi |
| Introducing Excel 97 | p. 1 |
| Overview of New Features and Features Geared for Power Users | p. 2 |
| A Brief Tour of Excel 97 | p. 6 |
| Onscreen Changes | p. 10 |
| Faster, Smarter Data Entry | p. 12 |
| Setting Excel 97 Options | p. 25 |
| View | p. 27 |
| Calculation | p. 29 |
| Edit | p. 33 |
| General | p. 35 |
| Transition | p. 38 |
| Custom Lists | p. 40 |
| Chart | p. 42 |
| Color | p. 43 |
| Power Formatting | p. 47 |
| Workaday Formatting | p. 48 |
| Merging Cells | p. 48 |
| Indenting Text in Cells | p. 55 |
| Rotating Text in Cells | p. 59 |
| Borders Changes | p. 63 |
| Drawing Tool Updates: OfficeArt | p. 68 |
| Adding a Worksheet Background | p. 86 |
| Adding a Watermark | p. 88 |
| Creating and Using Styles | p. 92 |
| Conditional Formatting | p. 95 |
| Defining Conditional Formats | p. 96 |
| Finding, Changing and Removing Conditional Formatting | p. 102 |
| Data Validation | p. 104 |
| Validation Examples | p. 108 |
| Finding, Changing and Removing Validation | p. 111 |
| Working With Page Breaks | p. 111 |
| Charting Improvements | p. 114 |
| Easier Access to Chart Commands | p. 114 |
| New Chart Types | p. 114 |
| More Information | p. 117 |
| Easier Access to Parts of Charts | p. 119 |
| Sharing Workbooks | p. 123 |
| Hiding and Revealing Data | p. 124 |
| Data Protection | p. 128 |
| Adding and Removing Simple Password Protection | p. 128 |
| Protecting and Unprotecting Elements of a Worksheet | p. 131 |
| Unlocking Cells and Hiding Formulas | p. 132 |
| Protecting and Unprotecting Workbook Elements | p. 135 |
| Virus Checking | p. 137 |
| Working With Comments | p. 139 |
| Inserting and Editing Comments | p. 139 |
| Selecting Comments | p. 141 |
| Comments From Different Users | p. 142 |
| Creating Better-Looking Comments | p. 143 |
| Printing Comments | p. 147 |
| Hiding and Showing Comments | p. 148 |
| Deleting a Comment | p. 149 |
| Sharing Workbooks and Tracking User Changes | p. 149 |
| Accessing a Shared Workbook | p. 150 |
| Tracking User Changes | p. 151 |
| Using Tools I Share Workbook | p. 154 |
| Preventing Others From Removing Sharing or the Change History | p. 158 |
| Reviewing and Merging Changes | p. 159 |
| Viewing the Change History in a Separate Worksheet | p. 162 |
| Removing Sharing | p. 163 |
| E-Mailing and Routing | p. 164 |
| Macros | p. 171 |
| This Is Not a Programming Book | p. 172 |
| Recording Macros | p. 173 |
| Running a Macro | p. 178 |
| Changing Macro Options | p. 179 |
| Deleting a Macro | p. 180 |
| Editing an Existing Macro | p. 180 |
| Installing Help for VBA | p. 184 |
| Writing Basic VBA Macros | p. 184 |
| Key Concepts | p. 185 |
| The Object Browser | p. 187 |
| Writing a Macro | p. 189 |
| The Stock Example | p. 191 |
| Toggling With If... Then... Else... | p. 201 |
| Saving Typing: With and End With | p. 201 |
| Using Variables | p. 202 |
| Creating Your Own Functions | p. 203 |
| Developing Onscreen Tools | p. 207 |
| Assigning Macros to Onscreen Objects | p. 208 |
| Customizing Toolbars | p. 211 |
| Adding a Toolbar Button | p. 211 |
| Adjusting the Button Display | p. 217 |
| Deleting and Moving Buttons | p. 221 |
| Making Your Own Toolbar | p. 222 |
| Customizing Menus | p. 224 |
| Adding, Moving and Deleting Menu Commands | p. 225 |
| Adjusting the Command Display | p. 229 |
| Adding a New Menu | p. 231 |
| Creating a Menu Bar (Actually, a Toolbar) | p. 232 |
| Resetting a Toolbar, Menu Bar, or Menu | p. 233 |
| Keyboard Shortcuts for Editing a Toolbar | p. 234 |
| Saving an Onscreen Toolbar Configuration | p. 234 |
| Saving a Toolbar or Menu Bar With a Workbook or Template | p. 235 |
| Auto_Open Macros and Toolbars | p. 238 |
| Controlling Toolbars in VBA | p. 239 |
| Using Excel's Form Features | p. 241 |
| Using Forms | p. 242 |
| Printed Forms | p. 242 |
| What We Mean by "Online" Forms | p. 243 |
| Forms as Templates | p. 243 |
| Distributing Form Files and Templates | p. 244 |
| Basic Fill-In Forms | p. 244 |
| Adding Field Names and Blanks | p. 244 |
| Spruce Up the Form With Formatting | p. 246 |
| Protection Makes the Form Easier to Use | p. 248 |
| Beefing Up Fill-In Forms | p. 250 |
| Backgrounds and Graphics | p. 250 |
| Formulas | p. 253 |
| User Guidance: Comments and Validation | p. 254 |
| Print Settings | p. 258 |
| Forms With Power--Adding Controls | p. 258 |
| Forms Versus ActiveX: Which to Choose? | p. 259 |
| Using the Forms Toolbar | p. 260 |
| Adding ActiveX Controls With the Control Toolbar | p. 270 |
| Creating UserForms (Dialog Boxes) With VBA | p. 278 |
| Creating a Dialog Box in the Visual Basic Editor | p. 279 |
| Displaying the Dialog Box | p. 293 |
| Working With Excel Templates | p. 295 |
| Excel 97 Templates | p. 296 |
| Excel Template Advantages | p. 296 |
| Creating a Workbook Based on a Template | p. 297 |
| Using Custom Setup to Access Other Templates | p. 301 |
| Opening and Editing an Excel Template | p. 302 |
| Installing the Templates from the Companion CD-ROM | p. 304 |
| Opening the CD Templates | p. 306 |
| Overview of Features in the Ventana Sampler Templates | p. 309 |
| Examining the Template Toolbar | p. 309 |
| Entering Data in the Sample Templates | p. 311 |
| Viewing Example Data in the Template | p. 312 |
| Modifying an Example Template | p. 314 |
| Understanding Formulas in the Ventana Sample Templates | p. 314 |
| Entering Percentages, Dates and Tax Rates | p. 316 |
| Entering Percentages | p. 316 |
| Entering Dates in Calendar Templates | p. 317 |
| Entering Dates in Other Sample Templates | p. 317 |
| Entering Tax Rates | p. 319 |
| Printing Example Templates | p. 319 |
| Previewing Your Work | p. 320 |
| Printing the Template With the Highlights On | p. 321 |
| Printing the Template Without the Footer | p. 321 |
| Using the Template Help System | p. 321 |
| Saving Your Work | p. 322 |
| Templates Included in the Ventana Sampler Folder | p. 323 |
| Building Your Own Templates | p. 357 |
| Settings Saved in a Template | p. 357 |
| Getting Started | p. 358 |
| Creating a Workbook Template | p. 358 |
| Creating a Worksheet Template | p. 360 |
| Editing a Template | p. 362 |
| Creating a Template That Tracks Data | p. 363 |
| Creating More Advanced Templates | p. 368 |
| The Template Master Toolkit | p. 369 |
| Installing the Toolkit | p. 369 |
| Contents of the Toolkit | p. 370 |
| How to Use the Toolkit | p. 370 |
| The KMT Template File: Functional Overview | p. 370 |
| Variables | p. 371 |
| Modulel | p. 372 |
| Dialogl | p. 373 |
| Sheet Layout: Achieving the 3D Effect | p. 374 |
| Protection and Unprotected Cells | p. 375 |
| Formula Logic and Transition Options | p. 375 |
| Monthly Calendar Formulas | p. 376 |
| Range Names and Scenarios | p. 376 |
| The Toolbar | p. 378 |
| Step-by-Step Template Creation Tutorial | p. 379 |
| VBA Code | p. 384 |
| KMT Tools (tools.xls) | p. 406 |
| Cross-Platform Issues | p. 407 |
| Adding Tools to the Toolbar | p. 407 |
| Creating Help Files | p. 409 |
| Installation Process | p. 410 |
| Sharing Data With OLE | p. 411 |
| Linking and Embedding in Excel 97 and Office 97 | p. 412 |
| Source and Destination | p. 413 |
| DDE Versus OLE | p. 414 |
| Working With Embedded Objects | p. 415 |
| Embedding an Object With Excel | p. 416 |
| Editing the Embedded Information | p. 425 |
| Using VBA to Share Data Between Applications | p. 429 |
| Linking Data in Excel | p. 435 |
| Linking With Paste Special | p. 436 |
| Creating Linking Formulas | p. 438 |
| Linking Cell Pictures | p. 440 |
| Dragging Between Files and Applications to Link and Embed | p. 441 |
| Information Hyperlinking | p. 445 |
| Adjusting a Linked Object | p. 448 |
| Updating the Linked Information | p. 448 |
| Making a Link Manual Only | p. 449 |
| Changing the Source Information | p. 450 |
| Formatting an Object | p. 451 |
| Working With the Business Plan Template | p. 452 |
| Locating and Loading the Business Plan Files | p. 453 |
| Working With the Business Plan Files | p. 453 |
| The Business Plan Features | p. 456 |
| Working With Add-Ins | p. 463 |
| What Add-Ins Are | p. 463 |
| Reviewing the Add-Ins That Come With Excel | p. 464 |
| Loading and Unloading an Add-In | p. 468 |
| Using a Loaded Add-In | p. 470 |
| Other Add-Ins | p. 474 |
| Finding Add-Ins | p. 475 |
| Installing a Third-Party Add-In | p. 476 |
| Removing an Add-In | p. 477 |
| Creating an Add-In | p. 478 |
| Plan and Create the Features | p. 478 |
| Protect the VBA Code | p. 481 |
| Add a Description and Save the Add-In | p. 483 |
| Working with Excel VBA Examples | p. 487 |
| The Ultimate Financial Calculator | p. 488 |
| Working With the Ultimate Financial Calculator | p. 489 |
| Using the Template Toolbar | p. 492 |
| Exploring the Calculator Code | p. 493 |
| The Visual Almanac | p. 510 |
| Sample Charts | p. 512 |
| How to Chart User-Defined Data | p. 514 |
| Exploring the Visual Almanac Code | p. 516 |
| Excel Online | p. 529 |
| Web and Intranet Overview | p. 530 |
| Your Connection | p. 531 |
| Internet Explorer 3.0.1 | p. 533 |
| Browsing Web Information | p. 533 |
| Help Menu | p. 534 |
| In Dialong Boxes | p. 535 |
| With the Web Toolbar | p. 537 |
| Opening a File From an Internet or Intranet Location | p. 540 |
| Working More Easily With FTP | p. 544 |
| Building Hyperlinks | p. 547 |
| Preparing to Publish | p. 552 |
| Methods for Publishing Excel Information to the Web | p. 553 |
| Using the Internet Assistant Wizard | p. 553 |
| Using the Web Form Wizard | p. 561 |
| Extra Stuff | p. 570 |
| Maximizing Effectiveness With Key Power Features | p. 573 |
| Creating Custom Views | p. 574 |
| Data Tables | p. 577 |
| Goal Seeking | p. 584 |
| Solver | p. 590 |
| Generating a Solver Report or Saving a Scenario | p. 597 |
| Saving and Loading a Model | p. 601 |
| Scenarios | p. 603 |
| Creating | p. 603 |
| Showing a Scenario on the Worksheet and Editing the Scenario | p. 605 |
| Summary Tables | p. 606 |
| Merging | p. 608 |
| Creating Custom Reports | p. 609 |
| Auditing | p. 611 |
| Map | p. 614 |
| High-End Data Features | p. 619 |
| Databases | p. 620 |
| Adding, Finding and Sorting Records | p. 621 |
| Filtering | p. 626 |
| Putting a Subtotal to Work | p. 632 |
| Group and Outline | p. 636 |
| Creating a PivotTable | p. 638 |
| Working With AccessLinks | p. 641 |
| Querying Data From Other Sources | p. 646 |
| Conclusion | p. 653 |
| Index | p. 655 |
| Table of Contents provided by Syndetics. 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.