Business Analysis With Microsoft Excel
<P style="MARGIN: 0px">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:</P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px">    •   What’s the relationship between my cost of goods sold and my inventory? </P> <P style="MARGIN: 0px">    •   How do I get Excel to keep these values up-to-date on my income statement and my balance sheet?</P> <P style="MARGIN: 0px">    •   I have to track service quality over time. How can I automate that using Excel charts?</P> <P style="MARGIN: 0px">    •   How can I forecast future demand for my products, based on prior sales results?</P> <P style="MARGIN: 0px">    •   What’s the difference between financial leverage and operating leverage? How do I calculate them using my financial records?</P> <P style="MARGIN: 0px">    •   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?</P> <P style="MARGIN: 0px">    •   How do I do all these things using the new Ribbon in Excel 2007?</P> <P style="MARGIN: 0px">    •   What are the best ways to automate a connection between Excel and an external database?</P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px">Category Spreadsheets</P> <P style="MARGIN: 0px">Covers   Applicable for versions of Microsoft Excel 97 to 2007</P> <P style="MARGIN: 0px">User Level   Intermediate–Advanced</P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px"> <B>More great stuff… </B> <B>is just a click away!</B> </P> <P style="MARGIN: 0px">    •   Sample journals and ledgers; examples of trial balances, income statements, and balance sheets</P> <P style="MARGIN: 0px">    •   Custom functions, such as FIFO and LIFO, for inventory management</P> <P style="MARGIN: 0px">    •   VBA routines that automate the creation of forecasts, quality control charts, and sales and marketing analysis</P> <P style="MARGIN: 0px">    •   Statistical process control charts: P charts, X-and-S charts, X-and-MR charts </P> <P style="MARGIN: 0px">    •   Forecasting tools: Seasonal smoothing and ARIMA model identification</P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px"> <B>quote from the front cover</B> </P> <P style="MARGIN: 0px">“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.â€</P> <P style="MARGIN: 0px">–Bob Umlas, Excel MVP</P> <P style="MARGIN: 0px"> </P>