{"title":"Business Solutions Ser","description":null,"products":[{"product_id":"business-analysis-with-microsoft-excel-book-conrad-carlberg-9780789736642","title":"Business Analysis with Microsoft Excel","description":"Whether you own a small business or work for a large corporation–whether you are looking for help making financial and business decisions–this book is for you.  Business Analysis with Microsoft® Excel, Third Edition, provides in-depth information that will streamline your use of the tools within Excel. Professional advice and guidance from an experienced author provide the answers to your most pressing questions:          •    What’s the relationship between my cost of goods sold and my inventory?        •    How do I get Excel to keep these values up-to-date on my income statement and my balance sheet?       •    I have to track service quality over time. How can I automate that using Excel charts?       •    How can I forecast future demand for my products, based on prior sales results?       •    What’s the difference between financial leverage and operating leverage? How do I calculate them using my financial records?       •    I need to project my financials for next year. Does Excel have a tool for that? What do I need to know to use it effectively?       •    How do I do all these things using the new Ribbon in Excel 2007?       •    What are the best ways to automate a connection between Excel and an external database?     Category  Spreadsheets  Covers    Applicable for versions of Microsoft Excel 97 to 2007  User Level    Intermediate–Advanced     More great stuff… is just a click away!       •    Sample journals and ledgers; examples of trial balances, income statements, and balance sheets       •    Custom functions, such as FIFO and LIFO, for inventory management       •    VBA routines that automate the creation of forecasts, quality control charts, and sales and marketing analysis       •    Statistical process control charts: P charts, X-and-S charts, X-and-MR charts        •    Forecasting tools: Seasonal smoothing and ARIMA model identification     quote from the front cover  “Conrad takes the time to give the readers an easy-to-follow step-by-step understanding of the material, accompanied by clear illustrations, making this an excellent book to learn the material. I recommend this book to anyone wanting to gain more expertise in using and manipulating business data from within Excel.”  –Bob Umlas, Excel MVP","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49580738052369,"sku":"GOR002328131","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":49994399252753,"sku":"CIN0789736640G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":51091875004689,"sku":"CIN0789736640VG","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":53135579185425,"sku":"GOR012620428","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789736640.jpg?v=1750703514"},{"product_id":"pivot-table-data-crunching-book-bill-jelen-9780789734358","title":"Pivot Table Data Crunching","description":"Become a savvy Microsoft Excel user. Pivot tables are a great feature in Excel that help you organize and analyze data, but not many Excel users know how to use pivot tables. Pivot Table Data Crunching offers a comprehensive review of all the functionalities of Pivot Tables from author Bill Jelen, otherwise known as Mr. Excel from www.mrexcel.com, and Michael Alexander, a Microsoft Certified Application Developer. The authors' practical scenarios and real-world advice demonstrate the benefits of Pivot Tables and how to avoid the common pitfalls of every day data crunching. Each solution presented in the book can be accomplished with resources available in the Excel interface, making Pivot Table Data Crunching a beneficial resource for all levels of Excel users.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49600644710673,"sku":"GOR001975545","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ WELL_READ \/ SBYB","offer_id":50365585916177,"sku":"CIN0789734354A","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50365587194129,"sku":"CIN0789734354G","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":51155430703377,"sku":"CIN0789734354VG","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789734354.jpg?v=1750785961"}],"url":"https:\/\/www.worldofbooks.com\/collections\/business-solutions-ser-book-series.oembed","provider":"World of Books ","version":"1.0","type":"link"}