{"product_id":"excel-francesco-iannello-9781530738724","title":"Excel: Strategic Use of the Calc Spreadsheet in Business Environment. Data Analysis and Business Modeling.","description":"The Best Excel Resource for your Business Excel: Strategic Use of the Calc Spreadsheet in Business Environment. Data Analysis and Business Modeling. Spreadsheets and the programs that create them are as common in the business world as cubicles and yet many people still don't know how to take full advantage of the software they use to create these ever-present files; despite the fact that it could ultimately save them time, headaches, even money in the long run. If you want to ensure you are getting the most out of your spreadsheet software then, Excel: Strategic Use of the Calc Spreadsheet in Business Environments, Data Analysis and Business Modeling is the book you have been waiting for. \u003cbr\u003e This book is written for those who are already familiar with all of the basics that these programs have to offer and are looking to take their game to another level. It describes everything you need to know when it comes to time saving things like making the most of Vertical or Horizontal Lookup features, productivity macros and the spreadsheet program's extensive filter function. \u003cbr\u003e What's more, there is plenty of information on how to create data models using pivot tables, edit those data models using Power Pivot and display them in the easiest to understand and use format possible with Power View. If you have ever wondered about a better way to complete common spreadsheet tasks, you can bet the answer to your problems can be found inside. Save yourself countless hours of frustration coupled with limited results, pick up this book today. Inside you will find \u003cbr\u003e \u003cul\u003e \u003cli\u003eHow to use phrases like IF, AND, OR to create more malleable formulas, perfect for any occasion\u003c\/li\u003e \u003cli\u003eThe time-saving reasons you will want to start using named ranges and will never want to go back\u003c\/li\u003e \u003cli\u003eThe easiest way to create macros without any programing required\u003c\/li\u003e \u003cli\u003eHow to get Pivot Table slicers to work with any type of table\u003c\/li\u003e \u003c\/ul\u003e Content \u003cul\u003e \u003cli\u003eChapter 1: Data Validation Functioning\u003c\/li\u003e \u003cli\u003eChapter 2: Conditional Formulas\u003c\/li\u003e \u003cli\u003eChapter 3: Matrixal Functions\u003c\/li\u003e \u003cli\u003eChapter 4: Vertical Lookup\/Horizontal Lookup\u003c\/li\u003e \u003cli\u003eChapter 5: Management of the Name Box\u003c\/li\u003e \u003cli\u003eChapter 6: Filters\u003c\/li\u003e \u003cli\u003eChapter 7: Pivot Tables\u003c\/li\u003e \u003cli\u003eChapter 8: Make the Most of Macros\u003c\/li\u003e \u003cli\u003eChapter 9: Modeling Management\u003c\/li\u003e \u003cli\u003eChapter 10: Power View\u003c\/li\u003e \u003c\/ul\u003e Take action befor price raises\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Francesco Iannello\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 1530738725\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9781530738724\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Createspace Independent Publishing Platform\u003cbr\u003e\u003cb\u003eLanguage:\u003c\/b\u003e English\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 03\/31\/2016\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 58\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 0.20lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.02h x 5.98w x 0.12d","brand":"Francesco Iannello","offers":[{"title":"Paperback","offer_id":43936604029183,"sku":"9781530738724","price":19.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/products\/img_c931e69d-8404-41ef-b14b-32b6ad6cefc7.jpg?v=1681426200","url":"https:\/\/www.whiterainbookhouse.com\/products\/excel-francesco-iannello-9781530738724","provider":"WR Book House","version":"1.0","type":"link"}