Improve Your Productivity By Using Conditional Formatting in Microsoft Excel


Non-Fiction - Business/Finance
87 Pages
Reviewed on 10/10/2015
Buy on Amazon

This author participates in the Readers' Favorite Free Book Program, which is open to all readers and is completely free. The author will provide you with a free copy of their book in exchange for an honest review. You and the author will discuss what sites you will post your review to and what kind of copy of the book you would like to receive (eBook, PDF, Word, paperback, etc.). To begin, click the purple email icon to send this author a private email.

This author participates in the Readers' Favorite Book Review Exchange Program, which is open to all authors and is completely free. Simply put, you agree to provide an honest review an author's book in exchange for the author doing the same for you. What sites your reviews are posted on (B&N, Amazon, etc.) and whether you send digital (eBook, PDF, Word, etc.) or hard copies of your books to each other for review is up to you. To begin, click the purple email icon to send this author a private email, and be sure to describe your book or include a link to your Readers' Favorite review page or Amazon page.

This author participates in the Readers' Favorite Book Donation Program, which was created to help nonprofit and charitable organizations (schools, libraries, convalescent homes, soldier donation programs, etc.) by providing them with free books and to help authors garner more exposure for their work. This author is willing to donate free copies of their book in exchange for reviews (if circumstances allow) and the knowledge that their book is being read and enjoyed. To begin, click the purple email icon to send this author a private email. Be sure to tell the author who you are, what organization you are with, how many books you need, how they will be used, and the number of reviews, if any, you would be able to provide.

    Book Review

Reviewed by Roy T. James for Readers' Favorite

Improve Your Productivity By Using Conditional Formatting in Microsoft Excel by John Smith explains what conditional formatting is, and how that can multiply the information content of a spreadsheet. Use of different colors, selective highlighting, and appropriate positioning of cells are some of the topics discussed in this book. As anyone working on computers will appreciate, John begins this book with an important topic – how to reverse the formatting. Use of these techniques in finding duplicate information, as well as custom formatting rules, is also discussed. The author has indicated the availability of a formal training course with online discussions.

Improve Your Productivity By Using Conditional Formatting in Microsoft Excel is a book with tremendous potential in actual use. The capabilities of Excel of selective highlighting are of great use when it comes to effective information display. Also discussed is the utility of selective highlighting in locating errors and discrepancies in a table. Though I have seen the use of spreadsheets quite extensively, instances of such advanced techniques of data presentation have been observed to be minimal.

This book explains such aspects quite well, in a manner that is simple and easy to follow. The necessary procedural details and commands are shown in a clear and unambiguous manner to make the whole activity completely error free. Screenshots are also shown to make it very user friendly. In short it is a very useful book; it taught me a few tricks I was not aware of.