Tutorial - Excel 2007: Filtros, macros y formularios

Title:
Tutorial - Excel 2007: Filtros, macros y formularios


Video:


Description:Videotutorial que muestra cómo combinar y usar correctamente filtros, macros y formularios.

Published:
30/Oct/2008

Excel MT #143: VBA: Avoid Data Validation 1 Rule Limit

Title:
Excel MT #143: VBA: Avoid Data Validation 1 Rule Limit


Video:


Description:See how to work around Data Validations one rule limit by getting VBA code to prevent duplicates. See how to ask questions at the Mr Excel Discussion Board and get answers.

Published:
29/Oct/2008

Excel MT142 p2: Array Formula for Counting Dates

Title:
Excel MT142 p2: Array Formula for Counting Dates


Video:


Description:See how to create a complex array formula that counts weekends between two dates with the SUM IF WEEKDAY ROW and INDIRECT functions in one formula See how to create an array formula that counts with date and other criteria Also see: From a beginning and ending date, see how to create a list of dates (serial numbers) in memory using the ROW and INDIRECT functions. Also see this video for another example of this date trick: Excel Magic Trick # 165: MACRO to Extract Birthdays.

Published:
28/Oct/2008

Excel Magic Trick #139: HYPERLINK function & Drop Down List

Title:
Excel Magic Trick #139: HYPERLINK function and Drop Down ListVideo:


Description:See how to use Data Validation List Drop-down and the hyperlink function to create a list of hyper links. See how to link to a web site or a cell on a different worksheet.

Published:
28/Oct/2008

Tutorial - Excel 2007: Referencias en 3D

Title:
Tutorial - Excel 2007: Referencias en 3D


Video:


Description:Videotutorial que explica paso a paso como realizar referencias 3D en Excel 2007.

Published:
28/Oct/2008

How To Use Microsoft Excel : Formatting Cells in Microsoft Excel

Title:
How To Use Microsoft Excel : Formatting Cells in Microsoft ExcelVideo:


Description:How to format cells in Microsoft Excel; learn more about spreadsheet software in this free instructional video. Expert: Gary Zier Bio: Gary Zier, originally from Florida, is a systems administrator with 10 years of computer networking experience and an expertise in conditional access security systems. Filmmaker: Gary Zier

Published:
25/Oct/2008

Excel - Auto MS Access Upload

Title:
Excel - Auto MS Access Upload


Video:


Description:Demo shows how to connect to Access programmatically and insert data directly to Access using ADO and SQL from Excel. Uses two textboxes and a command button.

Published:
24/Oct/2008