Excel 2002 Formulas covers every aspect of formulas, including some unusual uses –– such as chart series and conditional formatting specifications. This book answers virtually all formula–related questions posed in Excel newsgroups on the Internet. Plus, it contains a coupon for Walkenbach′s Professional Power Utility Pak.
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Visit the Books Trade-In Store for more details. Special Offer until June 30, 2013: Receive an additional £5 promotional Gift Certificate, when you trade-in at least £10 worth of books. Learn more. |
Book Description
Frequently Bought Together
Product details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, and more.
Product Description
From the Back Cover
Excel 2002 Formulas Unleash the Power of Excel Formulas Now revised to cover the new features of Excel 2002 and expanded with two all–new chapters on financial formulas, this one–of–a–kind reference delivers all the tips and techniques you need to maximize one of the most powerful spreadsheet tools: formulas. With clear explanations of operators, nesting, and functions plus hundreds of practical, real–world examples, spreadsheet expert John Walkenbach shares proven solutions for typical (and not–so–typical) Excel challenges. From working with dates to performing table lookups to creating array formulas, this in–depth guide will help you supercharge your spreadsheets – and make the most of Excel. Your Road Map to High–Performance Excel Formulas ∗ Get a concise overview of Excel′s many features, including cell formatting, analysis tools, and protection options ∗ Master basic formula facts – including absolute vs. relative references, operators, error values, naming techniques, and more ∗ Get practical tips on using Excel′s worksheet functions in your formulas ∗ Find expanded coverage of discounting, depreciation, and other financial formulas ∗ Perform magic with powerful array formulas ∗ Use your formulas to enhance charts and pivot tables ∗ Debug formulas and take advantage of Excel′s auditing tools ∗ Develop custom worksheet functions with VBA Bonus CD–ROM Includes ∗ A trial version of the author′s award–winning Power Utility Pak 2000 ∗ A demo of the author′s Sound–Proof 2000 ∗ Example Excel workbooks from the book System Requirements Pentium PC with Windows 98 or greater; 32 MB RAM; Microsoft Excel 2002. See About the CD appendix for details and complete system requirements. www.mandtbooks.com
About the Author
John Walkenbach is a principal of JWalk and Associates, Inc., a consulting firm that specializes in spreadsheet application development, and is the author of more than two dozen books, including, most recently, Excel 2002 Bible and Excel 2002 Power Programming with VBA. He maintains "The Spreadsheet Page," a popular Web resource at www.j–walk.com/ss.
Inside This Book
(Learn More)
First Sentence
MICROSOFT EXCEL HAS BEEN REFERRED TO as "the best application ever written for Windows." Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
MICROSOFT EXCEL HAS BEEN REFERRED TO as "the best application ever written for Windows." Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Reviews
Most Helpful Customer Reviews
25 of 25 people found the following review helpful
By P. Joyce
Format:Paperback
This was the second Excel book I ever read, and the fourth Walkenbach one I own. In fact, all of my books are Walkenbach books, which says alot for the guy.
I moved onto this book from his Excel 2000 Bible, as I was eager to learn some tricks of the trade. Despite this being the Excel 2002 version of the book, the majority of it applied to Excel 97 upwards - any compatability issues where formulas contain Excel 2000 and Excel 2002 specific functions are clearly marked.
The book is divided into the following parts;
1 - Basic Information
This covers a basic description of Excel, facts about formulas, and using named ranges. Complete beginners may not find this enough - I'd suggest Walkenbach's excellent Excel Bible for them.
2 - Using Functions in your Formulas
Takes you through text manipulation, dealing with times and dates, counting and summing, lookups, databases and lists, and various other calculations - the 40 pages on dates and time alone are worth their weight in gold! Excellent stuff.
3 - Financial Formulas
Definitely not for the faint of heart - takes you through the usage of all the financial formulas that Excel has to offer.
4 - Array Formulas
A short part covering the capabilities of array formulas - far more useful than the coverage that array formulas received in the previous book I had read.
5 - Miscellaneous Formula Techniques
An excellent reference section where you can gain some great tips and techniques. Covers intentional circular references, charting techniques, pivot tables, conditional formatting, data validation, the creation of 'megaformulas', and various debugging methods when things go wrong.
27 of 28 people found the following review helpful
By Ken Wright
Format:Paperback
The words on the cover say it all - "Even if you already have a shelf full of Excel Reference books, be sure to squeeze in a couple of inches for this one". 100% Correct. Anyone that finds they are digging into the real power of excel through the use of the multitude of available functions and capabilities is going to benefit from this book. There are many reference books that will give you an introduction to a whole host of things that excel can do, but they usually restrict themselves to just a few examples of the main functions, along with some explanatory text. This book focuses on those functions, plus a whole lot more, and in many cases provides real life business examples of how those functions work. This helps enormously to be able to grasp the concept of just how useful they can be.
There are a number of chapters in the book that it would be worth buying the book for any of them alone eg:-
Chapter 4 - Introducing Worksheet Functions
Chapter 6 - Working with dates and times
Chapter 7 - Counting and Summing Techniques
Chapter 8 - Lookups
Chapter 14 - Introducing Arrays
Chapter 15 - Performing Magic with Array Formulas
Chapter 18 - Pivot Tables
There are also chapters devoted to Financial formulas that are priceless in a Finance environment where Excel is the dominant resource available to users.
If I sound over enthusiastic then tough, because I am not apologising for that. I have been using the microsoft excel newsgroups for a couple of months now, simply to try and improve my knowledge of Excel and it's capabilities. I have printed off and saved many many notes to trawl through at my leisure, but all I really needed to do was buy this book.
... Read more ›5 of 5 people found the following review helpful
By Mr. Hm Bennett
VINE™ VOICE
Format:Paperback|Amazon Verified Purchase
Nice book. I'm an IT teacher which makes me feel, in my arrogance, that certain things in this book could be improved.
Still, despite several years teaching, during several places in this book, I audibly exclaimed 'Of course!' as the simple way to do something I had done in a laborious, tiring way for years was explained.
Lets face it, he wrote it when others talked about it, is MR.EXCEL with the best blog on the market and this book contains, in one place or another, everything you could possibly want to know about Excel.
Very nice effort.
Still, despite several years teaching, during several places in this book, I audibly exclaimed 'Of course!' as the simple way to do something I had done in a laborious, tiring way for years was explained.
Lets face it, he wrote it when others talked about it, is MR.EXCEL with the best blog on the market and this book contains, in one place or another, everything you could possibly want to know about Excel.
Very nice effort.
Thanks John
By Highlander
Format:Paperback|Amazon Verified Purchase
The tips in this book are superb and even though versions change, I now know to go looking for things it used to do - fab!
Would you like to see more reviews about this item?
›
Go to Amazon.com to see all 18 reviews
4.7 out of 5 stars
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
