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 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.
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.
{"itemData":[{"priceBreaksMAP":null,"buyingPrice":23.34,"ASIN":"076454800X","isPreorder":0},{"priceBreaksMAP":null,"buyingPrice":34.06,"ASIN":"0764547992","isPreorder":0}],"shippingId":"076454800X::KSu6LlOW8Ad%2F7O4kAUsizIpj9MbfmKiPFY2ZomiHGzyg2BT%2BdJaUcqr3kIFD1fyWakBfckZHhVe20kQy5E00Jowg1FjlmLJU,0764547992::Z97Apeg7tmxhaRppZq14DVjTwQn5as69Mi3iSZHIdNQxINwY8ZkBJzHm1EbZvQbNeUsSS7WzM6Yz0uqNUig3wSH30b%2FT1DWt","sprites":{"addToWishlist":["wl_one","wl_two","wl_three"],"addToCart":["s_addToCart","s_addBothToCart","s_add3ToCart"],"preorder":["s_preorderThis","s_preorderBoth","s_preorderAll3"]},"currenyCode":"GBP","shippingDetails":{"xy":"availability"},"tags":["x","y","z"],"strings":{"showDetails":"Show details","addToWishlist":[null,null,null],"shippingError":"An error occurred, please try again","differentAvailability":"One of these items is dispatched sooner than the other.","preorder":["Pre-order this item","Pre-order both items","Pre-order all three items"],"addToCart":["Add to Basket","Add both to Basket","Add all three to Cart"],"showDetailsDefault":"Show availability and delivery details","priceLabel":["Price:","Price For Both:","Price For All Three:"],"hideDetailsDefault":"Hide availability and delivery details","hideDetails":"Hide details"}}
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.
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.
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!!
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.