x

Our Privacy Policy has changed. By using this site, you agree to the Privacy Policy.

Business Analysis with Microsoft Excel

ISBN-10: 0789736640
ISBN-13: 9780789736642
Edition: 3rd 2007 (Revised)
List price: $39.99
eBook available
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

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(R) Excel, Third Edition, provides in-depth information  More...

eBooks Starting from $27.99
Buy
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
You could win $10,000

Get an entry for every item you buy, rent, or sell.

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Periodic Table Online content $4.95 $1.99
Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $39.99
Edition: 3rd
Copyright year: 2007
Publisher: Pearson Education
Publication date: 6/19/2007
Binding: Paperback
Pages: 504
Size: 7.00" wide x 8.75" long x 1.25" tall
Weight: 2.046

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(R) 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 andmarketing 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

Introduction
Taking It on Faith
About the Platform
How This Book Is Organized
Two Special Skills: Named Ranges and Array Formulas
Assigning Names
Using Array Formulas
Conventions Used in This Book
Analyzing Financial Statements
Working with Income Statements
Keeping Score
Choosing the Right Perspective
Defining Two Purposes for Accounting
Using the Income Statement
Choosing a Reporting Method
Measuring the Operating and Nonoperating Segments
Moving from the General Journal to the Income Statement
Getting the General Journal into Excel
Understanding Absolute, Relative, and Mixed References
Getting the Journal Data to the Ledger
Getting the Ledger Data to the Income Statement
Managing the Financial Analyses with Accrual Accounting
Organizing with Traditional vs. Contribution Approaches
Summary
Balance Sheet: Current Assets
Designing the Balance Sheet
Understanding Balance Sheet Accounts
Understanding Debit and Credit Entries
Getting a Current Asset Cash Balance

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×