If you'd rather place an order by talking to one of our cheerful order desk clerks, please call 1-888-232-4444 (USA and Canada only) or 250-383-6864. From Europe, ring our UK order desk clerk at local rate number 0845 230 9601 (UK only) or 44 (0)1865 722 113.

Excel Magic: Tips and Time Savers

by John H. Sweet

244 pages; quality trade paperback (softcover); catalogue #01-0531; ISBN 1-55369-129-6; US$39.95, C$57.00, EUR37.10, £25.70

These tips and time savers will take beginning and intermediate Microsoft Excel users to another level of expertise.

Read more!

about the book      about the author      sample excerpts or Table of Contents      catalogue info

About the Book Existing technical books are too lengthy and dull to be suitable as references for beginning and intermediate Excel users. The author cuts through the clutter and provides precise, useful information users want and need. This Microsoft Excel book will take you to the next level and you to be quicker and more comfortable with Excel. When you reach that next level, you will also feel better about yourself! This book is designed to increase your productivity and self-esteem.

---

About the Author The author has taught public and corporate computer software classes for more than twelve years and has drawn from student feedback for this book. He knows which tips and time savers make a lasting impression on people and which do not. The ones that do are in this book.

---

Sample Excerpts

Preface - Note to the Reader

My sole criterion for the tips and time savers in this book was:

"How useful are they?"

I've taught public and corporate computer software classes for more than twelve years and have drawn from student feedback for this book. I know which tips and time savers make a lasting impression on people and which do not. The ones that do are in this book.

I always recommend taking the instructor-lead classes, but most people seem to reach a plateau after taking them. Frustration sets in. You ask yourself. Why am I so slow? Why do I have to ask someone for help? I know most of you won't go out and buy one of the very good, 50-pound books about Microsoft® Excel. Are they good? You bet. But I know that most corporate users of Excel don't buy them and won't read them.

This book will take you to the next level. I want you to be quicker and more comfortable with Excel. When you reach that next level, you will also feel better about yourself! My book is designed to increase your productivity and self-esteem. I hope it does both. If it does, then I've done my job.

This is not a reference book, but there is a detailed index, so you can research a situation.

You don't have to "read" this book from cover to cover, but I would recommend flipping through it page by page. The biggest problem with using today's software is, "You don't know what you don't know!" So - why don't you flip through the book - right now?
John H. Sweet

---

TABLE OF CONTENTS

Acknowledgements
Foreward
Preface - Note to the Reader

ONE
Easy & Quick Tips
Quick Chart
Navigating through Worksheets
Close All
Mouse Pointers Galore
Clear Contents vs Delete
Copying Formulas
Looking at Long Lists
Doing The Splits
Easy Data Entry

TWO
Goodies Galore
Name That Cell
Range Names
Remembering Cell Names
Answers in a Hurry!
Best Fit
Absolute References
Custom Lists
Fill Series

THREE
Fun Tips
Fonts are Fun
Rotate
Magic Feature
Too Many Pages
Default Font
Quick Max
Rapid Data Entry

FOUR
Good Stuff
Three-D References
Great Views
Formula Viewing
On the Internet
Remember Your Workspace

FIVE
Quick Navigation
Move to Open Workbooks
Going to a Cell
Quick Sheet Movement
Move or Copy a Worksheet
Outlining

SIX
Quick Create/Delete
New Workbook
Closing a Workbook
Quick New Worksheet
Easy Sheet Renaming
Deleting a Worksheet
Multiple Selections
Enter without Moving
Word Wrap
XLStart

SEVEN
Chart Tips
Quick Add
Default Chart
Two Chart Types
Printing Embedded Charts
3-D Series
Embedding the Data Labels
Picture Charts
Data Table

EIGHT
Graphics
Straight Line
Watch your Fill
Grouping
Graphical Hyperlinks

NINE
Formatting
Shadow Effects
Format Painter
Styles
AutoShape
Underline Tool
Stripes

TEN
Intermediate Stuff
Sorting by Month
Subtotals
Filtering
Mapping
Comments

ELEVEN
File Information
File Properties
Protecting Your Worksheet

TWELVE
Hot Function Tips
Instant Function Help
Controlling Excel Errors
VLOOKUP() Made Easy
TRUNCATE()
COUNTIF()

THIRTEEN
Auditor's Delight
Auditing Toolbar
More Auditing Shortcuts

Appendix A - Keyboard Shortcuts
Appendix B - Glossary
Appendix C - File Extensions
Index

*********************************************

---

Catalogue Information

---