Databases Books

Many years ago I needed to learn ASP/ADO. I saw a lot of learning in front of me. But I was thrilled to find this book. It gave me the simple, clear explanations I needed to get rolling with ADO in short order. It's still one I keep handy, even thought I now use this technology to make my living. I have several big/thick ADO books, but this one is a quick reference that I still turn to often, as well as highly recommend to ADO (database connectivity) newbies for both web and Microsoft Office linking.

An excellent reference for the novise to advanced programmer. If you need a good overview of how to connect to a SQL Server or Access DB using VB, then you have got to get this book!

This was a very good book but it was not perfect. The code contained some coding errors, but what was worst was that I could not establish an internet connection to Rob's SQL server. Due to the connection problem I could not run those examples, which comprised about a third of the book. I e-mailed Rob, but Rob apparently is too good for his readers to reply back to. I would have given the book 5 stars if it weren't for these problems. The book certainly was not for beginners as it rightly claims. I actually had to read it twice. Any coding errors I was able to solve with some work. The book does offer a lot to learn though.

I bought this book looking for an introduction to ADO and DB programming in general with no prior ADO experience. I read the first 4 chapters for an introduction, and I have used the rest of the book for information on how to complete specific tasks. I have successfully created ADO applications using VB, Access, and ASP, using this book and online help as references. This is probably not the most complete book available for ADO programming, but if you have not used ADO in the past, you will not find a better introduction than this book!

This book is genuinely about ADO Programming without self promotion. Rob starts his book with the basic elements that lead up to ADO technology and steps up to very sophisticated programming procedures/techniques using ADO with Sql Server, MS Access 2000, Excel 2000, ASP and the Web in a very efficient and easy to understand manner. Of the features which set this book apart from others are the numerous runtime examples on Rob's website of procedures using ADO within VB/ASP scripts, and also the companion cd which includes all the of the programming code for each of the ADO examples on the website and all of the examples in the book. The information contained in this book has significantly enhanced my understanding of and coding abilities with ADO in a very short period of time, particularly in the web environment. I would highly recommend this book to any serious developer of data processing applications using ADO technology; especially for web applications.

Hey they are right; it covers Oracle 7 perfectly but there is Oracle 8 and now Oracle 8i. But for the basics, well this is a great starter. It will explain how to tune Oracle and why; after that get another and explore

When I used to work at Oracle, these books were our bibles. I had to learn a great deal about Oracle in a very short time (I knew extremely little about technology, and didn't know a database from a ring ding). These books are remarkably thorough, and go into a lot of detail. The added benefit is that they are extremely widely read by Oracle developers (both working for Oracle and not), that they get TONS of feedback, so any inaccuracies, development or new ideas/tricks get back to the publisher and often get incorporated in new editions. The Oracle series is general is a great foundation to start with for Oracle knowledge. The thick white Oracle PL/SQL guide is also extremely good, and comes with the server software. I believe that it is more easily available in soft copy, as Oracle is trying to limit the documentation that they distribute with their software.

This book offered a complete look at high performance computing for an Oracle7 database. It covers everything about Oracle7 server and hardware tuning. It the best high performance Oracle database book I've ever seen. I've used this book quite frequently when dealing and planning for performance issues. If an Oracle8 version of this book comes out - I will be one of the first to buy it.

No DBA's bookshelf is complete without this book. The authors covered some of the most important topics in oracle tuning and administration. This book gives the most complete and up to date information about underlying concepts and practical ways of using those theoritical concepts in day to day operations in oracle database tuning and administration.

The book is aimed at those interested in DBA issues however I recommend developers to shell out for the book just for the chapters on EXPLAIN PLAN and SQL Tuning Tips. My investment quickly paid back when I put the info to use recently for a major client.

When I first learned about computers, only a few of them existed in the world. Since then, something extraordinary has happened in computing about every ten years, like Aestiva's web-programming language HTML/OS which is the subject of this book. It grabbed my attention and turned my professional life in a new direction. ADVANCED WEB SITES MADE EASY teaches all major concepts of this exciting technology with many well chosen examples. It contains code and building blocks that can readily be used as the core of web-based applications. Included with the book is free access to a web site featuring solutions to the exercises, a user forum, book corrections, all the book's code in downloadable form, and your own copy of HTML/OS free for 30 days.

As you work your way through the book, you'll get a good understanding of this powerful and flexible language. Chapter after chapter teaches you how easy it is to make sophisticated use of it by adding just a few lines of BASIC-like code to your HTML documents. You'll also begin to think in a new way about web computing. HTML/OS frees you from the hassles of systems integration. Whether you just want to add dynamic features to an existing site, design complex web sites, or develop web-based software, you'll never have to worry about compatibility. It runs on all platforms and includes a built-in database engine.

You'll be well equipped to build advanced web sites with this clearly written book, its companion web site, the HTML/OS manual, and the Aestiva User Center with its many ready-made examples of commercial applications and utilities, collection of sample code, and extensive knowledge base.

"Advanced Web Sites Made Easy" is a remarkable book. I read lots of third-party technical books, and this one really stands out.

It's well written, the explanations are clear, the examples are not only useable code but paced so as to be make learning progressive, and there's no fluff or patronizing chattiness. What's amazing is how often the chapters answered the questions I was having AS I was having them.

I feel really lucky that this book was available when I came to HTML/OS. It's great software (I almost don't want other web developers to know how good it is) but the official documentation and help just aren't enough.

I especially appreciate the opening and closing sections, which give some historical pespective on this kind of software development, and illuminate some potential business uses that were obscure to me as a web developer.

Kudos on a really fine piece of technical writing.

i was not web programmer before and i found this book in aestiva H2O web site, it was my first advanced web programming and was really easy to achive perfect results

the only thing the author may need to add is a CD-Rom, book some time have long code parts or at least a web location where you can copy and paste the codes

also book did not mention that aestiva has released free and smaller copy of HTML/OS called H2O Gold, and because this release if free, it will encourage newbies to start learning HTML/OS rather than the $800 for HTMLOS PRO, the book is very usefull too if you just want to use H2O only.

last advice, if you totally new to web programming then get this book with a free copy of H2O and you really done, do not bother yourself again with complicated PHP and PERL things

The Aestiva HTML/OS program makes creating interactive websites with databases, search on demand systems, and other usually complicated programming tasks quite easy. I have NO programming experience. Aestiva's near-English commands and simple coding structure mean that I have built and helped to build dozens of sites. The syntax is easy to pick up (learn by doing) and the online lessons that come with each copy make the learning FAST. If you want more control of your website and less dependence on gurus I urge you to read this book.

ADVANCED WEB SITES MADE EASY is simple, clear and easy to understand with lots of examples and exercises. It travels deep in advanced HTML/OS programming for the more advanced programmers.
I have been working with Aestiva HTML/OS for 5 years; I have used PHP, ASP, Cold Fusion and many other similar products. I haven't found anything else that can come close to the performance, flexibility and easiness of use of Aestiva's engine. It's a tool to be use by beginners as well as veteran professionals in the Internet industry, like myself.
This book is a must for all web developers....

This book has been very helpful to me in my personal study of statistics. It is practical, with everyday applications, as well as explanations behind the formulae. Be sure to buy one with the CDROM. It is essential to solving the problems suggested in the book.

I really just had to take the class to finish my masters. The book explains the theories behind the formulas. Having an instructor was very help to understand it all.

I have a large library of math texts from many years in school and I have never read one that was so much fun. This book is really interesting and practical. Finally a statistics book that does more than scare the wit out of somebody. I would highly recommend that more professors choose this book for their students.

Incredibly useful book, easy to use. Contains all the Excel information you will even need in a basic statistics class.

I have used this book in my classroom for the last 3 years and found it very illustrative and simple for students to comprehend statistics. It covers theory with practical examples and therefore keeps it 'real' for students. I have used other books in the past, but students found them theoretical and 'brain show-offs' by authors who really did not care for student comprehensions unless they were math majors. This book is far different and even beginner students can easily relate to the hundreds of practical examples that the author provides.

