Detailed Explanation About Basic Macro Recording

A new video on the basics of recording a macro has been added to DataPigTechnologies.
This video covers the mechanics of recording a macro, the differences between recording with relative reference on vs off, and assigning a macro to a button.

Follow the link to watch:
http://www.datapigtechnologies.com/flashfiles/recordmacros.html

Formula to Convert Trailing Minus Signs

Ever need to convert trailing minus signs in Excel? Well you can do it without code or a fancy
Add-In. The below video tutorial will show you how to do it with a simple formula.

http://www.datapigtechnologies.com/flashfiles/trailingminusproblem.html

-M.Alexander

Online Excel Video Tutorials

Michael Alexander of DataPigTechnologies.com has a created a site with a great set of online Excel video tutorials. Topics include pivot tables, charts, basic Excel concepts, and advanced Excel functions.

I'm happy to announce that Michael has joined the Excel Tutorials team blog and we look forward to what he'll have to share in the future!

Monte Carlo Simulation in Excel: A Practical Guide

This online guide provides an introduction to Monte Carlo simulation. It discusses the difference between deterministic and stochastic models, using two online interactive examples. A sales forecast model in Excel is used to demonstrate the basic steps of a Monte Carlo simulation for risk and uncertainty analysis. It shows how to:

• Generate random numbers


• Create histograms


• Calculate summary statistics


• Estimate percentiles


• Graph a normal distribution