Search results
-
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
-
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