This website uses technical, customisation and analytical cookies, both first-party and third-party, to anonymously facilitate browsing and analyse statistics on use of the website. Learn more
Search results
-
Macros in Excel 2010
de Santiago, Rafael; Al Bekai, ImadTechnical Note ADN-276-EService and Operations ManagementThis technical note provides an introduction to using macros in Microsoft Excel 2010. It explains how to create, edit, save and call a macro, as well as how to use Solver with macros. Macros allow the automation of repetitive tasks like formatting, charting and other often-used spreadsheet tasks. The note gives an introduction to Visual Basic for Applications (VBA) programming language. This note is an updated version of the note "A Guided Tour t...Starting at €8.20
-
PivotTables in Excel 2010
de Santiago, RafaelTechnical Note ADN-277-EAccounting and Control, Service and Operations ManagementThis technical note provides an introduction to using PivotTables in Microsoft Excel 2010. A PivotTable is a powerful tool that allows the user to analyze, sort, count, summarize, and organize data from a spreadsheet. A PivotTable is especially useful when you have a long list of figures to sum, and aggregated data or subtotals would help you look at the data from different perspectives and compare figures of similar data. This note is an updated...Starting at €8.20
-
Present Value Tables
de Santiago, RafaelTechnical Note ADN-275-EEconomics, FinanceThese tables provide the values used to discount monetary when the cash flows span several periods. The first table shows the value of having 1 euro n years from now, at different discount rates. The second table shows the present value of receiving 1 euro each year during n years, at different discount rates.Starting at €8.20
-
Continuous Discounting
de Santiago, RafaelTechnical Note ADN-285-EDecision Analysis, FinanceThis technical note discusses how discounting works when it is done for periods shorter than a yearStarting at €8.20
-
Monte Carlo Simulation
de Santiago, RafaelTechnical Note ADN-284-EDecision Analysis, Entrepreneurship, Service and Operations ManagementThis technical note introduces the basic concepts of Monte Carlo simulation, as well as the software to run the models (Crystal Ball). The requirements to follow the note are a working knowledge of probability distributions, decision trees and expected values, as well as being familiar with Microsoft Excel spreadsheets. As Monte Carlo simulation is better understood when applied to practical problems, the concepts and techniques are introduced by...Starting at €8.20
-
An Introduction to Decision Trees
de Santiago, Rafael; Gorecka-Pietrucha, JustynaTechnical Note ADN-278-EDecision AnalysisWhen facing a complex decision, the structure of the problem is oftentimes not obvious. A decision diagram can help the decision-maker understand the nature of the problem he or she is facing and evaluate the impact of risk on the final decision. It also allows us to carry out a sensitivity analysis, which investigates how sensitive our initial decision is to small changes in the relevant parameters.Starting at €8.20
-
Excel Tips for Advanced Users
de Santiago, RafaelTechnical Note ADN-281-EDecision Analysis, FinanceThis technical note is meant to enhance the reader's ability to build Excel models or to use those developed by colleagues, clients, financial institutions or other parties. It is not an introduction to Excel (a working knowledge of the software is assumed throughout). This document cannot substitute practice. Mastering the use of Excel is a skill and, as is the case with any other type of applied knowledge, it is not enough to understand the con...Starting at €8.20