or
Sign in to turn on 1-Click ordering.
or
Amazon Prime free trial required. Sign up when you check out. Learn more
More Buying Choices
Have one to sell? Sell yours here
Excel 2002 Formulas (Professional Mindware)
 
 
Tell the Publisher!
I’d like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Excel 2002 Formulas (Professional Mindware) [Paperback]

John Walkenbach
4.7 out of 5 stars  See all reviews (3 customer reviews)
RRP: £29.99
Price: £25.49 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £4.50 (15%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.
Only 1 left in stock--order soon (more on the way).
Want guaranteed delivery by Tuesday, February 14? Choose Express delivery at checkout. See Details
Amazon.co.uk Trade-In Store
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 Amazon.co.uk Trade-In Store for more details.

Frequently Bought Together

Customers buy this book with Microsoft Excel 2002 Bible £23.76

Excel 2002 Formulas (Professional Mindware) + Microsoft Excel 2002 Bible
Price For Both: £49.25

Show availability and delivery details

  • This item: Excel 2002 Formulas (Professional Mindware)

    In stock.
    Dispatched from and sold by Amazon.co.uk.
    This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions

  • Microsoft Excel 2002 Bible

    In stock.
    Dispatched from and sold by Amazon.co.uk.
    This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions


Customers Who Bought This Item Also Bought


Product details

  • Paperback: 860 pages
  • Publisher: John Wiley & Sons; Pap/Cdr edition (15 Sep 2001)
  • Language English
  • ISBN-10: 076454800X
  • ISBN-13: 978-0764548000
  • Product Dimensions: 23.4 x 18.8 x 4.8 cm
  • Average Customer Review: 4.7 out of 5 stars  See all reviews (3 customer reviews)
  • Amazon Bestsellers Rank: 406,615 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

John Walkenbach
Discover books, learn about writers, and more.

Visit Amazon's John Walkenbach Page

Product Description

Product Description

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.

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

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
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Tag this product

 (What's this?)
Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items.
Your tags: Add your first tag
 

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

3 Reviews
5 star:
 (2)
4 star:
 (1)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
4.7 out of 5 stars (3 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

25 of 25 people found the following review helpful:
5.0 out of 5 stars Make Space On Your Bookshelf!, 15 Feb 2003
By 
P. Joyce (UK) - See all my reviews
(REAL NAME)   
This review is from: Excel 2002 Formulas (Professional Mindware) (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.

6 - Developing Custom Worksheet Functions
A brief part covering the wonders of VBA, from the basics of VBA and programming concepts, to a variety of custom function examples.

An essential purchase. This book showed me some really interesting ways to put the things I'd previously learnt into practice. Could be a problem for a complete beginner, but an ideal companion for the intermediate Excel user, or for the beginner who sticks his neck out a little.

Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


27 of 28 people found the following review helpful:
5.0 out of 5 stars 'Excel'lent Reference, 9 Oct 2002
By 
Kenneth Wright (UK) - See all my reviews
(REAL NAME)   
This review is from: Excel 2002 Formulas (Professional Mindware) (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. Everything I wanted to learn has been presented in a logical and easy to understand manner, and for anyone else hoping to take their knowledge of Excel and it's capabilities to the next level, I would have no hesitation in recommending this book.

Put it on your Xmas list, or if no-one is going to buy you any presents then beg or borrow the money to get it, but just BUY IT!!

Regards
Ken.............

Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


5 of 5 people found the following review helpful:
4.0 out of 5 stars Good!, 25 Oct 2003
By 
Mr. Hm Bennett "howardbennett3" (London) - See all my reviews
(VINE VOICE)    (TOP 1000 REVIEWER)    (REAL NAME)   
This review is from: Excel 2002 Formulas (Professional Mindware) (Paperback)
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.

Thanks John

Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Share your thoughts with other customers: Create your own review
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
 
 
Only search this product's reviews



Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Listmania!

Create a Listmania! list

Look for similar items by category


Look for similar items by subject


Feedback


Amazon.co.uk Privacy Statement Amazon.co.uk Delivery Information Amazon.co.uk Returns & Exchanges