发帖
雷达卡
完美分析师：分析师运用Excel在商务中的技巧：Introduction
The book you just opened is different from most others on Excel that you might have seen. That’s because it focuses on a topic that is deeply important to us all: money.
The novelist Rex Stout once wrote, facetiously,“The science of accounting has two main branches, first addition, and second subtraction.” I kept that in mind when I was casting about for the book’s theme. I wanted to write a book that would show people how to maximize profit, the result of combining those two branches.
Profit, of course, is not revenue. I can’t teach you how to create revenue—that’s more a matter for the heart, not the head—nor would I want to offer you MBA or CPA material. I did set out to write a book that any person engaged in any level of business could use as a refresher, from basic financial documents such as general ledgers and income statements,
to the operational methods such as statistical process control, to the procedures such as business case analysis that underlie investment decisions.
I also wanted to structure this book around the most popular and sophisticated numeric analysis program available: Microsoft Excel. Therefore, each chapter in Business Analysis: Microsoft® Excel 2010 provides information about a different business task or procedure and discusses how best to apply Excel in that situation.
This book references many Excel functions and capabilities that you might already use in your daily business activities. You might also find discussions of tools that you have never used or that you might never have considered using in the context of business analysis.
After all, no one can be completely familiar with every option in an application as extensive as Excel.
Several Internet newsgroups frequented by Excel users answer technical questions. Years ago, a user asked how to enter a number in a worksheet cell so that Excel would treat the number as text. (This is quite a basic operation.)
Surprisingly, the question was posted by one of the most experienced, best-known, and creative Excel consultants in the country. I thought that it was a put-on and responded appropriately, but it turned out that the question was genuine.
So we all have gaps in our knowledge. The purpose here is to help fill in some of the gaps that might have entered your knowledge base since your last course in business or since you first learned how to use a worksheet.
Business Analysis: Microsoft® Excel 2010 uses case studies—that is, situations that are typical of decisions or problems that you might face on any given workday. These case studies first discuss the problem itself: why it’s a problem and how a solution can contribute to a company’s profitability. Then the case studies demonstrate at least one possible solution
that uses Excel as a tool. The intent is for you to mentally put yourself in the situation described, work through it, and then apply or adapt the solution to an actual situation that you face.
京公网安备 11010802022788号
