VBA for Modelers
Author : S. Christian Albright
Publisher :
Page : 681 pages
File Size : 42,86 MB
Release : 2007
Category : Decision support systems
ISBN : 9780495106852
Excel Data Analysis
Author : Hector Guerrero
Publisher : Springer
Page : 358 pages
File Size : 14,10 MB
Release : 2018-12-14
Category : Business & Economics
ISBN : 3030012794
Book Description
This book offers a comprehensive and readable introduction to modern business and data analytics. It is based on the use of Excel, a tool that virtually all students and professionals have access to. The explanations are focused on understanding the techniques and their proper application, and are supplemented by a wealth of in-chapter and end-of-chapter exercises. In addition to the general statistical methods, the book also includes Monte Carlo simulation and optimization. The second edition has been thoroughly revised: new topics, exercises and examples have been added, and the readability has been further improved. The book is primarily intended for students in business, economics and government, as well as professionals, who need a more rigorous introduction to business and data analytics – yet also need to learn the topic quickly and without overly academic explanations.
Dashboards for Excel
Author : Jordan Goldmeier
Publisher : Apress
Page : 545 pages
File Size : 41,7 MB
Release : 2015-10-07
Category : Computers
ISBN : 1430249455
Book Description
This book takes a hands-on approach to developing dashboards, from instructing users on advanced Excel techniques to addressing dashboard pitfalls common in the real world. Dashboards for Excel is your key to creating informative, actionable, and interactive dashboards and decision support systems. Throughout the book, the reader is challenged to think about Excel and data analytics differently—that is, to think outside the cell. This book shows you how to create dashboards in Excel quickly and effectively. In this book, you learn how to: Apply data visualization principles for more effective dashboards Employ dynamic charts and tables to create dashboards that are constantly up-to-date and providing fresh information Use understated yet powerful formulas for Excel development Apply advanced Excel techniques mixing formulas and Visual Basic for Applications (VBA) to create interactive dashboards Create dynamic systems for decision support in your organization Avoid common problems in Excel development and dashboard creation Get started with the Excel data model, PowerPivot, and Power Query
Excel Basics to Blackbelt
Author : Elliot Bendoly
Publisher : Cambridge University Press
Page : 335 pages
File Size : 17,50 MB
Release : 2008-07-07
Category : Business & Economics
ISBN : 1139473026
Book Description
Excel Basics to Blackbelt is intended to serve as an accelerated guide to decision support designs. Its structure is designed to enhance the skills in Excel of those who have never used it for anything but possibly storing phone numbers, enabling them to reach a level of mastery that will allow them to develop user interfaces and automated applications. To accomplish this, the major theme of the text is 'the integration of the basic'; as a result readers will be able to develop decision support tools that are at once highly intuitive from a working-components perspective but also highly significant from the perspective of practical use and distribution. Applications integration discussed includes the use of MS MapPoint, XLStat and RISKOptimizer, as well as how to leverage Excel's iteration mode, web queries, visual basic code, and interface development. There are ample examples throughout the text.
Retail Category Management
Author : Alexander Hübner
Publisher : Springer Science & Business Media
Page : 172 pages
File Size : 11,79 MB
Release : 2011-08-30
Category : Business & Economics
ISBN : 3642224776
Book Description
Retail shelf management means cost-efficiently aligning retail operations with consumer demand. As consumers expect high product availability and low prices, and retailers are constantly increasing product variety and striving towards high service levels, the complexity of managing retail business and its operations is growing enormously. Retailers need to match consumer demand with shelf supply by balancing variety (number of products) and service levels (number of items of a product), and by optimizing demand and profit through carefully calibrated prices. As a result the core strategic decisions a retailer must make involve assortment sizes, shelf space assignment and pricing levels. Rigorous quantitative methods have emerged as the most promising solution to this problem. The individual chapters in this book therefore focus on three areas: (1) combining assortment and shelf space planning, (2) providing efficient decision support systems for practically relevant problem sizes, and (3) integrating inventory and price optimization into shelf management.
Microeconomics using Excel
Author : Gerald Schwarz
Publisher : Routledge
Page : 321 pages
File Size : 49,2 MB
Release : 2007-08-02
Category : Business & Economics
ISBN : 1134114133
Book Description
Using Microsoft Excel, the market leading spreadsheet package, this book combines theory with modelling aspects and spreadsheet analysis. Microeconomics Using Excel provides students with the tools with which to better understand microeconomic analysis.It focuses on solving microeconomic problems by integrating economic theory, policy analysis and
Developing Spreadsheet-based Decision Support Systems
Author :
Publisher :
Page : 956 pages
File Size : 34,95 MB
Release : 2011
Category :
ISBN : 9780975914687
Book Description
Financial Analysis and Modeling Using Excel and VBA
Author : Chandan Sengupta
Publisher : John Wiley & Sons
Page : 822 pages
File Size : 17,28 MB
Release : 2009-11-09
Category : Business & Economics
ISBN : 047027560X
Book Description
An updated look at the theory and practice of financial analysis and modeling Financial Analysis and Modeling Using Excel and VBA, Second Edition presents a comprehensive approach to analyzing financial problems and developing simple to sophisticated financial models in all major areas of finance using Excel 2007 and VBA (as well as earlier versions of both). This expanded and fully updated guide reviews all the necessary financial theory and concepts, and walks you through a wide range of real-world financial problems and models that you can learn from, use for practice, and easily adapt for work and classroom use. A companion website includes several useful modeling tools and fully working versions of all the models discussed in the book. Teaches financial analysis and modeling and illustrates advanced features of Excel and VBA, using a learn-by-doing approach Contains detailed coverage of the powerful features of Excel 2007 essential for financial analysis and modeling, such as the Ribbon interface, PivotTables, data analysis, and statistical analysis Other titles by Sengupta: Financial Modeling Using C++ and The Only Proven Road to Investment Success Designed for self-study, classroom use, and reference This comprehensive guide is an essential read for anyone who has to perform financial analysis or understand and implement financial models.
Building Financial Models with Microsoft Excel
Author : K. Scott Proctor
Publisher : John Wiley & Sons
Page : 370 pages
File Size : 43,14 MB
Release : 2004-10-28
Category : Business & Economics
ISBN : 0471693200
Book Description
A comprehensive guide to building financial models Building Financial Models with Microsoft Excel + CD-ROM provides beginning or intermediate level computer users with step-by-step instructions on building financial models using Microsoft Excel-the most popular spreadsheet program available. The accompanying CD-ROM contains Excel worksheets that track the course of the book and allow readers to build their own financial models. This comprehensive resource also covers important topics such as the concept of valuation, the concept of sensitivity analysis, the concepts of contribution margin and financial ratios and the basics of building and using a Capitalization Table. K. Scott Proctor, CFA, is the Director of Investor Analytics at SNL Financial, a financial information provider.
Simulation of Industrial Systems
Author : David Elizandro
Publisher : CRC Press
Page : 538 pages
File Size : 25,75 MB
Release : 2007-12-19
Category : Business & Economics
ISBN : 1420067451
Book Description
In any production environment, discrete event simulation is a powerful tool for the analysis, planning, and operating of a manufacturing facility. Operations managers can use simulation to improve their production systems by eliminating bottlenecks, reducing cycle time and cost, and increasing capacity utilization. Offering a hands-on tutorial on h
