{"id":2935,"date":"2013-02-01T22:42:12","date_gmt":"2013-02-02T06:42:12","guid":{"rendered":"http:\/\/learnbyblogging.com\/?p=2935"},"modified":"2013-02-01T22:42:12","modified_gmt":"2013-02-02T06:42:12","slug":"book-review-excel-formulas-and-functions-for-dummies-by-ken-bluttman","status":"publish","type":"post","link":"https:\/\/learnbyblogging.com\/?p=2935","title":{"rendered":"Book Review: &#8220;Excel Formulas and Functions For Dummies&#8221; by Ken Bluttman"},"content":{"rendered":"<p>Went through the book fairly quickly. Good examples. Too bad that they don&#8217;t provide the examples online for download. I consider myself fairly good at spreadsheet but was surprised how advanced Excel spreadsheet has come along with all the database, statistics and other programmable functions now.<\/p>\n<p>Some worthy takeaways:<br \/>\n1. Use of Arrays by using Ctl-Alt-Shift Enter. Wow!<br \/>\n2. Formula auditing tool to check dependents and precedents.<br \/>\n3. All the statistical functions including percentiles, quartile, frequency, and etc.<br \/>\n4. Database functions to search and match.<br \/>\n5. Computer binary\/hex\/octal conversions<\/p>\n<p>This book might come in handy for people who use the spreadsheets a lot. I&#8217;m a causal user and found those formulas out of the realm of my everyday usage.<\/p>\n<p><iframe src=\"http:\/\/rcm.amazon.com\/e\/cm?lt1=_blank&#038;bc1=000000&#038;IS2=1&#038;bg1=FFFFFF&#038;fc1=000000&#038;lc1=0000FF&#038;t=learbyblog-20&#038;o=1&#038;p=8&#038;l=as4&#038;m=amazon&#038;f=ifr&#038;ref=ss_til&#038;asins=047056816X\" style=\"width:120px;height:240px;\" scrolling=\"no\" marginwidth=\"0\" marginheight=\"0\" frameborder=\"0\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Went through the book fairly quickly. Good examples. Too bad that they don&#8217;t provide the examples online for download. I consider myself fairly good at spreadsheet but was surprised how advanced Excel spreadsheet has come along with all the database, statistics and other programmable functions now. Some worthy takeaways: 1. Use of Arrays by using &hellip; <a href=\"https:\/\/learnbyblogging.com\/?p=2935\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Book Review: &#8220;Excel Formulas and Functions For Dummies&#8221; by Ken Bluttman<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-2935","post","type-post","status-publish","format-standard","hentry","category-book-reviews"],"_links":{"self":[{"href":"https:\/\/learnbyblogging.com\/index.php?rest_route=\/wp\/v2\/posts\/2935","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learnbyblogging.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/learnbyblogging.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/learnbyblogging.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/learnbyblogging.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2935"}],"version-history":[{"count":2,"href":"https:\/\/learnbyblogging.com\/index.php?rest_route=\/wp\/v2\/posts\/2935\/revisions"}],"predecessor-version":[{"id":2937,"href":"https:\/\/learnbyblogging.com\/index.php?rest_route=\/wp\/v2\/posts\/2935\/revisions\/2937"}],"wp:attachment":[{"href":"https:\/\/learnbyblogging.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2935"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learnbyblogging.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2935"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learnbyblogging.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2935"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}