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

Curso Multimídia Access XP - Editora Terra

Title:
Curso Multimídia Access XP - Editora Terra


Video:


Description:Conheça e aprenda os principais recursos do Access XP, um software que tem a finalidade de auxiliar o usuário no desenvolvimento e na manipulação de arquivos de bancos de dados. Neste curso, você irá aprender, de maneira didática, como gerar um arquivo de banco de dados, trabalhar com tabelas, criar consultas, definir e criar formulários e relatórios e vários outros recursos que o Access XP disponibiliza. São 86 lições apresentadas em mais de 2 horas e meia de vídeo. O curso apresenta uma interface intuitiva, agradável e auto - explicativa. As lições são apresentadas, passo a passo, em vídeo e organizadas em capítulos e tópicos, facilitando o acompanhamento ea navegação.

Published:
23/Oct/2008