Business Analysis with Microsoft Excel or Media in the Digital Age

Business Analysis with Microsoft Excel

Author: Conrad Carlberg

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, Second Edition provides in-depth information that will maximize 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?

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, for inventory management
• Several VBA files that automate the creation of forecasts, quality control charts, and sales and marketing analysis
• Statistical process control charts: X-and-S, X-and-MR
• Forecasting tools: ARIMA model identification

Booknews

Carlberg (Ph.D., statistics), the president of a software and consulting firm that specializes in developing quality control and forecasting tools, distinguishes his book from others on Excel by its bottom line orientation. In coverage of financial statements and analysis, financial planning and control, investment decisions, and sales and marketing, he stresses making worksheets self- documenting for interpretation by others. Includes case studies, tips, a glossary, and auxiliary website. No date is given for the first edition. Annotation c. Book News, Inc., Portland, OR (booknews.com)

Table of Contents:

Book about: Grundsätze der Volkswirtschaft

Media in the Digital Age

Author: John V Pavlik

Digital technologies have fundamentally altered the nature and function of media in our society, reinventing age-old practices of public communication and at times circumventing traditional media and challenging its privileged role as gatekeepers of news and entertainment. Some critics believe these technologies keep the public involved in an informed discourse on matters of public importance, but it isn't clear this is happening on a large scale. Propaganda disguised as news is flourishing, and though interaction with the digital domain teaches children valuable skills, it can also expose them to grave risks.

John V. Pavlik critically examines our current digital innovations—blogs, podcasting, peer-to-peer file sharing, on-demand entertainment, and the digitization of television, radio, and satellites—and their positive and negative implications. He focuses on present developments, but he also peers into the future, foreseeing a media landscape dominated by a highly fragmented, though active audience, intense media competition, and scarce advertising dollars. By embracing new technologies, however, Pavlik shows how professional journalism and media can hold on to their role as a vital information lifeline and continue to operate as the tool of a successful democracy.