The Excel examples are easy to follow and my science students usually pick up many practical models from these examples. The regression covered at the beginning level in Chapter 3 is fully covered in multiple regressions in Chapters 17 &18 in a way that makes it easy to teach...

Of the 40-60 stats books I have in my office, this is by far my favorite....

Dr. Bjarne Berg
Assistant Professor Lenoir-Rhyne College
School of Math and Computer Science

This book is for beginners. I'm a seasoned system engineer and have worked with SQL 2005 before. However not having any formal training I decided to get a book. I don't want to be a developer so I needed something that demonstrates SQL server 2005 from the admin side. This is book is perfect for that. It explains the major features a sys admin would want to know. Anything above what this book teaches, can be found on technet or doing a google search. So in conclusion, for a sys admin wanting to know SQL Server 2005, this book will serve your purposes very well...

I found this book offers exactly what I needed. I learned how to best manage my SQL 2005 Database Server. I found the information to be accurate and well written, an excellent reference that I've used many times. I really appreciated how the authors used real world experience to relay hard to understand concepts.

Having taken several classes from Dan Wood I appreciate the years of practical experience these guys bring to the table. It is a very good, readable, and thorough introduction to MS SQL Server 2005. SQL 2005 is a big product with lots of intricacies. This is one of the best introductions to to it that I've read.

This is an awesome book for someone that is new to SQL Server and needs to learn basic administration. The authors did a really good job of explaining the fundamentals in clear simple language.

I especially enjoyed the explanation of the storage engine. It made things clear to me that I didn't understand previously.

I had not touched a DB box in quite a while, and I was recently handed a SQL 2005 box to manage. This book pretty much covered everything I needed. The writing style is laid back and readable, and they get right to the point, without going off on all sorts tangents. The chapter on Automating Administrative Tasks (Chapter 8) was pure gold.

Good stuff.

The book reads quickly and is pretty useful. You have to be commited to working on the steps in the book for it to really amount to much. But even if you just pick it up and read it quickly you'll probably take something usefull away from it.

No other book I've ever read delivers advice for a perfect way to live your life as easy to read and understand, than this book. I have discovered truths, which I've now applied to my own life, which really have made a remarkable difference - and that's what I love about this book. Advice that is not only sound, but works when you try it! I love that! Terri offers 'tools' to enable everyone to live a wonderfully rewarding life, and presented in such a way, you think, "well, gee, why didn't I think of that!" If I suspected Coaches were a special breed before, well, now I am convinced of it. I'm going to raise my child by these principles. Thank you, Terri!

Terri Levine's Coaching For An Extraordinary Life has given me new insights into working with my students.Thank you for this wonderful book.
Madeline Frank, Ph.D. author of The Secret of Teaching Science & Math Through Music and Musical Notes On Math, teaching children to enjoy math, fractions and decimals, through the rhythm of music.

Dear Terri:
I recieved via e-mail and read the first two chapters of you book Coaching for an Extraordinary Life. I was very much impressed and in awe of what I read there. If the remainder of the book is as good as the first two chapters and I have no doubt that if is, I am convinced that I am going in my life exactly where I want and need to go. It was very spiritual reading and convinced me that it was spirit that guided my fingers to e-mail you and it was spirit that responded. Thank you and I honor the spirit within. Peace and tranquility.

Sincerely,
Charles Emery Kelley

