Shop now Shop now Shop now  Up to 70% Off Fashion  Shop all Amazon Fashion Cloud Drive Photos Shop now Learn More Shop now Shop now Shop Fire Shop Kindle Shop now Shop now Shop now
Customer Review

4.0 out of 5 stars A good Excel book, 19 July 2014
Verified Purchase(What is this?)
This review is from: Learn Excel 2010 Expert Skills with The Smart Method: Courseware Tutorial teaching Advanced Techniques (Paperback)
I definitely learnt new things from this book. Like anything - it will be a worthwhile purchase if you actually start incorporating things you have learnt into your day to day work. Those things I have are second nature now, but there are useful functions in here that I haven't made use of and would not be able to use without spending some time reviewing again.

One thing I liked was the authors comments on vba - he stated in his experience most of problems people approached him for that they claimed needed vba could actually be handled easily by the normal Excel functions he teaches in this book.

I have borne that in mind since reading, and it seems like good advice. I have discovered one possible exception - trying to make dynamic forms where users input information which in turn drives the subsequent choices they are presented with. I have made use of the excellent data validation section here, but have found out that people can skirt the rules by inputting data, making a subsequent choice, and then removing the original choice. Validation can stop people entering data into a cell, but it is harder to control it once it is already in there.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Be the first person to comment on this review.

[Add comment]
Post a comment
To insert a product link use the format: [[ASIN:ASIN product-title]] (What's this?)
Amazon will display this name with all your submissions, including reviews and discussion posts. (Learn more)
Name:
Badge:
This badge will be assigned to you and will appear along with your name.
There was an error. Please try again.
Please see the full guidelines ">here.

Official Comment

As a representative of this product you can post one Official Comment on this review. It will appear immediately below the review wherever it is displayed.   Learn more
The following name and badge will be shown with this comment:
 (edit name)
After clicking on the Post button you will be asked to create your public name, which will be shown with all your contributions.

Is this your product?

If you are the author, artist, manufacturer or an official representative of this product, you can post an Official Comment on this review. It will appear immediately below the review wherever it is displayed.  Learn more
Otherwise, you can still post a regular comment on this review.

Is this your product?

If you are the author, artist, manufacturer or an official representative of this product, you can post an Official Comment on this review. It will appear immediately below the review wherever it is displayed.   Learn more
 
System timed out

We were unable to verify whether you represent the product. Please try again later, or retry now. Otherwise you can post a regular comment.

Since you previously posted an Official Comment, this comment will appear in the comment section below. You also have the option to edit your Official Comment.   Learn more
The maximum number of Official Comments have been posted. This comment will appear in the comment section below.   Learn more
Prompts for sign-in
  [Cancel]