Saturday 31 May 2008

Send email from excel using VBA

Title:
Send email from excel using VBA


Video:


Description:Send email from excel using VBA. Peter Kirklewski, Senior VBA programmer. tel: 0048787950948 in EU or 0013157794406 in NY.

Published:
01/Jun/2008

Friday 30 May 2008

Using Excel to calculate Black-Scholes-Merton option price

Title:
Using Excel to calculate Black-Scholes-Merton option price


Video:


Description:This is Black-Scholes for a European-style call option. You can download the XLS @ this forum thread on my site: www.bionicturtle.com

Published:
30/May/2008

Tuesday 27 May 2008

How to Do a Perceptual Map [Hafihz.com]

Title:
How to Do a Perceptual Map [Hafihz.com]


Video:


Description:www.hafihz.com Tweeter me! http Marketing degree major and author of The 10 Secrets of Power Presentations, Nurhafihz describes how to position your business using a perceptual map.

Published:
28/May/2008

Friday 23 May 2008

Remove Duplicate Records in Excel 2003

Title:
Remove Duplicate Records in Excel 2003


Video:


Description:www.contextures.com Use an Advanced Filter to create a list with no duplicates. Detailed instructions here: www.contextures.com

Published:
24/May/2008

Tuesday 20 May 2008

Excel Tutorial, Home, End, and GoTo Command

Title:
Excel Tutorial, Home, End, and GoTo Command


Video:


Description:One of a series of over 50 free videos. Comprehensive, step-by-step, learning the right way.

Published:
21/May/2008

Word 2007 Makro erstellen www.Effektiv-Verlag.de

Title:
Word 2007 Makro erstellen www.Effektiv-Verlag.de


Video:


Description:www.effektiv-verlag.de hier bekommen Sie das komplette Videotraining Word 2007 Makro erstellen www.effektiv-verlag.de - Videotrainings für Microsoft Office

Published:
20/May/2008

Tuesday 6 May 2008

Excel lesson 5

Title:
Excel lesson 5


Video:


Description:How to create macros to do repeatable tasks in Excel. Also cover the 'if' and 'countif' functions to create self marking tests.

Published:
07/May/2008

Thursday 1 May 2008

Excel Lookup Series #13: INDEX & MATCH functions Example 3!

Title:
Excel Lookup Series #13: INDEX and MATCH functions Example 3!


Video:


Description:See how to use the INDEX and 3 MATCH functions in one formula to look up a value from 1 of 3 different tables! Also see how adding Names and a Data Validation Drop-down List can make the INDEX and MATCH functions more accurate. Also see how to use Custom Number Formatting for a formula input number. See how to correct a formula using Formula Evaluator. See how the Amazing INDEX function can lookup values from different tables! See how we can tell the INDEX function a Row #, a Column# and a Table# and it will retrieve a value from 1 of three different tables. See how to make an invoice shipping charge formula when you have a complicated lookup requirement. In this Series learn 15 amazing ways to look things up in Excel. We will look at the functions VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, CHOOSE, and the non-function lookup formula using the intersector operator. We will look at simple lookups all the way to complicated, yet efficient methods to look things up in Excel. This is a logical (beginning to end) story about most of the lookup situations you may encounter in Excel.

Published:
02/May/2008