Coaching For An Extraordinary Life is a collection of sound advice from professional coach Terri Levine (Founder, Comprehensive Coach U., The Professional's Coach Training Program), who offers a wealth of "user friendly" tips, tricks, and techniques for coping with the common woes of everyday life. From learning the art of deep listening, to building up one's mind, body, and spirit, to the joy of helping others achieve their goals, Coaching For An Extraordinary Life is a simple, inspiring, practical guide to self-improvement, and a potentially life-changing catalyst which is especially recommended for the non-specialist general reader seeking to improve the day-to-day quality of their lives and life experiences.

Dispite the 300+ pages, I was able to finish this book in a day. It provides clear and concise information on how to manage a data warehousing project, caveats & pitfalls, and differences between DW technologies & strategies. The first half of the book focuses on step-by-step DW project management and methodology. The second half focuses on technologies and concepts. However, I felt that the second half of the book was not as strong as the first (probably because technology changes constantly). If you want a book that gives you a step-by-step task list that can be easily transferred to a MS Project plan, then this is the book you want!

This is a good introduction to data warehousing for business process owners, project managers and service delivery and support professionals. Like all books in the Enterprise Computing series this one follows the people-process-technology pattern, with a focus on business value.

The authors start by showing how data warehouses fit into the context of IT architecture, and how this relates to fulfilling business needs. This is followed by a clearly presented section on concepts that will be easily understood by non-technical readers, especially business process owner who are exploring the benefits and advantages of data warehousing.

Scope and complexity of designing, implementing and deploying a data warehouse are discussed in detail in Section II, starting with some excellent material for developing a business case and determining the cost/benefit ratio of a data warehouse initiative. Information in this section is also useful for planning a data warehouse project because it provides low-level details on roles and responsibilities. A key point here is the way the project is structured with both technical and business resources. I like this approach because it involves all of the major stakeholders and IT customers from the beginning instead of the more common practice of waiting until the last minute to involve the business. This approach will go a long way towards making a data warehouse project a success and ensuring that the business gets what it really needs instead of what IT thinks the business needs.

The technology section of this book is an excellent description of data structures, meta data and topics that need to be understood in view of the large difference between a data warehouse and an online transaction processing system. I learned a lot from this section and appreciated the way the information was clearly presented. I also liked the fact that the authors included a section on production and maintenance. Other books stop short of this important milestone in a development life cycle, which leaves a lot of unaccounted for issues. This section completes the total picture of a data warehousing initiative and sets realistic expectations for the true costs, resources and effort required to implement and maintain a data warehouse throughout its entire life cycle.

This is a nicely done book that is accessible to both technical and non-technical readers, and is one of the best resources with which to get up-to-speed on data warehousing without getting bogged down with too many technical details.

Data Warehousing covers a lot of territory, but does not go into depth. If you know this in advance it sets your expectations that this book is more of an educational tool for managers than a "how-to" for data architects and DBAs. I recommend The Data Warehouse Lifecycle Toolkit by Ralph Kimball for those who are seeking an in-depth technical treatment of the subject.

This book will give you a solid foundation of the basics, expose the issues and provide a high-level process for planning and implementing a data warehouse. It is divided into sections, the first three covering people, process and technology.

Section One starts with an overview enterprise IT architectures, how data warehousing fits into the scheme of things, and associated business and technical perspectives. I like the way the authors emphasize business perspectives, which is a consistent thread throughout the book. They use a framework called "InfoMotion", which covers all of the requirements, but (to me) is too wrapped-up in "consultant-speak". For example, they litter this section with nonsense such as "InfoMotion = Information/Data * motion. While it makes perfect sense from a conceptual viewpoint, there is no way to compute it, so why express it as a formula? Parenthetically, data is easy to quantify; measuring information is difficult, but can be done. The motion part of the equation is plain silliness because there is no basis given for measurement. But I am nitpicking here.

You are next introduced to data warehouse concepts. This gives a foundation that is complete and covers all key elements, such as reports, definitions of data warehouse and data mart and operational data stores. I thought this was an excellent introduction. Also included is a brief piece on cost/benefit and return on investment. It was short and hit all of the key points, but would have fit better in the prior discussion of the business perspective.

The next section addresses the people part of a data warehousing project, begining with the project sponsor. Answers to some incisive questions are given in this part, such as "how will the data warehouse affect decision-making processes?", "how will it improve financial, marketing and operations processes?" and similar business-focused questions. These draw your attention to the real reasons for data warehousing. This section moves naturally into project management considerations, and exposes some common problems like defining project scope, underestimating time and project overhead or factoring the operational support issues after the data warehouse is rolled out and in production. One of the best parts of this section is how the authors counter common problems and risks with advice on how to eliminate or mitigate them. I liked the approach to measuring results, which gives some sound key performance indications that you can use to baseline some total cost of ownership drivers after the data warehouse is in production. This section continues with roles and responsibilities of the project team. The authors have crafted a sound team structure that consists of business and technical representatives who are overseen by a steering committee. This is an excellent approach. I thought the inclusion of users from various business domains was one of the key strengths, because these people know the data's value to the business a lot better than the technical side of the team. On the other hand, I thought it was naive of the authors to state that this group would be required 80% of the time during the project. While I fully agree with this estimate, it is nearly impossible in practice. I wish the authors would have shared how they sold the business side on making an 80% commitment of their best and brightest.

As this section moves into the actual project there are some things I loved about their approach: breaking the project into four parallel tracks and the proposed rollout strategy. These give you a good understanding of the scope and magnitude of a typical data warehouse project.

Section 4 covers technology, and gets a little too technical for a business user in some places, but is just right for an IT manager who is not a DBA or data architect. I liked the discussion of metadata, why normalization is not appropriate for data warehousing, and the treatment of fact and dimension tables.

The final section discusses maintenance requirements once the data warehouse is in production. This prepares you for the realities of managing these systems. I wish the authors would have addressed some of the workload and scheduling issues that are a part of the territory - refreshing the warehouse is going to require a fine balancing act that is going to affect maintenance windows, other production jobs and a plethora of other production headaches if not planned for in advance.

Overall this is a good book for the audience I cited above. I strongly recommend anyone considering a data warehouse to also read Improving Data Warehouse and Business Information Quality by Larry P. English.

Excellent book that explains all the steps necessary to implement successful warehouse project. It approaches it from organizational point of view as oppossed to technical. It will complement many technical warehousing books out there.

A serious textbook about Data warehouse real world issues.

It provides material not covered by other textbook, the laterial about meta data in particular.

A must read

This book makes a good technical companion to Kahn's historic treatment in 'The Code Breakers'. It covers the technology up through the advent of computers. Its treatment is technical, going into details about how an encryption technique is performed, and how it is attacked. This book is the first place where I've seen the Enigma machine described in enough detail to understand how it works (or they worked since there were many variations and many of them are discussed here), and how to actually build (or simulate) one. It's a big book, and I carried it around for months, sometimes just diving into a chapter or topic. I loved it.

This book is the best book I have found so far on mathematical cryptology. Although the author does a fairly sketchy treatment of DES and IDEA compared to some other books out there, I feel that he makes up for it by placing all of the most common cryptographic systems in the context of a coherent and rigorous mathematical framework. Many other cryptology books fail to tie all the various cryptographic methods together using the powerful tools of modern mathematics. Dr. Bauer's text however, leaves no question in the student's mind where all the techniques fit into the theoretical framework. The second half of the book is also a pleasant surprise: a very readable but mathematically rigorous explanation of cryptanalysis. The author presents a number of statistical methods of attack that are difficult to find all in one place in the open literature. Dr. Bauer does a thorough job of explaining and augments the theory with many examples. This thorough treatment of cryptanalysis distinguishes his book from many other books on cryptology. Many authors of cryptology books pay lip-service to Kerckhoff's maxim (Only a cryptanalyst can judge the security of a crypto system.) but few bring the student enough cryptanalytic knowledge to even begin to evaluate the crypto systems presented in their books. Dr. Bauer does an excellent job of balancing cryptography with cryptanalysis. I highly recommend this book for any serious student of Cryptology. It is a real gem.

I read this book in the original German (even though reading in German is still a labor for me), and the effort was amply rewarded. This book is a first course in cryptography, at the upper undergraduate or beginning graduate level. Its competition would be books like Denning's or Beker and Piper or Koblitz' series. Denning's book is still great and worth buying (and Ms. Denning is a wonderful, accomplished, and intelligent person), but Bauer is more modern and complete. Koblitz' books are all first rate, but Bauer stays on the task of cryptology much more exactly and usefully. This is the basis of an excellent course in several German universities, especially in Munich. If I taught another course purely on cryptography (and not as part of a larger math curriculum---where Koblitz' book is best), I would certainly use this as the text. However, even though this is best, I really think everyone should still buy, read, and treasure Ms. Denning's book, Cryptology, too. (A true classic is never actually superseded.) Buy Bauer. It is better than an existing classic. While I don't have the English version yet, and cannot, therefore, vouch for the quality of the translation, I think that Springer Verlag is such a reliable editor that we can both trust that the translation will be good before we even see it.

This is an amazing book, and relatively inexpensive; Springer-Verlag has done it again.

Rather than being a dry recitation of encryption and cryptanalysis schemes, Bauer provides a great deal of information about what actually goes wrong when one tries to construct a cipher that must be used under pressure by non-cryptologists, with plenty of historical examples to illustrate his points. And he discusses at some length the ways in which cryptanalysts can hope to unravel ciphers and codes too strong to be broken by standard methods. Much of what he has to say I had never seen in print before; some of it was brand new to me. Perhaps it helps that Bauer is German, and doesn't have to write with the uneasy feeling that NSA or MI-6 is looking over his shoulder at every line he writes. For example, his explanation of how Robert Murphy compromised an American cipher in WW II so badly that the Germans could read it easily is one that I think some American officials would probably still prefer not to have in print.

Despite comments by other reviewers and by Cryptologia, I think it requires a certain mathematical sophistication to absorb much of the material in this book. The math is not hard, but Bauer implicitly assumes a mathematical mindset and a familiarity with the terminology of pure mathematics that most college undergraduates don't have. So I wouldn't choose it as the primary text for a first course in cryptology, but I would certainly use it as a supplementary text. I know of no other book that contains so much material on the practical realities of cryptology.

The book is full of very good and interesting technical information. The part on cryptanalysis is rather new and informative. The history part is mostly taken from Khan's book (you'll find some pictures in both) so there is nothing really new in this area

i am Happy to see the site, i cannat spellwords,

sorry

nithyanandan

I found this book to be a great way to become familiar with the range of issues that come to bear on incorporating graphics into a web page. Despite the exclusive use of Photoshop in the examples, the concepts are explained in such a way that makes it easy to identify the same graphic-editing techniques needed to be used with other software such as Paint Shop Pro, my graphic editor of choice. Good clear explanations and excellent examples do a great job of illustrating how "tweaking" things like the color depth and color pallete affect file sizes, download times, and picture quality. Originally, I kept renewing this book from my local library until I finally just bought my own copy. A great book!

Although the book is oriented around Photoshop on the Mac (which is even better if you use a Mac), the concepts are universal. The book is visually pleasing, very informative (especially on graphic formats), and an inexpensive way to get started

The book is deceptive. The author makes it seem simple. In fact she packs in a lot of very cogent points whilst retaining a friendly style. Great for anyone starting out in graphics for the Web (though it does more or less assume you will be using Photoshop).

I found this book by accident in the library when I was starting the process of designing our office's web site. Because I was a rank beginner to the world of web design (although I knew the PC, Windows 98, Microsoft Office, FrameMaker, PageMaker and a little Photoshop), I needed some hand-holding to get my feet wet. This book was better than anything else I found for that task.

There are other web design books I like (like Roger Black's book on Adobe Press) but this is the best one I have seen for the person who literally knows nothing about the topic.Yes, it was written in 1996 and is somewhat dated for the person who wants to be cutting edge, but you have to crawl before you can run, and this book got me through the crawling stage so I could start to feel comfortable with the concepts I would need to work with my Adobe (and now Macromedia) software.

The writing style is crisp and clean and right to the point. I read it in three hours.

Try this book if you don't know anything about web design, then take a look at Roger Black for one designer's viewpoint on design issues. Once you have those two books under your belt, the author's latest book, Web Design in a Nutshell, would be a great next step.

I'm always looking for more ways to use Excel - and I hoped this book would help me solve some of the glitches I've come across. But - it's better than that. It offers problems I've never even encountered - and what fun to try and duplicate them! There are so many little tricks that just aren't covered in the usual classes & seminars. Definitely worth having on the shelf - nearby, so you can grab it quickly!

At last, a computer book written, as I now think they all should be, by a professional comedian. This book is not written for the absolute beginner, but by someone who has used Excel enough to have a couple of annoying problems that they would like to have fixed.

The first Annoyance is "Kill Clippy." This was one of the most hated "innovations" in history. Even Microsoft eventually had the sense to turn him off in Excel 2002. But if you're running an older version, or if someone else using you're computer turns him on, here's how to get rid of him permanently. And for a joke he offers you a web site on "clippycide." That's what a computer book should be.

This goes on to nearly every aspect of working with Excel. Chapter 9 starts out:

Excel's basic functions haven't changed in years. Of course, Microsoft has to addd new stuff to give you a reason to upgrade to the latest version. In Excel 2003, that reason was support for XML."

XML is supposed to make it easy to transfer data from one program to another. Of course there are XML annoyances, one is that the XML that Access produces isn't necessarily readable by Excel. Oh Boy!

Excel Annoyances ...

This book is made for those who have had one or more vexing problems with Excel. If that's you, the answer can probably be found here and lots more besides.

Curtis Frye is an established author, including several books on Excel. He has the book divided into chapters that deal with several categories of problems: Entering Data, Formatting, Formulas, Manipulating Data, Charts, Exchanging Data, Printing, and Customization.

His solutions vary from basic training on how to use a feature, to how to tweak things "just so." Each Annoyance is the result of someone's problem with an aspect of Excel. Since many people do not upgrade to the latest version of Excel when it's available, the book covers solutions from Excel 97 through the current Excel 2003.

One of the most interesting things I learned was the existence of a function that translated numbers into Roman numerals! I never knew this existed. That's not to say I would ever have any use for such a function, but it was interesting playing around with it. If you want to try it out, type a number in one cell and in another, type this formula: = roman(cell), where "cell" is the location of the number you typed. You'll see the result in roman numbers, as advertised. Slick! Someone once threatened to file his income tax return using roman numbers, just to make things hard for IRS, and this is a way it could be done. IRS would probably object.

Screen shots are used liberally in the book. These may simply be a shot of a worksheet but often a related dialog box is also shown. Occasionally a text box includes extra information that may be of importance for a subject.

One extra feature include in the book is reference to some time-wasters, also known as games. Each is an Excel version and is free to download. There's Pac Man, Arkanoid, BlackJack, Rubik's Cube, Tetris and more.

There are occasional answers using Visual Basic, but for the most part, the answers simply use the settings that are already in Excel. Most users never tap the full potential of Excel, and I'm no exception. I feel I am an expert, but I certainly learned a lot by reading this book and you will too, if you use Excel at all.

Ok, Excel is the dominant spreadsheet. No question of that. But it has some surprising "features" which this book calls annoyances. It gives a multitude of them, with fixes for all. (Another O'Reilly series might call these fixes hacks.)

Logically enough, the book starts off with those difficulties that can be met when inputting data. Many of you will applaud that the leading annoyance is the Paperclip, on which much verbal ire has no doubt been expended. So Frye forthrightly shows how to terminate this pesky little bugger.

Later sections talk about formatting, formulae, charting, printing and so on. The chapters essentially follow the main functional structures of Excel. Some features might not be obvious to you; depending on your expertise. But chances are that for the average Excel user, you'll get some good advice from Frye.

This is a well organized and written set of useful hints and pointers for Excel. They range from solutions to difficult data analysis issues, to tips about graphing, pivot tables, and importing data from various formats, notably XML.

The book is organized into chapters around central Excel themes; editing, formulas, formatting, charting, etc. Each chapter has a set of annoyances with a description and a solution. These annoyances are sometimes bugs, and sometimes just difficult issues that reasonably advanced users will run into where the help is either insufficient or poorly written. The fixes are generally fairly short and contained within the bounds of Excel, though the book does point to external sites and software where appropriate.

Definitely a must have for the power Excel user.