Friday, December 10, 2004

 

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

Posted by Mike Alexander @ 2:25 PM permalink 0 comments

Monday, December 06, 2004

 

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




Posted by Mike Alexander @ 9:50 PM permalink 0 comments
 

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!

Posted by Jon Wittwer @ 8:35 PM permalink 0 comments

Wednesday, December 01, 2004

 

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

Posted by Jon Wittwer @ 11:26 PM permalink 0 comments

 

 

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. This weblog is in no way associated with Microsoft.

This page is powered by Blogger. Isn't yours?