Business Analysis with Microsoft Excel

Business & Finance, Accounting, Financial
Cover of the book Business Analysis with Microsoft Excel by Conrad Carlberg, Pearson Education
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Conrad Carlberg ISBN: 9780132713597
Publisher: Pearson Education Publication: June 19, 2007
Imprint: Que Publishing Language: English
Author: Conrad Carlberg
ISBN: 9780132713597
Publisher: Pearson Education
Publication: June 19, 2007
Imprint: Que Publishing
Language: English

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

 

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

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

 

More books from Pearson Education

Cover of the book Now You're Thinking by Conrad Carlberg
Cover of the book The Definitive Guide to Order Fulfillment and Customer Service by Conrad Carlberg
Cover of the book Optimizing and Troubleshooting Hyper-V Storage by Conrad Carlberg
Cover of the book The iPhone Book: Covers iPhone 4S, iPhone 4, and iPhone 3GS by Conrad Carlberg
Cover of the book A Photographer's Guide to Focus and Autofocus by Conrad Carlberg
Cover of the book Option Strategies for Earnings Announcements by Conrad Carlberg
Cover of the book Enterprise Content Management with Microsoft SharePoint by Conrad Carlberg
Cover of the book Landscape Photography by Conrad Carlberg
Cover of the book CCENT Practice and Study Guide by Conrad Carlberg
Cover of the book Photoshop CS3 by Conrad Carlberg
Cover of the book Easy Mac OS X Lion by Conrad Carlberg
Cover of the book Inside LightWave 3D v10 by Conrad Carlberg
Cover of the book King Lear: York Notes for A-level by Conrad Carlberg
Cover of the book The Flip Mino Pocket Guide by Conrad Carlberg
Cover of the book The Simple Dollar: How One Man Wiped Out His Debts and Achieved the Life of His Dreams by Conrad Carlberg
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy