This book reviews advanced functions in Excel 2016. Also Macro's are covered along with the creation of Forms. Many examples are supplied to help the software user to understand and use these functions. Areas that are covered are Accounting, Financial, Look Up, Logical, Math, Pivot tables, Statistical and Text functions.

This book shows the capabilities of Microsoft Excel in teaching business statistics effectively. Similar to the previously published Excel 2010 for Business Statistics, this book is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical business problems. If understanding statistics isn't your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in business courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2016 for Business Statistics: A Guide to Solving Practical Problems is the first book to capitalize on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand business problems. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned.

The jargon associated with Microsoft Excel's pivot tables ("n-dimensional cross tabulations") makes them look complex, but they're really no more than an easy way to build concise, flexible summaries of long lists of raw values. If you're working with hundreds (or hundreds of thousands) of rows, then pivot tables are the best way to look at the same information in different ways, summarize data on the fly, and spot trends and relationships. This handy guide teaches you how to use Excel's most powerful feature to crunch large amounts of data, without having to write new formulas, copy and paste cells, or reorganize rows and columns. You can download the sample workbook to follow along with the author's examples. Create pivot tables from worksheet databases. Rearrange pivot tables by dragging, swapping, and nesting fields. Customize pivot tables with styles, layouts, totals, and subtotals. Combine numbers, dates, times, or text values into custom groups. Calculate common statistics or create custom formulas. Filter data that you don't want to see. Create and customize pivot charts. Unlink a pivot table from its source data. Control references to pivot table cells. Plenty of tips, tricks, and workarounds. Fully indexed and cross-referenced.

Contents 1. Pivot Table Basics 2. Nesting Fields 3. Grouping Items 4. Calculations and Custom Formulas 5. Filtering Data 6. Charting Pivot Tables 7. Tricks with Pivot Tables

About the AuthorTim Hill is a data miner based in Las Vegas, Nevada. When he's not crunching numbers, Tim plays poker, hikes canyons, and avoids malls.

Quantitative Methods for Decision Making is a comprehensive guide that provides students with the key techniques and methodology they will need to successfully engage with all aspects of quantitative analysis and decision making; both on their undergraduate course, and in the larger context of their future business environments. Organized in accordance with the enterprise functional structure where the decision making takes place, the textbook encompasses a broad range of functions, each detailed with clear examples illustrated through the single application tool Microsoft Excel. The authors approach a range of methods which are divided into major enterprise functions such as marketing, sales, business development, manufacturing, quality control and finance; illustrating how the methods can be applied in practice and translated into a working environment. Each chapter is packed with short case studies to exemplify the practical use of techniques, and contains a wealth of exercises after key sections and concepts, giving students the opportunity to monitor their own progress using the solutions at the back of the book. An Online Resource Centre accompanies the text and includes: For students: - Numerical skills workbook with additional exercises, questions and content - Data from the examples and exercises in the book - Online glossary of terms - Revision tips - Visual walkthrough videos covering the application of a range of quantitative methods - Appendices to the book For lecturers: - Instructor's manual including solutions from the text and a guide to structuring lectures and seminars - PowerPoint presentations - Test bank with questions for each chapter - Suggested assignment and examination questions

Bookkeeping and financial reporting in less than hundred pages. Well written, pleasant reading with detailed practical examples. Authored by experienced, senior businessman with Henley MBA degree. Explains how to make a complete bookkeeping and financial reporting system in Excel. The system is designed for simplicity and manageability and can be implemented in a few hours. Covers the basics: Journal, ledger, profit & loss, balance sheet, cash flow and explanatory notes. Covers selected advanced topics: VAT, rolling budget, fixed budget and group consolidation. Text is IFRS compliant and globally valid. The system works in any country. No hard limit on number of businesses, accounts, records or reporting lines. No programmer skills required because VBA and macros are not used.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. 250 + ready-to-use, powerful DAX formulasDevelop effective business intelligence (BI) solutions and drive faster, better decision making across your enterprise with help from an experienced database consultant and trainer. Through clear explanations, screenshots, and examples, Practical PowerPivot & DAX Formulas for Excel 2010 shows you how to extract actionable insights from vast amounts of corporate data. More than 250 downloadable DAX formulas plus valuable appendixes covering SQL, MDX, and DMX query design are included in this hands-on guide. Build pivot tables and charts with PowerPivot for Excel Import information from Access, Excel, data feeds, SQL Server, and other sources Organize and format BI reports using the PowerPivot Field List Write DAX formulas that filter, sort, average, and denormalize data Construct complex DAX formulas from statistical, math, and date functions Compare current and past performance using date and time intelligence Handle non-additive numbers, non-numeric values, and running totals Develop complete self-service and sharable BI solutions in a few minutes Download the source code from www.mhprofessional.com/computingdownload

Existing technical books are too lengthy and dull to be suitable as references for beginning and intermediate Excel users. The author cuts through the clutter and provides precise, useful information users want and need. This Microsoft Excel book will take you to the next level and you to be quicker and more comfortable with Excel. When you reach that next level, you will also feel better about yourself This book is designed to increase your productivity and self-esteem.

Easy to use and equipped with a variety of functions, Microsoft Excel is the tool of choice when it comes to crunching numbers, building charts, and analyzing tables. But most users only scratch the surface of the program's functionality, especially the built-in formulas designed to make everyday operations and real-world tasks more efficient. "Microsoft Excel Functions & Formulas" demonstrates the secrets of Excel functions through the use of practical and useful examples in a quick reference format. Topics include logical, text, date and time, basic statistical, mathematical, financial, database, and lookup and reference functions as well as conditional formatting with formulas, array formulas, and user-defined functions. This book's extensive examples make it an excellent tutorial for all Excel users who want to understand, create, and apply formulas. Intermediate and advanced users will find "Microsoft Excel Functions & Formulas" an excellent reference to many of the program's advanced formulas and functions.

Microsoft Excel is a powerful tool that can transform the way you use data. This book explains in comprehensive and user-friendly detail how to manage, make sense of, explore and share data, giving scientists at all levels the skills they need to maximize the usefulness of their data. Readers will learn how to use Excel to: * Build a dataset - how to handle variables and notes, rearrangements and edits to data. * Check datasets - dealing with typographic errors, data validation and numerical errors. * Make sense of data - including datasets for regression and correlation; summarizing data with averages and variability; and visualizing data with graphs, pivot charts and sparklines. * Explore regression data - finding, highlighting and visualizing correlations. * Explore time-related data - using pivot tables, sparklines and line plots. * Explore association data - creating and visualizing contingency tables. * Explore differences - pivot tables and data visualizations including box-whisker plots. * Share data - methods for exporting and sharing your datasets, summaries and graphs. Alongside the text, Have a Go exercises, Tips and Notes give readers practical experience and highlight important points, and helpful self-assessment exercises and summary tables can be found at the end of each chapter. Supplementary material can also be downloaded on the companion website. Managing Data Using Excel is an essential book for all scientists and students who use data and are seeking to manage data more effectively. It is aimed at scientists at all levels but it is especially useful for university-level research, from undergraduates to postdoctoral researchers.

Microsoft Excel 2010 Programming by Example with VBA, XML and ASP is a practical how-to book on Excel programming, suitable for readers already familiar with the Excel user interface. The book introduces programming concepts via numerous multi-step, illustrated, hands-on exercises. More advanced topics are introduced via custom projects. From recording and editing a macro and writing VBA code to working with XML documents and using classic ASP to access and display data on the Web, this book takes you on a programming journey that will change the way you work with Excel. Completely updated for Excel 2010, this book provides information on performing automatic operations on files, folders, and other Microsoft Office applications. It also covers proper use of event procedures, testing and debugging, and programming advanced Excel features such as PivotTables, PivotCharts, and SmartTags. Thirty chapters loaded with illustrated hands-on projects and exercises that tell you exactly where to enter code, how to debug it, and then run it. Each exercise/project step is clearly explained as it is performed.Table of Contents1. Automating Worksheet Tasks with Macros. 2. Exploring the Visual Basic Editor (VBE). 3. Excel VBA Fundamentals. 4. Using Variables, Data Types, and Constants. 5. VBA Procedures: Subroutines and Functions.6. Decision Making with VBA. 7. Repeating Actions in VBA. 8.Working with Arrays. 9. Working with Collections and Class Modules. 10. VBE Tools for Testing and Debugging. 11. Conditional Compilation and Error Trapping. 12. File and Folder Manipulation with VBA. 13. File and Folder Manipulation with Windows Script Host (WSH). 14. Using Low-Level File Access. 15. Using Excel VBA to Interact with Other Applications. 16. Using Excel with Microsoft Access. 17. Event-Driven Programming. 18. Using Dialog Boxes. 19. Creating Custom Forms. 20. Formatting Worksheets with VBA. 21. Context Menu Programming and Ribbon Customizations. 22. Printing and Sending E-mail from Excel. 23. Programming PivotTables and PivotCharts. 24. Using and Programming Excel Tables. 25. Programming Special Features. 26. Programming the Visual Basic Editor (VBE). 27. HTML Programming and Web Queries. 28. Excel and Active Server Pages. 29. Using XML in Excel 2010. 30. Calling Windows API Functions from VBA. Index.

Measuring the abundance of individuals and the diversity of species are core components of most ecological research projects and conservation monitoring. This book brings together in one place, for the first time, the methods used to estimate the abundance of individuals in nature. The statistical basis of each method is detailed along with practical considerations for survey design and data collection. Methods are illustrated using data ranging from Alaskan shrubs to Yellowstone grizzly bears, not forgetting Costa Rican ants and Prince Edward Island lobsters. Where necessary, example code for use with the open source software R is supplied. When appropriate, reference is made to other widely used programs. After opening with a brief synopsis of relevant statistical methods, the first section deals with the abundance of stationary items such as trees, shrubs, coral, etc. Following a discussion of the use of quadrats and transects in the contexts of forestry sampling and the assessment of plant cover, there are chapters addressing line-intercept sampling, the use of nearest-neighbour distances, and variable sized plots. The second section deals with individuals that move, such as birds, mammals, reptiles, fish, etc. Approaches discussed include double-observer sampling, removal sampling, capture-recapture methods and distance sampling. The final section deals with the measurement of species richness; species diversity; species-abundance distributions; and other aspects of diversity such as evenness, similarity, turnover and rarity. This is an essential reference for anyone involved in advanced undergraduate or postgraduate ecological research and teaching, or those planning and carrying out data analysis as part of conservation survey and monitoring programmes.

Your guide to quickly turn data into results. Transform your skills, data, and business-and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel 2013, with a focus on real world scenarios, problem-solving, and data modeling. You'll learn how to quickly turn mass quantities of data into meaningful information and on-the-job results-no programming required! Understand the differences between PowerPivot for Self Service BI and SQL Server Analysis Services for Corporate BI Extend your existing data-analysis skills to create your own BI solutions Quickly manipulate large data sets, often in millions of rows Perform simple-to-sophisticated calculations and what-if analysis Create complex reporting systems with data modeling and Data Analysis Expressions Share your results effortlessly across your organization using Microsoft SharePoint Authors' note on using Microsoft Excel 2016: This book's content was written against Excel 2013, but it is useful and valid for users of Excel 2016 too. Excel 2016 introduces several new DAX functions and an improved editor for DAX without changing any existing behavior. In other words, all of the concepts and examples explained in this book continue to work with Excel 2016.

Newly revised to specifically address Microsoft Excel 2019, this book is a step-by-step, exercise-driven guide for students and practitioners who need to master Excel to solve practical biological and life science problems. Excel is an effective learning tool for quantitative analyses in biological and life sciences courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. Excel 2019 for Biological and Life Sciences Statistics capitalizes on these improvements by teaching students and professionals how to apply Excel 2019 to statistical techniques necessary in their courses and work.Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand biological and life science problems. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full practice test (with answers in an appendix) that allows readers to test what they have learned. This new edition offers a wealth of new practice problems and solutions, as well as updated chapter content throughout.

Set includes Introduction to Quantitative Methods in Business: With Applications Using Microsoft Office Excel ISBN 978-1-119-22097-8 and the accompanying Solutions Manual ISBN 978-1-119-22102-9 A well-balanced and accessible introduction to the elementary quantitative methods and Microsoft Office Excel applications used to guide business decision making Featuring quantitative techniques essential for modeling modern business situations, Introduction to Quantitative Methods in Business: With Applications Using Microsoft Office Excel provides guidance to assessing real-world data sets using Excel. The book presents a balanced approach to the mathematical tools and techniques with applications used in the areas of business, finance, economics, marketing, and operations. The authors begin by establishing a solid foundation of basic mathematics and statistics before moving on to more advanced concepts. The first part of the book starts by developing basic quantitative techniques such as arithmetic operations, functions and graphs, and elementary differentiations (rates of change), and integration. After a review of these techniques, the second part details both linear and nonlinear models of business activity. Extensively classroom-tested, Introduction to Quantitative Methods in Business: With Applications Using Microsoft Office Excel also includes: * Numerous examples and practice problems that emphasize real-world business quantitative techniques and applications * Excel-based computer software routines that explore calculations for an assortment of tasks, including graphing, formula usage, solving equations, and data analysis * End-of-chapter sections detailing the Excel applications and techniques used to address data and solutions using large data sets * A companion website that includes chapter summaries, Excel data sets, sample exams and quizzes, lecture slides, and an Instructors' Solutions Manual Introduction to Quantitative Methods in Business: With Applications Using Microsoft Office Excel is an excellent textbook for undergraduate-level courses on quantitative methods in business, economics, finance, marketing, operations, and statistics. The book is also an ideal reference for readers with little or no quantitative background who require a better understanding of basic mathematical and statistical concepts used in economics and business.

Updated look at financial modeling and Monte Carlo simulation with software by Oracle Crystal Ball

This revised and updated edition of the bestselling book on financial modeling provides the tools and techniques needed to perform spreadsheet simulation. It answers the essential question of why risk analysis is vital to the decision-making process, for any problem posed in finance and investment. This reliable resource reviews the basics and covers how to define and refine probability distributions in financial modeling, and explores the concepts driving the simulation modeling process. It also discusses simulation controls and analysis of simulation results.

The second edition of "Financial Modeling with Crystal Ball and Excel" contains instructions, theory, and practical example models to help apply risk analysis to such areas as derivative pricing, cost estimation, portfolio allocation and optimization, credit risk, and cash flow analysis. It includes the resources needed to develop essential skills in the areas of valuation, pricing, hedging, trading, risk management, project evaluation, credit risk, and portfolio management. Offers an updated edition of the bestselling book covering the newest version of Oracle Crystal BallContains valuable insights on Monte Carlo simulation--an essential skill applied by many corporate finance and investment professionalsWritten by John Charnes, the former finance department chair at the University of Kansas and senior vice president of global portfolio strategies at Bank of America, who is currently President and Chief Data Scientist at Syntelli Solutions, Inc. Risk Analytics and Predictive Intelligence Division (Syntelli RAPID)

Engaging and informative, this book is a vital resource designed to help you become more adept at financial modeling and simulation.

The trusted series of workbooks by Philip H. Pollock III and Barry C. Edwards continues with A Microsoft Excel (R)Companion to Political Analysis. In this new guide, students dive headfirst into actual political data working with the ubiquitous Excel software. Students learn by doing with new guided examples, annotated screenshots, step-by-step instructions, and exercises that reflect current scholarly debates in varied subfields of political science, including American politics, comparative politics, law and courts, and international relations. Chapters cover all major topics in political data analysis, from descriptive statistics through logistic regression, all with worked examples and exercises in Excel. No matter their professional goals, students can gain a leg up for their future careers by developing a working knowledge of statistics using Excel. By encouraging students to build on their existing familiarity with the Excel program, instructors can flatten the statistics learning curve and take some of the intimidation out of the learning process. Gain lost time usually spent troubleshooting software to provide students with a smooth transition into political analysis.

Features an authentic and engaging approach to mathematical modeling driven by real-world applications With a focus on mathematical models based on real and current data, Models for Life: An Introduction to Discrete Mathematical Modeling with Microsoft(R) Office Excel(R) guides readers in the solution of relevant, practical problems by introducing both mathematical and Excel techniques. The book begins with a step-by-step introduction to discrete dynamical systems, which are mathematical models that describe how a quantity changes from one point in time to the next. Readers are taken through the process, language, and notation required for the construction of such models as well as their implementation in Excel. The book examines single-compartment models in contexts such as population growth, personal finance, and body weight and provides an introduction to more advanced, multi-compartment models via applications in many areas, including military combat, infectious disease epidemics, and ranking methods. Models for Life: An Introduction to Discrete Mathematical Modeling with Microsoft(R) Office Excel(R) also features: * A modular organization that, after the first chapter, allows readers to explore chapters in any order * Numerous practical examples and exercises that enable readers to personalize the presented models by using their own data * Carefully selected real-world applications that motivate the mathematical material such as predicting blood alcohol concentration, ranking sports teams, and tracking credit card debt * References throughout the book to disciplinary research on which the presented models and model parameters are based in order to provide authenticity and resources for further study * Relevant Excel concepts with step-by-step guidance, including screenshots to help readers better understand the presented material * Both mathematical and graphical techniques for understanding concepts such as equilibrium values, fixed points, disease endemicity, maximum sustainable yield, and a drug s therapeutic window * A companion website that includes the referenced Excel spreadsheets, select solutions to homework problems, and an instructor s manual with solutions to all homework problems, project ideas, and a test bank The book is ideal for undergraduate non-mathematics majors enrolled in mathematics or quantitative reasoning courses such as introductory mathematical modeling, applications of mathematics, survey of mathematics, discrete mathematical modeling, and mathematics for liberal arts. The book is also an appropriate supplement and project source for honors and/or independent study courses in mathematical modeling and mathematical biology. Jeffrey T. Barton, PhD, is Professor of Mathematics in the Mathematics Department at Birmingham-Southern College. A member of the American Mathematical Society and Mathematical Association of America, his mathematical interests include approximation theory, analytic number theory, mathematical biology, mathematical modeling, and the history of mathematics.

Eek pracalit kahaavat hai ki paakkala, sabhee lookapriy praaceen kalaoon meen sarvashreeshth kala hai. Is kala nee hee vaastav meen maanavjeevan aur maanavsabhyata koo badala hai. Paakkala kee utpatti nee hee aadimaanav see aaj kee ikkeesaveen sadee kee maanavjeevan ka nirmaan kiya hai. Prakaashan kee vyavasaay meen lagabhag doo sadiyoon kee kaamayaabee kee pashcaat, paakkala eevan kaantineental vyannjan ab eek puurnatah nayee ruup meen vaapas aayee hai. Paakkala koo eek sampuurn gaid kee ruup meen prastut kiya gaya hai. Bhoojan pakaatee samay svacchata, saavadhanee, upayukt vaayu sanncaar tatha khaana pakaanee kee aadhunik vaijnaanik upakaran, ityaadi par vistaarapuurvak viveecana kee gayee hai. Khaana paroosana, meesh tatha bhoojan kaksh kee sajaavat, meehamaanoon ka svaagat, aadi par bhee is bhaag meen ulleekh kiya gaya hai. Kaaenteeneental vyannjanvidh, i saamagree tatha vuphach visheesh tips kee saath paathakoon kee sammukh prastut kiyee gayee hain. Har vyannjan eek aakarshak citra kee saath prastut kiya gaya hai. Apanee andar supt paakkala koo jaagrt karanee kee liee yah atyant utvrphasht eevan upayoogee pustak hai. Is pustak kee sahaayata see aap apanee paakkala koo aur bhee nikhaareen, gharparivaar va meehamaanoon kee samaksh parooseen aur vaahavaahee luuteen.(Preparing continental foods have come back in a totally transformed style, taste and appearance. The author claims this is a 'complete guide'. While cooking such dishes, the ambience has to be bland less dominating smell, cleanliness and clean air and follow the suggested method of cooking. The book contains the recipes of continental foods and gives tips on table decorum, presentation of dining sets, cutlery, ambience etc. ) #v&spublishers

Microsoft Excel is a powerful tool that can transform the way you use data. This book explains in comprehensive and user-friendly detail how to manage, make sense of, explore and share data, giving scientists at all levels the skills they need to maximize the usefulness of their data. Readers will learn how to use Excel to: * Build a dataset - how to handle variables and notes, rearrangements and edits to data. * Check datasets - dealing with typographic errors, data validation and numerical errors. * Make sense of data - including datasets for regression and correlation; summarizing data with averages and variability; and visualizing data with graphs, pivot charts and sparklines. * Explore regression data - finding, highlighting and visualizing correlations. * Explore time-related data - using pivot tables, sparklines and line plots. * Explore association data - creating and visualizing contingency tables. * Explore differences - pivot tables and data visualizations including box-whisker plots. * Share data - methods for exporting and sharing your datasets, summaries and graphs. Alongside the text, Have a Go exercises, Tips and Notes give readers practical experience and highlight important points, and helpful self-assessment exercises and summary tables can be found at the end of each chapter. Supplementary material can also be downloaded on the companion website. Managing Data Using Excel is an essential book for all scientists and students who use data and are seeking to manage data more effectively. It is aimed at scientists at all levels but it is especially useful for university-level research, from undergraduates to postdoctoral researchers.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Get beyond the basics with Excel 2007 charts Now you can take your Excel charting skills to the next level with help from this hands-on guide. Excel 2007 Charts Made Easy shows you how to upgrade from simple pie and bar charts to rich data visualization using the full range of charts available in the latest version of the software. Discover how easy it is to create custom charts with compelling effects and to display data in more meaningful ways. Manually format chart components Show trends in your data with line charts Combine line and pie charts to create area charts Plot data using scatter charts and bubble charts Create and format stock charts Connect three data points with a surface chart Display the relationship between various data series using doughnut charts Compare data values with radar charts Use PivotTables and PivotCharts to work with dynamic data Incorporate Excel charts into Word documents and PowerPoint presentations

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Get beyond the basics with Excel 2007 macros Now you can take your Excel skills to the next level with help from this hands-on guide. Excel 2007 Macros Made Easy shows you how to create, run, and revise macros to simplify repetitive tasks and store the instructions for complicated ones. You'll learn to use Visual Basic for Applications (VBA), add macros to the Excel toolbar, and share your macros with other users. Discover how easy it is to develop custom macros, save time, and boost productivity. Record and edit macros Create and debug macros in VBA Save macros to the Personal Macro Workbook or other workbooks Create VBA subroutines and functions Develop interactive macros Format cells using macros Create variables and arrays Apply logic to macros with If/Then/Else routines Use loops to process data Add controls to your worksheets

"Corporate Financial Analysis with Microsoft"(R) "Excel"(R) visualizes spreadsheets as an effective management tool both for financial analysis and for coordinating its results and actions with marketing, sales, production and service operations, quality control, and other business functions.

Taking an integrative view that promotes teamwork across corporate functions and responsibilities, the book contains dozens of charts, diagrams, and actual Excel(R) screenshots to reinforce the practical applications of every topic it covers. The first two sections-- Financial Statements and Cash Budgeting-- explain how to use spreadsheets for: Preparing income statements, balance sheets, and cash flow statements Performing vertical and horizontal analyses of financial statements Determining financial ratios and analyzing their trends and significance Combining quantitative and judgmental techniques to improve forecasts of sales revenues and customer demands Calculating and applying the time value of money Managing inventories, safety stocks, and the allocation of resources

The third and final section--Capital Budgeting-- covers capital structure, the cost of capital, and leverage; the basics of capital budgeting, including taxes and depreciation; applications, such as new facilities, equipment replacement, process improvement, leasing versus buying, and nonresidential real estate; and risk analysis of capital budgets and the potential impacts of unforeseen events.

"Corporate Financial Analysis with Microsoft"(R) "Excel"(R) takes a broad view of financial functions and responsibilities in relation to those of other functional parts of modern corporations, and it demonstrates how to use spreadsheets to integrate and coordinate them. It provides many insightful examples and case studies of real corporations, including Wal- Mart, Sun Microsystems, Nike, H. J. Heinz, Dell, Microsoft, Apple Computer, and IBM.

"Corporate Financial Analysis with Microsoft"(R) "Excel"(R) is the ideal tool for managing your firm's short-term operations and long-term capital investments.