{"product_id":"more-excel-outside-the-box-bob-umlas-9781615470365","title":"More Excel Outside the Box: Unbelievable Excel Techniques from Excel MVP Bob Umlas","description":"A follow-up to \u003ci\u003eExcel Outside the Box\u003c\/i\u003e, \u003ci\u003eMore Excel Outside the Box\u003c\/i\u003e is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software's most challenging problems. Through a series of more than 30 techniques, tables, formulas, and charts, this guide details processes that may be used in any Excel application and across all disciplines. Creative approaches for building formulas within formulas, pivot tables, conditional formatting, and mastering array formulas are just some of the numerous challenges explained. Other higher-level solutions discussed include using VBA macro code to override cell calculations, solve for sums from a text string, and trimming and cleaning all cells on a worksheet. This is the all-encompassing resource for advanced users of Excel wanting to learn more techniques to broaden and empower their knowledge of the program.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Bob Umlas\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 1615470360\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9781615470365\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Holy Macro! Books\u003cbr\u003e\u003cb\u003eLanguage:\u003c\/b\u003e English\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 07\/01\/2015\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 112\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 0.40lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 8.90h x 5.80w x 0.30d","brand":"Bob Umlas","offers":[{"title":"Paperback","offer_id":44078513914111,"sku":"9781615470365","price":24.95,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/files\/img_dbe41c66-c62d-4e71-9544-0dc4873c14e9.jpg?v=1685475954","url":"https:\/\/www.whiterainbookhouse.com\/products\/more-excel-outside-the-box-bob-umlas-9781615470365","provider":"WR Book House","version":"1.0","type":"link"}